ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAI
1
2
Cost AssumptionsFinancing AssumptionsRevenue Assumptions
3
Purchase Price$169,000
Downpayment
20%Monthly Rent$3,000
4
Land Value (25%)$42,250
Finance Amt
$144,200Vacancy Rate5%
ONLY CHANGE YELLOW CELLS!
5
Building Value (75%)$126,750
Downpayment Amt
$33,800
6
Improvements$10,000
Interest Rate
6.50%CF & ROI (Outsourced PM)
7
Closing Costs$5,000
Mortgage (Years)
30Annual Cash Flow$20,613
8
Total Cost $184,000
Mortgage Payment
$911Cash ROI42.24%
9
Cash Outlay
$48,800 Total ROI45.54%
10
CAP Rate17.15%
11
12
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
13
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%
14
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%
15
16
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
17
Revenues
18
Rental Income
$3,000$36,000$36720.00$37454.40$38203.49$38967.56$39746.91$40541.85$41352.68$42179.74$43023.33$43883.80$44761.48$45656.70$46569.84$47501.24$48451.26$49420.29$50408.69$51416.86$52445.20$53494.11$54563.99$55655.27$56768.37$57903.74$59061.82$60243.05$61447.91$62676.87$63930.41
19
Vacancy/Loss Rate
5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%
20
Vacancy/Loss Value
-$150.00-$1800.0-$1836.0-$1872.7-$1910.2-$1948.4-$1987.3-$2027.1-$2067.6-$2109.0-$2151.2-$2194.2-$2238.1-$2282.8-$2328.5-$2375.1-$2422.6-$2471.0-$2520.4-$2570.8-$2622.3-$2674.7-$2728.2-$2782.8-$2838.4-$2895.2-$2953.1-$3012.2-$3072.4-$3133.8-$3196.5
21
Gross Income
$2,850$34200.00$34884.00$35581.68$36293.31$37019.18$37759.56$38514.75$39285.05$40070.75$40872.17$41689.61$42523.40$43373.87$44241.35$45126.17$46028.70$46949.27$47888.26$48846.02$49822.94$50819.40$51835.79$52872.50$53929.95$55008.55$56108.73$57230.90$58375.52$59543.03$60733.89
22
23
Expenses
24
Property TaxesAnnual400 400 408 416 424 433 442 450 459 469 478 488 497 507 517 528 538 549 560 571 583 594 606 618 631 643 656 669 683 696 710
25
InsuranceAnnual400 400 408 416 424 433 442 450 459 469 478 488 497 507 517 528 538 549 560 571 583 594 606 618 631 643 656 669 683 696 710
26
Maintenance & RepairsAnnual50 50 51 52 53 54 55 56 57 59 60 61 62 63 65 66 67 69 70 71 73 74 76 77 79 80 82 84 85 87 89
27
Electric & GasAnnual0 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
28
W/SAnnual0 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
29
TrashAnnual0 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
Variable Cost PM(% 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
31
Fixed Cost PMAnnual0 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
32
Other 1Annual0 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
33
CapEX(% Income)5%$1800$1836.00$1872.72$1910.17$1948.38$1987.35$2027.09$2067.63$2108.99$2151.17$2194.19$2238.07$2282.84$2328.49$2375.06$2422.56$2471.01$2520.43$2570.84$2622.26$2674.71$2728.20$2782.76$2838.42$2895.19$2953.09$3012.15$3072.40$3133.84$3196.52
34
Total Expenses
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,497 3,567 3,638 3,711 3,785 3,861 3,938 4,017 4,097 4,179 4,262 4,348 4,435 4,523 4,614 4,706
35
Expenses as % of Gross Income
12.36%12.4%12.4%12.4%12.4%12.4%12.4%12.4%12.4%12.4%12.4%12.4%12.4%12.4%12.4%12.4%12.4%12.4%12.4%12.4%12.4%12.4%12.4%12.4%12.4%12.4%12.4%12.4%12.4%12.4%
36
37
Net Operating Income (NOI)
31,550 32,181 32,825 33,481 34,151 34,834 35,530 36,241 36,966 37,705 38,459 39,228 40,013 40,813 41,630 42,462 43,311 44,178 45,061 45,962 46,882 47,819 48,776 49,751 50,746 51,761 52,796 53,852 54,929 56,028
38
39
Cash Flow
40
NOI (Cash Available)2,629 31,550 32,181 32,825 33,481 34,151 34,834 35,530 36,241 36,966 37,705 38,459 39,228 40,013 40,813 41,630 42,462 43,311 44,178 45,061 45,962 46,882 47,819 48,776 49,751 50,746 51,761 52,796 53,852 54,929 56,028
41
Mortgage$911$10,937$10,937$10,937$10,937$10,937$10,937$10,937$10,937$10,937$10,937$10,937$10,937$10,937$10,937$10,937$10,937$10,937$10,937$10,937$10,937$10,937$10,937$10,937$10,937$10,937$10,937$10,937$10,937$10,937$10,937
42
Total Cash Flow1,718 20,613 21,244 21,887 22,544 23,213 23,896 24,593 25,304 26,029 26,768 27,522 28,291 29,076 29,876 30,692 31,525 32,374 33,240 34,124 35,025 35,944 36,882 37,838 38,814 39,809 40,824 41,859 42,915 43,992 45,091
43
Cash ROI42.24%43.53%44.85%46.20%47.57%48.97%50.40%51.85%53.34%54.85%56.40%57.97%59.58%61.22%62.89%64.60%66.34%68.12%69.93%71.77%73.66%75.58%77.54%79.54%81.58%83.66%85.78%87.94%90.15%92.40%
44
Equity Accrued1,6121,7201,8351,9582,0892,2292,3782,5372,7072,8893,0823,2883,5093,7443,9944,2624,5474,8525,1775,5235,8936,2886,7097,1587,6388,1498,6959,2779,89910,562
45
Total Return22,224 22,963 23,722 24,502 25,302 26,125 26,971 27,841 28,736 29,656 30,604 31,580 32,584 33,620 34,687 35,787 36,921 38,092 39,301 40,548 41,838 43,170 44,547 45,972 47,447 48,973 50,554 52,192 53,891 55,652
46
Total ROI45.54%47.06%48.61%50.21%51.85%53.54%55.27%57.05%58.88%60.77%62.71%64.71%66.77%68.89%71.08%73.33%75.66%78.06%80.53%83.09%85.73%88.46%91.29%94.21%97.23%100.35%103.59%106.95%110.43%114.04%
47
48
Cash Flow / Mortgage Ratio
288%294%300%306%312%318%325%331%338%345%352%359%366%373%381%388%396%404%412%420%429%437%446%455%464%473%483%492%502%512%
49
50
51
Total Equity Accrued
1,6123,3315,1667,1249,21311,44213,82016,35719,06421,95325,03528,32331,83235,57539,57043,83248,37953,23158,40763,93169,82476,11282,82189,98097,617105,767114,462123,739133,638144,200
52
Loan Payoff Amount
$142,588$140,869$139,034$137,076$134,987$132,758$130,380$127,843$125,136$122,247$119,165$115,877$112,368$108,625$104,630$100,368$95,821$90,969$85,793$80,269$74,376$68,088$61,379$54,220$46,583$38,433$29,738$20,461$10,562$0
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