DealYield
Formula governance

Calculator Methodology Index

Inspect the exact released version, field units, modeling assumptions, exclusions, and representative example behind each public calculator.

Content taxonomy

4 connected analysis clusters

Each cluster groups a distinct investor question without turning close keyword variants into duplicate pages.

Rental operations

Evaluate whether recurring rental income covers vacancy, operating expenses, debt service, and a cash-flow target.

Financing and debt

Test how property value, NOI, payment structure, and coverage constraints affect a modeled loan.

Returns and valuation

Compare property-level income yield with the cash return created by financing and upfront investment.

Renovation and exit

Reconcile transaction cash and model the complete cost and return of a renovation-and-resale project.

Released definitions

13 versioned methodology records

Version identifiers come from the same formula modules used by the calculators. A result-changing correction requires a new version.

Rental operationsrental-roi@1.1.0

Rental Property ROI baseline

Connect a rental property’s operating assumptions, fixed-rate financing, cash flow, property yield, cash yield, and break-even position.

Last reviewed

Inputs and units

Price, down payment, loan, and closing costs
USD
Interest rate and vacancy
annual %
Loan term
years
Rent and itemized operating expenses
USD/month

Outputs and units

Effective rent, operating expenses, debt service, and cash flow
USD/month
Annual cash flow and NOI
USD/year
Cap rate, cash-on-cash return, expense ratio, and break-even occupancy
%
Break-even rent
USD/month

Model assumptions

  • All income, expense, and financing inputs describe one internally consistent scenario.
  • The fixed-rate mortgage payment amortizes over the entered term.
  • NOI excludes debt service; pre-tax cash flow subtracts it.

Not modeled

  • Appreciation, sale proceeds, refinance proceeds, and multiyear return timing
  • Income taxes, depreciation, tax benefits, and jurisdiction-specific rules
  • Variable-rate, balloon-refinance, and complex multi-unit lease structures

Worked example

A $300,000 purchase with $84,000 total cash invested, $2,700 monthly rent, 5% vacancy, $986 monthly operating expenses, and a $225,000 loan produces $156.85 monthly cash flow, $18,948 NOI, 6.32% cap rate, and 2.24% cash-on-cash return.

Rental operationsnoi@1.0.0

Net operating income

Audit property income, vacancy, and recurring operating expenses before applying financing or valuation metrics.

Last reviewed

Inputs and units

Scheduled rent and other operating income
USD/year
Vacancy and credit loss
USD/year
Itemized recurring operating expenses
USD/year

Outputs and units

Gross potential and effective gross income
USD/year
Total operating expenses and NOI
USD/year
Monthly NOI equivalent
USD/month
Vacancy rate and operating expense ratio
%

Model assumptions

  • Income, vacancy, and every operating expense use the same annual period.
  • Replacement reserves are included as an operating expense when entered.
  • The calculator uses property-level operating income before financing and owner tax effects.

Not modeled

  • Debt service, loan fees, depreciation, amortization, and income taxes
  • Purchase price, acquisition costs, sale proceeds, and selling costs
  • Major one-time renovation projects unless represented by a recurring reserve

Worked example

$36,000 scheduled rent less $1,800 vacancy and $12,000 itemized operating expenses produces $34,200 effective gross income and $22,200 annual NOI.

Financing and debtdebt-yield@1.0.0

Debt yield

Compare annual NOI with loan principal and reverse-solve the income or principal that exactly meets an editable target.

Last reviewed

Inputs and units

Net operating income
USD/year
Loan amount
USD
Target debt yield
%

Outputs and units

Debt yield and target comparison
%
Required NOI and NOI difference
USD/year
Maximum loan and loan difference at target
USD

Model assumptions

  • NOI and loan principal describe the same property and analysis date.
  • The entered target is a user scenario, not a DealYield or lender benchmark.
  • The inverse calculations hold all other entered values constant.

Not modeled

  • Interest rate, amortization, payment timing, and borrower qualification
  • Property value, LTV, and collateral underwriting
  • Loan pricing, approval, commitment, and lender-specific NOI adjustments

Worked example

$100,000 annual NOI divided by a $1,000,000 loan produces a 10.00% debt yield and exactly meets the example 10.00% target.

Financing and debtloan-to-value@1.0.0

Loan-to-value ratio

Compare one modeled first-lien loan with one explicitly selected property-value basis and reverse-solve the principal and arithmetic equity that meet an editable LTV target.

Last reviewed

Inputs and units

Purchase price, current market value, and after-repair value
USD
Selected property-value basis
purchase, current, or ARV
Modeled first-lien loan amount
USD
Editable maximum LTV
%

Outputs and units

Loan-to-value and selected-target status
% and status
Maximum modeled loan at target
USD
Current and minimum target equity
USD
Remaining capacity or additional reduction/equity required
USD

Model assumptions

  • One positive purchase price, current market value, or after-repair value is explicitly selected as the denominator.
  • The entered loan is one modeled first-lien principal amount and the target maximum LTV is an editable scenario assumption.
  • Current and target equity are arithmetic value-minus-loan differences, not estimates of sale proceeds or cash invested.

Not modeled

  • Appraisal, valuation verification, market forecasts, and lender selection of the value basis
  • Subordinate liens, combined LTV, loan-to-cost, borrower qualification, pricing, and approval
  • Closing costs, tax effects, debt service, sale proceeds, and refinance proceeds

Worked example

A $300,000 modeled loan divided by a selected $400,000 purchase price produces 75.00% LTV. At an editable 80.00% maximum, modeled principal is $320,000, current equity is $100,000, minimum target equity is $80,000, and remaining capacity is $20,000.

Financing and debtmaximum-loan-amount@1.0.0

Combined maximum loan amount

Estimate one first-mortgage amount supported simultaneously by selected LTV, debt-yield, and DSCR constraints.

Last reviewed

Inputs and units

Property value and NOI
USD
Maximum LTV and target debt yield
%
Target DSCR
ratio
Interest rate, amortization, and loan term
% and years

Outputs and units

LTV, debt-yield, DSCR, and combined loan limits
USD
Binding constraint and modeled coverage/leverage
label and ratios
Payment capacity and modeled payment
USD/month and USD/year
Balance remaining at modeled maturity
USD

Model assumptions

  • LTV, debt-yield, and DSCR targets are user-entered scenario constraints.
  • DSCR sizing uses a fixed-rate amortizing payment over the entered amortization period.
  • The smallest valid modeled limit is the combined maximum; ties remain visible.

Not modeled

  • Borrower credit, liquidity, guarantees, loan fees, and lender approval
  • Interest-only sizing, stressed lender conventions, and product-specific adjustments
  • Appraisal conclusions, market value verification, and subordinate debt

Worked example

A $1,400,000 property with $100,000 NOI, 75% LTV, 10% debt yield, 1.25× DSCR, 7.25% interest, 30-year amortization, and a 10-year term is limited by DSCR to $977,264.51.

Rental operationsrental-break-even@1.0.0

Rental break-even

Solve the scheduled rent or collected occupancy required to cover monthly costs and an optional cash-flow target.

Last reviewed

Inputs and units

Scheduled rent, other income, operating expenses, debt service, and cash-flow target
USD/month
Collected occupancy
%
Presentation mode
rent or occupancy

Outputs and units

Required scheduled rent
USD/month
Required collected occupancy
%
Modeled cash flow and target margin
USD/month
Rent and occupancy margins
USD/month and percentage points

Model assumptions

  • Every money input uses a monthly period.
  • Collected occupancy combines vacancy, turnover, concessions, and collection loss.
  • Other income is a fixed collected amount and is not automatically adjusted by occupancy.

Not modeled

  • Market-rent, leasing, or occupancy forecasts
  • Rent regulation, financing eligibility, and lender underwriting
  • Property-level NOI break-even because direct debt service is included

Worked example

$2,700 scheduled rent at 95% occupancy, $100 other income, $986 operating expenses, $1,422.15 debt service, and a $250 target requires $2,692.79 rent or 94.75% occupancy.

Returns and valuationcap-rate@1.0.0

Capitalization rate

Compare annual NOI with property value and explore inverse valuation or income targets.

Last reviewed

Inputs and units

Property value
USD
Gross rent, vacancy allowance, and operating expenses
USD/year
Optional target cap rate
%
Optional target property value
USD

Outputs and units

Net operating income
USD/year
Capitalization rate
%
Implied property value and required NOI
USD

Model assumptions

  • Rent, vacancy, and operating expenses describe the same annual period.
  • NOI is measured before financing and owner-specific tax effects.
  • Target cap rate and target property value are optional user scenarios.

Not modeled

  • Mortgage payments, financing fees, and borrower structure
  • Appreciation, future sale proceeds, and a forecast exit cap rate
  • Income taxes, depreciation, and one-time capital projects

Worked example

A $300,000 property with $36,000 gross annual rent, $1,800 vacancy, and $12,000 operating expenses produces $22,200 NOI and a 7.40% cap rate.

Returns and valuationcash-on-cash-return@1.0.0

Cash-on-cash return

Compare annual pre-tax cash flow with the total cash invested upfront.

Last reviewed

Inputs and units

Annual pre-tax cash flow
USD/year
Down payment, closing costs, improvements, and other upfront cash
USD

Outputs and units

Total cash invested
USD
Annual and monthly cash-flow equivalents
USD/year and USD/month
Cash-on-cash return
%

Model assumptions

  • Annual pre-tax cash flow and upfront cash belong to the same scenario.
  • Every entered upfront amount is funded by the investor.
  • A zero cash-invested denominator produces an unavailable return.

Not modeled

  • Appreciation, sale proceeds, and refinance proceeds
  • Principal paydown, depreciation, and income-tax effects
  • Multiyear cash-flow timing and internal rate of return

Worked example

$12,000 annual pre-tax cash flow divided by $80,000 of down payment, closing, improvement, and other upfront cash produces a 15.00% cash-on-cash return.

Financing and debtmortgage-payment@1.0.0

Mortgage payment

Translate a fixed-rate loan structure into payments, financing costs, total interest, and scheduled balance snapshots.

Last reviewed

Inputs and units

Loan amount and fixed financing fees
USD
Interest rate and points
annual %
Loan term and interest-only opening period
years and months
Property taxes, insurance, and HOA
USD/month

Outputs and units

Principal-and-interest and total payment
USD/month
Post-interest-only payment when applicable
USD/month
Lifetime interest, points, and financing fees
USD
Scheduled loan balances
USD by month

Model assumptions

  • The note rate is fixed for the modeled payment path.
  • An interest-only phase is followed by amortization of the original balance over the remaining term.
  • Taxes, insurance, and HOA are fixed user-entered monthly amounts.

Not modeled

  • Loan approval, APR, escrow rules, prepaid interest, and lender disclosures
  • Adjustable rates, payment caps, negative amortization, and extra principal
  • Future changes in property costs, refinancing, default, and prepayment charges

Worked example

A $225,000 loan at 6.50% for 30 years produces $1,422.15 monthly principal and interest; adding $450 in property costs produces a $1,872.15 initial total payment.

Financing and debtdscr@1.0.0

Debt service coverage ratio

Compare property NOI with scheduled debt service and reverse-solve payment capacity or required income at an editable target.

Last reviewed

Inputs and units

NOI and annual debt service
USD/year
Or rent, operating expenses, and mortgage payment
USD/month
Target DSCR
ratio

Outputs and units

NOI and annual debt service
USD/year
DSCR and threshold result
ratio and status
Maximum debt service and payment
USD/year and USD/month
Required NOI
USD/year

Model assumptions

  • NOI and debt service describe the same property and annual period.
  • Monthly mode annualizes entered rent, expenses, and mortgage payment.
  • The target is an editable scenario rather than a universal lender rule.

Not modeled

  • Loan approval, borrower qualification, and lender-specific underwriting
  • Property value, LTV, loan principal, and payment amortization
  • Income normalization or verification of the entered operating statement

Worked example

$75,000 annual NOI divided by $60,000 annual debt service produces a 1.25× DSCR and exactly meets the example 1.25× target.

Rental operationsprorated-rent@1.0.0

Inclusive partial-month rent comparison

Compare one US-style USD partial-month rent period under explicit calendar and daily-rate conventions without interpreting a lease or selecting a legally correct method.

Last reviewed

Inputs and units

Monthly scheduled rent
USD/month
Mode and billing month
move-in or move-out; YYYY-MM
Inclusive move-in or move-out boundary date
YYYY-MM-DD
Optional lease-defined daily rate
USD/day

Outputs and units

Chargeable and non-chargeable calendar days
days
Daily rate and prorated charge by method
USD/day and USD
Difference from actual-days and full monthly rent
USD
Lowest, highest, and spread across modeled charges
USD

Model assumptions

  • Move-in counts the entered boundary date through month end, while move-out counts the first of the month through the entered boundary date; both boundaries are inclusive.
  • Actual-days, 30-day, annual/365, and the optional user-entered lease daily rate share one chargeable-day count and differ only in daily-rate convention.
  • A full chargeable calendar month returns monthly scheduled rent under every method instead of extending a daily convention beyond its partial-month purpose.

Not modeled

  • State or local legal determinations, lease interpretation, and selection of a required or preferred method
  • Rent collection, tenant ledgers, late fees, deposits, concessions, taxes, and property-management workflows
  • Periods spanning more than one billing month, time-of-day possession rules, and any credit or refund entitlement

Worked example

For $1,800 monthly rent and an inclusive February 12, 2028 move-in, 18 of 29 days are chargeable. Actual-days produces $1,117.24, 30-day produces $1,080.00, annual/365 produces $1,065.21, and a user-entered $58.50 daily rate produces $1,053.00, a $64.24 spread.

Renovation and exitclosing-costs@1.0.0

Buyer cash to close and seller proceeds before tax

Itemize one buyer or seller closing scenario and reconcile buyer cash to close, potential buyer basis additions, or seller proceeds before tax without inventing jurisdiction-specific fees.

Last reviewed

Inputs and units

Buyer purchase price and itemized buyer costs
USD
Buyer loan funds, deposit, credits, and other amount due
USD
Seller sale price and itemized seller costs
USD
Seller payoff obligations and other amount due
USD

Outputs and units

Buyer closing costs and potential basis additions
USD
Buyer cash to close and signed cash direction
USD and direction
Seller closing costs and payoff obligations
USD
Seller proceeds before tax and signed cash direction
USD and direction

Model assumptions

  • Buyer and seller modes describe separate sides of one US-style USD closing scenario.
  • Every cost, credit, deposit, payoff, and other adjustment is entered by the user rather than inferred from a location or percentage.
  • Potential buyer basis additions include only explicitly classified acquisition-cost lines and still require tax review.

Not modeled

  • State-specific fees, local transfer charges, customary rates, and settlement-provider estimates
  • Capital-gains, depreciation-recapture, income, withholding, and other tax calculations
  • Loan approval, legal conclusions, final settlement reconciliation, and tax-basis determinations

Worked example

A $300,000 buyer scenario with $16,000 of entered costs and $234,000 paid or credited produces $82,500 cash to close and $6,500 of potential basis additions. A separate $400,000 seller scenario with $31,000 of entered costs and $250,000 of payoff obligations produces $120,000 of proceeds before tax.

Renovation and exitflip-profit@1.0.0

Flip profit

Separate a renovation-and-resale project’s cost layers and calculate profit, ROI, break-even sale price, and a target-profit purchase allowance.

Last reviewed

Inputs and units

Purchase, closing, rehab, financing, and selling costs
USD
Holding period and monthly holding costs
months and USD/month
Contingency and agent commission
%
Sale price and target profit
USD

Outputs and units

Holding, contingency, commission, and total project costs
USD
Net sale proceeds and estimated profit
USD
Project and annualized ROI
%
Break-even sale price and maximum allowable offer
USD

Model assumptions

  • Acquisition, renovation, carrying, financing, and sale inputs describe one finite project.
  • Holding costs scale linearly with the entered holding months.
  • Commission and contingency are percentages of sale price and rehab budget respectively.

Not modeled

  • Sale-price, construction-duration, buyer-demand, and financing forecasts
  • Income taxes, depreciation, opportunity cost, and irregular cash-flow timing
  • Appraisal, offer recommendation, contractor scope, and due diligence

Worked example

A six-month project with a $200,000 purchase, $50,000 rehab budget, 10% contingency, and $350,000 sale produces $47,000 estimated profit and 17.09% project ROI.

Maintenance

How definitions stay aligned

Methodology records are checked against formula modules, schemas, fixtures, tests, calculator pages, reports, and guides. Learn how source review and result-changing corrections are handled.