Pro Forma - TEMPLATE - Google Sheets

	A	B	C
1	Pro Forma
2		Projected Cash Flows
3	RENTAL INCOME	$22,200.00	Monthly Rent $1850 total
4	LAUNDRY INCOME	0.00
5
6	TOTAL INCOME	22200.00
7
8	TAXES	0.00	True taxes
9	WATER	600.00	*estimate
10	TRASH/ASSOC.	0.00	*estimate
11	INSURANCE	1000.00	*estimate
12	ELECTRIC	0.00	*estimate
13	HEAT	0.00	*estimate
14	MORTGAGE	12476.04	*estimate
15	Management Fee	2220.00
16
17	TOTAL EXPENSES	16296.04
18	CASH FLOW	$5,903.96
19
20
21	Pro Forma
22	INCOME APPROACH
23	INCOME
24	LESS 5% VAC	21090.00
25
26	EXPENSE
27	MAINT 5%	1110.00
28	CAP IMP 10%	2220.00
29	ALL OTHER	1600.00
30	ADDESCROW	0.00
31
32	TOTAL EXP	4930.00
33
34	NET OPERATING	16160.00
35
36	INC APP MARKET VALUE	$248,615.38
37	CAP RATE	6.50%	What is 'Cap Rate'? https://www.investopedia.com/terms/c/capitalizationrate.asp
38
39	Estimated Closing Month	1.00
40	DOWN PAYMENT	$62,153.85	At 25% down
41	Estimated CLOSING COSTS	$1,150.00	Attorney fee, home inspection, prorated taxes
42
43	CASH ON CASH RETURN	9.33%	What is Cash On Cash Return? https://www.investopedia.com/terms/c/cashoncashreturn.asp
44
45
46
47
48	Information deemed reliable but not guaranteed.
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