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 first 15 payments. $

c) Find the total amount of interest paid over the life of the loan. $

d) Find the total of all payments made over 30 years. $

Suppose that payment number 4 is skipped and the interest owed for month 4 is added to the balance. Payments then resume as usual for the remainder of the 30 years.
e) Find the balance owing at the end of month 4. $
f) Find the balance remaining after the 360th payment. $

Solutions

Expert Solution

Principal payment for loan amount 490000 calculated by dividing 360 payment

Monthly principal amount of payment =49000/360 =1361

Interest payment for first 15 payments = 48648

C & d

Total amount payment made over 30 years =1087052

Total interest = 597052

e Balance owing at the end of month 4 = 489197

4th payment skipped that result in to interest payable added to outstanding balance.

balance remaining after 360th payment = 4641

Note -

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

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 amount of L is amortized over six years with monthly payments (at the end...

A loan amount of L is amortized over six years with monthly payments (at the end of each month) at a nominal interest rate of i(12) compounded monthly. The first payment is 500 and is to be paid one month from the date of the loan. Each subsequent payment will be 1% larger than the prior payment. (a) If i(12) = 9%, find the principal repaid in the 25th payment. (b) If i(12) = 12%, find the amount of loan...

QUESTION 1 A $150,000 loan is to be amortized over 7 years, with annual end-of-year payments....

QUESTION 1 A $150,000 loan is to be amortized over 7 years, with annual end-of-year payments. Which of these statements is CORRECT? a. The proportion of interest versus principal repayment would be the same for each of the 7 payments. b. The proportion of each payment that represents interest versus repayment of principal would be higher if the interest rate were higher. c. The proportion of each payment that represents interest as opposed to repayment of principal would be higher...

You obtain a loan of $150,000 at 5.875% amortized over 30 years with monthly payments. You...

You obtain a loan of $150,000 at 5.875% amortized over 30 years with monthly payments. You are required to pay closing costs and fees of 2% of the loan amount to the lender. What is the yield of the loan if paid off at the end of 5 years?

A loan of $10,000 is amortized by equal annual payments for 30 years at an effective...

A loan of $10,000 is amortized by equal annual payments for 30 years at an effective annual interest rate of 5%. The income tax rate level is at 25%. Assume the tax on the interest earned is based on the amortization schedule. a) Determine the income tax in the 10th year b) Determine the total income taxes over the life of the loan c) Calculate the present value of the after-tax payments using the before-tax yield rate. 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 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

) 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 is being amortized over n-years with monthly payments of $295.32. The rate of interest...

A loan is being amortized over n-years with monthly payments of $295.32. The rate of interest on the loan is j12=12%. The principal repaid in the 25th payment is $206.41.What is the size of the loan?

You obtain a loan of $300,000 at 5.75% amortized over thirty years with monthly payments.

Can you please help me the steps of this Finance Math problem?You obtain a loan of $300,000 at 5.75% amortized over thirty years with monthly payments. You are required to pay closing costs and fees of 1.0% of the loan amount to the lender. What is the yield of the loan if paid off at maturity?

Subjects