Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are considering investing in a real estate project. It is an eight-flex in a rural part of Oregon. Each unit rents for $600 per

You are considering investing in a real estate project. It is an eight-flex in a rural part of Oregon. Each unit rents for $600 per month. Your friend Mario is willing to finance your project, but it is going to cost you. Calculate the rental cash flows of the apartment building assuming three different occupancy discount scenarios, one at 5%, 10%, and 15%. Your model should have line items for rental revenue, management expenses (10$ of revenue), depreciation (straight line over 30 years) and taxes (25%). Create a sensitivity table with discount rates along the top and the three scenarios in rows like that below.

5%

10%

15%

5%

NPV

NPV

NPV

10%

NPV

NPV

NPV

15%

NPV

NPV

NPV

Use discount rates of 5%, 10%, and 15%. Your sensitivity table should hold NPVs for the property.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Foundations In Personal Finance

Authors: Dave Ramsey

College Edition

1936948001, 978-1936948000

More Books

Students also viewed these Finance questions