Question

In: Advanced Math

You have agreed to pay off an $8,000 loan in 30 monthly payments of $298.79 per...

You have agreed to pay off an $8,000 loan in 30 monthly payments of $298.79 per month. The annual interest rate is 9% on the unpaid balance.

(a) How much of the first month’s payment will apply towards reducing the principal of $8,000?

(b) What is the unpaid balance (on the principal) after 12 monthly payments have been made?

Solutions

Expert Solution

According to given information the principal amount is $8000 to be repaid in 30 months with monthly payment of $298.79

The annual rate is 9% per annum

So here P = $8000

Number of months = n = 30

Rate of interest = 9% = 9/100 = 0.09

And compounded monthly so r = 0.09/12 = 0.0075

a) For the first month the interest amount on principal amount

Interest amount = 8000 x 0.0075 = $60

And principal amount in monthly payment = payment amount – interest

                                                                                        = 298.79 – 60 = $238.79

So when first month was done then principal reduced to 8000 – 238.79 = 7761.21

So the principal reduced to $7761.21

The next step is to calculate the outstanding loan balance after 12 payments by calculating the present value of the remaining installments, using the present value of an annuity formula

From the given information we need to find the present value of given annuity

Pmt = Periodic monthly payment = 298.79

i = Mortgage interest rate per period = 0.0075

when calculation for after 12 payments then Number of remaining payments = 30-12 = 18

so number of payments = 18

we can use below formula

PV = Pmt x [(1 - 1 / (1 + i)n)] / i

PV = 298.79 x [(1 - 1 / (1 + 0.0075)18)] / (0.0075)

PV = 298.79 x [(1 - 1 / (1.0075)18)] / (0.0075)

PV = 298.79 x [(1 - 1 / (1.14396)] / (0.0075)

PV = 298.79 x [(1 – 0.87415)] / (0.0075)

PV = 298.79 x [0.12585] / (0.0075)

PV = 37.6027 / 0.0075

PV = 5013.6962 ~ 5013.7

So the principal payment due after 12 payments = $5013.7


Related Solutions

Q.5 You have borrowed $24,000 and agreed to pay back the loan with monthly payments of...
Q.5 You have borrowed $24,000 and agreed to pay back the loan with monthly payments of $200. If the interest rate is 12%,how long will it take you to pay back the loan?
You take out a loan for 10000. You pay off the loan with monthly payments of...
You take out a loan for 10000. You pay off the loan with monthly payments of 90 for 10 years. (a) What is the monthly effective rate? What is the annual effective rate? (b) What is the outstanding loan balance immediately after the 7th payment? Calculate using both the retrospective and prospective formulas. (c) Assume you miss the 13th and 53rd payments, what will be the outstanding loan balance after the 71st payment? actuarial science
You borrow $80,000 at 5.00% per year and will pay off the loan in equal payments...
You borrow $80,000 at 5.00% per year and will pay off the loan in equal payments starting one year after the loan is made over a period of ten years. What are the annual end-of-year payments? Determine the amount of interest and principal that are paid each year. What is the total interest paid for the loan? If you are using the excel please show me the code or equation to do it myself
If you pay off a loan early, you must also pay all the remaining interest payments...
If you pay off a loan early, you must also pay all the remaining interest payments along with the loan balance. Group of answer choices True False. Which of the following is correct? Group of answer choices Present values increase with a longer compounding period. Present values increase with a higher interest rate. Future values increase with a lower interest rate. Future values increase with a longer compounding period. 3. What does it mean when you see the message Error...
You borrow $720,000 at 3.25% per year compounded monthly and you plan to pay off this loan in equal annual payments starting one year after the loan is made over a period of fifteen (15) years.
You borrow $720,000 at 3.25% per year compounded monthly and you plan to pay off this loan in equal annual payments starting one year after the loan is made over a period of fifteen (15) years.a. What are the annual end-of-year payments? Determine the amount of interest and principal that are paid each year. What is the total interest paid for the loan?b. Restructure the loan in the previous question to make payments monthly. Determine the savings in interest overall.c....
as part of your retirement package, your company has agreed to pay you monthly payments over...
as part of your retirement package, your company has agreed to pay you monthly payments over the next three years that have the following characteristics. you will receive 12 monthly payments each year, with the first payment for the year being made on January 1st, and the last payment for the year being made on December 1st monthly payments for the first year will be $4,000 per month. after year 1, you will receive an annual cost of living adjustment...
You have a loan outstanding. It requires making four annual payments of $8,000 each at the...
You have a loan outstanding. It requires making four annual payments of $8,000 each at the end of the next four years. Your bank has offered to restructure the loan so that instead of making the four payments as originally​ agreed, you will make only one final payment in four years. If the interest rate on the loan is 9%​, what final payment will the bank require you to make so that it is indifferent to the two forms of​...
Today, you borrowed $20,000 at 5.5% with quarterly compounding. You have agreed to pay off the...
Today, you borrowed $20,000 at 5.5% with quarterly compounding. You have agreed to pay off the loan over 5 years by making equal weekly payments. If you were solving for your unknown weekly payment amount using the annuity present value equation, what interest rate would you use? (Hint: You don't actually need to solve for your unknown payment amount.)
You have borrowed 15,000 and agreed to repay the loan with 5 annual level payments of...
You have borrowed 15,000 and agreed to repay the loan with 5 annual level payments of 4000, with the first payment occurring one year from today. What annual interest rate are you paying?
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?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT