Realset example 1

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1	Condo Ownernship input		$/ sqft	sqft	income
2	Purchase price	$ 1,000,000	1200	833	$192,664.45	37%	Housing to income
3	downpayment %	25%
4	Downpayment amount	$ 250,000
5	purchase fees	$ 37,944
6
7		Finance/ Loan1					Refinance / Loan2					Refinance / Loan3					Refinance / Loan4					Loan
8		Amount	$ 750,000				Amount	$ 625,338				Amount	$ 456,553				Amount	$ 245,239				Amount	0
9		Interest	5.00%				Interest	4.00%				Interest	3.00%				Interest	3.00%
10		Amortize	20				Amortize	15				Amortize	10				Amortize	5
11		years	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20
12	Home value	$ 1,000,000	1,032,500	1,066,056	1,100,703	1,136,476	1,173,411	1,211,547	1,250,923	1,291,578	1,333,554	1,376,894	1,421,643	1,467,847	1,515,552	1,564,807	1,615,663	1,668,173	1,722,388	1,778,366	1,836,163	1,895,838
13	home value increase %	3.25%	32,500	33,556	34,647	35,773	36,935	38,136	39,375	40,655	41,976	43,340	44,749	46,203	47,705	49,255	50,856	52,509	54,216	55,978	57,797	59,675
14	mortgage payment		59,141	59,141	59,141	59,141	59,141	55,383	55,383	55,383	55,383	55,383	52,855	52,855	52,855	52,855	52,855	52,855	52,855	52,855	52,855
15	property tax	$ 5,721	5,950	6,188	6,435	6,692	6,960	7,239	7,528	7,829	8,142	8,468	8,807	9,159	9,525	9,907	10,303	10,715	11,143	11,589	12,053	12,535
16	insurance property %	0.10%	1,033	1,066	1,101	1,136	1,173	1,212	1,251	1,292	1,334	1,377	1,422	1,468	1,516	1,565	1,616	1,668	1,722	1,778	1,836	1,896
17	maintenance fees %	0.50%	5,163	5,330	5,504	5,682	5,867	6,058	6,255	6,458	6,668	6,884	7,108	7,339	7,578	7,824	8,078	8,341	8,612	8,892	9,181	9,479
18
19	Total payment per year		71,286	71,725	72,181	72,653	73,142	69,891	70,417	70,962	71,527	72,112	70,192	70,821	71,474	72,151	72,852	73,579	74,333	75,115	75,925	23,910	1,396,245	Paid over 20yrs
20
21	Realset input		rent/ sqft	sqft	Income
22	Monthly rent	$3,600.00	4.32	833	$144,000	30%	Housing to income
23	Monthly investment	$900.00				7.50%	Savings to income
24	Monthly investment %	25%
25	Initial investment	$ 287,944
26
27		years	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20
28	investment value	$ 287,944	$ 323,939	$ 363,299	$ 406,324	$ 453,339	$ 504,696	$ 560,781	$ 622,012	$ 688,844	$ 761,772	$ 841,334	$ 928,116	$ 1,022,754	$ 1,125,942	$ 1,238,433	$ 1,361,046	$ 1,494,673	$ 1,640,283	$ 1,798,931	$ 1,971,762	$ 2,160,025
29	REIT distribution	8.75%	$ 25,195	$ 28,345	$ 31,789	$ 35,553	$ 39,667	$ 44,161	$ 49,068	$ 54,426	$ 60,274	$ 66,655	$ 73,617	$ 81,210	$ 89,491	$ 98,520	$ 108,363	$ 119,092	$ 130,784	$ 143,525	$ 157,406	$ 172,529	1,609,670	interest
30	REIT investment	25%	$ 10,800	$ 11,016	$ 11,236	$ 11,461	$ 11,690	$ 11,924	$ 12,163	$ 12,406	$ 12,654	$ 12,907	$ 13,165	$ 13,428	$ 13,697	$ 13,971	$ 14,250	$ 14,535	$ 14,826	$ 15,123	$ 15,425	$ 15,734	262,412	invested
31	REIT share price	$ 10	$ 10.33	$ 10.66	$ 11.01	$ 11.36	$ 11.73	$ 12.12	$ 12.51	$ 12.92	$ 13.34	$ 13.77	$ 14.22	$ 14.68	$ 15.16	$ 15.65	$ 16.16	$ 16.68	$ 17.22	$ 17.78	$ 18.36	$ 18.96
32	REIT share price increase	3.25%	$ 0.33	$ 0.34	$ 0.35	$ 0.36	$ 0.37	$ 0.38	$ 0.39	$ 0.41	$ 0.42	$ 0.43	$ 0.45	$ 0.46	$ 0.48	$ 0.49	$ 0.51	$ 0.53	$ 0.54	$ 0.56	$ 0.58	$ 0.60
33	REIT holding shares	28,794.36	1,046.00	1,033.34	1,020.83	1,008.47	996.26	984.20	972.29	960.52	948.89	937.40	926.05	914.84	903.76	892.82	882.01	871.34	860.79	850.37	840.07	829.90	47,475	total shares
34	Monthly rent	$ 3,600	$ 43,200	$ 44,064	$ 44,945	$ 45,844	$ 46,761	$ 47,696	$ 48,650	$ 49,623	$ 50,616	$ 51,628	$ 52,661	$ 53,714	$ 54,788	$ 55,884	$ 57,001	$ 58,142	$ 59,304	$ 60,490	$ 61,700	$ 62,934	1,049,646	paid in rent
35	Rent increase %	2.0%	$ 864	$ 881	$ 899	$ 917	$ 935	$ 954	$ 973	$ 992	$ 1,012	$ 1,033	$ 1,053	$ 1,074	$ 1,096	$ 1,118	$ 1,140	$ 1,163	$ 1,186	$ 1,210	$ 1,234	$ 1,259
36
37	total payment per year		54,864	55,961	57,081	58,222	59,387	60,574	61,786	63,021	64,282	65,568	66,879	68,216	69,581	70,972	72,392	73,840	75,317	76,823	78,359	79,926	1,333,051	Paid over 20yrs
38
39	AFTER 20 YEARS
40	ownership
41	house sale price	$ 1,895,838
42	agent to sell 5%	$ 94,792
43	13% tax on agent service	$ 12,323
44	Cash	$ 1,788,723	assuming principal residence tax exemption
45	opportunity cost	$ 1,396,245
46
47	Realset
48	investment value	$ 2,160,025
49	Share value increase	$ 425,295
50	initial investment	$ 287,944
51	contribution	$ 262,412
52	taxable gains	$ 1,017,482	50% taxable
53	capital gains tax	$ 539,266	tax rate	53%
54	Cash	$ 2,046,054
55	Opportuntiy cost	1,333,051
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