ABCDEFG
1
PROPERTY / DEAL DETAILS:
2
>>> VIDEO BREAKDOWN <<< (CLICK HERE AND REVIEW THIS FIRST)
3
Property Address10529 E Durant Dr, Mesa, AZ 85212Bedroom Count:6<<<converting to 6th bedroom to give us more capacity to house more guests will be a substantial lift in revenue (highlighted in cell C65)
4
Purchase Price$675,000Bathroom Count:5
5
Listing URLLink to PhotosSquare Footage:3,426
6
7
CASHFLOW, TAX SAVINGS AND RETURNS:NOTES:
8
Cash on Cash Return (CoC):14.13%
9
Annual Cash-Flow:$25,656.46
10
Estimated Bonus Depreciation:$216,000.00
11
Estimated Additional Offset:$146,152.50
12
Total Year 1 Offset:$362,152.50
13
Year 1 Estimated Net Effective Tax Savings:$133,996.42
14
Year 1 Estimated Tax Savings And Cash-Flow:$159,652.88
15
Year 1 ROI:87.92%
16
17
DEAL SNAPSHOT:NOTES:
18
CASH NEEDED:CASHFLOW, TAX SAVINGS AND RETURNS:
19
Purchase Price:$675,000.00
20
Down Payment:$67,500.00
21
Mortgage Amount:$607,500.00
22
Closing Costs:$13,656.59
23
Seller Credit:$15,000.00
24
Inspection Seller Credit:$0.00
25
Adjusted Closing Costs:-$1,343.41
26
Total Cash To Close:$66,156.59
27
Post-Close Enhancements Budget:$115,424.20
28
Total Cash Needed:$181,580.79
29
30
MONTHLY INCOME PROJECTIONS:NOTES:
31
Average Nightly Rate (ADR):$565Comp 1 = $144k
32
Average Occupancy (OCC):70%Comp 2 = $163k
33
Gross Booking Revenue:$12,030this
34
Cleaning Revenue:$1,500
35
Gross Monthly Income:$13,530
36
Gross Annual Revenue (Before ALL Expenses)$162,358
37
Net Annual Cashflow (After ALL Expenses)$25,656
38
Net Monthly Cashflow (After ALL Expenses)$2,138
39
40
RECURRING MONTHLY EXPENSES BREAKDOWN:NOTES:
41
RECURRING PAYMENTS:UTILITIES:
42
Principal + Interest Payments:$3,839.81Water/Sewer:$198
43
Property Taxes:$270.33Gas And Electricity:$675
44
STR Insurance Policy:$355.36Internet:$114
45
Flood Insurance:$0.00Cleaning:$1,260
46
Private Mortgage Insurance (PMI):$234.56HOA Dues:$0
47
TOTAL Monthly Mortgage Payment (PITI):$4,700.06Pest Control:$20
48
Repairs And Capex:$722Lawn Care:$84
49
Co-Hosting Fee:$2,165Snow Removal:$0
50
Average Platform Fee:$1,203Pool/Hot Tub Maintenance:$250
51
Net Annual Expenses:$136,701.04
52
Net Monthly Expenses:$11,391.75
53
54
ONE-TIME DESIGN AND ENHANCEMENTS BUDGET:NOTES:
55
INTERIOR:EXTERIOR:
56
Handyman/General Contractor "Wear And Tear" Enhancements:$2,500Handyman/General Contractor "Wear And Tear" Enhancements:$2,500The home is really nice and beautiful Has a beautiful pool but a bit small. Relatively small backyard but design is good enough.
57
One-Time Supplies Stocking:$1,785Games:$0Has a better interior overall than the comps but the exterior is a bit inferior.
58
Bedrooms:$30,000Firepit:$3,500
59
Living Room:$5,000Hot Tub:$10,000
60
Dining Room:$5,000Sauna:$0
61
Basement:$0Artificial Turf Putting Green:$0
62
Loft Living Area:$0Patio Furniture (Including "Patio Tabletop Fireplace"):$5,500
63
Game Room:$0Pickleball Court:$0
64
Garage + Golf Simulator Upgrades:$17,500Pool:$0
65
6th Bedroom Conversion:$5,000-$0
66
Misc Improvement 2:$0Misc Amenity 2:$0
67
Paint/Mural:$5,139Misc Amenity 3:$0
68
Designer:$22,000Misc Amenity 4:$0
69
Total:$93,924Total:$21,500
70
NET DESIGN AND ENHANCEMENTS BUDGET TOTAL:$115,424