Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you calculate f ) and g ) please? On the left there's the assumptions and on the right is how I need to complete

Can you calculate f) and g) please? On the left there's the assumptions and on the right is how I need to complete it. Thank you!assumptions to complete the analysis below:
The assumed purchase price is $2.5 million
Potential gross income (PGI) for the first year of operations is projected to be
$425,000.
PGI is expected to increase 3 percent per year.
Vacancies are expected to be 5 percent of PGI.
Operating expenses are estimated at 45 percent of effective gross income.
The holding period is five years.
The market value of the property is expected to increase 5 percent per year.
Selling expenses will be 5 percent when the property is sold at the end of the 5th
year.
The appropriate rate of return to discount projected NOIs and the projected NSP
is 12 percent.
The appropriate rate of return to discount projected BTCFs and the projected
BTER is 14 percent.
70 percent of the purchase price can be borrowed with a 30-year, monthly
payment mortgage.
The annual interest rate on the mortgage will be 8.0 percent.
Financing costs will equal 2 percent of the mortgage amount.
a) Develop a cash flow statement showing NOI for each of the five years.
b) Calculate the net selling price from the sale of the property at the end of the fifth
year.
c) Calculate the net present value and the internal rate of return of this investment
assuming no mortgage debt. Should you purchase? Why?
d) Calculate the monthly mortgage payment. What is the total per year?
e) Calculate the remaining loan balance at the end of years 1,2,3,4 and 5.
f) Calculate the amount of principal reduction achieved during each of the five
years.
g) Calculate the total interest paid during each of the five years. (Remember the debt
service equals principal plus interest.)
h) Calculate the required initial equity investment.
i) Calculate the before-tax cash flows (BTCF) from operations for each of the five
years.
j) Calculate the before-tax equity reversion (BTER) from the sale of the property.
k) Calculate the net present value and the internal rate of return on the equity
investment. Should you purchase? Why?
image text in transcribed

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

Step: 3

blur-text-image

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

Public Finance A Contemporary Application Of Theory To Policy

Authors: David N Hyman

12th Edition

0357442156, 978-0357442159

More Books

Students also viewed these Finance questions

Question

2. What are the prospects for these occupations?pg 87

Answered: 1 week ago