1% Deal Calculator

	A	B	C	D	E	H	I	K	L
1	RENTAL PROPERTY CALCULATOR
2	Download this template and input your numbers
3
4		Unit Breakdown				Present Pro Forma Analysis
5
6		Unit #	#Beds	Rent/Mo	Market Rent	Item	$/Mo.	Mortgage Calculator
7		1	2	$ 2,000.00	$ 2,000.00	Gross Rents	$ 6,000.00	Property Value	$ 615,000.00
8		2	2	$ 2,000.00	$ 2,000.00	Property Mgmt (9%)	$ 600.00	Loan to Value Ratio	0.8
9		3	2	$ 2,000.00	$ 2,000.00	Property Taxes	$ 500.00	Down Payment	$ 123,000.00
10						Insurance	$ 100.00	Closing Costs	$ -
11						Owner-Paid Utilities	$ 120.00	Principal	$ 492,000.00
12						Vacancy Reserve (5%)	$ 300.00	Interest Rate	0.0599
13						Maintenance Reserve (10%)	$ 600.00	Term (Years)	30
14						Total Operating Expenses	$ 2,220.00	Monthly Mortgage	$ 2,946.63
15					$ -	Monthly NOI	$ 3,780.00	Monthly Net	$ 833.37
16		Totals		$ 6,000.00	$ -	Annualized NOI	$ 45,360.00	Annualized Net	$ 10,000.49
17						Capitalization Rate	7.38%	Annualized ROI	8.13%
18		Does it qualify for a loan?
19						Stabilized Pro Forma Analysis
20				Pro Forma	Actual
21		Gross Rents		$72,000.00	$72,000.00	Item	$/Mo.	Mortgage Calculator
22		Lender Vacancy (10%)		$7,200.00	$7,200.00	Gross Potential Rents	$ 6,000.00	Property Value	$ 615,000.00
23		Property Management (10%)		$7,200.00	$7,200.00	Property Mgmt (10%)	$ 600.00	Loan to Value Ratio	0.8
24		Cash Res (3%)		$2,160.00	$2,160.00	Property Taxes	$ 500.00	Down Payment	$ 123,000.00
25		Taxes (actual)		$6,000.00	$6,000.00	Insurance	$ 100.00	Closing Costs
26		Ins (actual)		$1,200.00	$1,200.00	Owner-Paid Utilities	$ 120.00	Principal	$ 492,000.00
27		Util + Rep (20% or actual)		$14,400.00	$8,640.00	Vacancy Reserve (5%)	$ 300.00	Interest Rate	0.0599
28		Total Expenses		$38,160.00	$32,400.00	Maintenance Reserve (10%)	$ 600.00	Term (Years)	30
29		NOI		$33,840.00	$39,600.00			Monthly Mortgage	$ 2,946.63
30		Mortgage		$35,359.51	$35,359.51	Monthly NOI	$ 3,780.00	Monthly Net	$ 833.37
31						Annualized NOI	$ 45,360.00	Annualized Net	$ 10,000.49
32						Capitalization Rate	7.38%	Annualized ROI	8.13%
33		DSCR (lender requires 1.25)		0.96	1.12
34		Net Profit		-$1,519.51	$4,240.49
35
36
37
38
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