Midwest Duplex Analysis
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJ
1
Learn more at The Frugal Vagabond (http://frugalvagabond.com)
Select File->Make a Copy... to save to your own drive and edit
2
3
Cost AssumptionsFinancing AssumptionsRevenue AssumptionsInsurance AssumptionsUnit AssumptionsClosing Costs Totalled
4
Purchase Price$65,000
Downpayment
25%Monthly Rent per unit$638Square Footage2,000Number of Units2Loan Due at Closing$3,251
5
Land Value (25%)$16,250
Finance Amt
$48,750Vacancy Rate10%$/per square foot/year$0.45Average Tenant Stay in years2Seller Paid Ins($187)
6
Building Value (75%)$48,750
Downpayment Amt
$16,250Assessment Value over Market23.00%Cash Back at Closing($500)
7
Improvements$2,140
Interest Rate
4.625%CF & ROI (Outsourced PM)CF & ROI (Doing My Own PM)Tax Rate68.00
8
Closing Costs$2,564
Mortgage (Years)
30Annual Cash Flow$3,205 Annual Cash Flow$4,582 Reduction Factor0.196156
9
Total Cost $69,704
Mortgage Payment
$251Cash ROI15.30%Cash ROI21.87%Total Closing Costs$2,564
10
Cash Outlay
$20,954 Total ROI18.97%Total ROI23.72%
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
30 Year Totals
17
Revenues
18
Rental Income
1,275 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 27,170 620,692
19
Vacancy/Loss Rate
10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%10.0%
20
Vacancy/Loss Value
(128)(1,530)(1,561)(1,592)(1,624)(1,656)(1,689)(1,723)(1,757)(1,793)(1,828)(1,865)(1,902)(1,940)(1,979)(2,019)(2,059)(2,100)(2,142)(2,185)(2,229)(2,273)(2,319)(2,365)(2,413)(2,461)(2,510)(2,560)(2,612)(2,664)(2,717)(62,197)
21
Gross Income
1,148 13,770 14,045 14,326 14,613 14,905 15,203 15,507 15,817 16,134 16,456 16,786 17,121 17,464 17,813 18,169 18,533 18,903 19,281 19,667 20,060 20,461 20,871 21,288 21,714 22,148 22,591 23,043 23,504 23,974 24,453 559,770
22
23
Expenses
24
Property TaxesAnnual 1,551 1,551 1,582 1,613 1,646 1,678 1,712 1,746 1,781 1,817 1,853 1,890 1,928 1,967 2,006 2,046 2,087 2,129 2,171 2,215 2,259 2,304 2,350 2,397 2,445 2,494 2,544 2,595 2,647 2,700 2,754 64,456
25
InsuranceAnnual 904 904 922 941 959 979 998 1,018 1,038 1,059 1,080 1,102 1,124 1,146 1,169 1,193 1,217 1,241 1,266 1,291 1,317 1,343 1,370 1,398 1,426 1,454 1,483 1,513 1,543 1,574 1,605 37,578
26
Maintenance & RepairsAnnual 689 689 702 716 731 745 760 775 791 807 823 839 856 873 891 908 927 945 964 983 1,003 1,023 1,044 1,064 1,086 1,107 1,130 1,152 1,175 1,199 1,223 28,620
27
Variable Cost PM(% Income)10% 1,377 1,405 1,433 1,461 1,491 1,520 1,551 1,582 1,613 1,646 1,679 1,712 1,746 1,781 1,817 1,853 1,890 1,928 1,967 2,006 2,046 2,087 2,129 2,171 2,215 2,259 2,304 2,350 2,397 2,445 55,862
28
Tenant Placement Fee (per unit)Annual 638 650 650 663 677 690 704 718 732 747 762 777 793 809 825 841 858 875 893 911 929 947 966 986 1,005 1,025 1,046 1,067 1,088 1,110 1,132 26,512
29
Annual Tuneup/InspectionAnnual 130 130 133 135 138 141 144 146 149 152 155 158 162 165 168 172 175 178 182 186 189 193 197 201 205 209 213 218 222 226 231 5,404
30
Sewer Service (per unit)Monthly 33 800 800 816 832 849 866 883 901 919 937 956 975 995 1,014 1,035 1,055 1,077 1,098 1,120 1,142 1,165 1,189 1,212 1,237 1,261 1,287 1,312 1,339 1,365 1,393 31,864
31
Lease Renewal FeeAnnual 195 195 199 203 207 211 215 220 224 228 233 238 242 247 252 257 262 268 273 279 284 290 296 301 307 314 320 326 333 339 346 8,106
32
Water (per unit)Monthly 33 800 816 832 849 866 883 901 919 937 956 975 995 1,014 1,035 1,055 1,077 1,098 1,120 1,142 1,165 1,189 1,212 1,237 1,261 1,287 1,312 1,339 1,365 1,393 1,421 32,485
33
Lawn Care (7 months)Monthly 66 462 471 481 490 500 510 520 531 541 552 563 574 586 598 610 622 634 647 660 673 687 700 714 729 743 758 773 789 804 820 18,808
34
Total Expenses
7,557 7,679 7,833 7,990 8,149 8,312 8,479 8,648 8,821 8,998 9,178 9,361 9,548 9,739 9,934 10,133 10,335 10,542 10,753 10,968 11,187 11,411 11,639 11,872 12,110 12,352 12,599 12,851 13,108 13,370 305,456
35
Expenses as % of Gross Income
59.39%59.2%59.2%59.2%59.2%59.2%59.2%59.2%59.2%59.2%59.2%59.2%59.2%59.2%59.2%59.2%59.2%59.2%59.2%59.2%59.2%59.2%59.2%59.2%59.2%59.2%59.2%59.2%59.2%59.2%59.23%
36
37
Net Operating Income (NOI)
6,213 6,366 6,493 6,623 6,756 6,891 7,029 7,169 7,313 7,459 7,608 7,760 7,915 8,074 8,235 8,400 8,568 8,739 8,914 9,092 9,274 9,460 9,649 9,842 10,039 10,239 10,444 10,653 10,866 11,083 253,166
38
39
Cash Flow
40
NOI (Cash Available) 518 6,213 6,366 6,493 6,623 6,756 6,891 7,029 7,169 7,313 7,459 7,608 7,760 7,915 8,074 8,235 8,400 8,568 8,739 8,914 9,092 9,274 9,460 9,649 9,842 10,039 10,239 10,444 10,653 10,866 11,083 253,684
41
Mortgage 251 3,008 3,008 3,008 3,008 3,008 3,008 3,008 3,008 3,008 3,008 3,008 3,008 3,008 3,008 3,008 3,008 3,008 3,008 3,008 3,008 3,008 3,008 3,008 3,008 3,008 3,008 3,008 3,008 3,008 3,008 90,482
42
Total Cash Flow 267 3,205 3,358 3,486 3,616 3,748 3,883 4,021 4,161 4,305 4,451 4,600 4,752 4,908 5,066 5,227 5,392 5,560 5,732 5,906 6,085 6,266 6,452 6,641 6,834 7,031 7,232 7,436 7,645 7,858 8,076 163,202
43
Cash ROI15.30%16.03%16.63%17.25%17.89%18.53%19.19%19.86%20.54%21.24%21.95%22.68%23.42%24.18%24.95%25.73%26.54%27.35%28.19%29.04%29.91%30.79%31.69%32.61%33.55%34.51%35.49%36.49%37.50%38.54%25.96%
44
% Profit1.65%1.68%1.71%1.75%1.78%1.82%1.85%1.89%1.93%1.97%2.01%2.05%2.09%2.13%2.17%2.22%2.26%2.31%2.35%2.40%2.45%2.50%2.55%2.60%2.65%2.70%2.75%2.81%2.87%2.92%2.23%
45
Equity Accrued7698068448839259691,0151,0631,1131,1651,2201,2781,3381,4021,4681,5371,6101,6861,7661,8491,9362,0282,1242,2242,3292,4392,5542,6752,8012,934 48,750
46
Total Return 3,975 4,164 4,329 4,499 4,673 4,852 5,036 5,224 5,418 5,617 5,821 6,031 6,246 6,468 6,695 6,929 7,170 7,417 7,672 7,934 8,203 8,480 8,765 9,058 9,360 9,671 9,991 10,320 10,660 11,009 211,685
47
Total ROI18.97%19.87%20.66%21.47%22.30%23.16%24.03%24.93%25.86%26.80%27.78%28.78%29.81%30.87%31.95%33.07%34.22%35.40%36.61%37.86%39.15%40.47%41.83%43.23%44.67%46.15%47.68%49.25%50.87%52.54%33.67%
48
49
Cash Flow / Mortgage Ratio
207%212%216%220%225%229%234%238%243%248%253%258%263%268%274%279%285%291%296%302%308%315%321%327%334%340%347%354%361%369%
50
51
52
Total Equity Accrued
7691,5752,4183,3024,2275,1966,2117,2738,3869,55110,77212,05013,38814,79016,25817,79519,40521,09122,85724,70626,64228,67030,79433,01835,34737,78640,34043,01545,81648,750
53
Loan Payoff Amount
$47,981$47,175$46,332$45,448$44,523$43,554$42,539$41,477$40,364$39,199$37,978$36,700$35,362$33,960$32,492$30,955$29,345$27,659$25,893$24,044$22,108$20,080$17,956$15,732$13,403$10,964$8,410$5,735$2,934$0
54
55
Loading...
 
 
 
SFH ANALYSIS