Enter details
Example data table
Sample inputs and outputs to sanity-check your entries.
| Scenario | Purchase price | Down payment | Closing + prepaids | Other upfront | Total upfront | Available cash | Cash after close |
|---|---|---|---|---|---|---|---|
| Moderate buffer | $350,000 | $52,500 (15%) | $7,900 | $3,500 | $63,900 | $80,000 | $16,100 |
| Higher prepaids | $350,000 | $52,500 (15%) | $10,600 | $3,500 | $66,600 | $80,000 | $13,400 |
| Low cash | $350,000 | $52,500 (15%) | $7,900 | $3,500 | $63,900 | $55,000 | -$8,900 |
Formula used
- Down payment = purchase price × down payment rate (or entered amount).
- Loan amount = purchase price − down payment (unless overridden).
- Origination fee = loan amount × origination rate + flat origination.
- Discount points = loan amount × points rate.
- Prepaid taxes = (annual taxes ÷ 12) × tax prepaid months.
- Prepaid insurance = (annual insurance ÷ 12) × insurance prepaid months.
- Escrow buffer = (monthly taxes + monthly insurance) × escrow buffer months.
- Prepaid interest = (loan amount × annual rate ÷ 365) × prepaid interest days.
- Total upfront required = down payment + closing costs + prepaids + other upfront.
- Cash after close = available cash − total upfront required.
- Required reserve = reserve months × monthly living expenses.
- Suggested upfront limit = available cash − required reserve.
The score combines shortfall, reserve gap, upfront concentration, and DTI.
How to use this calculator
- Enter the purchase price and your planned down payment.
- Add closing costs and prepaids from your estimate worksheet.
- Include moving costs and a repairs buffer for safer planning.
- Enter available cash and choose a reserve months target.
- Click Calculate and review cash shortfall and reserve gap.
- Use the suggested upfront limit to adjust your plan.
Disclaimer
This tool provides planning estimates only. Actual fees and required prepaids vary by lender, location, and timing. Verify figures with official loan and closing disclosures.