Posted by
**Stephanie** on
.

Jake is looking at refinancing his mortgages and paying off his credit cards at the same time. Currently, his debt situation is as follows:

First mortgage: 6%, 30 years due 20xx (15 years left) $269,238

Second mortgage: 8%, interest only due in 15 years $80,000

Credit cards: 21%, minimum payments made $12,000

Total refinanced: $361,238

Jake is trying to decide between:

a. 5.5% loan with a 15- or 30-year mortgage with 1 point

b. 6% loan with a 15- or 30-year mortgage with 0.5 points

c. 6.5% loan with a 15- or 30-year mortgage with no points

Calculate the monthly payment for all six mortgages and the interest that will be paid over the life of the mortgage to decide which is Jake’s best option and what amount he will save with this option. You know that Jake’s take-home pay is $8,332 per month and the new financing should not be more than 36 percent of that value.

Procedure/Steps:

1. Use the time value of money to calculate the mortgage payment on all loans.

2. Calculate the total interest expense of each new loan by using the amortization schedule in Microsoft Excel.

3. Calculate the total interest expense on his current loans for the credit cards; assume that he pays interest for only 15 years.

4. Use the time value of money to calculate which loan saves Jake the most money.

5. Compare the best alternative to how much his current loans cost.

Outcome:

• You should be able to use the time value of money to determine mortgage payments.

• You should be able to calculate the total interest expense of a mortgage loan.

• You should be able to compare old and new financing costs.

• You should be able to perform a mortgage loan amortization schedule in Excel.

• You should be able to compare interest savings on different types of loans.

Note: If you don’t have the amortization schedule in Excel, go to microsoft and download Loan amortization schedule. You can download the schedule from this site for free.