Build the property worksheet
Jump to results & research tasks ↓Enter an explicit 0 only when a cost does not apply. Blanks remain unknown.
Purchase & financing
Where to find it & what to check
Use the intended offer price. Confirm closing and setup costs separately.
Record a source or next actionWhere to find it & what to check
Ask the lender for the actual down-payment requirement and permitted property use.
Record a source or next actionWhere to find it & what to check
Use a written quote. This model holds a fixed principal-and-interest payment; it does not model refinancing.
Record a source or next actionWhere to find it & what to check
Enter an amortizing loan term. Balloon and interest-only loans are outside this prototype.
Record a source or next actionWhere to find it & what to check
Include lender fees, title/escrow and other acquisition costs from a written estimate.
Record a source or next actionCash reserve · explain
Property cash available for uneven receipts, bills and unexpected expenses. A reserve floor is your chosen minimum balance. Adding cash improves liquidity but does not improve operating income.
Where to find it & what to check
Dedicated property cash held after acquisition, separate from your household emergency fund.
Record a source or next actionSTR revenue & launch
Where to find it & what to check
Include furnishing, repairs, permits and pre-opening carrying costs.
Record a source or next actionAverage daily rate (ADR) · explain
Average room revenue per paid night in this site, excluding cleaning charges and lodging taxes. An advertised nightly price is not necessarily the rate actually earned. Check other sources’ definitions before comparing.
Where to find it & what to check
Use comparable paid-night rates, not only peak advertised prices. Room revenue only; excludes cleaning fees and tax collections.
Research STR income →Record a source or next actionPaid-night occupancy · explain
Paid nights divided by the nights offered for rental, including both booked and still-open nights. A 60% occupancy assumption over 300 available nights means 180 paid nights. Owner-blocked nights do not earn room revenue.
Where to find it & what to check
Paid nights divided by available nights. Personal-use days must be removed from availability.
Research STR income →Record a source or next actionWhere to find it & what to check
Exclude personal-use and unavailable nights. The prototype distributes availability evenly across months.
Research STR income →Record a source or next actionSTR itemized operating budget
Where to find it & what to check
Check the host fee schedule for the listing platform and fee structure you expect. This model charges it on room revenue.
Record a source or next actionWhere to find it & what to check
Use a written management proposal. Confirm which revenue the fee applies to and extra leasing or setup charges. This model applies the percentage to collected room revenue.
Build an expense budget →Record a source or next actionWhere to find it & what to check
Estimate recurring repairs from property condition and contractor/manager input. Capital replacements belong in the replacement budget. This model applies the percentage to collected room revenue.
Build an expense budget →Record a source or next actionWhere to find it & what to check
Enter variable utilities, supplies and net cleaning cost per night. If cleaning fees fully offset cleaning expense, include neither.
Record a source or next actionWhere to find it & what to check
Ask the assessor about the expected assessed value after purchase, exemptions and special assessments. Save the estimate and date.
Build an expense budget →Record a source or next actionWhere to find it & what to check
Obtain a written quote for this rental use. Check exclusions, deductibles and interruption coverage; do not reuse an owner-occupied quote.
Build an expense budget →Record a source or next actionWhere to find it & what to check
Request twelve months of bills. Separate fixed utility charges from STR usage already included per occupied night.
Build an expense budget →Record a source or next actionWhere to find it & what to check
Review the current dues schedule, rental restrictions and special assessments.
Build an expense budget →Record a source or next actionWhere to find it & what to check
Check official local renewal fees. Put initial setup fees in setup costs; avoid counting the same fee twice.
Record a source or next actionWhere to find it & what to check
List what this includes in your evidence notes. Do not include debt service, capital replacement funding or costs already entered elsewhere.
Record a source or next actionReplacement funding · explain
Money you plan to set aside for major components such as a roof or HVAC system. It reduces modeled distributable cash, but an internal transfer does not reduce consolidated property cash. Actual repairs or replacements do.
Where to find it & what to check
Build a component list: roof, HVAC, appliances and furnishings. Estimate remaining life and replacement cost. This internal allocation reduces distributable cash, not consolidated reserve cash.
Build an expense budget →Record a source or next actionLTR revenue & launch
Where to find it & what to check
Include rent-ready repairs, initial leasing and pre-opening carrying costs.
Record a source or next actionWhere to find it & what to check
Use rent supported by comparable leases or a local manager. Separate concessions and utility arrangements.
Research LTR rent →Record a source or next actionVacancy / nonpayment · explain
An allowance for rent that is not collected. Here it reduces scheduled LTR rent. Avoid counting the same vacant month, concession or unpaid rent twice.
Where to find it & what to check
Base allowance for vacancy and nonpayment combined. Do not count the same lost rent twice.
Research LTR rent →Record a source or next actionLTR itemized operating budget
Where to find it & what to check
Use a written management proposal. Confirm which revenue the fee applies to and extra leasing or setup charges. This model applies the percentage to collected rent.
Build an expense budget →Record a source or next actionWhere to find it & what to check
Estimate recurring repairs from property condition and contractor/manager input. Capital replacements belong in the replacement budget. This model applies the percentage to collected rent.
Build an expense budget →Record a source or next actionWhere to find it & what to check
Ask the assessor about the expected assessed value after purchase, exemptions and special assessments. Save the estimate and date.
Build an expense budget →Record a source or next actionWhere to find it & what to check
Obtain a written quote for this rental use. Check exclusions, deductibles and interruption coverage; do not reuse an owner-occupied quote.
Build an expense budget →Record a source or next actionWhere to find it & what to check
Request twelve months of bills. Separate fixed utility charges from STR usage already included per occupied night.
Build an expense budget →Record a source or next actionWhere to find it & what to check
Review the current dues schedule, rental restrictions and special assessments.
Build an expense budget →Record a source or next actionWhere to find it & what to check
Ask local managers about tenant placement, renewal fees and expected tenancy length. Annualize recurring leasing costs; initial placement belongs in setup.
Record a source or next actionWhere to find it & what to check
List what this includes in your evidence notes. Do not include debt service, capital replacement funding or costs already entered elsewhere.
Record a source or next actionReplacement funding · explain
Money you plan to set aside for major components such as a roof or HVAC system. It reduces modeled distributable cash, but an internal transfer does not reduce consolidated property cash. Actual repairs or replacements do.
Where to find it & what to check
Build a component list: roof, HVAC, appliances and flooring. Estimate remaining life and replacement cost. This internal allocation reduces distributable cash, not consolidated reserve cash.
Build an expense budget →Record a source or next actionPercentages apply to collected revenue. Annual costs exclude debt, setup and replacement funding unless explicitly labeled. Avoid counting cleaning costs both here and in net per-night costs.
Follow the money · annual
| Annual breakdown | STR | LTR |
|---|---|---|
| Collected operating income | $77,350 | $28,500 |
| Revenue & night-based costs | $23,622 | $3,420 |
| Fixed operating expenses | $16,500 | $12,000 |
Net operating income · explainCollected operating income minus operating expenses, before loan payments, income taxes, depreciation and capital replacements. In this site’s model, $50,000 income less $20,000 operating costs gives $30,000 NOI. | $37,229 | $13,080 |
Loan principal & interest · explainThe loan repayment plus interest. The Deal Lab models fixed-rate amortizing debt. Enter taxes and property insurance separately in operating costs, even if the lender collects them through escrow. Account for other loan charges separately. | $21,890 | $21,890 |
Replacement allocation · explainMoney you plan to set aside for major components such as a roof or HVAC system. It reduces modeled distributable cash, but an internal transfer does not reduce consolidated property cash. Actual repairs or replacements do. | $3,600 | $3,600 |
Cash flow after allocation · explainIn this site, NOI minus loan principal and interest and planned replacement funding. This is a pre-tax planning amount, not a total investment return. | $11,738 | -$12,410 |
| Cash required at purchase (one time) | $153,750 | $131,750 |
Cap rate (annual) · explainAnnual NOI divided by purchase price in this model. It describes operating income relative to price before financing; it does not include appreciation or sale proceeds. | 9.9% | 3.5% |
Cash-on-cash return (annual) · explainHere, annual cash flow after replacement funding divided by down payment, closing costs, setup and starting reserve. $2,400 divided by $100,000 is 2.4%. Other tools may count invested cash differently. | 7.6% | -9.4% |
Monthly averages are annual amounts divided by 12, not a month-by-month forecast. Acquisition cash includes down payment, closing, setup and reserves.
What does break-even require?
| Annual breakdown | STR | LTR |
|---|---|---|
| Paid-night occupancy | 53.1% | — |
| Monthly lease rent | — | $3,737 |
Covers operating costs, debt and replacement funding. Occupancy above 100% is unattainable with these inputs. No appreciation, tax benefits or sale proceeds are included.