1588 Redhill Fairplay CO

	A	B	C	D	E	F	G	H	I
1		1588 Redhill Rd, Fairplay, CO 80440		Airbnb Listing
2	Cash Flow Summary
3	Cash Flow Summary	Cap Rate	8.22%	Net Operating Income (Year) :	$65,772
4		Estimated Cash Flow Per Year (Gross Revenue - PITI - OpEx)	$17,229	Net Operating Income (Month) :	$5,481
5		Estimated Cash Flow Per Month	$1,436	Cash on Cash Return:	10.02%
6				Cash on Cash Return W Cost Seg (Year 1)	60.62%
7	Passive Financial Benefits
8	1 Year Financial Results	Principal Paydown	$5,282	Cumulative Cash Flow	$17,229
9		Appreciation	$26,000	Year 1 Bonus Depreciation Tax Savings	$87,040
10		Estimated General Tax Savings	$28,641	Total Financial Benefit	$164,192
11		Total Tax Write Off	$89,503
12
13	5 Year Cumulative Financial Results	Principal Paydown	$30,516	Cumulative Cash Flow	$86,146
14		Appreciation	$140,824
15		Estimated General Tax Savings	$141,891	Total Financial Benefit	$486,417
16		Total Tax Write Off	$443,410
17
18	10 Year Cumulative Financial Results	Principal Paydown	$73,776	Cumulative Cash Flow	$172,292
19		Appreciation	$312,159
20		Estimated General Tax Savings	$279,704	Total Financial Benefit	$924,970
21		Total Tax Write Off	$874,075
22
23
24	Inputs			Notes					Notes
25	Acquisition and Mortgage Expenses	Purchase Price	$800,000		Projections	Average Monthly Rate (Low/High):	$300	$475.00
26		Downpayment %	20%			Occupancy Rate Range:	55%	75%
27		Mortgage Amount	$640,000			Average Nightly Rate:	$388
28		Down Payment	$160,000			Average Occupancy:	65%
29		Interest Rate	6.50%
30		Escrow	$400		Cleaning Fees	Cleaning Fee Per Reservation:	$250
31		Taxes Annually	$2,300			Cleans per Month:	6
32		Insurance Annually	$2,500			Monthly Pass Through Cleaning:	$1,500
33		PMI Monthly	$0			Annual Cleaning Cost	$18,000
34		PITI	$4,445
35		Closing Costs %	1.50%
36		Estimated Closing Costs	$12,000		Revenue	Annual Gross Revenue w/o Cleaning	$91,934
37		Annual PITI	$53,343		Revenue	Annual Gross Revenue w/ Cleaning	$109,934
38
39	Start-up Costs	# of Bedrooms	3
40		Furnishing	$0		Appreciation	Estimated annual appreciation %	4%
41		Designer Fee	$0		Appreciation	Estimated annual appreciation $	$32,000
42		Start Up / Renovations	$0
43		Furniture install Fee	$0
44		Amenities	$0
45					Bonus Depreciation	Bonus Depreciation %	100%
46		Total Cash Invested	$172,000			Estimated Land Value	$120,000
47						Estimated Bonus Depreciation	$272,000
48						Estimated Tax Bracket %	32%
49	Operating Expenses	Property Management Fee %	0			Estimated Tax Savings (Year 1)	$87,040
50		HOA	$100
51		Gas	$350
52		Electric	$250
53		Starlink	$120
54		Water/Sewer/Well/Septic/Trash	$175
55		Capital Expenditures	$77
56		Snow Removal 15X per year at $55	$69
57		Pest Control	$40
58		Hot Tub Maintenance	$250
59		PMS (Guesty, Hospitable, Pricelabs)	$75
60		Annual HOA + Utility Expense	$18,064
61		Annual Property Management Cost	$0
62		Annual Booking Platform Fee	$3,298
63		Annual Total	$21,362
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