Answered step by step
Verified Expert Solution
Link Copied!
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

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

Investments

Authors: Zvi Bodie, Alex Kane, Alan J. Marcus

8th Edition

0077261453, 978-0077261450

More Books

Students explore these related Finance questions