Question

Adam Wilson just purchased a home and took out a $250,000 mortgage for 30 years at 8%, compounded monthly.

a. How much is Adam’s monthly mortgage payment?

b. How much sooner would Adam pay off his mortgage if he made an additional $100 payment each month? The financial tables in Appendix A are not sufficiently detailed to do parts (c) and (d).

c. Assume Adam makes his normal mortgage payments and at the end of five years, he refinances the balance of his loan at 6%. If he continues to make the same mortgage payments, how soon after the first five years will he pay off his mortgage?

d. How much interest will Adam pay in the 10th year of the loan i. he does not refinance ii. If he does refinance

Answer #1

**Part (a):**

Monthly payments= **$
1,834.41** Calculated as
follows:

**Part (b):**

Number of months required to repay the loan (if payments are increased by $100)

= 298 (Rounded to nearest whole month)

Number of months as per original plan= 360

Therefore, the loan will be closed sooner by 360-298 =
**62 months**.

Calculation of revised period using NPER function of Excel as follows:

**Part (c):**

Amount to be refinanced is the present value of future (unpaid) installments treating it as ordinary annuity.

Number of future installments= 360- 60 = 300

Amount to be refinanced= $237,674.64 Calculated as PV of annuity as follows

Number of months required to repay the loan (if payments are retained at $1,834.41)

= 209 (Rounded to nearest whole month)

Number of remaining months as per original plan= 300

Therefore, the loan will be closed sooner by 300-209 =
**91 months**.

Calculation of revised period using NPER function of Excel as follows:

**Part (d):**

Interest paid in 10th year of the loan (109th through 120th month):

(i ) If not refinanced: $17,732.68

Relevant portion of amortization schedule as follows:

(ii ) If refinanced, monthly payments will be
**$
1,531.34** as
follows:

With the **revised monthly payments**, Interest
paid in 10th year of the loan from beginning (109th through 120th
month) ie., 61 through 72 months of new
loan**=$12,669.51**

Relevant portion of amortization schedule of the new loan as follows:

A couple took out a $390,000.00 mortgage ten years ago. The
original terms called for 30 years of monthly payments at a 6.60%
APR. The couple has made all payments over the last 10 years.
Currently, the couple is considering re-financing their
mortgage.
The couple has been offered a chance to re-finance their
mortgage balance. The new mortgage will be for 30 years at the
lower rate of 4.92% APR with monthly compounding. The mortgage will
call for monthly payments....

Tom buys a $240,000 home. He must make monthly mortgage
payments for 30 years, with the first payment to be made a month
from now. The annual effective rate of interest is 8%. After 15
years Tom doubles his monthly payment to pay the mortgage off more
quickly. Calculate the interest paid over the duration of the
loan.

The mortgage on your house is five years old. It required
monthly payments of
$1,390,
had an original term of 30 years, and had an interest rate
of
10%
(APR). In the intervening five years, interest rates have
fallen and so you have decided to
refinance—that
is, you will roll over the outstanding balance into a new
mortgage. The new mortgage has a 30-year term, requires monthly
payments, and has an interest rate of
5.625%
(APR).
a. What monthly repayments...

You just took a fixed-rate mortgage for $250,000 at 4.50% for 30
years, monthly payments, two discount points. Before you make any
payments you receive a nice raise so you plan to pay an extra $160
per month on top of your normal payment.
A. (1 pt) How many monthly payments do have to make at the
higher payment to fully amortize the loan?
B. (1 pt) What is your net interest savings over the life of the
loan, assuming...

You took out your home mortgage five years ago, and are
currently considering refinancing into a loan at a lower rate and
for a shorter term. Your original loan was for 30 years, at 6%
interest on the $200,000 borrowed, and you pay monthly. The new
loan you are considering will be for 15 years at a rate of 4%.
Again, the payments will be monthly. What will your new payment be
if you take on this new loan? SHOW...

A young couple take out a 30-year home mortgage of $145,000.00
at 6.9% compounded monthly. They make their regular monthly payment
for 7 years, then decide to up their monthly payment to
$1,200.00.
a) What is the regular monthly payment? $
b) What is the unpaid balance when they begin paying the
accelerated monthly payment of $1,200.00? $
c) How many monthly payment of $1,200.00 will it take to pay off
the loan? payments d) How much interest will this...

3. You take a $500,000 mortgage to buy a vacation home. The
mortgage entails equal monthly payments for 10 years, 120 payments
in all, with the first payment in one month. The bank charges you
an interest rate of 9.6% (APR with monthly compounding).
a. How much of your first payment is interest, and how much is
repayment of principal?
b. What is the loan balance immediately after the 10th payment?
(Calculate the loan balance using the annuity formula.)
c....

The mortgage on your house is five years old. It required
monthly payments of $1,402, had an original term of 30 years, and
had an interest rate of 10%(APR). In the intervening five years,
interest rates have fallen and so you have decided to refinancethat
is, you will roll over the outstanding balance into a new
mortgage. The new mortgage has a 30-year term, requires monthly
payments, and has an interest rate of 6.625%(APR). a. What monthly
repayments will be...

It’s been exactly five years since Mr. Smith bought his house
with a 30-year mortgage which had an interest rate of 9.00% (APR,
monthly compounding). The outstanding balance of the current
mortgage is $178,799.01. In the intervening five years, interest
rates have fallen and so Mr. Smith has decided to refinance the
remaining balance on his current mortgage with a new 32-year
mortgage which has monthly payments and an interest rate of 5.7%
(APR, monthly compounding). How much would the...

A buddy still owes $200,000 on his home mortgage. The mortgage
has an annual interest rate of 3.5%. He is currently making monthly
payments of $5,000.
A. How long will it take him to pay off his loan? (Months &
Years)
B. What affect would making $2,500 payments every other week
have on paying off his loan?

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 2 minutes ago

asked 3 minutes ago

asked 29 minutes ago

asked 32 minutes ago

asked 43 minutes ago

asked 43 minutes ago

asked 44 minutes ago

asked 48 minutes ago

asked 50 minutes ago

asked 54 minutes ago

asked 54 minutes ago

asked 59 minutes ago