Will it cash flow?
Acquisition & Financing
$
%
$
%
$
$
$
%
Loan Amount$0
Monthly P&I$0
Total Cash Needed at Closing$0
Revenue
$
$
$
$
$
Leave a comp at $0 to exclude it. The average of the comps you fill in becomes your Base case.
$
%
Selected Annual Revenue$0
$
%
ADR × occupancy implies $0 a year — a sanity check against your comps.
Operating Expenses — Annual
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
%
%
Total Operating Expenses$0
Net Operating Income$0
Setup — Furniture, Amenities, Renovation
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
Setup Total — used in the model$0
How does it build equity?
%
$
Projection Assumptions
%
%
Every expense except debt service inflates each year. Debt service runs for the full loan term, then stops.
Year-1 Appreciation Gain$0
Year-1 Principal Paydown$0
Equity at End of Year 1$0
How much does it shelter?
$
Do You Qualify?
Cost Segregation
%
%
%
yr
Total Depreciable Basis$0
First-Year Bonus Depreciation$0
Combined Effective Rate0%
Deal Test
%
The Verdict
—
Total Orbit Return · Year 1
$0
Cash flow + equity gain + tax savings
FlowAnnual cash flow after debt service
$0
GrowAppreciation + paydown + forced
$0
KeepCost seg / bonus depreciation savings
$0
Orbit ROI · Year 1Total Orbit return ÷ cash invested
0%
Monthly Cash Flow
$0
Cash-on-Cash
0%
Cap Rate
0%
DSCR
0.00
Break-Even Revenue
$0
Cash Invested
$0
Estimate only, not tax or investment advice. Depreciation is a deferral — recapture applies at sale. Verify with your CPA.
30-Year Orbit Projection
30-Year Total Return
$0
Equity at Year 30
$0
Cumulative Cash Flow
$0
Cash Recovered By ?
—
Flow
Grow
Keep
annual return by source
Yr 1102030
| Year | Revenue | Expenses | Debt Service | Flow | Grow | Keep | Total | Equity (EOY) | Return % |
|---|
Year 1 return is measured against the cash you invested. Every year after that is measured against the equity you held at the start of the year — the return on the capital actually sitting in the deal.