ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
2
 CASHFLOW FRIDAY — Real Estate Deal Calculator
3
Enter numbers in the yellow cells only | All other cells calculate automatically | Built by Jahbari McLennan
4
5
6
 ▸ PROPERTY INPUTS ▸ FINANCING INPUTS
7
Purchase price ($)$290,000Down payment (%)0.0%
8
Gross monthly rent ($)$3,900Interest rate (%)7.25%
9
Operating expenses (%)33%Loan term (years)20 yrs
10
Annual appreciation (%)6.0%Target monthly cashflow ($)$300
11
12
 ▸ DEAL ANALYSIS ▸ INVESTOR RULES CHECK
13
Down payment amount ($)$01% Rule (rent/price)1.34%
14
Loan amount ($)$290,000Monthly operating expenses ($)$1,287
15
Monthly mortgage payment ($)$2,292Net Operating Income ($)$2,613
16
Monthly cashflow ($)$321Annual cashflow ($)$3,851
17
Cap rate (%)10.81%Cash-on-cash return (%)0.00%
18
Annual appreciation ($)$17,400Year 1 equity build ($)$315,664
19
20
TOTAL YEAR 1 WEALTH CREATED ($)
$336,915
Return on down payment (%)
0.0%
21
22
 ▸ DEAL VERDICT ▸ RULES SCORECARD
23
#DIV/0!
24
1% Rule (rent ÷ price ≥ 1%)✓ PASSActual: 1.34% | Need: 1.00%
25
Positive cashflow (> $0/mo)✓ PASSCashflow: $321/mo | Target: $300
26
Cap rate (≥ 6%)✓ PASSg
27
Cash-on-cash return (≥ 6%)—Enter down payment
28
29
Rules passed:3 of 4Cashflow vs target:On target ✓
30
31
 ▸ YEAR 1 WEALTH BREAKDOWN ▸ QUICK SUMMARY
32
Annual cashflow$3,851Mortgage paydown (equity)$315,664
33
Appreciation$17,400Total Year 1 return$336,915
34
Return on down pmt0.0%Down payment used$0
35
Purchase price$290,000Monthly mortgage$2,292
36
Gross monthly rent$3,900Monthly expenses$1,287
37
38
 ⚠ Educational use only. This calculator provides estimates for learning purposes. Always verify with a licensed real estate agent, CPA, and mortgage lender before investing. This is not financial advice. | CashFlow Friday by Jahbari McLennan
39
40
41
42
43
44
45
46
47
48
49
50
51
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