Start with the property’s records
Use the lender’s principal-and-interest payment, the actual tax bill and tax year, insurance quotes, association documents and utility estimates. A seller’s exemptions or past bills may not describe your future costs. Confirm the address’s current county and taxing authorities; the municipality name alone is insufficient.
The suburban profiles link to locally applicable research. Keep one-time closing expenses, special assessments and repair projects in a separate plan. This worksheet does not calculate a loan payment, determine tax liability or predict future increases.
- Enter each charge once. If association fees include a utility, include only your additional utility cost.
- Use the cash-to-close worksheet for purchase and sale settlement amounts.
- Enter an explicit zero when a cost does not apply; leave genuinely unknown amounts blank.
Separate financing from escrow
A lender’s total payment may include taxes, property insurance and mortgage insurance as well as principal and interest. Enter only principal and interest in the financing field, and place the other amounts in their separate fields. Adding taxes or insurance to an already inclusive payment counts the expense twice.
Check the projected payments in your Loan Estimate or the breakdown on your current statement. If you cannot separate the components, leave the financing amount unknown until the lender or servicer confirms it. An explicit zero is appropriate when there is no financing payment.
A planning budget, with its limits visible
This is a sum of your entered recurring costs and a separately chosen maintenance reserve. It supplies no rates, municipal tax estimates or Census medians. The reserve is a budgeting assumption, rather than a component of the ACS selected monthly owner-cost measure. Review special assessments and deferred repairs separately.
All figures remain in browser memory. They are not placed in a link, saved to local storage, transmitted or added to a consultation message. Reset clears them, and reloading starts a blank worksheet. Print before leaving if you want a personal copy.
Find your municipality’s official property research →
Put your figures in context.
Use current figures for the actual property. All fields start blank. Enter 0 for a cost that does not apply.
Your amounts stay in this tab. Nothing is saved or sent.
Include principal and interest for all applicable loans. Exclude escrow and insurance. Enter 0 if there is no loan payment.
Use the actual bill year and your expected exemptions. Do not add escrow payments again.
Use your quote or policy. Exclude flood insurance here if entering it separately below.
Enter 0 if it does not apply or is already included in the property-insurance figure.
Keep this separate from principal and interest. Enter 0 if none applies.
Include recurring condo, co-op or HOA charges once. Plan one-time special assessments separately.
Include your electricity, gas, water, sewer and other recurring services, excluding charges already included above.
Choose your own annual reserve. This is separate from the survey owner-cost definition and from known major repair projects.
Confirm that taxes, insurance and escrow are excluded before calculating with a financing payment. If you cannot separate them, leave this amount blank.
Subtotal of known amounts
No known amounts yet.
Amounts still unknown: 8. A blank amount is unknown. The subtotal is incomplete until every applicable cost has an amount or an explicit zero.
Still to establish: Financing · principal and interest; Property taxes; Property insurance; Separate flood insurance; Mortgage insurance; Association charges; Utilities and fuel; Maintenance reserve.
| Cost | Entered amount | Monthly equivalent | Annual equivalent |
|---|---|---|---|
| Financing · principal and interest | Unknown | — | — |
| Property taxes | Unknown | — | — |
| Property insurance | Unknown | — | — |
| Separate flood insurance | Unknown | — | — |
| Mortgage insurance | Unknown | — | — |
| Association charges | Unknown | — | — |
| Utilities and fuel | Unknown | — | — |
| Maintenance reserve | Unknown | — | — |
| Incomplete subtotal | 0 of 8 amounts entered | — | — |
Amounts are stored as whole cents. Annual costs are divided by 12 for the monthly view; totals are rounded only for display. Rounded monthly figures may not multiply to the exact annual figure.
Planning date: Current planning session · Amounts supplied by you · Not a quote or final bill.
Sources and effective dates
Read the original guidance and use the version applicable to your property and transaction. Practical planning suggestions are distinguished from legal or program requirements.
- Principal and interest versus the total mortgage payment · CFPB
Consumer payment explanation; individual loan estimates and servicing statements govern actual amounts.
Source checked · United States - Cook County Treasurer: Property taxes
Use the property's PIN, actual bill and applicable tax year. Seller bills do not establish the buyer's future liability.
Source checked · Cook County, Illinois