Exam 2018, answers PDF

Preview

Summary

Download Exam 2018, answers PDF

Description

Year PGI VAC EGI OE NOI TaxRoute NOI InterestonDebt Depreciation TaxableIncome Taxes CashFlowRoute NOI DS BTCF Taxes ATCF Equity(Acq&Disp) NetCashFlow NPV=

0

1

2

3

4

5

$675,000.00

$705,375.00

$737,116.88

$770,287.13

$804,950.06

‐$54,000.00

‐$56,430.00

‐$58,969.35

‐$61,622.97

‐$64,396.00

$621,000.00

$648,945.00

$678,147.53

$708,664.16

$740,554.05

‐$112,500.00 ‐$116,437.50 ‐$120,512.81 ‐$124,730.76

‐$129,096.34

$508,500.00

$532,507.50

$557,634.71

$583,933.40

$611,457.71

$508,500.00

$532,507.50

$557,634.71

$583,933.40

$611,457.71

‐$324,395.27 ‐$317,044.50 ‐$309,099.41 ‐$300,511.97

‐$291,230.24

‐$156,000.00 ‐$156,000.00 ‐$156,000.00 ‐$156,000.00

‐$156,000.00

$28,104.73

$59,463.00

$92,535.30

$127,421.43

$164,227.48

‐$12,647.13

‐$26,758.35

‐$41,640.88

‐$57,339.64

‐$73,902.36

$508,500.00

$532,507.50

$557,634.71

$583,933.40

$611,457.71

‐$415,314.16 ‐$415,314.16 ‐$415,314.16 ‐$415,314.16

‐$415,314.16

$93,185.84

$117,193.34

$142,320.55

‐$12,647.13

‐$26,758.35

‐$41,640.88

‐$57,339.64

‐$73,902.36

$80,538.71

$90,434.98

$100,679.66

$111,279.59

$122,241.18

‐$3,215,000.00 ‐$3,215,000.00 ‐$476,058.51

$168,619.24

$196,143.55

$4,200,000.00 $80,538.71

$90,434.98

IRR

$100,679.66 8.28%

$111,279.59 $4,322,241.18...