Question

1) Consider a $126,714 35-year mortgage with an interest rate of 8% compounded monthly.

a) Calculate the monthly payment.

b) How much of the principal is paid the first, 25th, and last year?

c) How much interest is paid the first, 25th, and last year?

d) What is the total amount of money paid during the 35 years?

e)What is the total amount of interest paid during the 35 years?

f) What is the unpaid balance after 25 years?

g)How much has to be deposited now into a savings account with an interest rate of 5% compounded quarterly in order to pay the unpaid balance of the mortgage after 25 years?

h)How much has to be deposited each quarter year from now in a fund with an interest rate of 6% compounded quarterly in order to cover the unpaid balance after 25 years?

Answer #1

a.

Formula to compute EMI is:

EMI = [P x r x (1+r) ^{n}]/[(1+r) ^{n} – 1]

P = Principal of loan = $ 126,714

r = Periodic rate = 0.08 /12 = 0.006666667 p.m.

n = Number of periods = 35 years x 12 months = 420 periods

EMI = [$ 126,714 x 0.006666667 x (1+0.006666667)
^{420}]/ [(1+0.006666667) ^{420} – 1]

= [$ 126,714 x 0.006666667 x
(1.006666667) ^{420}]/ [(1.006666667) ^{420} –
1]

= ($ 126,714 x 0.006666667 x 16.2925521636058)/ (16.2925521636058– 1)

= $ 13763.2970538924/ 15.2925521636058

= $ 900.000007 or **$
900**

Monthly payment is $ 900

b.

Principal paid in month n = EMI/[(1+r) ^{(N – n
+1)}]

N = Total number of payments = 420

r = Monthly rate = 0.006666667

n = 1;

Principal paid in 1^{st} month = $ 900/ [(1+0.006666667)
^{(420 – 1 +1)}]

**
**=
$ 900/ [(1.006666667)^{420}]

**
**=
$ 900/ 16.2925521636058

= $ 55.2399643077661 or **$ 55.24**

n = 25;

Principal paid in 25^{th} month = $ 900/
[(1+0.006666667) ^{(420 – 25 +1)}]

**
**=
$ 900/ [(1.006666667)^{395+1}]

**
**=
$ 900/ [(1.006666667)^{396}]

= $ 900/ 13.8909708192533

= $ 64.7902880015103 or **$ 64.79**

n = 420;

Principal paid in last month = $ 900/ [(1+0.006666667) ^{(420
– 420 +1)}]

**
**=
$ 900/1.006666667

=
$ 894.039734803298 or **$ 894.04**

Principal paid in 1^{st}, 25^{th} and last
payments are $ 55.24, $ 64.79 and $ 894.04 respectively.

c)

Interest paid in each payment = EMI – Principal portion

Interest paid in 1^{st} month = $ 900 - $ 55.24 =
**$ 844.76**

Interest paid in 25^{th} month = $ 900 - $ 64.79 =
**$ 835.21**

Interest paid in last month = $ 900 - $ 894.04 = **$
5.96**

Interest paid in 1^{st}, 25^{th} and last
payments are $ 844.76, $ 835.21 and $ 5.96 respectively.

d)

Total amount of money paid = Total number of EMI x EMI = 420 x $
900 = **$ 378,000**

e)

Total amount of interest paid = Total amount of money paid – Loan principal amount

= $ 378,000 - $ 126,714 = **$ 251,286**

Consider a 30-year mortgage with an interest rate of 10%
compounded monthly and a monthly payment of $850. Cannot use excel
must be equation based . If principal is 96,858.20 than....How much
of the principal is paid the first, 5th, 20th and last year

Consider a 30-year mortgage at an interest rate of 8% compounded
monthly with a $1200 monthly payment. What is the total amount paid
in interest?
a.
$236,403.75
b.
$249,448.74
c.
$268,459.81
d.
$289,450.19

A 25 year mortgage at 4.5% interest compounded monthly with a
monthly payment of $258.96 has an unpaid balance of $5,000 after
280 months. Find the unpaid balance after 281 months.

An $600,000 Mortgage is amortized by monthly payments over 25
years. The interest rate charged is 4% compounded
semi-annually.
1.What is the size of the monthly payment to the nearest
dollars?
2.How much interest paid in the first payment?
3.What is the outstanding balance after the first
payment?

A family has a $98,663,
30-year mortgage at 6.3 %
compounded monthly. Find the monthly payment.
Also find the unpaid balance after the following periods of
time.
(A) 10 years (B) 20 years (C) 25 years

A
$280000 mortgage has an interest rate of 12% compounded monthly.
The original amortization period was 10 years. After 5 years how
much of the principal is still outstanding in the mortgage?

Suppose you borrowed $200,000 for a home mortgage on January 1,
2015 with an annual interest rate of 6% per year. The balance on
the mortgage is amortized over 30 years with equal monthly payments
at the end of each month. (This means the unpaid balance on January
1, 2045 should be $0).
(a) What are the monthly payments?
(b) How much interest was paid during the 30 years of the
mortgage?
(c) What is the unpaid balance on the...

A $10000 loan has an interest rate of 12% per year, compounded
monthly, and 30 equal monthly payments are required.
a) If payments begin at the end of the first month, what is the
value of each payment?
b) How much interest is in the 10th payment?
c) What would you enter into Excel to solve part b?
d) What is the unpaid balance immediately after the 10th
payment?
e) If the 30 loan payments are deferred and begin at...

Problem 37.8 The interest rate on a 30 year mortgage is 12%
compounded monthly. Lauren is repaying the mortgage by paying
monthly payments of 700. Additionally, to pay o the loan early,
Lauren has made additional payments of 1,000 at the end of each
year. Calculate the outstanding balance at the end of 10 years.
Answer should be: $45,435.32

A couple who borrow $60,000 for 30 years at 7.2%, compounded
monthly, must make monthly payments of $407.27. (Round your answers
to the nearest cent.)
(a) Find their unpaid balance after 1 year.
(b) During that first year, how much interest do they
pay?

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 8 minutes ago

asked 21 minutes ago

asked 21 minutes ago

asked 49 minutes ago

asked 55 minutes ago

asked 55 minutes ago

asked 55 minutes ago

asked 57 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago