ABCDEFGHIJKLMNOPQRS
1
VariableBase CaseTarget CaseControl
2
Loan Rate7.20%6.80%6.80%Investment Amount$100,000Investor Pref7.00%Worcester50.00%
3
Refi Rate7.00%6.00%6.00%Percentage of 1st Tranche Equity2.43%Investor Split50.00%
4
Exit Cap6.50%5.50%5.50%
5
Y1 Economic Vacancy15%15%15%Key Events/Notes2024202520262027202820292030203120322033
6
Y3+ Economic Vacancy12%8%8%Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Total
7
Rent Growth Yr 1-32.50%3.00%3.00%Investment Basis$100,000$100,000$100,000$100,000$100,000$30,042$30,042$30,042$30,042$30,042
8
Rent Growth Yr 4+2.50%3.00%3.00%Investor Property Cash Flow$3,773$7,059$7,447$7,889$8,832$6,537$5,530$6,036$6,559$7,100$66,761
9
Tax Discount90%85%85%Initial Investment Returned at Sale$69,958$30,042$100,000
10
% of Utilities to RUB By Y340%50%50%Sale Proceeds$134,830$134,830
11
Total Return on Investment$3,773$7,059$7,447$7,889$78,789$6,537$5,530$6,036$6,559$171,972$301,591
12
Annual Cash on Cash Return3.77%7.06%7.45%7.89%8.83%21.76%18.41%20.09%21.83%472.44%
13
Annual Return on Investment3.77%7.06%8.90%9.45%10.01%21.76%23.53%25.53%27.61%29.76%
14
15
Total Investor Return on Investment$301,591Sale InputsSale Proceeds
16
Annual Investor Internal Rate of Return (IRR)16.40%Sale Year10Sale Price$22,561,323
17
Equity Multiple3.02NOI$1,240,873Loan Balance$9,766,366
18
Average Annual Investor Cash on Cash Return Before Sale
14.07%Cap Rate5.50%Remaining Investor Initial Investment$1,237,341
19
Average Annual Investor Cash on Cash Return After Sale
58.95%Sale Fees$451,187
20
Average Annual Investor ROI Before Sale16.74%Total Proceeds$11,106,429
21
31
33
34
35
36
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
103
104
105
106
107
108
109
110