image 18

Thomas Paul Investment, Inc.

Property Investment Analysis

EXCEL WORKING CASE: ADVANCED LEVEL

Submission Instructions Complete Case 18 in Excel. Answer the questions at the end of this case and insert the answers on an Answer Sheet in the Case 18 Excel spreadsheet. Ask your instructor for submission instructions.

Preview Thomas Paul Investment, Inc., purchases residential real estate for short-term investment and/or rental income. The company's main purpose is to carry out minor repairs, lease the properties, and eventually sell them for a profit. As a real estate investor for the company, you want to create a spreadsheet application to analyze and compare the costs associated with each of three properties and to decide which two of the three properties would be the best investments.

Skill Set

PMT function

Data validation

Solver

Data table

Formula audit

Scenario manager

Background Thomas Paul Investment, Inc., purchases residential real estate for short-term investment and/or rental income. The investment company owns more than 200 rental properties across the United States and is interested in purchasing two properties in San Diego County, California. The company has narrowed their search to three properties. You need to develop a spreadsheet application to analyze and compare the costs associated with each of the three properties and to decide which two of the three properties ...

Get MIS Cases: Solving Small Business Scenarios Using Application Software, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.