PORTFOLIO REVIEW - ROI Calculations

	A	B	C	D	E	F	G	H
1	Actual 'In-Place' Rental Investments - we brokered, rehabbed, rented, and manage for clients
2		Examples show the highest and lowest ROI in our managed portfolio.
3
4		Portfolio approximate results to date:
5
6			3880 Lawley		6184 Flushing
7		Research link	http://www.zillow.com/homedetails/3880-Lawley-Ave-Waterford-MI-48328/24397147_zpid/		http://www.zillow.com/homedetails/6184-Flushing-Rd-Flushing-MI-48433/73902747_zpid/
8					http://www.realtor.com/realestateandhomes-detail/6184-Flushing-Rd_Flushing_MI_48433_M37411-04930
9				Brokers Estimate		Brokers Estimate
10		On	7/1/2013	7/1/2013	9/26/2014	9/26/2014
11		Paid	$49,900	$49,900.00	$42,500	$42,500.00
12		Improvements	$6,000	$6,000.00	$20,000	$20,000.00
13		Total outlay	$55,900	$55,900.00	$62,500	$62,500.00	$118,400
14
15
16	EQUITY	On	12/31/2015	12/31/2015	12/31/2015	12/31/2015
17	BUILD	Estimated Market Value *	$105,600		$92,950
18		Brokers Estimate #		$95,000		$75,000
19		Years owned	2.5	2.5	1.3	1.3
20		To date appreciation	$49,700	$39,100	$30,450	$12,500
21		Per year $ appreciation	$19,869	$15,631	$24,109	$9,897
22		Per year % appreciation	35.5%	28.0%	38.6%	15.8%
23
24	CASH	In service / rented on:	8/1/2013	8/1/2013	6/1/2015	6/1/2015
25	FLOW	Years rented	2.4	2.4	0.6	0.6
26		Monthly rent payout to client	$828	$900	$765	$810
27		Full yr approx prop taxes	$2,400	$2,400	$2,868	$2,868		https://www.co.genesee.mi.us/tax/address_search_results.asp?addnum=6184&addstreet=flushing
28		Full yr approx insurance	$350	$350	$350	$350
29		Full yr $ flow	$7,186	$8,050	$5,962	$6,502
30		Per year % ROI	12.86%	14.4%	9.54%	10.4%
31
32		If investment was sold today, below would be the approx. results:
33
34	TOTAL	Cash + appreciation to date	$67,065	$58,552	$33,929	$16,294	$74,847
35	ROI	Total % ROI to date	120.0%	104.7%	54.3%	26.1%
36		% ROI to date, Annualized	48.0%	41.9%	43.0%	20.6%
37
38	# Broker column shows estimate of 1. current market value and 2. potential rent value vs. 1. website est. of value and 2. current actual rents.
39	* This is the average of Realtor.com & Zillow.com estimates
40
41
42
43
44
45
46	indepth analysis with changing rental cash flows
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