Question

In: Finance

A $40,000 mortgage loan charges interest at 6.6% compounded monthly for a four-year term. Monthly payments...

A $40,000 mortgage loan charges interest at 6.6% compounded monthly for a four-year term. Monthly payments were calculated for a 15-year amortization and then rounded up to the next higher $10.
a) What will be the principal balance at the end of the first term?
b) What will the monthly payments be on renewal for a three-year term if it is calculated for an interest rate of 7.2% compounded monthly and an 11-year amortization period, but again rounded to the next higher $10?

Solutions

Expert Solution

First let us find the monthly payment. For that we can use the Present value of annuity formula:

Where,
PVA = Present Value of Annuity
A = Annuity / Payment
i = rate of interest
n = number of years
a = number of payments per year
na = number of payments

Since the problem asks us to round off the payment to next $10, it will be $360 Per month.

a) Now let us find the Principal balance after the four year term, that is balance after 48th payment.

For that we can use the following formula:

Where,
PV = Present value / original balance
A = Annuity / Payment
i = rate of interest
a = number of payments per year
n = number of years
na = total number of payments

Therefore, the principal balance at the end of the first term is $32,333.43

b)

We can use the same formula for present value of annuity to find the monthly payment.

Rounding it off to the next higher $10 will become $360 per month.


Related Solutions

Monthly payments on a $165,000 mortgage are based on an interest rate of 6.6% compounded semiannually...
Monthly payments on a $165,000 mortgage are based on an interest rate of 6.6% compounded semiannually and a 30-year amortization. If a $5000 prepayment is made along with the thirty-second payment: (Do not round the intermediate calculations.) a. How much will the amortization period be shortened? (Round UP to the next whole number.)    The amortization period will be shortened by years and month(s).    b.What will be the principal balance after four years? (Round your answer to two decimal...
A family has a $ 144447 , 20 -year mortgage at 6.6 % compounded monthly. Find...
A family has a $ 144447 , 20 -year mortgage at 6.6 % compounded monthly. Find the monthly payment. Also find the unpaid balance after 5 years and after 10 years.
(2) A 2 year, $6,000 loan at 7% interest with monthly payments. The lender charges you...
(2) A 2 year, $6,000 loan at 7% interest with monthly payments. The lender charges you a $100 fee that can be paid off, interest free, in equal monthly installments over the life of the loan. Thinking of the fee as additional interest, what is the actual interest rate you will pay?
A borrower is repaying a $19000 loan at 9.2%/year compounded monthly with monthly payments over 26...
A borrower is repaying a $19000 loan at 9.2%/year compounded monthly with monthly payments over 26 years. Just after the 78th payment he has the loan refinanced at 7.2%/year compounded monthly. If the number of payments remains unchanged, what will be the new monthly payment?
Bank A charges 12% compounded monthly on its business loan. BankB charges 11.5% compounded daily....
Bank A charges 12% compounded monthly on its business loan. Bank B charges 11.5% compounded daily. Bank C charges 11% compounded continuously. If you want to borrow money that you will return after a number of years, which bank would you choose? Justify your answer.
A 20-year, $ 490,000 mortgage at 4.20\% compounded annually is repaid wit monthly payments . a....
A 20-year, $ 490,000 mortgage at 4.20\% compounded annually is repaid wit monthly payments . a. What is the size of the monthly payments ? Round to the nearest cent. b. Find the balance of the mortgage at the end of 5 years 00 Round to the nearest cent c. By how much did the amortization period shorten by if the monthly payments are increased by $ 200 at the end of year five
A 25-year, $435,000 mortgage at 4.10% compounded quarterly is repaid with monthly payments. a. What is...
A 25-year, $435,000 mortgage at 4.10% compounded quarterly is repaid with monthly payments. a. What is the size of the monthly payments? b. Find the balance of the mortgage at the end of 6 years? c. By how much did the amortization period shorten by if the monthly payments are increased by $100 at the end of year six?
What are the yearly mortgage payments on a 10-year loan for RM150,000 at 9% p.a. compounded...
What are the yearly mortgage payments on a 10-year loan for RM150,000 at 9% p.a. compounded annually? Construct an amortization table for the loan if the payment is made at the end of the period. Ans: P = RM 23,373.01
How do I amortize a mortgage loan with daily compounded AND monthly compunded interest with bi-weekly...
How do I amortize a mortgage loan with daily compounded AND monthly compunded interest with bi-weekly payments in excel? Let's use the example: Loan Amount - $100,000.00 Rate - 4.0% Period - 30 years (fixed) Please provide both solutions. Thanks.
A 25-year, $455,000 mortgage at 4.30% compounded semi-annually is repaid with monthly payments. a. What is...
A 25-year, $455,000 mortgage at 4.30% compounded semi-annually is repaid with monthly payments. a. What is the size of the monthly payments? b. Find the balance of the mortgage at the end of 6 years? c. By how much did the amortization period shorten by if the monthly payments are increased by $275 at the end of year six?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT