822 W Newport Ave, Chicago, IL 60657-6694

	B	C	D	E	F	G	H	I	J	K	L
1					Property Area:
2					MLS Area Code	8006
3					Community Area	Lake View
4					Area Investment Grade	A
5	Property Information				Property Analysis		BR	Current Rents		Proforma Rents
6					Gross Annual Operating Income	$120,096.00		Unit 1	$3,350
7	Asking Price		$1,550,000.00		Gross Annual Operating Expenses	$36,019.13		Unit 2	$3,475
8	Renovations*				Net Operating Income	$84,076.87		Unit 3	$3,600
9	Number of Units		3		Annual Loan Payments	$88,173.49		Unit 4
10	Down Payment	25.0%	$387,500		DSCR (Debt Service Coverage Ratio)	0.95		Unit 5
11	Closing Costs	2%	$31,000		Capitalization Rate	5.42%		Unit 6
12	Total Initial Investment		$418,503.00		Monthly Cash Flow	$ (341.38)		Unit 7
13	Monthly Income				Annual Cash Flow	-$4,096.62		Unit 8
14	Rental Income $	Current	$10,425.00		GRM	12.4		Unit 9
15	Other Income				Exp. Ratio	29.99%		Unit 10
16	Vacancy Rate	4%	$417.00		Principle Reduction In First Year	$12,993.56		Unit 11
17	Gross Operating Monthly Income		$10,008.00		Appreciation in First Year	$69,750.00		Unit 12
18	Monthly Expenses (if applicable)				Return on Investment - Year 1				$10,425		$0
19	Landlord Paid Utilites		$240.00		Cash on Cash Return	-0.98%			-0.03274675681		#DIV/0!
20	HOA Dues		$ -		Principal Reduction	2.13%
21	PMI				Appreciation	15.69%
22	Annual Operating Expenses				Total Return On Investment	18.79%
23	Property Taxes		$22,533.13	1.50%	Financial Details
24	Insurance		$3,100.00	0.20%	Loan Amount	$1,162,500.00
25	Annual CapEx Budget	3.0%	$3,753.00		Loan Points	0.00%
26	Maintanance Budget	3.0%	$3,753.00		Amortization	30
27	Property Management	0%	$0.00		Interest Rate	6.50%
28	Total Annual Expenses		$36,019.13		Annual Appreciation Rate	4.50%
29	Monthly Expenses		$3,001.59
30
31
32
33
34
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