Questions that come up in scenarios related to buying or refinancing a home:
- Is mortgage A better than mortgage B?
- Each mortgage may be amortized over a different duration (e.g., $15$ vs. $30$ years)
- Given that I'm part-way through mortgage C, should I refinance to mortgage D?
Setting aside the emotional aspects, there is almost always a clear answer based on the Net Present Value ($NPV$) calculation of the cashflows related to the principal, interest, and loan fees. For a fixed-rate mortgage with no taxes or unusual features:$$NPV = F + P_0 + \sum_{k=1}^N \frac{PMT_k}{(1+d)^k}$$where
- $F$ is the amount in fees paid to acquire the loan
- $P_0$ is the initial cash outflow ("downpayment"), if any, outside of fees
- $N$ is the total number of payment periods
- For a $30$ year mortgage with monthly payments, $N = 30 \times 12 = 360$
- $PMT_k$ is the payment due in the $k^\text{th}$ period
- Usually the $PMT$ is the same across the entire loan duration for a fixed-rate mortgage
- $d$ is the chosen discount rate per period
For question $1$, the Loan Estimate would include an APR value that can be the basis for a comparison if the loan durations being compared are identical. It's not immediately obvious how to use the APR to compare loans of different durations. Also, the APR cannot be used to answer question $2$ related to a refinance.
Sometimes the total (undiscounted) cashflow of interest payments over the span of the loan is used for the comparison, but as you'll see below that may give you the wrong answer.
Discount rate
For the $NPV$ calculation you'll need an appropriate discount rate (aka, opportunity cost). This would be the expected risk-adjusted after-tax return on an investment that you'd redirect your cash into if you didn't have to pay the mortgage.
One option is to use the "risk-free" rate of return (yield on T-bills/T-notes of the appropriate duration).
I use a conservative after-tax expected portfolio return of $7.1$ %/year (nominal rate which includes inflation). Note that the risk characteristics of a portfolio that includes stocks is completely unlike a fixed-rate mortgage which is a risk-free liability. Ergo, the choice of $7.1$ %/year for the discount rate is a personal one; it is not a universal discount rate.
Caveat
While the discount rate is specified in terms of %/year, most mortgages require monthly payments. If so, payments must be discounted on a monthly basis using $1/12^\text{th}$ the assumed discount rate. For the $7.1$ %/year choice above, it would be $7.1/12$ $=$ $0.5917$ %/month.
Buying a house
Inputs needed:
- Initial downpayment
- Starting principal
- Interest rate (%/year)
- Amoritization duration (years)
- Amortization period (usually monthly; to wit, $12$ periods/year)
- Loan fees (origination fees, title/insurance/deed fees, recording fees, etc.)
- Do not include any escrow amounts for home insurance and/or property taxes as they are not pertinent to the cost-benefit analysis
Set-up your amortization table for each mortgage and then calculate:
Net Present Value of the loan =
Downpayment +
$PV$ of cashflows for principal +
$PV$ of cashflows for interest +
Loan fees
Choose the loan that has the lowest present value. That's it.