ToolHuts

Practical tools for measured work

Home purchase budget worksheet

Explore a purchase-price scenario from entered debt caps, ownership costs, rate and down payment.

Calculate the layout, check the diagram, then print the result for the shop or jobsite.

%
%
%
months
Scenario purchase price433620.71
Scenario loan principal383620.71
Principal and interest allowance2300.00
Total housing payment cap2800.00

How it works

Monthly housing cap is the smaller of gross income × chosen housing percentage and gross income × chosen total-debt percentage minus other debts. Subtract entered ownership costs to obtain the principal-and-interest allowance, then solve for a fixed-rate loan and add the down payment.

The example caps of 28% and 36% are editable planning assumptions, not approval criteria. Include property taxes, insurance, mortgage insurance, association charges and maintenance in your entered costs. Recheck costs when the proposed price changes.

Reference: CFPB debt-to-income definition

Current-input example

The result above uses these exact values. This snapshot is included when the page is printed so the output can be checked against the original measurements.

Gross monthly household income
10000
Other monthly debt payments
500
Chosen housing-to-income cap
28 %
Chosen total debt-to-income cap
36 %
Monthly tax insurance HOA and other ownership costs
500
Assumed annual loan interest rate
6 %
Loan term
360 months
Cash down payment
50000

Primary result: Scenario purchase price: 433620.71.

Before using the result

  • Check the selected mode, units and input values before using the result.
  • Read the assumptions and rounding rules; compare the worked example with your intended calculation.
  • A numerical result does not supply missing context or change the stated limitations.

Limitations

This worksheet does not establish what you can safely afford or qualify to borrow. It excludes closing costs, cash reserves, income taxes, changing rates and lender-specific underwriting. Down payment is separate from closing cash. Compare the result with your actual after-tax household budget and current financing terms.

Frequently asked questions

What should I verify before using this result?

Check the input values, units, dates and assumptions. Compare the method and its stated limits with the source relevant to your task.

Why might the finished result differ?

Results depend on the entered data and the model’s assumptions. Rounding, changing conditions or omitted factors can affect the comparison. Read the limitations before using the result.