Investment Property Analysis Worksheet

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1								Unit	Rent	Doors	BD/BR	Property Reference links (update url with your prop):
2	Gross scheduled rental income						$110,400	1	$1,800	1	2/1	Realtor . com	click
3	Plus other income (garages, laundry, etc)						$0	2	$1,800	1	2/1	Zillow	click
4	Total gross income						$110,400	3	$1,400	1	1/1	Trulia	click
5	Vacancy and credit losses (+tenant placement)				8.00%	$4,600	$13,432	4	$1,400	1	1/1	Loopnet	click
6	Gross Operating Income						$96,968	5	$1,400	1	1/1	City Tax DB	click
7	Less operating expenses							6	$1,400	1	1/1	Rentometer	click
8		Accounting and legal				$0		7
9		Advertising, licenses and fees				$0		8				Legend:
10		Property insurance				$5,000		9				Calculated Field
11		Payroll				$0		10				Manual Entry Field
12		Personal property tax				$0		11				Important Calculated Field
13		County taxes				$5,000		12
14		Village taxes				$5,000			$9,200	6
15		School taxes				$4,000
16		Repairs and maintenance			7.00%	$6,788
17		Property management			10.00%	$11,040
18		Services / Utilities							KPI			Other costs	Price	Notes
19			Electric			$1,200			PITI	$5,427		exterior	$0
20			Gas / oil			$0			Expenses/Mon	$3,629		interior	$0
21			Water / sewer			$500			Repair/CapEx	$404		lowes/home depot trips	$0
22			HVAC Annual Svc			$175			$/Month/Door	$101		air conditioning unit	$0
23			Lawn & snow maint			$0						furnace	$0
24			Other - rubbish			$0			Annual Cash	$7,297		roof	$0
25		Miscellaneous, pools, janitorial				$0			Cash on Cash	3.39%		garage door & install	$0
26		Replacement (Cap Ex)			5.00%	$4,848						change locks	$0
27	Total Operating Expenses						$43,551		Depreciation	$20,606		plumber	$0
28	Net Operating Income						$53,417		Tax Rate	30%		misc	$2,500
29	Less total annual debt service						$46,120		Tax savings	$6,182		Total:	$2,500
30	Cash flow before taxes						$7,297
31									Total return received	$13,478
32	Debt	Amount		Term	Interest	payment			Total ROI	6.27%
33	1st	$680,000		30	5.50%	$3,843
34	2nd	$0		30	3.75%	$0			Cap Rate	6.28%
35						$3,843			DCR	1.16
36	Purchase data
37		Purchase price (including all closing costs)				$850,000
38		Down payment (% of purchase price)			20%	$170,000
39		Closing costs			5%	$42,500
40		Required additional cash outlay				$2,500
41		Total cash investment				$215,000
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