Question

In: Accounting

A mortgage of $100,000 is amortized over 25 years using level payments at the end of...

A mortgage of $100,000 is amortized over 25 years using level payments at the end of each quarter and the first interest payment at the end of the first quarter is $2411.37. Calculate the 62nd principal payment amount.

a. 1074.21

b. 1048.92

c. 1100.11

d. 1024.22

e. None of these answers

Solutions

Expert Solution

Correct Answer b. 1048.92
Step 1 : Calcuation of interest rate per quarter
=$2411.37/100000
2.4114%
Step 2: Calculation of Montly payment
EMI = [P x R x (1+R)^N]/[(1+R)^N-1]
Where,
EMI= Equal Monthly Payment
P= Loan Amount
R= Interest rate per period
N= Number of periods  
= [ $100000x0.0241137 x (1+0.0241137)^100]/[(1+0.0241137)^100 -1]
= [ $2411.37( 1.0241137 )^100] / [(1.0241137 )^100 -1
=$2656.56
Step 3: Calculation of balance of laon after 61st payment
Present Value Of An Annuity
= C*[1-(1+i)^-n]/i]
Where,
C= Cash Flow per period
i = interest rate per period
n=number of period
= $2656.56[ 1-(1+0.0241137)^-39 /0.0241137]
= $2656.56[ 1-(1.0241137)^-39 /0.0241137]
= $2656.56[ (0.6052) ] /0.0241137
= $66,669.31
Step 4: Calculation of balance of laon after 62st payment
Present Value Of An Annuity
= C*[1-(1+i)^-n]/i]
Where,
C= Cash Flow per period
i = interest rate per period
n=number of period
= $2656.56[ 1-(1+0.0241137)^-38 /0.0241137]
= $2656.56[ 1-(1.0241137)^-38 /0.0241137]
= $2656.56[ (0.5956) ] /0.0241137
= $65,620.40
Step 5: Calculation of principal paid
=$66669.31-65620.40
=$1048.92

Related Solutions

An $600,000 Mortgage is amortized by monthly payments over 25 years. The interest rate charged is...
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?
The Grewals agreed to monthly payments on a mortgage of $363,000.00 amortized over 25 years. Interest...
The Grewals agreed to monthly payments on a mortgage of $363,000.00 amortized over 25 years. Interest for the first five years was 4.3% compounded semi-annually. a. Determine the Grewals’ monthly payments. b. Determine the balance owing after the 5-year term. c. Before renewing for another term of 5 years at 4.5% compounded semiannually, the Grewals make an additional payment of $21,000. If they keep the same monthly payments, by how much will the amortization period be shortened? note; sir i...
You have just negotiated a 5 year mortgage on $100,000 amortized over 25 years at a...
You have just negotiated a 5 year mortgage on $100,000 amortized over 25 years at a rate of 5%. After 5 years of payments, assume that the mortgage rate remains the same, but you change your monthly payment to $1500. If you change your payment, how many more periods will it take you to pay off the remaining loan balance?
A mortgage of 198,000 is to be amortized by monthly payments over 22.5 years. If the...
A mortgage of 198,000 is to be amortized by monthly payments over 22.5 years. If the payments are mafe at the end of each month and interest is 8.75% compounded semi-amnually, what is the size of monthly payments?
A $86,000 mortgage is to be amortized by making monthly payments for 25 years. Interest is...
A $86,000 mortgage is to be amortized by making monthly payments for 25 years. Interest is 5.1% compounded semi-annually for a six-year term. ​(a) Compute the size of the monthly payment. ​(b) Determine the balance at the end of the six-year term. ​(c) If the mortgage is renewed for a six-year term at 6​% compounded semi-annually, what is the size of the monthly payment for the renewal​ term? ​(a) The size of the monthly payment is ​$__. ​(Round the final...
A $95,000 mortgage is to be amortized by making monthly payments for 25 years. Interest is...
A $95,000 mortgage is to be amortized by making monthly payments for 25 years. Interest is 8.6% compounded semi-annually for a six​-year term. ​(a)Compute the size of the monthly payment. ​(b) Determine the balance at the end of the six-year term. ​(c)If the mortgage is renewed for a six-year term at 6​% compounded semi-annually, what is the size of the monthly payment for the renewal​ term? ​(a) The size of the monthly payment is $__.(Round the final answer to the...
Consider a mortgage loan of $300,000, to be amortized over thirty years with monthly payments. If...
Consider a mortgage loan of $300,000, to be amortized over thirty years with monthly payments. If the annual percentage rate on this mortgage is 4% : What is the monthly payment on this loan? What is the balance of this loan AFTER the 14th payment is made? How much of the 8th payment is allocated to interest? How much of the 19th payment is allocated to principal?
) A $30 000.00 mortgage is amortized by monthly payments over twenty years and is renewable...
) A $30 000.00 mortgage is amortized by monthly payments over twenty years and is renewable after five years. a) If the interest rate is 8.5% compounded semi-annually, calculate the outstanding balance at the end of the five-year term. b) If the mortgage is renewed for a further three-year term at 8% compounded semi-annually, calculate the size of the new monthly payment. c) Calculate the payout figure at the end of the three-year term.
A loan of $330,000 is amortized over 30 years with payments at the end of each...
A loan of $330,000 is amortized over 30 years with payments at the end of each month and an interest rate of 6.9%, compounded monthly. Use Excel to create an amortization table showing, for each of the 360 payments, the beginning balance, the interest owed, the principal, the payment amount, and the ending balance. Answer the following, rounding to the nearest penny. a) Find the amount of each payment. $ b) Find the total amount of interest paid during the...
A loan of $490,000 is amortized over 30 years with payments at the end of each...
A loan of $490,000 is amortized over 30 years with payments at the end of each month and an interest rate of 8.1%, compounded monthly. Use Excel to create an amortization table showing, for each of the 360 payments, the beginning balance, the interest owed, the principal, the payment amount, and the ending balance. Answer the following, rounding to the nearest penny. a) Find the amount of each payment. $ b) Find the total amount of interest paid during the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT