ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAI
1
2
Cost AssumptionsFinancing AssumptionsRevenue Assumptions
3
Purchase Price$55,000
Downpayment
20%Monthly Rent$1,250
4
Land Value (25%)$13,750
Finance Amt
$0Vacancy Rate2%
5
Building Value (75%)$41,250
Downpayment Amt
$11,000
6
Improvements$14,000
Interest Rate
5.0%CF & ROI (Outsourced PM)CF & ROI (Doing My Own PM)
7
Closing Costs$2,500
Mortgage (Years)
30Annual Cash Flow$8,699 $724.92 Annual Cash Flow$8,699
8
Total Cost $71,500
Mortgage Payment
$0Cash ROI31.63%Cash ROI31.63%
9
Cash Outlay
$27,500 Total ROI#NUM!Total ROI#NUM!
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 292045
16
Revenues
17
Rental Income
 1,250 15,000 15,300 15,606 15,918 16,236 16,561 16,892 17,230 17,575 17,926 18,285 18,651 19,024 19,404 19,792 20,188 20,592 21,004 21,424 21,852 22,289 22,735 23,190 23,653 24,127 24,609 25,101 25,603 26,115 26,638
18
Vacancy/Loss Rate
2.0%5.0%7.0%7.0%7.0%7.0%7.0%7.0%7.0%7.0%7.0%7.0%7.0%7.0%7.0%7.0%7.0%7.0%7.0%7.0%7.0%7.0%7.0%7.0%7.0%7.0%7.0%7.0%7.0%7.0%7.0%
19
Vacancy/Loss Value
(25)(750)(1,071)(1,092)(1,114)(1,137)(1,159)(1,182)(1,206)(1,230)(1,255)(1,280)(1,306)(1,332)(1,358)(1,385)(1,413)(1,441)(1,470)(1,500)(1,530)(1,560)(1,591)(1,623)(1,656)(1,689)(1,723)(1,757)(1,792)(1,828)(1,865)
20
Gross Income
 1,225 14,250 14,229 14,514 14,804 15,100 15,402 15,710 16,024 16,345 16,672 17,005 17,345 17,692 18,046 18,407 18,775 19,150 19,533 19,924 20,323 20,729 21,144 21,566 21,998 22,438 22,886 23,344 23,811 24,287 24,773
21
22
Expenses
23
Property TaxesAnnual2,231 2,231 2,276 2,321 2,368 2,415 2,463 2,512 2,563 2,614 2,666 2,720 2,774 2,829 2,886 2,944 3,003 3,063 3,124 3,186 3,250 3,315 3,381 3,449 3,518 3,588 3,660 3,733 3,808 3,884 3,962
24
InsuranceAnnual 300 300 306 312 318 325 331 338 345 351 359 366 373 380 388 396 404 412 420 428 437 446 455 464 473 483 492 502 512 522 533
25
Maintenance & RepairsAnnual 500 500 510 520 531 541 552 563 574 586 598 609 622 634 647 660 673 686 700 714 728 743 758 773 788 804 820 837 853 871 888
26
UtilitiesAnnual 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
27
AdvertisingAnnual 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
28
AdministrativeAnnual 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
Variable Cost PM (Profit Margin)(% 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
Fixed Cost PMAnnual 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
Other 1Annual 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
32
HOAMonthly 210 2,520 2,570 2,622 2,674 2,728 2,782 2,838 2,895 2,953 3,012 3,072 3,133 3,196 3,260 3,325 3,392 3,459 3,529 3,599 3,671 3,745 3,819 3,896 3,974 4,053 4,134 4,217 4,301 4,387 4,475
33
Total Expenses
 5,551 5,662 5,775 5,891 6,009 6,129 6,251 6,376 6,504 6,634 6,767 6,902 7,040 7,181 7,324 7,471 7,620 7,773 7,928 8,087 8,248 8,413 8,582 8,753 8,928 9,107 9,289 9,475 9,664 9,858
34
Expenses as % of Gross Income
42.01%44.0%44.0%44.0%44.0%44.0%44.0%44.0%44.0%44.0%44.0%44.0%44.0%44.0%44.0%44.0%44.0%44.0%44.0%44.0%44.0%44.0%44.0%44.0%44.0%44.0%44.0%44.0%44.0%44.0%
35
36
Net Operating Income (NOI)
 8,699 8,567 8,738 8,913 9,091 9,273 9,459 9,648 9,841 10,038 10,238 10,443 10,652 10,865 11,082 11,304 11,530 11,761 11,996 12,236 12,480 12,730 12,985 13,244 13,509 13,779 14,055 14,336 14,623 14,915
37
38
Cash Flow
39
NOI (Cash Available) 725 8,699 8,567 8,738 8,913 9,091 9,273 9,459 9,648 9,841 10,038 10,238 10,443 10,652 10,865 11,082 11,304 11,530 11,761 11,996 12,236 12,480 12,730 12,985 13,244 13,509 13,779 14,055 14,336 14,623 14,915
40
Mortgage 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
41
Total Cash Flow 725 8,699 8,567 8,738 8,913 9,091 9,273 9,459 9,648 9,841 10,038 10,238 10,443 10,652 10,865 11,082 11,304 11,530 11,761 11,996 12,236 12,480 12,730 12,985 13,244 13,509 13,779 14,055 14,336 14,623 14,915
42
Cash ROI31.63%31.15%31.78%32.41%33.06%33.72%34.40%35.08%35.78%36.50%37.23%37.97%38.73%39.51%40.30%41.11%41.93%42.77%43.62%44.49%45.38%46.29%47.22%48.16%49.12%50.11%51.11%52.13%53.17%54.24%
43
Equity Accrued#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
44
Total Return#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
45
Total ROI#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
46
47
Cash Flow / Mortgage Ratio
#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
48
49
50
Total Equity Accrued
#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
51
Loan Payoff Amount
#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
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