ABCEFGHIJKLMNOPQRSTUVWXYZ
2
ALL FIGURES ARE PER UNIT
3
ADJUST BLUE CELLS12345678910
4
Rent:1000
5
use dropdownYear: 1Year: 2Year: 3Year: 4Year: 5Year: 6Year: 7Year: 8Year: 9Year: 10
6
use dropdown $ 12,000 $ 12,330 $ 12,669 $ 13,017 $ 13,375 $ 13,743 $ 14,121 $ 14,510 $ 14,909 $ 15,319
7
Vacancy: 5.00% $ (600) $ (617) $ (633) $ (651) $ (669) $ (687) $ (706) $ (725) $ (745) $ (766)
8
Operating Expenses: 3.00% $ (12,000) $ (12,360) $ (12,731) $ (13,113) $ (13,506) $ (13,911) $ (14,329) $ (14,758) $ (15,201) $ (15,657) Reversion
9
Net Operating Income: $ (600) $ (646) $ (695) $ (746) $ (799) $ (855) $ (913) $ (974) $ (1,038) $ (1,105) $ - sale proceeds
10
Debt Service: $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - balloon due
11
Net Cash Flow: $ (600) $ (646) $ (695) $ (746) $ (799) $ (855) $ (913) $ (974) $ (1,038) $ (1,105)
12
Discounted Cashflow:-$522-$489-$457-$427-$397-$370-$343-$319-$295-$273
13
14
Financing TermsInterest7%
15
DSCR: 1.25Return on Equity15%
16
LTV: 70.00%
17
Interest Rate: 5.00%use dropdown
18
Return on Equity: 3.00%use dropdown
19
Prevailing Wageuse dropdown
20
Total Development Cost: $ 800,000
21
Debt Portion: $ -
22
Equity Portion: $ -
23
Total Debt & Equity Raised: $ -
24
BUDGET GAP: $ 800,000
25
26
Affordable to household earning annual income of:
$40,000
27
28
29
30
31
32
33
34
35
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102