| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | *EDIT BLUE TEXT ONLY* | 0 | 2nd Home | |||||||||||||||||||||||||||
2 | https://www.zillow.com/homedetails/308-46th-St-W-Bradenton-FL-34209/45742256_zpid/ | |||||||||||||||||||||||||||||
3 | AQUISITION COSTS | PROPERTY VARIABLES | INCOME SCENARIO 1 | PROFIT & LOSS PROJECTIONS | ANNUALIZED RETURN PROJECTIONS | 0.05 | Jumbo | |||||||||||||||||||||||
4 | Purchase Price Per Unit | $800,000.00 | # of Turns | 5 | ADR | $400.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 | $350 | MONTHLY | ANNUAL | MONTHLY | ANNUAL | MONTHLY | ANNUAL | Down Payment | $157,800 | $157,800 | $157,800 | 0.15 | DSCR | ||||||||||||
6 | Closing Cost | $16,000.00 | Yearly Maintenance % | 3% | Nights Booked | 20 | Gross Rent Income | $8,184 | $98,208 | $10,230 | $122,760 | $13,299 | $159,588 | Closing Cost | $16,000 | $16,000 | $16,000 | 0.2 | ||||||||||||
7 | Reno, Furnishings, design, amenities, photos, assembly | $47,120 | Hot Tub, Firepit, Some Furnishing | Occupancy Rate | 66.00% | Cleaning Income | $1,750 | $21,000 | $1,750 | $21,000 | $1,750 | $21,000 | Reno, Furnishings, design, amenities, photos, assembly | $47,120 | $47,120 | $47,120 | 0.25 | |||||||||||||
8 | Pet Fee | $91 | $1,086 | $91 | $1,086 | $91 | $1,086 | |||||||||||||||||||||||
9 | Pro Design/Install | % | % | % | 0.3 | |||||||||||||||||||||||||
10 | Not Sure Yet | INCOME SCENARIO 2 | TOTAL INCOME | $10,025 | $120,294 | 100% | $12,071 | $144,846 | 100% | $15,140 | $181,674 | 100% | 0.35 | |||||||||||||||||
11 | Loan Option | 1 | ADR | $500.00 | Maintenance Repair | $246 | $2,946 | $307 | $3,683 | $399 | $4,788 | TOTAL CASH Needed | $220,920 | $220,920 | $220,920 | 0.4 | ||||||||||||||
12 | MORTGAGE CALCULATIONS | Loan Option 1 | Loan Option 2 | HELOC Payment | Cleaning Fee | $350 | Revenue Management | $0 | $0 | $0 | $0 | $0 | $0 | CASH FLOW | $2,490 | $25,569 | $60,187 | 0.5 | ||||||||||||
13 | Loan Type | 2nd Home | 2nd Home | Nights Booked | 20 | Property Management & Concierge Trash | $600 | $7,200 | $600 | $7,200 | $600 | $7,200 | CASH ON CASH % | 1% | 12% | 27% | ||||||||||||||
14 | Purchase Price | $789,000 | $789,000 | Occupancy Rate | 66.00% | Tech Fee | $100 | $1,200 | $100 | $1,200 | $100 | $1,200 | ||||||||||||||||||
15 | Down Payment Option | 20% | 10% | Pest Control | $73 | $876 | $73 | $876 | $73 | $876 | Break Even Years | 89 | 9 | 4 | ||||||||||||||||
16 | Down Payment | $157,800 | $78,900 | INCOME SCNEARIO 3 | Utilities | $500 | $6,000 | $500 | $6,000 | $500 | $6,000 | DSCR | 1.05 | 1.54 | 2.26 | |||||||||||||||
17 | Loan Amount | $631,200 | $710,100 | $0 | ADR | $650.00 | Internet/Cable | $88 | $1,056 | $88 | $1,056 | $88 | $1,056 | CAP RATE | 6% | 9% | 13% | |||||||||||||
18 | PMI Percentage | 0.0% | 0% | Cleaning Fee | $350 | Insurance(Click for Quote) | $516 | $6,188 | $516 | $6,188 | $516 | $6,188 | ||||||||||||||||||
19 | PMI Payment | $0 | $0 | Nights Booked | 20 | Cleaning Fee | $1,750 | $21,000 | $1,750 | $21,000 | $1,750 | $21,000 | POTENTIAL COST SEGREGATION BENEFIT | |||||||||||||||||
20 | Occupancy Rate | 66.00% | Household Supplies | $200 | $2,400 | $200 | $2,400 | $200 | $2,400 | Potential Tax Savings Year 1 | $ 35,579.04 | $ 35,579.04 | $ 35,579.04 | |||||||||||||||||
21 | Interest Rate | 6.50% | 7.50% | 8.50% | HOA | $0 | $0 | $0 | $0 | $0 | $0 | After Tax Savings CoC Return* | 17% | 28% | 43% | |||||||||||||||
22 | Amortization | 30 | 30 | 10 | MONTHLY EXPENSES | Property Taxes | $926 | $11,112 | $926 | $11,112 | $926 | $11,112 | ||||||||||||||||||
23 | Monthly Payment | $3,968.12 | $4,934.28 | $0.00 | Revenue Management | $0.00 | Pool Cleaning/Landscaping | $550 | $6,600 | $550 | $6,600 | $550 | $6,600 | |||||||||||||||||
24 | Annual Payment | $47,617.43 | $59,211.40 | $0.00 | Property Management & Concierge Trash | 600 | OTA(Airbnb) Fee | $301 | $3,609 | $362 | $4,345 | $454 | $5,450 | |||||||||||||||||
25 | Tech Fee | $100 | ||||||||||||||||||||||||||||
26 | TAX ASSUMPTIONS | Pest Control | $73.00 | TOTAL EXPENSE | $5,849 | $70,187 | 58% | $5,972 | $71,660 | 49% | $6,156 | $73,870 | 41% | |||||||||||||||||
27 | Filing Status: | MFJ | Utilities | $500.00 | NOI | $4,176 | $50,107 | 42% | $6,099 | $73,186 | 51% | $8,984 | $107,804 | 59% | ||||||||||||||||
28 | W2/Business Income: | Internet/Cable | $120.00 | HELOC Payment | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||
29 | Total Rental Income (All Properties) | Insurance(Click for Quote) | $515.67 | PMI Payment | $0 | $0 | $0 | $0 | $0 | $0 | ||||||||||||||||||||
30 | Type of Market | Beach (Not Condo/Townhome) | Cleaning Fee | $1,750.00 | Debt Service | $3,968 | $47,617 | 40% | $3,968 | $47,617 | 33% | $3,968 | $47,617 | 26% | ||||||||||||||||
31 | Building Value (Can Override) | 70% | Household Supplies | $200.00 | NET CASH FLOW | $207 | $2,490 | 2% | $2,130.72 | $25,569 | 18% | $5,016 | $60,187 | 33% | ||||||||||||||||
32 | Bonus Depreciation % | 60% | HOA | $0.00 | ||||||||||||||||||||||||||
33 | Property Taxes | $926.00 | Assumptions Made: Professional Design, Re-finish Pickleball Court, Heated Pool, Hot Tub | |||||||||||||||||||||||||||
34 | Income to Offset: | $200,000 | Pool Cleaning/Landscaping | $550 | ||||||||||||||||||||||||||
35 | Purchase Price Needed: | $416,667 | OTA(Airbnb) Fee | 3% | ||||||||||||||||||||||||||
36 | ||||||||||||||||||||||||||||||
37 | Similar Properties | Revenue | Occupancy | ADR | BR/BA | Guest Count | Amenities | ADJ ADR | ||||||||||||||||||||||
38 | ||||||||||||||||||||||||||||||
39 | https://www.airbnb.com/rooms/827041849167049837?source_impression_id=p3_1733195328_P3xJVSNX8QayRV5Y | $142,350.00 | 78% | $500.60 | 4/2 | 14 | Pool, High Design | |||||||||||||||||||||||
40 | https://www.airbnb.com/rooms/551350548878240442?source_impression_id=p3_1733195074_P3BgmuJgPHOYJ-H9 | $124,649.00 | 63% | $514.00 | 4/2.5 | 12 | Pool, Closer to the Bridge | |||||||||||||||||||||||
41 | https://www.airbnb.com/rooms/664455783742768009?source_impression_id=p3_1734366637_P33DQKYsbgYij6ET | $94,858.00 | 71% | $336.00 | 4/3 | 12 | Pool, Putting Green | |||||||||||||||||||||||
42 | https://www.airbnb.com/rooms/565897273111284824?source_impression_id=p3_1734366891_P3nCPh3yQKAmeQdZ | $91,038.00 | 65% | $396.00 | 4/2.5 | 12 | Pool | |||||||||||||||||||||||
43 | https://www.airbnb.com/rooms/52772144?source_impression_id=p3_1734367061_P3FF6VdhVhbv1tce | $94,191.00 | 53% | $519.00 | 4/3 | 12 | Pool | |||||||||||||||||||||||
44 | https://www.airbnb.com/rooms/692000039160609370?source_impression_id=p3_1734367142_P30eHRnLAgZ6Hj3f | $108,004.00 | 73% | $404.00 | 4/3 | 14 | Pool, Gameroom, Firepit | |||||||||||||||||||||||
45 | https://www.airbnb.com/rooms/52827918?source_impression_id=p3_1734367318_P3DSYAjz2A2K65PR | $104,700.00 | 61% | $410.00 | 4/3.5 | 12 | Pool, Massage Chair | |||||||||||||||||||||||
46 | https://www.airbnb.com/rooms/791304240840673354?source_impression_id=p3_1734367412_P3IcqQXdDeXfDiR_ | $98,833.00 | 54% | $476.00 | 4/2 | 12 | Pool | |||||||||||||||||||||||
47 | https://www.airbnb.com/rooms/1056774331070140764?adults=1&checkin=&checkout=&children=0&infants=0&pets=0&wishlist_item_id=11004310125349&source_impression_id=p3_1734843317_P36sKNY1bSAC1utc&previous_page_section_name=1000 | |||||||||||||||||||||||||||||
48 | https://www.airbnb.com/rooms/959653978299677908?source_impression_id=p3_1734843633_P33RWQ1cBaP1u_w1 | |||||||||||||||||||||||||||||
49 | https://www.airbnb.com/rooms/51796549?source_impression_id=p3_1734843643_P3rPnzaoU_frFuLx | |||||||||||||||||||||||||||||
50 | https://www.airbnb.com/rooms/44493623?source_impression_id=p3_1734843987_P3ap3FfrHIfuKkZB | |||||||||||||||||||||||||||||
51 | https://www.airbnb.com/rooms/683929564274890104?source_impression_id=p3_1734843484_P3qsiVB7dGN_XojH | |||||||||||||||||||||||||||||
52 | ||||||||||||||||||||||||||||||
53 | ||||||||||||||||||||||||||||||
54 | Bradenton Set-up | Costs | Handyman | Steve | Matt | Hung | ||||||||||||||||||||||||
55 | Design (refresh) | $3,200.00 | $330.00 | |||||||||||||||||||||||||||
56 | Photography | $2,000.00 | $120.00 | |||||||||||||||||||||||||||
57 | Pickleball court painting | $2,500.00 | ||||||||||||||||||||||||||||
58 | Murals on shed | $5,200.00 | ||||||||||||||||||||||||||||
59 | Remaining seller credit | -$1,000.00 | ||||||||||||||||||||||||||||
60 | Essentials, furniture upgrade and assembly, firepit | $18,620.00 | ||||||||||||||||||||||||||||
61 | Assembly | $4,000.00 | ||||||||||||||||||||||||||||
62 | Mini golf incl. sod removal | $12,000.00 | ||||||||||||||||||||||||||||
63 | Landscaping improvement | $0.00 | ||||||||||||||||||||||||||||
64 | Bulk trash removal | |||||||||||||||||||||||||||||
65 | Accent wall painting | $350.00 | ||||||||||||||||||||||||||||
66 | Cleaning | $250.00 | ||||||||||||||||||||||||||||
67 | Total | $47,120.00 | ||||||||||||||||||||||||||||
68 | ||||||||||||||||||||||||||||||
69 | ||||||||||||||||||||||||||||||
70 | ||||||||||||||||||||||||||||||
71 | Lake | 85% | For cost seg purposes | |||||||||||||||||||||||||||
72 | Beach (Not Condo/Townhome) | 70% | ||||||||||||||||||||||||||||
73 | Beach (Condo/Townhome) | 95% | ||||||||||||||||||||||||||||
74 | City Market | 80% | ||||||||||||||||||||||||||||
75 | Mountain (Not Smokies) | 85% | ||||||||||||||||||||||||||||
76 | Smokies | 92% | ||||||||||||||||||||||||||||
77 | ||||||||||||||||||||||||||||||
78 | ||||||||||||||||||||||||||||||
79 | ||||||||||||||||||||||||||||||
80 | ||||||||||||||||||||||||||||||
81 | ||||||||||||||||||||||||||||||
82 | ||||||||||||||||||||||||||||||
83 | ||||||||||||||||||||||||||||||
84 | ||||||||||||||||||||||||||||||
85 | ||||||||||||||||||||||||||||||
86 | ||||||||||||||||||||||||||||||
87 | ||||||||||||||||||||||||||||||
88 | ||||||||||||||||||||||||||||||
89 | ||||||||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||||||
91 | ||||||||||||||||||||||||||||||
92 | ||||||||||||||||||||||||||||||
93 | ||||||||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||||||
100 | ||||||||||||||||||||||||||||||