Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

Use the following property data: Purchase price $1,850,000 Cash flow from operations: Year 1 2 3 4 5 NOI $175,000 $200,000 $225,000 $250,000 $275,000 Debt

Use the following property data:
Purchase price$1,850,000
Cash flow from operations:
Year12345
NOI$175,000$200,000$225,000$250,000$275,000
Debt Service$140,000$140,000$140,000$140,000$140,000
Cash Flow at sale:
Sale Price:$2,137,500
Cost of sale:$64,125
Mortgage balance:$1,603,125
Going in Cap Rate8%
Required return, UNLEVERED CF's (APR)10%
Required return, LEVERED CF's (APR)15%


Compute a value for the property using direct capitalization and the first year's NOI: 2187500

Calculate the initial equity investment in this property, assuming UNLEVERED CF's (i.e. LTV = 0). Enter a positive number.,Find the UNLEVERED net sale proceeds from the sale of the property:,Calculate the UNLEVERED BTCF to equity in year 2. Don't overthink this…,Calculate the UNLEVERED BTCF to equity in year 4. Don't overthink this...,Calculate the TOTAL UNLEVERED CF in Year 5.,Compute the NPV of the property based on UNLEVERED cash flows. Round to the nearest dollar.,Calculate the IRR of the property, based on UNLEVERED CF's. Express your answer in percent. Round to TWO decimal places.



Step by Step Solution

3.60 Rating (161 Votes )

There are 3 Steps involved in it

Step: 1

a Direct Capitalization Rate This rate is obtained by dividing the net operatin... blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting an introduction to concepts, methods and uses

Authors: Clyde P. Stickney, Roman L. Weil, Katherine Schipper, Jennifer Francis

13th Edition

978-0538776080, 324651147, 538776080, 9780324651140, 978-0324789003

More Books

Students explore these related Accounting questions