Updated Strategy

	A	B	C	D	F	G	H	J	K	L	N	O	P	R
1		Airbnb duplex strategy with refi			Airbnb duplex strategy w/o refi			Duplex 1/2 rented out to family and 1/2 Airbnb			Duplex
2		Year 1	Year 2	Year 3	Year 1	Year 2	Year 3	Year 1	Year 2	Year 3	Year 1	Year 2	Year 3
3	Down payment and closing costs	138,878			138,878			138,878			138,878
4	PITI	92,172	110,904	110,904	92,172	92,172	92,172	92,172	92,172	92,172	92,172	92,172	92,172
5	Repairs (1% of fair market value)	12,380	12,380	12,380	12,380	12,380	12,380	12,380	12,380	12,380	12,380	12,380	12,380
6	CapEx (.67/sqft)	2680	2680	2680	2680	2680	2680	2680	2680	2680	2680	2680	2680
7	Utilities	9,912	9,912	9,912	9,912	9,912	9,912	2,478	2,478	2,478
8	Lawyer fees for eviction	30,000			30,000			30,000			30,000
9	Furnishing rooms	16000			16000			8000
10	Remodelling kitchen	40,000			40,000			40,000			30,000
11	Moving walls	5000			5000			5000			5000
12	Sliding glass doors for kitchens	10000			10000			10000			10000
13	Flooring	20,000			20,000			20,000			20,000			40,000
14	New HVAC	20,000			20,000			20,000			20,000			5000
15	Mold remediation	20,000			20,000			20,000			20,000			10000
16	STL license	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000				20,000
17	New electric panels		20000			20,000			20,000			20,000		20,000
18	Furnishing common areas	20,000			20,000			20,000						20,000
19	Furnishing kitchen	10,000			10,000			10,000						115,000
20	Backyard space	10,000			10,000			10,000
21	Total Expenses	462,022	160,876	140,876	462,022	142,144	122,144	446,588	134,710	114,710	381,110	127,232	107,232
22		160,000
23	Expenses Minus Downpayment	323,144			323,144			307,710			242,232
24	Expenses Minus PITI and Downpayment	230,972			230,972			215,538			150,060
25	Total income	56,664.00	170,000	170,000	56,664.00	170,000	170,000	56,664.00	139,000	139,000	56,664.00	108,000	108,000
26	Cash out Refi	271,000
27
28	Cashflow (including 20% management/cleaning fee)	-134,358	9,124	29,124	-405,358	27,856	47,856	-389,924	4,290	24,290	-324,446	-19,232	768
29	Cashflow - Downpayment				-266,480			-251,046			-185,568
30
31	Loan paydown		25,989	25,989	20,736	25,989	25,989	20,736	25,989	25,989	20,736	25,989	25,989
32	Appreciation 3%		36,900	36,900	36,900	36,900	36,900	36,900	36,900	36,900	36,900	36,900	36,900
33	Forced appreciation				462,000			462,000			462,000
34	Equity	340,000
35	Tax advantages Approximate*	207,000	112,000	92,000	207,000	112,000	92,000	197,000	112,000	92,000	197,000	112,000	92,000
36
37	Total networth increase	412,642	184,013	184,013	54,798	202,745	202,745	75,666	179,179	179,179	206,622	155,657	155,657
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			Lifespan			Lifespan
94	CapEx - Roof		$15			$15
95	CapEx - Foundation		$15			$15
96	CapEx - Plumbing		$15			$15
97	CapEx - Electrical		$15			$15
98	CapEx - Carpentry		$20			$20
99	CapEx - Painting		$5			$5
100	CapEx - HVAC		$15			$15