calculate-loan

01 Loan payments

Second Home Affordability Calculator: Estimate Costs

Calculator No. 01-12895 · Updated · Formula and assumptions shown below

The calculator on this page is switched off while it is checked. The formula is below, and the worked example shows how to do the sum by hand.

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

A second home affordability calculator estimates a monthly mortgage payment from a home price, down payment, interest rate, and loan term, then compares it with your existing housing costs and income. Enter the figures below to see an estimated payment and total interest; the result is a borrowing-cost illustration, not a loan approval or a personal affordability recommendation.

Formula

The calculator first subtracts the down payment from the purchase price to find the loan principal, then applies the standard fixed-rate, fully amortizing mortgage payment formula:

Loan principal (P) = home price − down payment
Monthly payment (M) = P × r ÷ [1 − (1 + r)−n]

  • P is the amount borrowed, in dollars.
  • r is the monthly interest rate, calculated as APR ÷ 1,200 when APR is entered as a percentage per year.
  • n is the number of monthly payments, calculated as loan term in years × 12.
  • M is monthly principal and interest, in dollars.

Total interest is estimated as M × n − P. This uses the unrounded payment in the calculator’s expression; displayed figures are rounded to cents. Actual lender schedules can differ because payments are typically rounded and loan terms, fees, and payment dates vary.

Worked Example

Using the defaults—$300,000 purchase price, $60,000 down, 7% APR, and a 30-year term:

  1. Principal: $300,000 − $60,000 = $240,000.
  2. Monthly rate: 7 ÷ 1,200 = 0.0058333333.
  3. Number of payments: 30 × 12 = 360.
  4. Payment: $240,000 × 0.0058333333 ÷ [1 − (1 + 0.0058333333)−360] = approximately $1,596.67 per month.
  5. Total interest using the displayed monthly payment: $1,596.67 × 360 − $240,000 = $334,801.20.

The calculator’s total-interest expression uses its unrounded formula result for the monthly payment, while the example above multiplies the displayed, cent-rounded payment. This can produce a small rounding difference in the total; the lender’s amortization schedule controls the exact amount.

Assumptions

  • The interest rate remains fixed for the full loan term.
  • Payments are monthly and made at the end of each monthly period.
  • Interest compounds monthly at APR divided by 12.
  • The estimate excludes taxes, insurance, maintenance, utilities, association charges, closing costs, loan fees, mortgage insurance, and escrow.

How to Use the Estimate

Use a realistic price and down payment, then enter the annual percentage rate and term shown in a lender’s current written estimate if you have one. Rates and fees depend on the loan and borrower; this page does not supply or predict them. If you do not yet have a quote, treat the rate as a scenario input and test several possible values rather than interpreting one result as an offer.

The payment shown covers principal and interest only. To understand the monthly cash cost of owning another property, make a separate budget that also accounts for recurring bills and irregular costs. Depending on the property, that can include property taxes, homeowners or other insurance, repairs, seasonal maintenance, utilities, furnishings, travel, and association fees. Obtain actual figures from relevant providers or property records; this calculator cannot determine them from the purchase price.

A second home also sits alongside existing obligations. For a personal budget review, list the current home payment and other recurring debt payments, then compare the combined outgoings with take-home income and savings needs. That is a budgeting exercise, not the same as a lender’s debt-to-income calculation or underwriting decision. The calculator does not assess income, assets, credit history, reserves, occupancy, or eligibility.

Costs and Common Misunderstandings

  • Confusing payment with total ownership cost: principal and interest are only part of the expense. Taxes, insurance, repairs, and utilities can materially change the cash required.
  • Assuming the down payment is the only upfront cost: transaction costs, prepaid expenses, furnishing, and immediate repairs may require additional funds. Their amounts are not estimated here.
  • Treating APR as a guaranteed rate: the entered APR is a scenario, not a market quote or promise. Ask a lender for the rate, fees, and payment schedule that apply to the specific transaction.
  • Overlooking the loan term: a longer term generally spreads repayment across more months, affecting the payment and total interest. The calculator assumes the same fixed rate throughout.
  • Relying on rounded figures: calculations display cents, but lender schedules may use their own rounding and exact payment dates. Small differences can accumulate.

For example, lowering the loan principal by increasing the down payment reduces the amount used in the payment formula, but it also means more cash is paid upfront. The calculator compares the arithmetic only; it does not assess the trade-off between cash on hand and borrowing.

Limits and Alternatives

This calculation is useful for a first-pass principal-and-interest estimate when the loan is a conventional level-payment mortgage with a fixed annual rate. It does not model adjustable rates, interest-only periods, balloon payments, extra repayments, construction financing, multiple loans, or fees rolled into the balance. It also does not establish whether a property qualifies for any particular loan treatment.

For a fuller estimate, use a lender-provided loan estimate or payment schedule and add property-specific costs from reliable sources. A separate mortgage calculator with taxes, insurance, and fees can model those items if you know their amounts. The second-home affordability calculator here remains a simple loan-payment tool, not a substitute for those figures.

Frequently Asked Questions

What does a second home affordability calculator calculate?
It estimates monthly principal and interest, plus total interest over the entered term, based on price, down payment, APR, and loan length. It does not decide whether the home is affordable or whether a lender will approve a loan.

Does the monthly payment include taxes and insurance?
No. The result includes principal and interest only. Add taxes, insurance, maintenance, utilities, and any association charges separately to estimate broader ownership costs.

Can I use this calculator for a vacation home?
Yes, as a basic fixed-rate mortgage estimate if you know the loan amount, APR, and term. It does not model occupancy-related lending conditions or determine the loan terms available for a vacation property.

Why does my lender’s payment differ?
The lender may use a different rate, loan balance, term, payment date, or rounding method. Its quoted payment may also include escrowed taxes or insurance, while this calculator excludes those expenses.

Does this result show how much I can borrow?
No. It estimates payments for the figures you enter. Income, existing debts, assets, credit information, property details, and lender requirements are not assessed.

This result is an estimate; the lender’s disclosure gives the exact figures.

Related

Formula used
in price | Second home price | $ | 300000 | 1 | 100000000
in down | Down payment | $ | 60000 | 0 | 99999999
in apr | Interest rate (APR) | % | 7 | 0.01 | 100
in yrs | Loan term | years | 30 | 0.0833 | 50
out pmt | Monthly principal and interest | $ | (price - down) * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest over loan term | $ | pmt * yrs * 12 - (price - down) | 2

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.

More in this section

The whole Loan payments section →