ABCDEFGHI
1
PROPERTY / DEAL DETAILS:
2
>>> VIDEO BREAKDOWN <<< (CLICK HERE AND REVIEW THIS FIRST)INTERNAL USE ONLY KEY
3
Property Address725 W Palo Verde Street, Gilbert, AZ 85233Bedroom Count:5Yield20
4
Purchase Price$600,000Bathroom Count:3StateAZ
5
Listing URLLink to PhotosSquare Footage:2,501Months left in the year7
6
Is the home furnished (Y/N)Y
7
CASHFLOW, TAX SAVINGS AND RETURNS:NOTES:
8
Cash on Cash Return (CoC):11.91%
9
Annual Cash-Flow:$22,660.86Client Credit Score780
10
Estimated Bonus Depreciation:$192,000.00
11
Estimated Additional Offset:$148,966.87
12
Total Year 1 Offset:$340,966.87
13
Year 1 Estimated Net Effective Tax Savings:$126,157.74
14
Year 1 Estimated Tax Savings And Cash-Flow:$148,818.60
15
Year 1 ROI:78.23%
16
Case-Shiller annual appreciation assumption4.00%
17
DEAL SNAPSHOT:NOTES:Interest Rate6.50%
18
CASH NEEDED:CASHFLOW, TAX SAVINGS AND RETURNS:Term: (Years)30
19
Purchase Price:$600,000.00# of Payments360
20
Down Payment:$60,000.00Hot tub (Y/N)No
21
Mortgage Amount:$540,000.00Pool (Y/N)No
22
Closing Costs:$12,733.34HOA Fees (Month)$0.00
23
Seller Credit:$10,000.00
24
Inspection Seller Credit:$0.00
25
Adjusted Closing Costs:$2,733.34
26
Total Cash To Close:$62,733.34CLOSING KEY:
27
Post-Close Enhancements Budget:$127,500.20Down Payment %10.00%
28
Total Cash Needed:$190,233.54Closing Cost %2.12%
29
Home Depreciation %32.00%
30
MONTHLY INCOME PROJECTIONS:NOTES:Tax Bracket:37.00%
31
Average Nightly Rate (ADR):$525NK Main Comp 1 URL | Comp 2 URLINCOME KEY:
32
Average Occupancy (OCC):69%$225kAverage Number Of Reservations Per Month:6
33
Gross Booking Revenue:$11,018$178kAverage Number Of Cleans Per Month:6
34
Cleaning Revenue:$1,500$170kAverage Cleaning Revenue:$250
35
Gross Monthly Income:$12,518$153kAverage Cleaning Expense:$250
36
Gross Annual Revenue (Before ALL Expenses)$150,221$148k
37
Net Annual Cashflow (After ALL Expenses)$22,661
38
Net Monthly Cashflow (After ALL Expenses)$1,888Gross Booking Revenue:$132,221
39
Gross Yearly Revenue:$150,221
40
RECURRING MONTHLY EXPENSES BREAKDOWN:NOTES:
41
RECURRING PAYMENTS:UTILITIES:EXPENSE KEY:
42
Principal + Interest Payments:$3,413.17Water/Sewer:$156Property Tax (Year)$2,500.00
43
Property Taxes:$208.33Gas And Electricity:$418Property Tax (Month)$208.33
44
STR Insurance Policy:$314.58Internet:$100Insurance (Year)$3,775.01
45
Flood Insurance:$0.00Cleaning:$1,500Insurance (Month)$314.58
46
Private Mortgage Insurance (PMI):$208.50HOA Dues:$0Flood Insurance (Y/N)No
47
TOTAL Monthly Mortgage Payment (PITI):$4,144.58Pest Control:$20Flood Insurance ($)$0
48
Repairs And Capex:$661Lawn Care:$75Flood Insurance (Monthly)$0
49
Co-Hosting Fee:$1,983Snow Removal:$0
50
Average Platform Fee:$1,322Pool/Hot Tub Maintenance:$250
51
Net Annual Expenses:$127,560.39
52
Net Monthly Expenses:$10,630.03
53
54
ONE-TIME DESIGN AND ENHANCEMENTS BUDGET:NOTES:DESIGN KEY (INTERNAL USE ONLY)
55
INTERIOR:EXTERIOR:Cost Per Square Foot:
56
Handyman/General Contractor "Wear And Tear" Enhancements:$3,500Handyman/General Contractor "Wear And Tear" Enhancements:$3,500game roomAverage Cost Per Bedroom:
57
One-Time Supplies Stocking:$1,500Games:$2,500fire pit
58
Bedrooms:$25,000Firepit Chairs:$1,500putting green
59
Living Room:$5,000Hot Tub:$12,000string lights
60
Dining Room:$5,000Sauna:$12,000<<<sauna might need to go in garage due to space constraints
61
Basement:$0Artificial Turf Putting Green:$10,000
62
Loft Living Area:$0Patio Furniture:$2,500
63
Game Room:$4,000Pickleball Court:$0
64
Garage:$12,500Pool Repairs/Fixes (Estimated):$3,500<<garage is a blend of game room/movie theater area with sofa style seating plus projecter; likely including games like pool/table top ping pong table (removable); small portable bar setup; POTENTIALLY adding in golf simulator to make this even more competitive
65
Misc Improvement 1:$0String Lights$1,500
66
Misc Improvement 2:$0Misc Amenity 2:$0
67
Paint/Mural:$4,500Misc Amenity 3:$0
68
Designer:$17,500Misc Amenity 4:$0
69
Total:$78,500Total:$49,000
70
NET DESIGN AND ENHANCEMENTS BUDGET TOTAL:$127,500