Hogan McGaheysville.xlsx

	A	B	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	T	U	V	W	X	Y
1	https://www.airbnb.com/rooms/1307318532940861475?guests=1&adults=1&s=67&unique_share_id=9b78e5b0-f5c0-48e1-ae2f-0051df3a3815
2	EDIT BLUE TEXT ONLY																					0	2nd Home
3	ACQUISITION COSTS		PROPERTY VARIABLES		INCOME SCENARIO 1			PROFIT & LOSS PROJECTIONS										ANNUALIZED RETURN PROJECTIONS				0.05	Jumbo
4	Purchase Price Per Unit	$549,900.00	# of Turns	5	ADR	$375.00			Scenario 1			Scenario 2			Scenario 3				Scenario 1	Scenario 2	Scenario 3	0.1	Commercial
5	Closing Cost Percentage	2%	# of Units	1	Cleaning Fee	$275			MONTHLY	ANNUAL		MONTHLY	ANNUAL		MONTHLY	ANNUAL		Down Payment	$82,485	$82,485	$82,485	0.15	DSCR
6	Closing Cost	$10,998.00	Yearly Maintenance %	3%	Nights Booked	17		Gross Rent Income	$6,588	$79,050		$8,344	$100,130		$9,300	$111,600		Closing Cost	$10,998	$10,998	$10,998	0.2
7	Reno & Furnishings	$61,000			Occupancy Rate	56.67%		Cleaning Income	$1,375	$16,500		$1,375	$16,500		$1,375	$16,500		Reno & Furnishings	$61,000	$61,000	$61,000	0.25
8	Set Up Costs (Design & Amenities)	$12,000									%			%			%	Set Up Costs (Design & Amenities)	$12,000	$12,000	$12,000	0.3
9	Legal Costs	$0			INCOME SCENARIO 2			TOTAL INCOME	$7,963	$95,550	100%	$9,719	$116,630	100%	$10,675	$128,100	100%	Legal Costs	$0	$0	$0	0.35
10	Loan Option	1			ADR	$425.00		Maintenance Repair	$198	$2,372		$250	$3,004		$279	$3,348		TOTAL CASH Needed	$166,483	$166,483	$166,483	0.4
11	MORTGAGE CALCULATIONS	Loan Option 1	Loan Option 2	HELOC Payment	Cleaning Fee	$275		Association Fee	$85	$1,020		$85	$1,020		$85	$1,020		CASH FLOW	$11,095	$30,911	$41,692	0.5
12	Loan Type	Commercial	2nd Home		Nights Booked	19		Property Management	$0	$0		$0	$0		$0	$0		CASH ON CASH %	7%	19%	25%
13	Purchase Price	$549,900	$549,900		Occupancy Rate	63.33%		Tech Fee	$150	$1,800		$150	$1,800		$150	$1,800
14	Down Payment Option	15%	20%					Pest Control	$35	$420		$35	$420		$35	$420		Break Even Years	15	5	4
15	Down Payment	$82,485	$109,980		INCOME SCENARIO 3			Utilities	$500	$6,000		$500	$6,000		$500	$6,000		DSCR	1.26	1.71	1.96
16	Loan Amount	$467,415	$439,920	$0	ADR	$450.00		Internet/Cable	$80	$960		$80	$960		$80	$960		CAP RATE	10%	13%	15%
17	PMI Percentage	0.4%	0%		Cleaning Fee	$275		Insurance(Click for Quote)	$319	$3,828		$319	$3,828		$319	$3,828
18	PMI Payment	$183	$0		Nights Booked	20		Cleaning Fee	$1,375	$16,500		$1,375	$16,500		$1,375	$16,500		POTENTIAL COST SEGREGATION BENEFIT
19					Occupancy Rate	66.67%		Household Supplies	$200	$2,400		$200	$2,400		$200	$2,400		Potential Tax Savings Year 1	$ 18,272.63	$ 18,272.63	$ 18,272.63
20	Interest Rate	8.06%	6.50%	8.50%				Landscaping/Snow Plowing / Trash Pickup	$100	$1,200		$100	$1,200		$100	$1,200		After Tax Savings CoC Return*	18%	30%	36%
21	Amortization	30	30	10	MONTHLY EXPENSES			Property Taxes	$147	$1,764		$147	$1,764		$147	$1,764
22	Monthly Payment	$3,427.09	$2,765.61	$0.00	Association Fee	$85.00		Marketing(Click)	$0	$0		$0	$0		$0	$0
23	Annual Payment	$41,125.04	$33,187.36	$0.00	Property Management	0%		OTA(Airbnb) Fee	$239	$2,867		$292	$3,499		$320	$3,843
24					Tech Fee	$150												Click HERE to learn how to qualify for STR Tax Benefits
25	TAX ASSUMPTIONS				Pest Control	$35.00		TOTAL EXPENSE	$3,428	$41,130	43%	$3,533	$42,395	36%	$3,590	$43,083	34%
26	Filing Status:	MFJ			Utilities	$500.00		NOI	$4,535	$54,420	57%	$6,186	$74,235	64%	$7,085	$85,017	66%	Click HERE to learn how to find profitable STR properties
27	W2/Business Income:	$ 150,000.00			Internet/Cable	$80.00		HELOC Payment	$0	$0		$0	$0		$0	$0
28	Total Rental Income (All Properties)	$ -			Insurance(Click for Quote)	$319.00		PMI Payment	$183	$2,200		$183	$2,200		$183	$2,200
29	Type of Market	Mountain (Not Smokies)			Cleaning Fee	$275.00		Debt Service	$3,610	$43,325	45%	$3,610	$43,325	37%	$3,610	$43,325	34%
30	Building Value (Can Override)	85%			Household Supplies	$200.00		NET CASH FLOW	$925	$11,095	12%	$2,575.88	$30,911	27%	$3,474	$41,692	33%
31	Bonus Depreciation %	25%			Landscaping/Snow Plowing / Trash Pickup	$100.00
32					Property Taxes	$147.00
33	Income to Offset:	$200,000			Marketing(Click)	$0
34	Purchase Price Needed:	$1,000,000			OTA(Airbnb) Fee	3%
35
36
37
38												Scenario 1 Comp	https://www.airbnb.com/rooms/915323839634191252?source_impression_id=p3_1727121874_P3PyT-rJZcgqVDWY
39												Scenario 2 Comp	https://www.airbnb.com/rooms/841294360399463890?source_impression_id=p3_1727121975_P3ygemgCjvs_9UPs
40												Scenario 3 Comp	https://www.airbnb.com/rooms/971802499381913124?source_impression_id=p3_1727115116_P3QqHYnYHKYPtl5P
41				Closing Costs		Reno & Furnishing			Set Up Costs
42						Firepit area	$1,000		Hired help	$4,950
43						Hot tub	$9,000		Travel for us to go setup	$2,500
44						Painting	$11,000		Business Application and Fees (Town + LLC)	$500
45				Insurance		Game room in basement	$5,000		Photography	$3,000
46	Lake	85%		$159 per month (USAA)		Furnishings and Supplies	$16,000		Inspections - home, pest/bug, air quality, radon	$1,050
47	Beach (Not Condo/Townhome)	70%		$160 per month assuming 66% occupancy (Safely $8 per night stay)		Designer	$2,388
48	Beach (Condo/Townhome)	95%				Theater room
49	City Market	80%				Electrician	$3,000
50	Mountain (Not Smokies)	85%				Contractor	$5,000
51	Smokies	92%				Radon mitigation system	2000
52						Mold cleaning	2000
53						Retaining wall	1000
54						Deck repairs	1000
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