ABC_PropertyEstimate.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1					Passive Monthly Income Potential (5%)	Passive Monthly Income Potential (6%)	Passive Monthly Income Potential (7%)	Passive Monthly Income Potential (8%)						Calc'd Cells	Input Values
2	Est'd Property Value			179500
3	Down payment (20%)			35900	149.58	179.50	209.42	239.33
4	Adjusted Loan Value			143600
5
6	Expenditure		Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
7		Taxes	164.54	164.54	164.54	164.54	164.54	164.54	164.54	164.54	164.54	164.54	164.54	164.54	1,974.50
8		Utilities			35.00							35.00			70.00
9		Insurance	71.00	71.00	71.00	71.00	71.00	71.00	71.00	71.00	71.00	71.00	71.00	71.00	852.00
10		Repairs	150.00	25.00	25.00	25.00	25.00	150.00	0.00	0.00	100.00	25.00	25.00	25.00	575.00
11		Landscaping	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	50.00	600.00
12		Pest Control	40.00	40.00	40.00	40.00	40.00	40.00	40.00	40.00	40.00	40.00	40.00	40.00	480.00
13		Loan	617	617	617	617	617	617	617	617	617	617	617	617	7,400
14		Tax Prep	7.00	7.00	7.00	7.00	7.00	7.00	7.00	7.00	7.00	7.00	7.00	7.00	84.00
15	Total Expense		1,099.2	974.2	1,009.2	974.2	974.2	1,099.2	949.2	949.2	1,049.2	1,009.2	974.2	974.2	12,035.9
16
17	Direct Income		Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
18		apt 1	1,100.00	1,100.00	1,100.00	1,100.00	1,100.00	1,100.00	1,100.00	1,100.00	500.00	1,100.00	1,100.00	1,100.00	12,600.00
19		apt 2													0.00
20	Total Direct Income		1,100.00	1,100.00	1,100.00	1,100.00	1,100.00	1,100.00	1,100.00	1,100.00	500.00	1,100.00	1,100.00	1,100.00	12,600.00
21
22	Indirect Deductable Values		Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
23		Depreciation	554.01	554.01	554.01	554.01	554.01	554.01	554.01	554.01	554.01	554.01	554.01	554.01	6,648.15
24		Loan Interest	861.60	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	861.60
25	Total Income	Direct + 0.30*I	1,358.48	1,100.00	1,100.00	1,100.00	1,100.00	1,100.00	1,100.00	1,100.00	500.00	1,100.00	1,100.00	1,100.00	12,858.48
26	Profit/Loss		259.2	125.8	90.8	125.8	125.8	0.8	150.8	150.8	-549.2	90.8	125.8	125.8	822.6	68.5
27
28	Total Income														25,458.48
29	Notes:
30		Taxes from 2004 billing
31		Utilities from COR Utilities typical billing (outdoor lighting, water, ss, refuse)
32		Insurance is based on current rates from Allied Insurance
33		Repairs are estimated
34	1	Assume a vacancy rate of 1month/2years for each apartment								Variables:
35	2	Depreciate total property value over 27-yrs								Interest rate, annually		0.05	% annually
36	3	No inflationary factor considered								Return Period		30	yr
37		Loan interest assume 20% down and 5 % annually, compounded monthly
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