Cash Flow Calculator
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ACDEFGHIJKLMOPQRSTU
1
yellow = ENTERred = NO ENTERgreen = LABEL
2
3
Rental Property12345678910
4
Name5105 N 410 WBig BearAshley Avenue
5
Info4 Bed, 3 Bath - 2900 Sq Ft. 4 Bed 3 Bath
2500 Sq Ft.
6
address5105 N 410 W
7
INCOME
8
Room Rents12345678910
9
room A$1,300$1,200$850
10
room B$500
11
room C
12
room D
13
room E
14
room F
15
room G
16
room H
17
Total$1,800$1,200$850$0$0$0$0$0$0$0
18
vacancy rate /yr8%8%8%7%7%7%7%7%7%7%
19
Rent Total /mo$1,650$1,100$779$0$0$0$0$0$0$0
20
Total Rooms411
21
22
EXPENSES
23
Costs12345678910
24
advertising /yr$0$0$0
25
exterior costs /yr $250$250$250
26
gas electric /yr$1,200$1,200$1,200
27
heating fuel /yr$600$1,200$1,200
28
improvements /yr$1,000$1,000$1,000
29
insurance /yr$1,200$1,200$1,200
30
leasing management fees /yr$0$0$0
31
property management fees /yr$0$0$0
32
repairs /yr$1,000$1,000$1,000
33
supplies /yr$100$100$100
34
taxes /yr$1,782$1,485$2,079
35
trash /yr$0$0$0
36
water sewer /yr$0$0$0
37
Total Costs /mo$594$620$669$0$0$0$0$0$0$0
38
39
CASH FLOW
40
Investment12345678910
41
buy price $$330,000$275,000$385,000
42
down %5%5%5%20%20%20%20%20%20%20%
43
down $$16,500$13,750$19,250$0$0$0$0$0$0$0
44
closing $$9,900$8,250$11,550$0$0$0$0$0$0$0
45
initial invest$56,400$62,000$30,800$0$0$0$0$0$0$0
46
current loan $$313,500$261,250$365,750$0$0$0$0$0$0$0
47
loan %rate4.500%4.500%4.500%0.000%0.000%0.000%0.000%0.000%0.000%0.000%
48
loan term yrs30303030303030303030
49
p&i $/mo$1,588$1,324$1,853$0$0$0$0$0$0$0
50
PMI$130.63$131$183$0$0$0$0$0$0$0
51
Total w/PMI$1,719$1,454$2,036$0$0$0$0$0$0$0
52
53
Income12345678910
54
max rent /mo$1,800$1,200$850$0$0$0$0$0$0$0
55
avg rent /mo$1,650$1,100$779$0$0$0$0$0$0$0
56
57
SUMMARY12345678910
58
Total Income /mo$1,650$1,100$779$0$0$0$0$0$0$0
59
less P&I (&PMI)/mo$1,719$1,454$2,036$0$0$0$0$0$0$0
60
less Costs /mo$594$620$669$0$0$0$0$0$0$0
61
PITI$1,968$1,678$2,309$0$0$0$0$0$0$0
62
Monthly Flow-$663-$974-$1,926$0$0$0$0$0$0$0
63
64
3 RETURNs on
65
annual cash flow-$7,961-$11,687-$23,112$0$0$0$0$0$0$0
66
initial investment$56,400$62,000$30,800$0$0$0$0$0$0$0
67
Cash-on-Cash Return-14%-19%-75%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
68
69
annual principal$5,057$4,215$5,900#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
70
initial investment$56,400$62,000$30,800$0$0$0$0$0$0$0
71
Return9%7%19%#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
72
73
appreciation %/yr2%2%1%1%1%1%1%1%1%1%
74
buy price$330,000$275,000$385,000
75
appreciation $/yr$6,600$5,500$3,850$0$0$0$0$0$0$0
76
initial investment$56,400$62,000$30,800$0$0$0$0$0$0$0
77
Return12%9%13%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
78
total ROI % /yr7%-3%-43%#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
79
total ROI $ /yr$3,696-$1,973-$13,362#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
80
81
Total Income /mo$1,650$1,100$779$0$0$0$0$0$0$0
82
83
address5105 N 410 W
84
Name5105 N 410 WBig BearAshley Avenue
85
Rental Property12345678910
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu