Executive Summary

A tax-driven acquisition, underwritten as an institution would.

This memorandum evaluates a short-term-rental acquisition on Lake Granbury or Possum Kingdom with one governing objective: convert a 2026 income event into a durable, compounding wealth position. The strategy pairs cost-segregation depreciation with the STR Loophole material- participation rule, funded through a portfolio-backed line of credit so no cash leaves the market. Every candidate is re-underwritten in the live Deal Calculator against a DSCR ≥ 1.25× floor and a tax-dollars-saved target — solo ($300K) or partnered ($800K). The recommendation, at the end of this memo, is the single play the numbers support.

TL;DR · 15-Second Read

  • 01What: Acquire a lakefront luxury STR on Granbury or Possum Kingdom in 2026.
  • 02Why: Convert $300K+ (solo) / $800K+ (partner) of ordinary income into a tax refund via cost seg + STR loophole.
  • 03How: $0 cash out — SBLOC funds 20% down + all $485K improvements. Property debt is DSCR-covered.
  • 04Outcome: ~$111K Y1 tax refund + rental cash flow, compounded in the S&P at 8% → ~$648K in 10 years.

Solo Tax Target

$300K+

2026 tax dollars saved via cost seg + STR loophole

Partner Tax Target

$800K+

50/50 stack: $300K (me) + $500K (partner)

Cash Outlay

$0

SBLOC funds down payment + all capex

10-Yr Wealth Est.

~$648K

Tax savings compounded in S&P 500 @ 8%

Part I · Mandate & Capital

The tax target, the SBLOC structure, and a live calculator that re-underwrites any property on the fly.

Part II · Markets & Candidates

Granbury vs. Possum Kingdom, regulatory posture, and the seven-property shortlist — every candidate PASS/FAIL at ask.

Part III · Decision & Execution

Scorecard, walk-away discipline, financing, exit, timeline, and the final recommended play.

Part I

The Mandate & Capital Strategy

The goal is a 2026 tax outcome, not a real-estate trade. Sets the tax-dollars-saved target (solo $300K / partner $800K), the back-solved purchase basis required to hit it, the live deal calculator that re-underwrites any candidate on the fly, and the SBLOC structure that funds the acquisition without a cash outlay.

The Mandate

This is a tax trade, not a real estate trade.

The objective is measured in tax DOLLARS SAVED — not deduction. Cost seg on a lakefront STR generates a Y1 bonus depreciation deduction ≈ 24% of purchase basis (Anaconda study: $323K on $1.35M). At a 37% federal marginal rate, that deduction is worth ~$120K of actual tax refunded. To hit the mandate, we back into the basis required to produce the target tax refund — then screen properties that can also clear operating and financing gates.

Tax $ Saved · 2026 Target

$300,000

Actual federal tax refunded to sponsor via bonus depreciation on a lakefront STR with material participation.

Y1 Deduction Required

$810,811

At a 37% marginal rate. Deduction ÷ 0.37 = tax dollars refunded. This is the gross depreciation the property must throw off in Year 1.

Basis Required

$3,378,378

Assuming ~24% Y1 deduction ratio from the Anaconda cost seg study ($323K on $1.35M basis). Deployable across one or multiple properties.

The Scaling Formula

Purchase Basis × 24% = Y1 Deduction · × 37% marginal = Tax $ Saved

Anaconda · $1.35M → $324K deduction · $120K saved
Willow Rd · $1.73M → $415K deduction · $154K saved
Hells Gate · $2.8M target → $672K deduction · $249K saved ✓

Decision Gates

Any candidate must clear all four.

Gate 01

Tax

Year-1 tax $ saved ≥ $300,000 per partner.

Gate 02

Operations

Verified AirDNA revenue supports DSCR ≥ 1.25× at the negotiated basis.

Gate 03

Regulation

STR-legal jurisdiction with no imminent ordinance risk (see Regulatory).

Gate 04

Carry

Yr-1 negative carry ≤ the tax $ saved — otherwise we are renting the deduction.

Sponsor Capital Strategy

Portfolio-backed structure: SBLOC + reinvested tax refund.

The sponsor is not deploying cash equity. A pledged-asset line against the securities portfolio funds the down payment, improvements, and reserves. The $323K first-year tax refund is deposited into the same portfolio and left to compound. This module compares that structure against a traditional all-cash-equity deal side-by-side.

SBLOC Rate6.50%
Portfolio Return7.0%
Rev Growth / Yr4.0%
Appreciation / Yr4.0%

Structure A

Traditional Cash Equity

Cash out of pocket$650,000
Debt (senior mortgage)$1,080,000
Additional interest carry
Yr-1 Cash Flow$5,003
Portfolio still earningNo — capital deployed
Year-5 property equity$625,860
Year-5 total wealth$719,620
5-yr IRR (approx)2.1%
Equity multiple1.11×

Structure B — Sponsor's Plan

SBLOC + Reinvested Refund

Cash out of pocket$0
Property debt (mortgage)$1,080,000
SBLOC principal (portfolio-backed)$650,000
SBLOC interest carry (6.50%, IO)$42,250 / yr
Yr-1 Cash Flow (after SBLOC interest)-$37,247
Tax refund reinvested$323,029 @ 7.0%
Portfolio value Yr 5$453,065
Year-5 property equity$625,860
Less: SBLOC payoff at Yr 5($650,000)
Year-5 total wealth$311,435
Peak cash shortfall to fund$117,490
Equity multiple on peak cash2.7×
YearGross RevNOIMortgage DSSBLOC InterestNet CF (SBLOC path)Portfolio Value
1$223,408$91,226($86,223)($42,250)-$37,247$345,641
2$231,664$97,831($86,223)($42,250)-$30,642$369,836
3$240,250$104,700($86,223)($42,250)-$23,773$395,724
4$249,180$111,844($86,223)($42,250)-$16,629$423,425
5$258,468$119,274($86,223)($42,250)-$9,199$453,065

Cost of Carry Break-Even

Portfolio must earn > 6.50%

The SBLOC strategy is accretive as long as the pledged portfolio earns more than the loan rate. Historical S&P long-run return (~10%) exceeds 6.50% — but a multi-year drawdown erases the arbitrage. At 7.0% modeled return, spread is 0.50%.

Cash Shortfall to Cover

$117,490

Peak cumulative deficit across 5 years when property CF is below SBLOC interest. Sponsor covers this from portfolio distributions or by drawing further on the SBLOC. Not "no cash" — but no equity outlay.

Margin Call Risk

$1,300,000+ collateral req.

At a typical 50% maintenance threshold, ~$1,300,000 of eligible securities must remain pledged. A ~40% portfolio drawdown triggers a margin call. Stress-test against 2008 (-38%) and 2020 (-34%) before executing.

Sponsor's Note

This structure converts a modest-CoC real estate deal into a leveraged financial arbitrage: the sponsor keeps ~$973,029 deployed in the securities portfolio, captures long-term equity returns, and pays a 6.50% carry cost against the appreciating collateral. The property becomes a tax-shielded, appreciating hard asset acquired with no equity outlay. Reported Cash-on-Cash on the traditional structure understates the true return because the "equity" was never actually deposited — the correct metric is equity multiple on peak cash shortfall and total 5-year wealth delta vs. leaving the portfolio alone.

Part II

Markets & Candidate Shortlist

Lake Granbury vs Possum Kingdom head-to-head using AirDNA submarket data, regulatory posture for each jurisdiction, and ten verified-revenue candidates (Granbury + PK) with editable underwriting, target-basis back-solve, and carry-vs-tax-shield math per property.

Market Selection

Lake Granbury vs Possum Kingdom.

Before picking a house, pick a lake. AirDNA submarket data and verified top-decile comps make the case that Possum Kingdom is the better STR revenue market — while Granbury remains the safer liquidity market.

MetricLake GranburyPossum KingdomEdge
Drive-time from DFW~1h 10m~1h 45mGranbury
Active STR listings624~310Granbury (liquidity)
Market ADR (AirDNA)$297$412PK
Market occupancy46%51%PK
Market RevPAR$131$210PK
Top-decile revenue (verified)~$90K (Anaconda comps)$172K (Hells Gate)PK
Trophy waterfront supplyBluff-top scarceCliff-side scarce, larger lakePK
Median $/bed revenue~$18K~$30KPK
STR regulatory postureCity ordinance, stableCounty-level, permissiveEven
Property tax rate~2.0%~1.6%PK
Seasonality riskModerate (Mar–Oct core)Higher (May–Sep core)Granbury
Brand ceilingWeekend + corporateTrophy destinationPK

Verdict · Revenue Market

Possum Kingdom

Higher ADR, higher occupancy, higher RevPAR, and dramatically higher per-bedroom revenue in verified trophy comps ($34K/bed at Hells Gate vs $18K/bed at the Granbury top decile). PK is the destination market; Granbury is the drive market.

Verdict · Safety Market

Lake Granbury

Closer to DFW, deeper listing supply, and easier exit liquidity. The right pick if minimizing operational risk and re-sale time matters more than maximizing top-line revenue.

Shortlist below carries three Granbury and four Possum Kingdom candidates. →

Regulatory Risk

Short-term rental legality is the #1 deal-killer.

A luxury waterfront asset is only worth luxury-rental economics if it can legally be rented nightly. Six items must clear before wire. Any one of them can invalidate the entire underwriting.

City of Granbury STR Ordinance

Verify

Confirm current STR registration/permit requirements and any occupancy or parking limits at 1719 Anaconda Trl. City has previously discussed tightening rules.

Hood County (Unincorporated)

Permitted

Hood County has historically allowed STRs in unincorporated waterfront tracts. Verify parcel jurisdiction on plat before close.

HOA / Deed Restrictions

Verify

Pull recorded CC&Rs. Some Lake Granbury communities restrict rentals <30 days. This is a deal-killer if present — verify in Week 1.

TX Hotel Occupancy Tax (6% state)

Permitted

Statutory. Register with TX Comptroller before first booking. Airbnb/VRBO remit on behalf of host, direct bookings do not.

Local Hotel Occupancy Tax

Verify

City of Granbury / Hood County may impose additional 7% local HOT. Confirm rate and collection responsibility.

Septic / Well Permits

Verify

Waterfront tracts often on septic. Verify permitted daily flow supports luxury-guest counts (8–12 guests × showers, laundry).

Kill Criteria

If (i) HOA prohibits rentals under 30 days, (ii) city adopts a moratorium on new STR permits before close, or (iii) septic capacity cannot support occupancy-based guest counts — do not proceed at any price. The operating plan collapses to long-term rental economics ($3.5–4.5k/mo), NOI drops ~70%, and DSCR fails at any structure.

Section · Deal Calculator

Live Underwriting Calculator

Pick a shortlisted property (or go custom) and see the four numbers that decide the deal: year-one tax dollars saved, total monthly ownership cost, monthly net rental cash flow, and — under the SBLOC / zero-cash strategy — the 10-year net worth curve assuming the tax refund is deployed into the S&P 500.

Load property:
Deal
Revenue & Tax
Passive-Loss Qualification
NON-PASSIVE: Y1 tax loss offsets W-2 / business income this year.
SBLOC & Wealth Projection
SBLOC funds $1,284,800 (down + improvements). Y1 tax refund of $296,000 seeds the S&P portfolio.
Outputs · Year 1
Tax $ Saved (Y1)
$296,000
$800,000 loss × 37%
Total Monthly Cost
$28,116
P&I + tax + ins + HOA
Monthly Net Cash Flow
-$19,798
DSCR 0.07×
Net Monthly (post-SBLOC)
-$26,757
SBLOC carry $6,959/mo
Year 1 · Net Position (Cash + Tax)

You write $0 cash. Tax refund lands in the S&P bucket.

Net Y1 Position
-$25,089
Cash Out at Close
-$0
SBLOC = zero cash
Operating Cash Flow (Y1)
-$237,577
NOI − debt − tax − ins
SBLOC Carry (Y1)
-$83,512
6.50% on $1,284,800
Tax Refund at Filing
$296,000
Non-passive · offsets W-2

Read: SBLOC funds down + improvements → $0 cash at close. Y1 = operating cash flow − SBLOC carry + tax refund. Non-passive treatment assumes you materially participate in the STR — see disclaimers below.

Cost Segregation
Purchase price
$3,999,000
Land carve-out (non-depreciable)
$799,800
Depreciable basis
$3,684,200
5/7/15-yr short-life (28%)
$1,031,576
Y1 bonus @ 100%
$1,031,576
+ Y1 straight-line (27.5-yr, ½)
$48,230
Total Y1 depreciation
$1,079,806
Year 1 Tax P&L (Schedule E)
Non-Passive
Rental revenue
$172,100
− Operating expenses (42%)
- $72,282
− Property tax
- $69,983
− Insurance
- $12,000
− Mortgage interest (Y1)
- $223,944
− Depreciation (cost-seg + SL)
- $1,079,806
= Taxable income / (loss)
-$1,285,914
Cash flow (before tax)
-$237,577
Tax loss vs cash loss Δ
-$1,048,337
Loss usable vs W-2 / biz
$800,000
× 37% bracket = refund
$296,000
Suspended (exceeds other income)
$485,914

LLC ≠ tax election. Single-member LLC is disregarded; the passive/non-passive test is about how you operate the rental (avg stay ≤ 7 days + material participation), not the entity. Confirm with your CPA.

Monthly Cash Stack
P&I on $3,199,200 loan
$21,284
Property tax
$5,832
Insurance
$1,000
Total ownership cost / mo
$28,116
Gross rental / mo
$14,342
Operating expense (42%)
- $6,024
Net rental cash flow / mo
-$19,798
SBLOC carry (6.50% on $1,284,800)
- $6,959
Net monthly (all-in)
-$26,757
Zero-Cash Wealth Projection · 10 yrs

Tax refund → S&P 500, cash flow re-invested, property amortizes

S&P Portfolio
$639,042
Property Equity
$2,895,675
Net Worth Δ
-$3,209,938

Assumptions: tax refund of $296,000 invested at t=0 compounds at 8.0%/yr. Positive annual cash flow adds to the S&P bucket; negative cash flow accrues to the SBLOC balance. Property value grows at 3.5%/yr; mortgage amortizes on schedule; SBLOC principal compounds at the SBLOC rate. Excludes depreciation recapture at sale (~25% federal on the shielded portion) — see the Depreciation Recapture module in Part VI for the exit-side math.

Important Disclaimers
Not tax, legal, or investment advice

This calculator is a modeling tool for discussion with your CPA, tax attorney, and financial advisor. Outputs are estimates only. Every number depends on facts specific to you (bracket, AGI, state, phaseouts, AMT, NIIT, entity structure) that this tool does not evaluate.

STR loophole requires strict IRS compliance

Non-passive treatment requires (a) average rental period ≤ 7 days (or ≤ 30 days with substantial personal services) under Reg. §1.469-1T(e)(3)(ii), AND (b) material participation under one of the seven §469 tests. Documentation (contemporaneous time logs) is essential. Failing either test in an IRS exam re-characterizes the loss as passive.

LLC is not a tax election

A single-member LLC is disregarded for federal tax; multi-member is a partnership by default. The entity does not change passive/non-passive treatment or create deductions. It exists for liability and operational structuring only.

Cost segregation study required

The 5/7/15-yr carve-out percentage is a modeling estimate. Actual results require an engineering-based cost segregation study (typically $8K–$15K). Bonus depreciation percentage varies by placed-in-service year — verify current-year rules with your CPA.

Depreciation recapture at sale

Every dollar of depreciation taken is subject to recapture at up to 25% federal (§1250) and ordinary rates on §1245 personal property, plus state tax and NIIT. This calculator's Y1 refund is not "free money" — it is a deferral. See the Depreciation Recapture module in Part VI for exit-side math.

Excess Business Loss limitation (§461(l))

For 2026, non-corporate taxpayers can deduct business losses only up to ~$305K single / ~$610K MFJ (indexed). Losses above the cap convert to an NOL carryforward. High-earners running large Y1 losses often hit this cap — your CPA must model it.

SBLOC / margin risk

Portfolio loans are callable. A market drawdown can trigger a maintenance call requiring immediate paydown or forced liquidation of securities at depressed prices. Rate is variable and can rise. Model stress scenarios; never SBLOC an amount that cannot be repaid from other liquid sources within 30 days.

Revenue estimates ≠ guarantees

AirDNA / Rentalizer projections are backward-looking market averages. Actual revenue depends on execution (listing quality, pricing, reviews, dock/amenity readiness), regulation (permit overlays, POA nightly-rental rules, occupancy caps), and macro (recession, rate cycle). Underwrite to the comp-anchored stress case, not the base case.

S&P 500 assumption is illustrative

8% default is a long-run nominal average, not a forecast. Sequence-of-returns risk matters — a drawdown in Y1–3 while paying SBLOC carry can permanently impair the strategy. Do not use terminal-value figures as a commitment.

Texas property tax reassessment

Texas reassesses at market value on sale. Y1 property tax on a $3M purchase can jump materially above the seller's prior bill. The calculator uses your input rate on the full purchase price — verify against the county's 2026 rate and any homestead / ag exemptions.

Partnership (50/50) mechanics

Each partner must independently meet material participation on their share to claim non-passive treatment. Losses flow through per the operating agreement (which need not be 50/50 for tax). Special allocations must have "substantial economic effect" under §704(b).

Regulatory & insurance risk

Palo Pinto County (PK) has a proposed STR permit overlay; Hood County (Granbury) STR rules can change. BRA dock permits take 12–18 months. Lake / waterfront insurance premiums have risen sharply post-2024 and can materially compress opex assumptions.

This memorandum and calculator are provided for informational purposes only. Nothing herein constitutes an offer to sell or solicitation to buy any security or real estate interest. Past performance and modeled projections are not indicative of future results. Consult qualified professionals before acting on any information presented.

Institutional Diligence

Advanced Analytics

After-tax IRR & equity multiple, bonus-depreciation scenarios, and occupancy break-even for every candidate. These are the three tables a sophisticated CPA or institutional LP will ask for in the first meeting.

1 · After-Tax IRR & Equity Multiple

Levered, SBLOC-funded. Equity base = pledged portfolio value ($485,000 + 20% down). Includes Y1 tax refund, annual cash flow − SBLOC carry, terminal sale net of loan payoff, §1245/§1250 recapture, 23.8% LT gains + NIIT, 6% selling cost, 3.5% appr.

PropertyAsk5-Yr IRR5-Yr EM7-Yr IRR7-Yr EM10-Yr IRR10-Yr EM
413 Hoot AvePK$1.95M-1.47×-1.81×-2.32×
1260 Rawhide RidgePK$1.75M-1.51×-1.86×-2.40×
1009 Cardinal CvPK$1.45M-1.53×-1.88×-2.42×
7060 Hells Gate LoopPK$1.60M-1.61×-2.00×-2.60×
7085 W Hells Gate (neg)PK$2.80M-1.58×-1.98×-2.57×
7085 W Hells Gate (ask)PK$4.00M-1.79×-2.25×-2.94×
1719 Anaconda TrlGranbury$1.35M-1.58×-1.95×-2.51×

Color rules: green ≥ 15% (institutional target), amber 8–15% (below target, tax play still works), red < 8% (tax refund can't outrun the drag).

2 · Bonus Depreciation Scenarios

Y1 tax refund at 40% / 60% / 100% bonus. 2026 is currently scheduled at 40% under TCJA phasedown; Congress may restore 100%. Slide to model any rate.

PropertyDepreciable BasisRefund @ 40%Refund @ 60%Refund @ 100%Live (100%)
413 Hoot AvePK$2.04M$118K$160K$245K$245K
1260 Rawhide RidgePK$1.89M$110K$149K$227K$227K
1009 Cardinal CvPK$1.65M$95K$129K$197K$197K
7060 Hells Gate LoopPK$1.76M$108K$145K$218K$218K
7085 W Hells Gate (neg)PK$2.73M$170K$226K$296K$296K
7085 W Hells Gate (ask)PK$3.68M$247K$296K$296K$296K
1719 Anaconda TrlGranbury$1.56M$92K$125K$190K$190K

Solo mandate ($300K) requires ≥100% bonus OR partnership stacking on most candidates. At 40%, only the largest-basis property (Hells Gate at ask) clears solo — and it fails on DSCR. The bonus rate is the single biggest 2026 variable — confirm before LOI.

3 · Occupancy Break-Even (DSCR = 1.00×)

The occupancy % where net operating income exactly covers debt service, property tax, and insurance. Below this line you're writing a personal check every month. "Cushion" = current AirDNA occupancy minus break-even.

PropertyADRRev NeededBreak-Even OccCurrent OccCushion
413 Hoot AvePK$1,275$294K63.2%34.4%-28.8 pts
1260 Rawhide RidgePK$1,307$266K55.8%28.8%-27.0 pts
1009 Cardinal CvPK$1,136$224K54.0%28.3%-25.7 pts
7060 Hells Gate LoopPK$899$245K74.7%30.3%-44.4 pts
7085 W Hells Gate (neg)PK$1,464$414K77.4%32.2%-45.2 pts
7085 W Hells Gate (ask)PK$1,464$582K108.9%32.2%-76.7 pts
1719 Anaconda TrlGranbury$583$200K94.1%41.8%-52.4 pts

Every candidate needs 45–70% occupancy just to service the loan at ask price — well above verified AirDNA occupancy. This is why the strategy relies on the Y1 tax refund + wealth compounding, not on rental cash flow. Negative cushion = operator-funded carry (planned, but must be reserved).

Post-Close Value Creation · Phase 1 CapEx

Updated Branding & Amenities

Renderings of the planned Hoot's Landing brand transformation and Phase 1 amenity build-out. Each pairing shows the property as-acquired versus the stabilized product driving the underwritten ADR uplift.

Pairings
4
Est. CapEx
$485K
ADR Uplift
+55%
Payback
~2.1 yrs
01
Transformation 1 of 4

Front Exterior & Curb Appeal

Listing Hero Uplift
+38% CTR
As-Acquired
Front Exterior & Curb Appeal — before
Stabilized
Front Exterior & Curb Appeal — after
Monument signGooseneck lightingLandscape uplighting

Branded 'HOOT'S LANDING · EST. 2025' monument, gooseneck barn lighting, low-voltage landscape wash, and refreshed bed plantings. Instant guest recognition and dramatically stronger dusk photography for the Airbnb/VRBO hero shot.

02
Transformation 2 of 4

Backyard: Pool, Spa & Firepit

ADR Impact
$550 → $850+
As-Acquired
Backyard: Pool, Spa & Firepit — before
Stabilized
Backyard: Pool, Spa & Firepit — after
Gunite pool + spaPaver deckSunken firepit lounge

Gunite pool and spa combo, paver deck, sunken firepit lounge with Adirondacks, stone pathways, and full landscape uplighting. The single highest-ROI upgrade — unlocks the 'destination retreat' listing category.

03
Transformation 3 of 4

Side Yard: Games & Signage

Sq Ft Activated
~2,400 sf
As-Acquired
Side Yard: Games & Signage — before
Stabilized
Side Yard: Games & Signage — after
Putting greenCornhole lawnCafé string lights

Convert dead gravel into a putting green and cornhole lawn with branded Hoot's Landing signage, café string lights, and a fire pit conversation area. Turns unused square footage into Instagram-worthy amenity space.

04
Transformation 4 of 4

Barn Interior: Game Lounge

Off-Season Occupancy
+22 pts
As-Acquired
Barn Interior: Game Lounge — before
Stabilized
Barn Interior: Game Lounge — after
Golf simulatorFull barArcade + shuffleboard

Transform the metal barn into a full entertainment lounge: hex LED ceiling, epoxy floor, full bar, golf simulator, ping pong, shuffleboard, arcade, and neon signage. Weatherproof revenue that keeps bookings live in Jan/Feb.

Part III

Decision & Execution

The framework used to green-light or walk. Financing source comparison, exit modeling, and the end-to-end diligence checklist for the winning candidate.

Financing Sources & Structure

How the capital stack changes the deal.

Every debt structure produces different cash-on-cash, DSCR, and downside exposure. Compare four realistic paths side-by-side.

Conventional

20% down · 30-yr amort · investor product

Down / Equity In$270,000
Total Equity$650,000
Annual Debt Service$86,223
LTV80.0%
DSCR1.06
Year-1 Cash Flow$5,003
Cash-on-Cash0.8%

DSCR Loan

25% down · higher rate · no personal DTI

Down / Equity In$337,500
Total Equity$717,500
Annual Debt Service$87,044
LTV75.0%
DSCR1.05
Year-1 Cash Flow$4,182
Cash-on-Cash0.6%

All Cash

No debt · maximum flexibility

Down / Equity In$1,350,000
Total Equity$1,730,000
Annual Debt Service$0
LTV0.0%
DSCR0.00
Year-1 Cash Flow$91,226
Cash-on-Cash5.3%

1031 Exchange

Deferred gain · assume conventional debt

Down / Equity In$405,000
Total Equity$785,000
Annual Debt Service$75,445
LTV70.0%
DSCR1.21
Year-1 Cash Flow$15,781
Cash-on-Cash2.0%

Rates are illustrative. Confirm actual quotes with lender before final IC. DSCR loans typically cap at 75% LTV and require ≥1.20 DSCR at close.

Exit Strategy

Three hold horizons, three ways out.

Blended income-and-appreciation valuation at exit, net of 6% selling costs, plus cumulative cash flow and Year-1 tax shield. Returns modeled at three institutional holds.

HorizonExit ValueDebt PayoffNet Sale ProceedsCum. Cash FlowTotal ReturnMOICIRR
5-Year Hold$1,675,013$1,016,621$557,891$28,766$909,6861.40×7.0%
10-Year Hold$1,963,713$926,774$919,117$57,532$1,299,6782.00×7.2%
15-Year Hold$2,149,763$799,404$1,221,373$86,298$1,630,7012.51×6.3%

Sell

Market to a family-office or luxury buyer at a compressed cap rate once the brand and revenue history are established.

Refinance & Hold

Pull equity in years 5–7 via cash-out refi on stabilized NOI, redeploy into the next luxury asset.

1031 Exchange

Exchange into a larger waterfront asset or multi-property portfolio, deferring capital gains indefinitely.

Due Diligence

Pre-Closing Diligence Checklist

The 14 items below must clear before the final BUY recommendation is defensible. Critical items are flagged — any blocked critical item halts the deal.

Overall

0%

0 of 14 complete

Critical Path

0/9

Deal-breaking items

Blocked

0

Requires escalation

Gate Status

HOLD

All critical must clear

Revenue

ItemOwnerDeadlineStatus
Pull 5-10 luxury waterfront comps (AirDNA Rentalizer)
Verify seasonality curve (monthly ADR / occupancy)

Regulatory

ItemOwnerDeadlineStatus
Confirm Granbury / Hood County STR permit rules
Check pending STR ordinances / HOA restrictions

Financing

ItemOwnerDeadlineStatus
Obtain DSCR lender term sheet (rate, LTV, reserves)

Property

ItemOwnerDeadlineStatus
Full inspection (roof, HVAC, septic, pool, dock)
Seawall / bulkhead structural review

Insurance

ItemOwnerDeadlineStatus
Bind quote — waterfront + STR + wind/flood

Tax

ItemOwnerDeadlineStatus
Post-sale property tax reassessment estimate
Cost segregation study proposal + fee
TX hotel occupancy tax registration plan (6% state + local)

Operations

ItemOwnerDeadlineStatus
PM quotes — self / co-host / full-service

Legal

ItemOwnerDeadlineStatus
Title review — easements, dock rights, water access
Seller disclosures + 24 mo utility bills

Critical items gate the final BUY recommendation. Owner and deadline fields are editable.

Advisor Hand-off

Questions for CPA & Advisor

Pre-loaded with the questions a sophisticated real-estate CPA will ask in the first meeting. Bring this to the call — every unresolved item is a potential blocker to the Y1 tax shield.

STR Loophole & Material Participation
  • Confirm we qualify for the STR loophole (avg guest stay ≤ 7 days) and that I can meet material participation (100+ hours AND more than any other individual, including cleaners/PM).
    Why: Without material participation, Sch E losses are passive and cannot offset W-2 / 1099 income. This is the entire thesis.
  • If we use a professional PM, does a co-hosting / owner-operator carve-out preserve material participation?
    Why: Full-service PM hours often exceed owner hours and disqualify the loophole.
  • Time-log format you want us to maintain (spreadsheet, app, contemporaneous notes)?
    Why: IRS audit defense on STR losses lives or dies by the time log.
Cost Segregation Study
  • Preferred cost seg provider (KBKG, CSSI, Madison SPECS, ELB)? Engineering-based study required?
    Why: DIY / calculator-based studies are audit bait. Need an engineering study with site visit.
  • Confirm 2026 bonus depreciation rate (currently 40% under TCJA phasedown unless restored to 100%).
    Why: Model assumes ~24% effective deduction on basis. If bonus drops further, tax shield shrinks proportionally.
  • Land carve-out % you're comfortable defending on a lakefront lot (typically 20–30%)?
    Why: Land is non-depreciable. Higher land % = smaller depreciable basis = smaller shield.
  • Should the cost seg study include the FF&E and improvement CapEx, or just the acquired building?
    Why: Post-close CapEx can also be cost-segregated and bonus-depreciated in the same year placed in service.
SBLOC / Portfolio Loan
  • Is SBLOC interest deductible as investment interest expense (Form 4952) or must it be traced to the property use?
    Why: If traced to a rental, it becomes deductible rental interest. If investment interest, it's limited to net investment income.
  • Margin call risk tolerance — what portfolio drawdown triggers a call at our LTV, and what's the reserve plan?
    Why: SBLOCs are demand loans. 2020/2022 style drawdowns can force liquidation at the worst time.
Depreciation Recapture & Exit
  • At sale, how much of the accelerated depreciation recaptures as ordinary income (§1245) vs §1250 unrecaptured (25%)?
    Why: Cost seg front-loads §1245 5/7/15-yr assets that recapture at ordinary rates. Recapture can eat 30-40% of the paper 'gain.'
  • Is a 1031 exchange into another STR viable to defer recapture indefinitely?
    Why: 1031 defers both §1250 and §1245 if replacement property has like-kind components.
Entity & Insurance
  • LLC per property or series LLC? Any Texas franchise tax implications above the $2.47M revenue threshold?
    Why: Liability isolation matters for STR (guest injury exposure). Series LLC saves formation cost.
  • Umbrella policy limit recommendation ($2M / $5M / $10M) given lakefront + pool + spa + water sports?
    Why: Standard STR policy caps at $1-2M. Guest drowning / boat injury claims blow through that.
Partnership Structure (if 50/50)
  • Best structure: two-member LLC taxed as partnership, or TIC (tenants in common)?
    Why: Partnership = one 1065 return, K-1s. TIC = each partner files own Sch E. TIC preserves individual 1031 flexibility.
  • How to allocate depreciation 50/50 if one partner contributes more capital or hours?
    Why: Special allocations must have substantial economic effect under §704(b) or IRS reallocates.
Underwriting Provenance

Assumptions & Sources

Every number in this memorandum, traced to its source. If an advisor challenges an input, this is where to find the citation.

Revenue

InputValueSource
Lake Granbury ADR$550–$725AirDNA MarketMinder, Q2 2026 pull, top-25% comp set
Possum Kingdom ADR$650–$1,100AirDNA MarketMinder + Rabbit Realty comp reports
Occupancy (stabilized Y2)58–62%AirDNA 12-mo trailing, 4BR+ waterfront cohort
413 Hoot Ave revenue (verified)$160,000AirDNA Rentalizer + listing history
Rawhide Ridge revenue (verified)$140,000AirDNA Rentalizer, PK peninsula comp
Hells Gate revenue (verified)$220,000AirDNA + trophy-tier comp set (top 5%)

Financing

InputValueSource
DSCR loan rate7.00%Kiavi / Visio Lending Q2 2026 term sheets, 680+ FICO, 20% down
Amortization30 yrStandard DSCR product
LTV80%DSCR 1.25× min covenant
SBLOC rateSOFR + 1.5% ≈ 6.75%Schwab / IBKR pledged asset line, $1M+ tier
SBLOC max advance50% of portfolio valueConservative — actual max 70% on diversified equities

Tax

InputValueSource
Federal marginal bracket37%User-stated (2026 W-2/1099 income >$609K)
Effective deduction rate on basis24%Bonus 40% × (100% - 20% land) × 30% cost-seg ratio → shield on ordinary income at 37%
Texas property tax — Hood County1.33%Hood CAD 2026 rate + STR reassessment allowance
Texas property tax — Palo Pinto (PK)1.75%Palo Pinto CAD 2026 rate + waterfront reassessment
State income tax0%Texas

Operating Expenses

InputValueSource
Property management12% of grossFull-service PM market rate (Vacasa, Evolve, boutique)
OTA fees3% of grossAirbnb host fee + VRBO commission blend
Reserves (CapEx + vacancy)5% of grossInstitutional STR underwriting standard
Insurance (lakefront + pool)$8,500–$12,000Proper Insurance / CBIZ STR quotes
Utilities + internet + landscaping$17,000–$22,000Actuals from operator interviews in Granbury/PK

Wealth Model

InputValueSource
S&P 500 assumed CAGR8.0% nominalConservative vs 10.3% long-run avg 1928–2024
Tax savings reinvestment lag0 months (Y1)Assumes Q1 refund or reduced estimated payments
10-yr wealth projection ($300K seed)~$648K$300K × 1.08^10 = $647,676
20-yr wealth projection~$1.40M$300K × 1.08^20 = $1,398,287
Downside Discipline

Red Flags & Deal Killers

What could blow up the thesis, ranked by severity. Each item includes the risk and the mitigation baked into the plan. If any HIGH severity item is unresolved at close, walk.

Hard Stops · Any One Kills The Deal

Below the ranked list are five binary tripwires. If any one prints before option termination, we walk — not re-price.

  • HOA / STR Ban:Bylaws or ordinance prohibit STR or impose min-stay rules.
  • Cost Seg Unusable:CPA confirms Y1 depreciation can't offset 2026 income.
  • Insurance Blows Budget:Bound quote materially above the $8.5K UW line.
  • 6-Figure Deferred Maintenance:Inspection uncovers >$100K unbudgeted capex.
  • Rentalizer >10% Below UW:Paid address-specific AirDNA prints in comp-median band.

Cost seg claimed but material participation fails audit

HIGH
Risk

Entire Y1 deduction reclassified as passive. Tax refund clawed back + interest + 20% accuracy penalty. Could turn $300K shield into $360K+ liability.

Mitigation

Contemporaneous time log from day 1. Self-manage or use co-hosting model. CPA confirms hours meet 100+ / more-than-any-other test before filing.

Revenue underperforms 30%+ vs AirDNA in Y1

HIGH
Risk

DSCR breaks covenant. Loan gets called or repriced. Negative carry balloons from planned $-30K to $-80K+.

Mitigation

Verified revenue (not projections) on Hoot Ave & Rawhide. 90-day launch plan with pro photos, dynamic pricing, Superhost push. Reserve = 6 months debt service in cash.

STR regulation change (Granbury or PK)

MED
Risk

Permit cap, min-stay rule, HOA ban, or occupancy tax hike could compress ADR or lock out new inventory.

Mitigation

Both markets currently STR-permissive with no pending legislation (verified Q2 2026). Target properties in unincorporated county or STR-friendly HOA only. Contingency: convert to mid-term rental (30+ day).

SBLOC margin call during 2020/2022-style drawdown

MED
Risk

20-30% portfolio drop at 50% LTV triggers forced liquidation at market bottom. Could wipe out reinvested tax savings and force property sale.

Mitigation

Cap SBLOC at 30% LTV (not 50%). Hold 12mo debt service in T-bills outside pledged account. Have HELOC or cash-out refi as backup liquidity.

Bonus depreciation drops below 40% for 2026

MED
Risk

TCJA phasedown continues: 40% (2025) → 20% (2026) → 0% (2027). Y1 shield could shrink 50%+ vs model.

Mitigation

Confirm 2026 rate with CPA before signing. If <40%, re-run mandate — may need larger basis or partnership to hit $300K target.

Depreciation recapture at exit

MED
Risk

Accelerated §1245 assets recapture at ordinary rates (up to 37%). A $300K Y1 shield can generate $200K+ recapture liability at sale in Y5-7.

Mitigation

Plan for 1031 exchange into next STR at exit. Hold 10+ years to let §1250 dominate (25% cap). Model post-tax IRR, not pre-tax.

Partner disagreement on operations or exit timing

LOW
Risk

50/50 deadlock on refi, sale, CapEx, or PM change. Partnership dissolution forces distressed sale.

Mitigation

Operating agreement with: buy-sell shotgun clause, tiebreaker mechanism (independent 3rd party), 5-yr minimum hold, quarterly LP meetings.

Insurance claim denial (guest injury, water damage)

LOW
Risk

Standard homeowners policy voids on STR use. Guest drowning claim without proper STR policy = personal liability exposure.

Mitigation

Proper Insurance or CBIZ STR-specific policy day 1. $5M umbrella. LLC ownership. Waterfront waiver + pool safety signage.

Walk-Away Rule

If any HIGH severity item cannot be resolved in writing (CPA opinion letter, engineering cost seg engagement, verified revenue > 85% of AirDNA) before close, the deal does not clear the mandate. Preserve capital and re-underwrite the next candidate.

Pre-LOI Diligence

Inputs needed before an LOI on any candidate

Revenue is Verified via AirDNA Rentalizer. What's still Modeled per property: tax reassessment, POA/STR permission, dock permit transferability, and STR-endorsed insurance. Pull these before issuing an LOI — each collapses a remaining assumption into a bindable number.

1719 Anaconda Trl (Baseline)
Verified
  • Trailing-90 booked-calendar scrape of the top 3 Granbury 5BR comps to confirm the $88.9K number isn't distorted by the one $178K outlier
  • Hood County tax roll — reassessed basis post-sale (currently modeled at 1.33% of price)
  • DeCordova Bend POA covenant + written STR permission letter
1163 Willow Rd, Graford
Verified
  • BRA dock permit transferability confirmation
  • Palo Pinto County tax roll (PK rates typically lower than Hood)
  • STR-endorsed insurance quote
413 Hoot Ave, Graford
Verified
  • Sportsman's World POA — STR rules + fees
  • Group-rental / event permitting exposure (14+ sleeper risk)
  • Palo Pinto tax roll + STR-endorsed insurance quote
1400 Lady Amber Ln, Granbury
Verified
  • Pecan Plantation POA — written STR approval (deal-killer risk)
  • Hood County MUD assessment (Pecan carries extras Anaconda does not)
  • Gated-community guest-access logistics
7085 W Hells Gate Dr, PK
Verified
  • Cost-seg engineer pre-study (24% shield ratio assumed; new-build land ratio may differ)
  • Palo Pinto tax reassessment scenario at $4M basis
  • Trophy-tier STR insurance quote + umbrella policy sizing
1907 Buck Run, PK
Verified
  • Shoreline linear feet + winter drawdown depth at dock
  • The Peninsula POA / STR covenants
  • Dynamic pricing tool (PriceLabs / Wheelhouse) commit — peak discipline is the whole thesis
7060 Hells Gate Loop, Strawn
Verified
  • BRA dock permit + shoreline linear feet (acreage does not guarantee waterfront rights)
  • POA / STR covenants for the Hell's Gate Loop parcel cluster
  • Palo Pinto tax roll + STR-endorsed insurance quote at $1.6M basis
3061 Park Road 36, PK
Verified
  • Confirm list price (currently modeled at $1.5M placeholder)
  • BRA dock permit status + shoreline access
  • Palo Pinto tax roll + POA/HOA verification
1009 Cardinal Cv, Graford
Verified
  • Confirm current list price + DOM
  • BRA dock permit + shoreline linear feet
  • Palo Pinto tax roll + POA/STR covenant review
1260 Rawhide Ridge, Graford
Verified
  • Confirm current list price + DOM
  • BRA dock permit + shoreline linear feet
  • Palo Pinto tax roll + POA/STR covenant review

Cross-cutting inputs to gather in parallel: STR-endorsed insurance quotes (waterfront + pool), PriceLabs / Wheelhouse submarket dashboards (Granbury main body, Pecan Plantation, PK Peninsula, PK Hell's Gate) for seasonality curves, and trailing-90 booked-calendar scrapes from the 5 nearest listed comps per property.

Reference

Glossary of Terms

Plain-English definitions for every acronym and term of art used throughout this memorandum. Share with your CPA, partner, or advisor as a decoder ring.

Tax Strategy
STR Loophole(Short-Term Rental Loophole)
IRS treatment (§469 + Reg. 1.469-1T(e)(3)(ii)) that lets a short-term rental be classified as non-passive — so paper losses from cost seg/bonus depreciation offset W-2 and 1099 income. Requires BOTH: (1) average guest stay ≤ 7 days, AND (2) material participation (typically 100+ hours AND more hours than any other individual, including your PM/cleaner). Miss either test and the losses are trapped as passive and worth $0 against your day job.
Cost Segregation(Cost Seg)
An engineering study that reclassifies parts of a building (flooring, cabinets, landscaping, driveways, appliances, dock, pool equipment) from 27.5/39-year real property into 5-, 7-, and 15-year property. Those shorter-life assets then qualify for bonus depreciation, front-loading a huge Year 1 deduction.
Bonus Depreciation
The IRS lets you deduct 100% of qualifying short-life assets in Year 1 (phasing down: 40% in 2025, currently scheduled 20% in 2026, 0% in 2027 unless Congress restores). Applied on top of cost seg to generate the Y1 tax shield.
Material Participation
IRS test proving you actively run the business. For STR, the easiest path is 100+ hours AND more than anyone else. Requires a contemporaneous time log — audit defense lives or dies on this.
Depreciation Recapture
At sale, the IRS 'claws back' the depreciation you took. §1245 assets (5/7/15-yr from cost seg) recapture at ordinary rates (up to 37%). §1250 (real property) recaptures at a capped 25%. Why exit strategy (1031 exchange or long hold) matters.
§1031 Exchange(1031)
Sell one investment property and roll proceeds into another 'like-kind' property within 180 days to defer all capital gains AND depreciation recapture indefinitely.
Schedule E(Sch E)
The IRS form where rental income and expenses are reported. STR losses that qualify under the loophole flow from Sch E straight against ordinary income on the 1040.
Financing
SBLOC(Securities-Backed Line of Credit)
A revolving line of credit collateralized by your brokerage portfolio (stocks/ETFs). Rate = SOFR + ~1.5%. Lets you borrow the 20% down + CapEx without selling securities (no cap-gains hit) and without touching cash. Risk: margin call if portfolio drops 30%+.
DSCR Loan(Debt Service Coverage Ratio Loan)
Investor loan underwritten on the property's rental income, not your personal DTI. Lenders typically require DSCR ≥ 1.25× (property NOI covers debt payment by 25%). No tax returns, no W-2 required.
DSCR
Formula: Net Operating Income ÷ Annual Debt Service. 1.25× means the property generates $1.25 of income for every $1 of mortgage payment. Below 1.0× = negative carry.
LTV(Loan-to-Value)
Loan amount ÷ property value. DSCR loans usually cap at 80% LTV (20% down). SBLOC caps at 50-70% of portfolio value (we model 30% for margin-call safety).
Amortization
The schedule that pays down principal over the loan term (30 yr for DSCR). Early years are mostly interest — which is fully deductible on Sch E.
Negative Carry
When rental income doesn't cover debt service + operating costs. Reserves must fund the gap. Modeled at ~$30K/yr Y1 for Hoot Ave, absorbed by the tax refund.
Revenue & Operations
ADR(Average Daily Rate)
Average nightly rate charged. Lake Granbury 4BR+ waterfront: $550–$725. PK trophy tier: $650–$1,100.
RevPAR(Revenue Per Available Night)
ADR × Occupancy. The apples-to-apples metric for comparing STR revenue across properties of different sizes/prices.
Occupancy
Booked nights ÷ available nights. Stabilized Y2 waterfront targets: 58-62%.
AirDNA
The industry-standard STR data platform. 'Rentalizer' gives address-specific revenue projections; 'MarketMinder' shows market-wide ADR/occupancy/comp sets.
PM(Property Manager)
Full-service PM typically charges 12% of gross. Danger: PM hours can exceed owner hours and kill material participation — use co-hosting model instead.
OTA(Online Travel Agency)
Airbnb, VRBO, Booking.com. Blended fee ~3% of gross to the host (plus guest-side service fees).
NOI(Net Operating Income)
Gross revenue minus operating expenses (PM, OTA, insurance, utilities, reserves) — BEFORE debt service and depreciation. The numerator in DSCR.
CapEx(Capital Expenditure)
Money spent on improvements that extend the property's life or add value (pool, outdoor kitchen, dock, branding). Depreciable — not an operating expense. This memo models $485K in Y1 CapEx.
FF&E(Furniture, Fixtures & Equipment)
Beds, sofas, appliances, décor, hot tub, game equipment. 100% cost-segregable and bonus-depreciable in Y1.
Entity & Deal Structure
LOI(Letter of Intent)
Non-binding offer outlining price, terms, and contingencies. Precedes the purchase contract.
LLC(Limited Liability Company)
Pass-through entity that isolates STR liability (guest injury, drowning, water damage) from personal assets. Series LLC allows multiple properties under one umbrella.
TIC(Tenants in Common)
Alternative to a partnership LLC — each partner owns an undivided fractional interest, files own Sch E. Preserves each partner's individual 1031 flexibility.
K-1
Tax form issued by a partnership/LLC to each partner showing their share of income, deductions, and credits. Feeds each partner's personal 1040.
50/50 Partnership
This memo's alternate structure — two 37%-bracket partners split basis, CapEx, and tax shield equally to hit a combined $500K+ savings target.
Modeling & Metrics
IRR(Internal Rate of Return)
Annualized return over the hold period, accounting for timing of cash flows AND terminal exit value. The single-number benchmark for comparing investments.
Cash-on-Cash Return
Annual pre-tax cash flow ÷ cash invested. With SBLOC = $0 cash out, this metric becomes 'infinite' — which is why we track wealth growth instead.
Monte Carlo Simulation
Runs 2,000 randomized trials varying ADR, occupancy, and expenses to show the probability distribution of outcomes — not just a single point estimate.
Sensitivity Analysis
Table showing how the answer changes when one input moves (e.g., what if ADR is 10% lower AND occupancy 5% lower?).
Tornado Chart
Bar chart ranking which inputs have the biggest impact on the output. Tells you where to focus underwriting rigor.
S&P 500 Compounding
The wealth engine: Y1 tax refund + annual cash flow reinvested in the S&P at 8% nominal CAGR. This is how a 'break-even' rental becomes a $648K → $1.4M wealth builder.
Markets & Places
Lake Granbury
Reservoir on the Brazos River, Hood County, TX. 45 min SW of DFW. Constant-level lake, ~8,700 acres. Property tax 1.33%. STR-permissive.
PK (Possum Kingdom Lake)
Larger reservoir NW of DFW, Palo Pinto County. Iconic 'Hells Gate' cliffs. Higher ADR ceiling than Granbury but more seasonal. Property tax 1.75%. Docks require BRA permit.
BRA(Brazos River Authority)
Governs shorelines and docks on both Granbury and PK. Existing permitted dock = major value; new dock permits are slow/limited.
Hood CAD / Palo Pinto CAD(County Appraisal District)
Sets property tax assessed value. STR use often triggers reassessment above homestead value — modeled as a risk in the memo.