Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Unlevered Before Tax Cash Flow Year 0 1 2 3 4 5 6 Potential Gross Income (PGI) $814,500 $855,225 $897,986 $942,886 $990,030 $1,039,531 Less: Vacancy
| Unlevered Before Tax Cash Flow | |||||||||
| Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | ||
| Potential Gross Income (PGI) | $814,500 | $855,225 | $897,986 | $942,886 | $990,030 | $1,039,531 | |||
| Less: Vacancy and Collection Loss | -$65,160 | -$68,418 | -$71,839 | -$75,431 | -$79,202 | -$83,163 | |||
| Other Income | $44,100 | $46,305 | $48,620 | $51,051 | $53,604 | $56,284 | |||
| Effective Gross Income (EGI) | $793,440 | $833,112 | $874,768 | $918,506 | $964,431 | $1,012,653 | |||
| Operating Expenses (OPEX) | -$507,802 | -$533,192 | -$559,851 | -$587,844 | -$617,236 | -$648,098 | |||
| Net Operating income (NOI) | $285,638 | $299,920 | $314,916 | $330,662 | $347,195 | $364,555 | |||
| Purchase Price | -$5,450,000 | ||||||||
| Net Proceeds from Sale | $3,783,490 | ||||||||
| Total | -$5,450,000 | $285,638 | $299,920 | $314,916 | $330,662 | $4,130,685 | |||
| Property Metrics | |||||||||
| Unlevered NPV | |||||||||
| Unlevered IRR | |||||||||
| OAR at Acquisition |
The answers to NPV $367,393 and IRR is 13.73%. The Discount Rate is 12%.
I need to know what Excel formula is needed to find the answers to NPV, IRR, and OAR at Acquisition.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
The New Microfinance Handbook A Financial Market System Perspective
Authors: Joanna Ledgerwood, Julie Earne, Candace Nelson
1st Edition
0821389270, 978-0821389270
