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

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
INPUTAddress:
2
3
AssumptionsCashflow AnalysisThe Facts20 Year Profitability AnalysisAmortization Table
4
Purchase Price$325,000 MonthAnnualOperating Expenses$1,231 YearProp ValueApprecDebt ReducCashflowTotal ReturnCum ReturnEquityMonthBeg BalanceInterestPrincipalEnd Balance
5
Down Payment$81,250 25.0%Rents - Unit 1$1,600 $19,200 Mortgage Payment$1,309 1$331,500 $6,500 $3,596 $6,132 $16,228 $16,228 $91,346 1$243,750 $1,015.63 $292.88 $243,457
6
Loan Amount$243,750 Rents - Unit 2$1,450 $17,400
Total Monthly Expenses
$2,539 2$338,130 $6,630 $3,780 $6,255 $16,665 $32,893 $101,756 2$243,457 $1,014.40 $294.10 $243,163
7
Interest Rate5.00%Rents - Unit 3$0 Monthly Income$3,050 3$344,893 $6,763 $3,974 $6,380 $17,116 $50,009 $112,493 3$243,163 $1,013.18 $295.32 $242,868
8
Terms (Months)360Rents - Unit 4$0 Monthly Cashflow$511 4$351,790 $6,898 $4,177 $6,507 $17,582 $67,591 $123,567 4$242,868 $1,011.95 $296.55 $242,571
9
Mortgage$1,309 Total Rents$3,050 $36,600 NOI$1,820 5$358,826 $7,036 $4,391 $6,637 $18,064 $85,655 $134,994 5$242,571 $1,010.71 $297.79 $242,273
10
PMI$0.00 Mortgage$1,309 $15,702 Cap Rate6.7%6$366,003 $7,177 $4,615 $6,770 $18,562 $104,217 $146,785 6$242,273 $1,009.47 $299.03 $241,974
11
Closing Costs$9,750 3.0%Taxes$360 $4,316 Total Cash Needed$91,000 7$373,323 $7,320 $4,851 $6,906 $19,077 $123,294 $158,957 7$241,974 $1,008.23 $300.28 $241,674
12
Initial Repairs$0 Insurance$133 $1,600 Cash on Cash ROI6.7%8$380,789 $7,466 $5,100 $7,044 $19,610 $142,903 $171,523 8$241,674 $1,006.98 $301.53 $241,373
13
After Repair Value$325,000 Water$0 $0 Rents %0.94%9$388,405 $7,616 $5,360 $7,185 $20,161 $163,064 $184,499 9$241,373 $1,005.72 $302.78 $241,070
14
Apprec Rate2%Electric $0 $0 Gross Rent Multiplier 8.9 10$396,173 $7,768 $5,635 $7,328 $20,731 $183,795 $197,902 10$241,070 $1,004.46 $304.05 $240,766
15
Rent Incr2%Gas$0 $0 11$404,097 $7,923 $5,923 $7,475 $21,321 $205,117 $211,748 11$240,766 $1,003.19 $305.31 $240,460
16
Garbage$0 $0 12$412,179 $8,082 $6,226 $7,624 $21,932 $227,049 $226,056 12$240,460 $1,001.92 $306.58 $240,154
17
Management$260 $3,120 13$420,422 $8,244 $6,545 $7,777 $22,565 $249,614 $240,844 13$240,154 $1,000.64 $307.86 $239,846
18
Minor Repairs$75 $900 14$428,831 $8,408 $6,879 $7,932 $23,220 $272,834 $256,132 14$239,846 $999.36 $309.14 $239,537
19
Vacancy$122 4%$1,464 15$437,407 $8,577 $7,231 $8,091 $23,899 $296,733 $271,940 15$239,537 $998.07 $310.43 $239,226
20
Capital Exp.$250 $3,000 16$446,155 $8,748 $7,601 $8,253 $24,602 $321,335 $288,290 16$239,226 $996.78 $311.73 $238,915
21
Misc.$31 1%$366 17$455,078 $8,923 $7,990 $8,418 $25,331 $346,666 $305,203 17$238,915 $995.48 $313.03 $238,602
22
Total Costs$2,539 $30,468 18$464,180 $9,102 $8,399 $8,586 $26,087 $372,753 $322,704 18$238,602 $994.17 $314.33 $238,287
23
Cashflow$511 $6,132 19$473,464 $9,284 $8,829 $8,758 $26,870 $399,623 $340,816 19$238,287 $992.86 $315.64 $237,972
24
20$482,933 $9,469 $9,280 $8,933 $27,683 $427,306 $359,566 20$237,972 $991.55 $316.95 $237,655
25
Disclaimer: All amounts including operating, financing, and evaluation are estimates. Results are not guaranteed.21$237,655 $990.23 $318.27 $237,336
26
22$237,336 $988.90 $319.60 $237,017
27
23$237,017 $987.57 $320.93 $236,696
28
24$236,696 $986.23 $322.27 $236,374
29
25$236,374 $984.89 $323.61 $236,050
30
26$236,050 $983.54 $324.96 $235,725
31
27$235,725 $982.19 $326.32 $235,399
32
28$235,399 $980.83 $327.67 $235,071
33
29$235,071 $979.46 $329.04 $234,742
34
30$234,742 $978.09 $330.41 $234,412
35
31$234,412 $976.71 $331.79 $234,080
36
32$234,080 $975.33 $333.17 $233,747
37
33$233,747 $973.94 $334.56 $233,412
38
34$233,412 $972.55 $335.95 $233,076
39
35$233,076 $971.15 $337.35 $232,739
40
36$232,739 $969.74 $338.76 $232,400
41
37$232,400 $968.33 $340.17 $232,060
42
38$232,060 $966.92 $341.59 $231,718
43
39$231,718 $965.49 $343.01 $231,375
44
40$231,375 $964.06 $344.44 $231,031
45
41$231,031 $962.63 $345.87 $230,685
46
42$230,685 $961.19 $347.32 $230,338
47
43$230,338 $959.74 $348.76 $229,989
48
44$229,989 $958.29 $350.22 $229,639
49
45$229,639 $956.83 $351.68 $229,287
50
46$229,287 $955.36 $353.14 $228,934
51
47$228,934 $953.89 $354.61 $228,579
52
48$228,579 $952.41 $356.09 $228,223
53
49$228,223 $950.93 $357.57 $227,866
54
50$227,866 $949.44 $359.06 $227,506
55
51$227,506 $947.94 $360.56 $227,146
56
52$227,146 $946.44 $362.06 $226,784
57
53$226,784 $944.93 $363.57 $226,420
58
54$226,420 $943.42 $365.08 $226,055
59
55$226,055 $941.90 $366.61 $225,689
60
56$225,689 $940.37 $368.13 $225,320
61
57$225,320 $938.84 $369.67 $224,951
62
58$224,951 $937.30 $371.21 $224,580
63
59$224,580 $935.75 $372.75 $224,207
64
60$224,207 $934.20 $374.31 $223,833
65
61$223,833 $932.64 $375.87 $223,457
66
62$223,457 $931.07 $377.43 $223,079
67
63$223,079 $929.50 $379.01 $222,700
68
64$222,700 $927.92 $380.59 $222,320
69
65$222,320 $926.33 $382.17 $221,937
70
66$221,937 $924.74 $383.76 $221,554
71
67$221,554 $923.14 $385.36 $221,168
72
68$221,168 $921.53 $386.97 $220,781
73
69$220,781 $919.92 $388.58 $220,393
74
70$220,393 $918.30 $390.20 $220,003
75
71$220,003 $916.68 $391.83 $219,611
76
72$219,611 $915.04 $393.46 $219,217
77
73$219,217 $913.41 $395.10 $218,822
78
74$218,822 $911.76 $396.74 $218,425
79
75$218,425 $910.11 $398.40 $218,027
80
76$218,027 $908.45 $400.06 $217,627
81
77$217,627 $906.78 $401.72 $217,225
82
78$217,225 $905.11 $403.40 $216,822
83
79$216,822 $903.42 $405.08 $216,417
84
80$216,417 $901.74 $406.77 $216,010
85
81$216,010 $900.04 $408.46 $215,602
86
82$215,602 $898.34 $410.16 $215,191
87
83$215,191 $896.63 $411.87 $214,780
88
84$214,780 $894.91 $413.59 $214,366
89
85$214,366 $893.19 $415.31 $213,951
90
86$213,951 $891.46 $417.04 $213,534
91
87$213,534 $889.72 $418.78 $213,115
92
88$213,115 $887.98 $420.52 $212,694
93
89$212,694 $886.23 $422.28 $212,272
94
90$212,272 $884.47 $424.04 $211,848
95
91$211,848 $882.70 $425.80 $211,422
96
92$211,422 $880.93 $427.58 $210,995
97
93$210,995 $879.14 $429.36 $210,565
98
94$210,565 $877.36 $431.15 $210,134
99
95$210,134 $875.56 $432.94 $209,701
100
96$209,701 $873.75 $434.75 $209,266
Loading...