Sign up for our newsletter
Monthly insights, tips, and exclusive offers for STR investors.
All Real Estate Services are offered through Chalet Realty (DBA of Mahalla Realty LLC).
Texas Real Estate Commission Consumer Protection NoticeTexas Real Estate Commission Information About Brokerage ServicesTREC DisclaimerChalet (“GetChalet Inc.”) provides general educational content and tools for real-estate investors. Chalet is not a law firm, CPA firm, or investment adviser, and does not provide tax, legal, or accounting advice. Nothing on this site creates a CPA-client, attorney-client, or fiduciary relationship. Tax laws change, and state rules may differ from federal rules (e.g., California decouples from federal bonus depreciation). Always consult your own qualified tax and legal professionals about your specific situation.
The term 'Airbnb' is used on our site in a colloquial sense, akin to saying 'I am going to Airbnb it.' This usage is intended to refer broadly to the concept of short-term rentals and not specifically to the Airbnb platform or services. Airbnb, Inc. is not affiliated with Chalet, nor does it endorse or sponsor our services. We use the term in this generalized manner to easily convey the idea of participating in short-term rental activities, recognizing 'Airbnb' as a term familiar to many in this context.
Affiliate & Referral Disclosure. Chalet may receive referral fees or other consideration when you engage with featured agents, lenders, cost-seg providers, or other partners referenced on this site. These relationships may influence which partners we present. We follow the FTC Endorsement Guides and aim to disclose material connections clearly and conspicuously.
Chalet (DBA of GetChalet Inc.) is not affiliated, associated, authorized, endorsed by, or in any way officially connected with Airbnb, Airbnb.com, or any of its subsidiaries or its affiliates. The official Airbnb website can be found at http://www.airbnb.com. The name "Airbnb" as well as related names, marks, emblems and images are registered trademarks of Airbnb, Inc.
382 Carpenter St, Columbus, OH 43205, USA
Priced too high to cash-flow with a loan — an equity or tax play, not income.
Investment potential
Your scenario · adjust the levers below or open advanced settings to see how returns change
$36,585
$3,049/mo · at 63% occupancy & $201/night
-$24,472
-$2,039/mo after costs & mortgage
Cap rate
2%
Cash-on-cash
-13.8%
DSCR
0.33
Confidence
Your assumptions
Revenue
$36,585/yr
Market avg: $36,585/yr · 63% occ · $201 ADR
Financing
$36,363/yr
Operating costs
$24,693/yr
How this property compares to similar short-term rentals nearby.
Comparable set · 27 properties
$143–$337
Median $201
33%–89%
Median 63%
$20.9K–$63.1K
Median $36.9K
209–365
Median 290
This property · $36.6K
Comparable properties (27)
Cash flow potential Low · Appreciation potential Medium
358 days available · 196 days booked ·
365 days available · 272 days booked ·
365 days available · 279 days booked ·
335 days available · 215 days booked ·
365 days available · 246 days booked ·
290 days available · 152 days booked ·
293 days available · 198 days booked ·
287 days available · 213 days booked ·
365 days available · 176 days booked ·
302 days available · 213 days booked ·
279 days available · 172 days booked ·
313 days available · 195 days booked ·
294 days available · 184 days booked ·
333 days available · 194 days booked ·
287 days available · 170 days booked ·
297 days available · 221 days booked ·
231 days available · 105 days booked ·
244 days available · 178 days booked ·
287 days available · 164 days booked ·
241 days available · 151 days booked ·
209 days available · 157 days booked ·
301 days available · 135 days booked ·
237 days available · 148 days booked ·
261 days available · 86 days booked ·
245 days available · 119 days booked ·
253 days available · 85 days booked ·
247 days available · 134 days booked ·
Revenue and occupancy reflect Chalet's modeled estimates from observed booking activity for comparable active listings. Individual results vary with management, seasonality, and pricing.
Who this property is for
The same property is a great buy for one investor and a trap for another. Here's the honest read.
1031 / high-equity buyer
~$150.0K
Year-1 tax shield
Buying with cash or low leverage removes the debt-coverage problem entirely, so the thesis rests on appreciation plus a large first-year write-off. At roughly 25% of purchase price, the shield is substantial enough to carry the deal on its own.
Price-disciplined buyer
—
Break-even purchase price
Even a deep discount doesn't get this deal to break even within a realistic range, so there's no price anchor to negotiate toward. A price-disciplined buyer should pass unless the revenue assumptions change.
DSCR cash-flow buyer
0.33
DSCR at asking
At asking price the property doesn't cover its own debt service, so it won't qualify for DSCR financing as modeled. If you need cash flow from day one, look at a mid-term-rental fallback or a different Columbus submarket.
For a buyer who materially participates and qualifies for the STR tax treatment.
$150.0K
Estimated first-year deduction · range $124.5K–$171.0K
Why this matters here
At a marginal bracket, this deduction can be worth $46.1K–$63.3K in estimated federal tax saved.
This only applies if you meet the IRS material-participation tests for short-term rentals and are not using a full-service property manager.
Estimate, subject to CPA review. Cost-segregation percentages shown here are illustrative and depend on an actual study of the property.
Some states do not conform to federal bonus depreciation, so your state may not allow the same first-year treatment shown above.
Chalet can introduce a cost-segregation partner — this is not tax, legal, or financial advice.
How cash-on-cash return moves with purchase price. The marked line is break-even (1.0 DSCR).
At this price: cash-on-cash -13.8%, DSCR 0.33, cash flow -$24,472/yr
| Price vs asking | Price | Cash-on-cash | DSCR | Band |
|---|---|---|---|---|
| -25% | $455,475 | -11.1% | 0.44 | Below break-even |
| -22% | $473,694 | -11.5% | 0.42 | Below break-even |
| -15% | $516,205 | -12.3% | 0.38 | Below break-even |
| -8% | $558,716 | -13.0% | 0.36 | Below break-even |
| Asking | $607,300 | -13.8% | 0.33 | Below break-even |
| +8% | $655,884 | -14.4% | 0.30 | Below break-even |
| +15% | $698,395 | -14.8% | 0.28 | Below break-even |
Break-even price
Out of range
This deal does not reach break-even within ±25% of asking.
Discount needed
—
The gap between asking and the price a cash-flow buyer can underwrite.
If refi to 5.5% in 24 mo
+$5,330/yr
Illustrative cash-flow improvement at asking price if rates fall. Planning figure, not a forecast.
Annual avg $3,049 · peaks at $4,362 in Apr
Annual avg 59% · peaks at 69% in Apr
−$2,039/mo after all expenses
Cash to close
Down payment, closing costs, and furnishing
$176,117
Return on cash:3.3%
DSCR below 1.0 — but you can still qualify
Your DSCR is 0.33 · lenders typically require 1.0+.
Get matched with 2–3 vetted STR lenders, free.
What the deal returns over the hold — including the tax shield, which is the whole point for an appreciation buyer.
Levered IRR
6.2%
over 5-yr hold, with tax shield
Equity multiple
1.4×
total proceeds vs. $176,117 invested
Projected value at exit
$775,086
year 5 · 5.0% annual appreciation
Tax shield contribution
+5.6 pts
of IRR comes from year-1 depreciation
| Year | Equity | Appreciation | Cumulative cash flow | Total value |
|---|---|---|---|---|
| Year 1 | $156,452 | $30,365 | $31,029 | $217,846 |
| Year 2 | $161,413 | $62,248 | $7,106 | $230,767 |
| Year 3 | $166,733 | $95,726 | -$16,260 | $246,198 |
| Year 4 | $172,437 | $130,877 | -$39,061 | $264,253 |
| Year 5 | $178,554 | $167,786 | -$61,288 | $285,052 |
Projection, not a promise.
Assumes 5.0% annual appreciation, 1.5% rent growth (operating costs held flat), and that the property qualifies for short-term-rental tax treatment. The year-1 depreciation shield depends on a real cost-segregation study and your tax situation — consult a CPA.
Appreciation is the dominant driver of this return. When cash flow is negative, the deal depends on the property gaining value — it is not paying for itself from income.
Appreciation, rent growth, and financing rates are editable under Edit financials.
STR deals turn on local rules and demand that a generalist agent misses. Chalet matches you with a vetted Columbus agent who knows which properties actually cash flow — and which to avoid.
© 2026 Chalet. All rights reserved.
This analysis is generated by Chalet's Airbnb Calculator
Visit getchalet.com for more tools
Real Estate Investment Analysis & Market Insights
Disclaimer
This page and the data presented are for informational purposes only. The information provided should not be construed as financial, legal, or investment advice. Market conditions can change rapidly, and past performance does not guarantee future results. Always consult with qualified professionals before making investment decisions.
783 Ann St, Columbus, OH 43206, USA
3 bed 2 bath 8 guests
Revenue
$38,077/yr
Daily Rate
$218
Occupancy
0.6%
907 S Champion Ave, Columbus, OH 43206, USA
6 bed 2 bath 14 guests
Revenue
$41,573/yr
432 E Rich St, Columbus, OH 43215, USA
3 bed 2 bath 8 guests
Revenue
$32,624/yr
603 East Columbus Street, Columbus, OH, USA
3 bed 2 bath 8 guests
Revenue
$38,077/yr
248 N 18th St, Columbus, OH 43203, USA
4 bed 4 bath 10 guests
Revenue
$49,687/yr
Mt Vernon Ave, Columbus, OH, USA
1 bed 1 bath 2 guests
Revenue
$16,588/yr
Daily Rate
$285
Occupancy
0.5%
Daily Rate
$215
Occupancy
0.6%
Daily Rate
$218
Occupancy
0.6%
Daily Rate
$396
Occupancy
0.5%
Daily Rate
$118
Occupancy
0.5%