Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Year-0 Year-1 Year-2 Year-3 Year-4 Year-5 Year-6 PGI $ 18,522,480 $ 19,078,154 $ 19,650,499 $ 20,240,014 $ 20,847,214 $ 21,472,631 Vacancy Loss $ (926,124) $
Year-0 | Year-1 | Year-2 | Year-3 | Year-4 | Year-5 | Year-6 | |
PGI | $ 18,522,480 | $ 19,078,154 | $ 19,650,499 | $ 20,240,014 | $ 20,847,214 | $ 21,472,631 | |
Vacancy Loss | $ (926,124) | $ (953,908) | $ (982,525) | $ (1,012,001) | $ (1,042,361) | $ (1,073,632) | |
Misc Income | $ 477,000 | $ 486,540 | $ 496,271 | $ 506,196 | $ 516,320 | $ 526,647 | |
EGI | $ 19,925,604 | $ 20,518,602 | $ 21,129,295 | $ 21,758,211 | $ 22,405,895 | $ 23,072,909 | |
Operating Expenses | $ (7,293,131) | $ (7,511,925) | $ (7,737,282) | $ (7,969,401) | $ (8,208,483) | $ (8,454,737) | |
Capital Expeditures | $ (909,664) | $ (936,954) | $ (965,062) | $ (994,014) | $ (1,023,835) | $ (1,054,550) | |
NOI | $ 28,128,398 | $ 28,967,480 | $ 29,831,639 | $ 30,721,626 | $ 31,638,213 | $ 32,582,196 | |
ADS | $ 8,225,468 | $ 8,225,468 | $ 8,225,468 | $ 8,225,468 | $ 8,225,468 | ||
BTCF | $ 36,353,866 | $ 37,192,948 | $ 38,057,107 | $ 38,947,094 | $ 39,863,681 | $ 32,582,196 | |
Cost of Acqusition | ?? | ||||||
Bank Loan | $ 400,000,000 | ||||||
Equity Investment | ?? | ||||||
Future Sale Price | ?? | ?? | |||||
Selling Costs | 6% of sales price | ?? | |||||
Loan Balance | ?? | ||||||
BTER | ?? | ||||||
Cash Flows | ?? | ? | ? | ? | ?? | ||
IRR | ?? | ||||||
NPV | ?? | ||||||
Show excel formulas | |||||||
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