ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAI
1
2
Cost AssumptionsFinancing AssumptionsRevenue AssumptionsTotal Benefit (Year 1)
3
Purchase Price$400,000
Downpayment
15%Monthly Rent$5,330Cash Flow($8,692)
4
Land Value (25%)$100,000
Finance Amt
$342,125Vacancy Rate6%Equity Accrued$10,220
5
Building Value (75%)$300,000
Downpayment Amt
$60,375Tax Benefits (Depreciation)$2,618 24%
6
Improvements$0
Interest Rate
5.000%Cashflow & Returns (Year 1)Appreciation$0 0%
7
Closing Costs$2,500
Mortgage (Years)
20Annual Cash Flow($8,692)Total Benefit $4,146
8
Reserves$0
Mortgage Payment
$2,257.87Cash-On-Cash Return-14.40%Total Benefit Return6.87%
9
Total Cost $402,500
Cash Outlay
$60,375 Total Return2.53%
10
11
Year 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11Year 12Year 13Year 14Year 15Year 16Year 17Year 18Year 19Year 20Year 21Year 22Year 23Year 24Year 25Year 26Year 27Year 28Year 29Year 30
12
Annual Revenue Increase2%0.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%
13
Annual Operating Expense Increase2%0.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%
14
15
MonthlyYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10Year 11Year 12Year 13Year 14Year 15Year 16Year 17Year 18Year 19Year 20Year 21Year 22Year 23Year 24Year 25Year 26Year 27Year 28Year 29Year 30
16
Revenues
17
Rental Income
 5,330 63,960 65,239 66,544 67,875 69,232 70,617 72,029 73,470 74,939 76,438 77,967 79,526 81,117 82,739 84,394 86,082 87,803 89,559 91,351 93,178 95,041 96,942 98,881 100,858 102,876 104,933 107,032 109,172 111,356 113,583
18
Vacancy/Loss Rate
6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%
19
Vacancy/Loss Value
(320)(3,838)(3,914)(3,993)(4,072)(4,154)(4,237)(4,322)(4,408)(4,496)(4,586)(4,678)(4,772)(4,867)(4,964)(5,064)(5,165)(5,268)(5,374)(5,481)(5,591)(5,702)(5,817)(5,933)(6,052)(6,173)(6,296)(6,422)(6,550)(6,681)(6,815)
20
Gross Income
 5,010 60,122 61,325 62,551 63,802 65,078 66,380 67,708 69,062 70,443 71,852 73,289 74,755 76,250 77,775 79,330 80,917 82,535 84,186 85,870 87,587 89,339 91,125 92,948 94,807 96,703 98,637 100,610 102,622 104,675 106,768
21
22
Expenses
23
Property TaxesAnnual 5,000 5,000 5,100 5,202 5,306 5,412 5,520 5,631 5,743 5,858 5,975 6,095 6,217 6,341 6,468 6,597 6,729 6,864 7,001 7,141 7,284 7,430 7,578 7,730 7,884 8,042 8,203 8,367 8,534 8,705 8,879
24
InsuranceAnnual 5,000 5,000 5,100 5,202 5,306 5,412 5,520 5,631 5,743 5,858 5,975 6,095 6,217 6,341 6,468 6,597 6,729 6,864 7,001 7,141 7,284 7,430 7,578 7,730 7,884 8,042 8,203 8,367 8,534 8,705 8,879
25
Maintenance & RepairsAnnual 3,600 3,600 3,672 3,745 3,820 3,897 3,975 4,054 4,135 4,218 4,302 4,388 4,476 4,566 4,657 4,750 4,845 4,942 5,041 5,142 5,245 5,349 5,456 5,566 5,677 5,790 5,906 6,024 6,145 6,268 6,393
26
UtilitiesAnnual 12,000 12,000 12,240 12,485 12,734 12,989 13,249 13,514 13,784 14,060 14,341 14,628 14,920 15,219 15,523 15,834 16,150 16,473 16,803 17,139 17,482 17,831 18,188 18,552 18,923 19,301 19,687 20,081 20,483 20,892 21,310
27
WaterAnnual 4,000 4,000 4,080 4,162 4,245 4,330 4,416 4,505 4,595 4,687 4,780 4,876 4,973 5,073 5,174 5,278 5,383 5,491 5,601 5,713 5,827 5,944 6,063 6,184 6,308 6,434 6,562 6,694 6,828 6,964 7,103
28
Lawn / SnowAnnual 2,400 2,400 2,448 2,497 2,547 2,598 2,650 2,703 2,757 2,812 2,868 2,926 2,984 3,044 3,105 3,167 3,230 3,295 3,361 3,428 3,496 3,566 3,638 3,710 3,785 3,860 3,937 4,016 4,097 4,178 4,262
29
Property Management(% Income)0% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
30
Other Annual CostsAnnual 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
31
CapexMonthly 475 5,700 5,814 5,930 6,049 6,170 6,293 6,419 6,548 6,678 6,812 6,948 7,087 7,229 7,374 7,521 7,671 7,825 7,981 8,141 8,304 8,470 8,639 8,812 8,988 9,168 9,351 9,538 9,729 9,924 10,122
32
Capital CostsMonthly 335 4,020 4,100 4,182 4,266 4,351 4,438 4,527 4,618 4,710 4,804 4,900 4,998 5,098 5,200 5,304 5,410 5,519 5,629 5,742 5,856 5,974 6,093 6,215 6,339 6,466 6,595 6,727 6,862 6,999 7,139
33
Total Expenses
 41,720 42,554 43,405 44,274 45,159 46,062 46,983 47,923 48,882 49,859 50,856 51,874 52,911 53,969 55,049 56,150 57,273 58,418 59,586 60,778 61,994 63,234 64,498 65,788 67,104 68,446 69,815 71,211 72,636 74,088
34
Expenses as % of Gross Income
71.23%71.2%71.2%71.2%71.2%71.2%71.2%71.2%71.2%71.2%71.2%71.2%71.2%71.2%71.2%71.2%71.2%71.2%71.2%71.2%71.2%71.2%71.2%71.2%71.2%71.2%71.2%71.2%71.2%71.2%
35
36
Net Operating Income (NOI)
 18,402 18,770 19,146 19,529 19,919 20,318 20,724 21,139 21,561 21,993 22,432 22,881 23,339 23,805 24,282 24,767 25,263 25,768 26,283 26,809 27,345 27,892 28,450 29,019 29,599 30,191 30,795 31,411 32,039 32,680
37
38
Cash Flow
39
NOI (Cash Available) 1,534 18,402 18,770 19,146 19,529 19,919 20,318 20,724 21,139 21,561 21,993 22,432 22,881 23,339 23,805 24,282 24,767 25,263 25,768 26,283 26,809 27,345 27,892 28,450 29,019 29,599 30,191 30,795 31,411 32,039 32,680
40
Mortgage 2,258 27,094 27,094 27,094 27,094 27,094 27,094 27,094 27,094 27,094 27,094 27,094 27,094 27,094 27,094 27,094 27,094 27,094 27,094 27,094 27,094 27,094 27,094 27,094 27,094 27,094 27,094 27,094 27,094 27,094 27,094
41
Cash Flow(724)(8,692)(8,324)(7,949)(7,566)(7,175)(6,777)(6,370)(5,956)(5,533)(5,102)(4,662)(4,213)(3,756)(3,289)(2,813)(2,327)(1,832)(1,327)(811)(286) 251 797 1,355 1,924 2,505 3,097 3,700 4,316 4,945 5,585
42
Cash-on-Cash Return
-14.40%-13.79%-13.17%-12.53%-11.88%-11.22%-10.55%-9.86%-9.16%-8.45%-7.72%-6.98%-6.22%-5.45%-4.66%-3.85%-3.03%-2.20%-1.34%-0.47%0.41%1.32%2.24%3.19%4.15%5.13%6.13%7.15%8.19%9.25%
43
Equity Accrued10,22010,74311,29311,87112,47813,11613,78714,49315,23416,01416,83317,69418,59919,55120,55121,60322,70823,87025,09126,375#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
44
Equity-on-Cash Return
16.93%17.79%18.70%19.66%20.67%21.72%22.84%24.00%25.23%26.52%27.88%29.31%30.81%32.38%34.04%35.78%37.61%39.54%41.56%43.68%#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
45
Cash Flow + Equity 1,528 2,419 3,344 4,305 5,303 6,340 7,417 8,537 9,701 10,912 12,171 13,481 14,844 16,262 17,738 19,275 20,876 22,543 24,280 26,089 #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
46
Total Return
2.53%4.01%5.54%7.13%8.78%10.50%12.28%14.14%16.07%18.07%20.16%22.33%24.59%26.94%29.38%31.93%34.58%37.34%40.21%43.21%#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
47
48
Debt Service Coverage Ratio (DSCR)
0.680.690.710.720.740.750.760.780.800.810.830.840.860.880.900.910.930.950.970.991.011.031.051.071.091.111.141.161.181.21
49
50
51
Total Equity Accrued
10,22020,96432,25644,12756,60569,72183,50998,002113,236129,250146,083163,777182,376201,927222,479244,081266,789290,659315,750342,125#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
52
Loan Payoff Amount
$331,905$321,161$309,869$297,998$285,520$272,404$258,616$244,123$228,889$212,875$196,042$178,348$159,749$140,198$119,646$98,044$75,336$51,466$26,375$0#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
53
54
55
Capital ExpensesCapital Expenses
56
ComponentLifespan
Replacement
Annual Cost
ComponentMethodMonthlyYearly
57
Roof25 $ 25,000.00 $ 1,000.00 Unit 1Airbnb $ 1,000.00 $ 12,000.00
58
HVAC 20 $ 25,000.00 $ 1,250.00 Unit 2Tenant $ 570.00 $ 6,840.00
59
H2O Heater10 $ 3,000.00 $ 300.00 Unit 3Tenant $ 750.00 $ 9,000.00
60
Electric40 $ 25,000.00 $ 625.00 Unit 4Tenant $ 550.00 $ 6,600.00
61
Plumbing40 $ 25,000.00 $ 625.00 Unit 5Tenant $ 490.00 $ 5,880.00
62
Appliances15 $ 16,000.00 $ 1,066.67 Unit 6Tenant $ 470.00 $ 5,640.00
63
Siding30 $ 25,000.00 $ 833.33 Unit 7Tenant $ 600.00 $ 7,200.00
64
Annual Average Cost
 $ 5,700.00 Unit 8Tenant $ 900.00 $ 10,800.00
65
Monthly Average Cost
 $ 475.00 Gross $ 5,330.00 $ 63,960.00
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