**: A person buying a house is considering two different financing options. The first financing option entails a $200,000 30-year mortgage. The second financing option entails a larger down payment and a smaller 15-year mortgage. The monthly mortgage payment is identical in both financing options.**

__Question__
The interest rate on the 30-year FRM is 3.43%. The interest rate on the 15-year FRM is
2.65%. These are the rates that
actually exist in the week of April 11, 2013.

Based on these facts:

·
What is the monthly mortgage payment for the two
financing options?

·
What is the loan balance on the 15-year FRM
under the second financing option?

·
How much liquid assets must the homebuyer use to
reduce the mortgage under financing option two.

·
What is the outstanding balance on the 30-year
FRM after 15 years?

·
What rate of return on liquid assets must a
person who takes financial package one earn to have the same wealth as a person
who takes financing package two?

**The answer to this problem relies on mortgage payment and annuity formulas. The formula for the monthly mortgage payment is**

*:*__Background__
C=r x P/ (1-(1+r)

^{-N})
Where c is the monthly payment on the mortgage, r is the
monthly interest rate, N is the maturity of the loan in months, and P is the
initial balance of the loan.

The formula for the outstanding loan balance after N
payments is

AO=(1+r

^{N}) x P – ((1+r)^{N}-1)/(r)) x C
Where AO is the amount outstanding on the loan, r, N, P and
c are as defined above.

Wikipedia has an excellent discussion of the derivation of
these formulas.

The values for the mortgage payments and the outstanding
balance equation can also be calculated with pre-programmed finance functions
in Excel. The Excel function for the
mortgage payment is PMT. The Excel
function for the outstanding balance value is FV.

__Answer____:__

*Mortgage payments:*

Plugging r=0.0343/12, N=360, and P=$200,000 into the formula
for monthly payment we get c=$890.32.

*The loan balance on a 15-year loan with a mortgage payment of $890.32:*

Plugging r=0.0265/12 N=180 and P=$200,000 we find the
mortgage payment of a 15-year mortgage on a $200,000 loan is $1,347.7. In order to reduce the payment to $890.32 the
loan balance must be reduced to $132,116 (890.29/1347.7) x $200,000. See the formula for c for the intuition
behind this adjustment.

*Reduction in liquid assets*:

In order to reduce the loan from $200,000 to $132,116 the
person must reduce liquid assets by $67,884 ($200,000-$132,116.)

*Mortgage balances after 15 years:*

The loan balance for the 15-year mortgage after 15 years of
payment is $0.

The loan balance for the 30-year mortgage after 15 years can
be obtained by plugging r=0.0343/12, N=180, PMT=890.29, and PV=$200,000 into
the FV function in Excel. (You can also
use the formula for AO above.) The
30-year loan balance after 15 years is $125,137.

*Breakeven point*:

The person using financial package number one initially has
$67,884 more in liquid assets than the person using financial package two. (Under investment strategy two the mortgage
is reduced by this amount.) The rate of
return needed for $67,884 to grow to $125,137 in 15 years is:

Rate=100*((125,137/67,884

^{)(1/15})-1)=4.16%**: Under current market conditions, a person with some cash should take financing package two. Use the cash to pay down the mortgage and take out the 15-year FRM. The 15-year FRM has a lower interest rate. CD rates are much lower than 4.16%.**

*Some concluding remarks*
True mortgage interest is tax deductible. However, interest income, dividends and
capital gains are also taxed and investments in equities are risky.

Individuals with higher cost student loans or credit card
debts would be better off with a 30-year FRM, or perhaps renting until they can
afford a 15-year FRM.

The riskless opportunity cost for people who do not have
high-interest debt and have a lot of cash is the CD rate, which is very low
right now. (Ten-year CDs are around
1.0%.) Homebuyers with cash and little
debt should take the 15-year mortgage.

Most homebuyers do not have a ton of cash so the selection
of a 15-year FRM will probably involve higher mortgage payments.

Other Posts of Interest:

Interested in financial ratios. Go to this post on how to obtain projected earnings growth rates from three financial ratios -- trailing PE, forward PE and PEG.

http://www.dailymathproblem.com/2018/09/financial-ratio-math.html

http://www.dailymathproblem.com/2018/09/financial-ratio-math.html

[www.omj.ca] are a great financial source to realise your dreams and take you to the heights of success without anyone’s help. second financing

ReplyDeleteThis is not desirable if you want to consolidate a substantial amount of non-mortgage debt. It is worth mentioning to show you a more complete picture of your options.guarantor loans

ReplyDeleteWhenever I visited www.mortgage-advice-online.org, I am blocked instantly from viewing the contents of your website. Plz resolve this issue. www.mortgage-advice-online.org

ReplyDeleteThis comment has been removed by the author.

ReplyDeleteThank you for sharing such great information.

ReplyDeleteIt is informative, can you help me in finding out more detail on

mortgage loan.

In spite of the fact that borrowers have various choices while picking movable rate mortgages, the multi year ARM is frequently one of the most shrewd choices. mortgage advice manchester

ReplyDeletePresently, what is a home loan dealer? They are somebody who encourages this trade of property possession for cash. They can be a piece of a bank, credit association, or other loan specialist's paid staff, or they can be free after they increase a few years of experience. Mortgage Brokers

ReplyDeleteAn expansive budgetary organization is somebody or organization that gives mortgage merchandise of a few distinct loan specialists.Mortgages

ReplyDeleteExcellent .. Amazing .. I’ll bookmark your blog and take the feeds also…I’m happy to find so many useful info here in the post, we need work out more techniques in this regard, thanks for sharing. Best Mortgages

ReplyDeleteAt the point when that you are arranging a financing cost, ask your present moneylender when they can offer you preferable conditions and terms over with your past house credit term. mortgage broker

ReplyDeleteYou have done a great job. I will definitely dig it and personally recommend to my friends. I am confident they will be benefited from this site. Sunlife Lifetime Mortgages

ReplyDeleteIn spite of the fact that the customer must arrangement specifically with the bank or building society their mortgage consultant regularly offers help to the shopper.

ReplyDeletemortgage services

Math Calculator - Pre-Algebra, Algebra, Pre-Calculus, and Calculus solver with detailed steps, videos, and thousands of practice problems math calculator

ReplyDeleteaa

ReplyDeleteA home loan car dealership normally works well with the customer rather than any certain loan provider. Donna Mullen website

ReplyDelete