Proforma: 5910 County Road 10, Twin Lakes

	A	B	C	D	E	F	G	H	I
1		5910 County Road 10, Twin Lakes	Zillow Link
2	Cash Flow Summary
3	Cash Flow Summary	Cap Rate	7.86%	Net Operating Income (Year) :	$154,424
4		Estimated Cash Flow Per Year (Gross Revenue - PITI - OpEx)	$33,636	Net Operating Income (Month) :	$12,869
5		Estimated Cash Flow Per Month	$2,803	Cash on Cash Return:	6.70%
6
7	Passive Financial Benefits
8	1 Year Financial Results	Principal Paydown	$5,282	Cumulative Cash Flow	$33,636
9		Appreciation	$26,000	Year 1 Bonus Depreciation Tax Savings	$286,466
10		Estimated General Tax Savings	$57,281	Total Financial Benefit	$408,665
11		Total Tax Write Off	$179,003
12
13	5 Year Cumulative Financial Results	Principal Paydown	$30,516	Cumulative Cash Flow	$168,178
14		Appreciation	$140,824
15		Estimated General Tax Savings	$170,531	Total Financial Benefit	$796,515
16		Total Tax Write Off	$532,910
17
18	10 Year Cumulative Financial Results	Principal Paydown	$73,776	Cumulative Cash Flow	$336,356
19		Appreciation	$312,159
20		Estimated General Tax Savings	$308,344	Total Financial Benefit	$1,317,101
21		Total Tax Write Off	$963,575
22
23
24	Inputs
25	Acquisition and Mortgage Expenses	Purchase Price	$1,965,000	Notes	Projections	Average Monthly Rate (Low/High):	$475.00	$875.00	Notes
26		Downpayment %	20.00%			Occupancy Rate Range:	40%	60%
27		Mortgage Amount	$1,572,000			Average Nightly Rate:	$715.00
28		Down Payment	$393,000			Average Occupancy:	72%
29		Interest Rate	6.63%
30		Escrow	$757		Cleaning Fees	Cleaning Fee Per Reservation:	$300.00
31		Taxes Annually	$5,888			Cleans per Month:	7
32		Insurance Annually	$3,200			Monthly Pass Through Cleaning:	$2,100.00
33		PMI Monthly	$0			Annual Cleaning Cost	$25,200.00
34		PITI	$10,823
35		Closing Costs %	1.00%
36		Estimated Closing Costs	$19,650		Revenue	Annual Gross Revenue w/o Cleaning	$187,902.00
37		Annual PITI	$129,876		Revenue	Annual Gross Revenue w/ Cleaning	$213,102.00
38
39	Start-up Costs	# of Bedrooms	3
40		Furnishing	$40,000		Appreciation	Estimated annual appreciation %	2%
41		Designer Fee	$7,500		Appreciation	Estimated annual appreciation $	$39,300
42		Start Up / Renovations	$30,000	*Upgrade from 3 to a 4 BR Septic Tank
43		Furniture install Fee	$0
44		Amenities	$12,000	*Already comes with a Hot Tub
45					Bonus Depreciation	Bonus Depreciation %	100%
46		Total Cash Invested	$502,150			Estimated Land Value	$160,149
47						Estimated Bonus Depreciation	$895,206
48						Estimated Tax Bracket %	32%
49	Operating Expenses	Property Management Fee %	0%			Estimated Tax Savings (Year 1)	$286,466
50		HOA	$0
51		Gas	$200
52		Electric	$175
53		Cable	$90
54		Water/Sewer/Well/Septic	$50
55		Capital Expenditures	$470
56		Landscaping	$150
57		Pest Control	$40
58		Hot Tub Maintenance	$250
59		PMS (Guesty, Hospitable, Pricelabs)	$75
60		Annual HOA + Utility Expense	$17,997
61		Annual Property Management Cost	$0.00
62		Annual Booking Platform Fee	$6,393.06
63		Annual Total	$24,390
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