Question

In: Finance

A loan of $30,000 is paid off in 36 payments at the end of each month...

A loan of $30,000 is paid off in 36 payments at the end of each month in the following way: Payments of $750 are made at the end of the month for the first 12 months. Payments of $750 + x are made at the end of the month for the second 12 months. Payments of $750 + 2x are made at the end of the month for the last 12 months. What should x be if the nominal monthly rate is 8%?

Solutions

Expert Solution

The nominal monthly rate is 8%. Hence, the monthly rate, r = 8%/12 = 0.6667%

-------------------

PV today of first 12 payments = PV of annuity = A/ r x [1 - (1 + r)-n] = 750 / 0.6667% x [1 - (1 + 0.6667%)-12] = 8,621.84

PV at the end of 12 months of the second 12 months payments = PV of annuity = A/ r x [1 - (1 + r)-n] = (750 + x) / 0.6667% x [1 - (1 + 0.6667%)-12] = 11.4958 x (750 + x) = 8,621.84 + 11.4958x

PV today = [8,621.84 + 11.4958x] x (1 + r)-n = [8,621.84 + 11.4958x] x (1 + 0.6667%)-12 = 7,961.07 + 10.6148x

PV at the end of 24 months of the third 12 months payments = PV of annuity = A/ r x [1 - (1 + r)-n] = (750 + 2x) / 0.6667% x [1 - (1 + 0.6667%)-12] = 11.4958 x (750 + 2x) = 8,621.84 + 22.9916x

PV today = [8,621.84 + 22.9916x] x (1 + r)-n = [8,621.84 + 22.9916x] x (1 + 0.6667%)-24 = 7,350.95 + 19.6025x

Hence, total PV = 8,621.84 + 7,961.07 + 10.6148x + 7,350.95 + 19.6025x = 23,933.85 +30.2173x = value of the loan today = 30,000

Hence, x = (30,000 - 23,933.85) / 30.217 = 200.75 (Please do round it off as per your requirement)



Related Solutions

3. A loan of $5000 is to be paid off with level payments at the end...
3. A loan of $5000 is to be paid off with level payments at the end of each month at 3% compounded monthly. The amount of interest paid in the 61" payment is $2.24 and the amount of principal repaid in the 42nd payment is $70.31. Find: a) The amount of principal repaid in the 61" payment. b) The size of the level monthly payment. c) The number of months necessary to pay off the loan. d) The amount of...
b. An individual obtains a car loan whim pays $30,000. The loan will he paid off...
b. An individual obtains a car loan whim pays $30,000. The loan will he paid off in 3 years, and payments are made monthly. Interest rate on the loan is 7%, and compounding is monthly. 1. Find the amount of monthly payments to pay the loan off. Provide a complete amortization schedule of the loan ( this will entail a long table containing 37 rows). 2. Present your work in detail and explain. Provide references for content. (Excel sheet required).
A 18 year loan is being repaid with level payments at the end of each month....
A 18 year loan is being repaid with level payments at the end of each month. The loan rate of interest is 15.6% compounded monthly. In which month is the interest portion approximately equal to 5 times principal the portion? Give an integer answer.
Assume a loan of $30,000, 36 months, 6.5% interest. Generate a table of payments showing the...
Assume a loan of $30,000, 36 months, 6.5% interest. Generate a table of payments showing the principal payment and the interest payment for each of the 36 months.
Nick paid off a $15,000 car loan over 3 years with monthly payments of $466.59 each....
Nick paid off a $15,000 car loan over 3 years with monthly payments of $466.59 each. Find the finance charge and the APR.
SHOW ALL WORK LOAN PAYMENTS ARE MADE AT THE END OF EACH MONTH When Sarah Jean...
SHOW ALL WORK LOAN PAYMENTS ARE MADE AT THE END OF EACH MONTH When Sarah Jean purchased her house 12 years ago, she took out a 30-year mortgage for $220,000. The mortgage has a fixed interest rate of 6 percent compounded monthly. (a) Compute Sarah Jean’s monthly mortgage payments. (b) If Sarah Jean wants to pay off her mortgage today, for how much should she write a check? She made her most recent mortgage payment earlier today.
2. You just took a $315,000, 30-year loan. Payments at the end of each month are...
2. You just took a $315,000, 30-year loan. Payments at the end of each month are flat (equal in every month) at an annual interest rate of 3.75 percent. a)Calculate the monthly payment. b)Provide the appropriate loan table, showing the breakdown in each month between principal repayment and interest. (PLEASE SHOW STEP-BY-STEP EXCEL FORMULA WITH FUNCTIONS)
Consider a $30,000 loan to be repaid in equal installments at the end of each of...
Consider a $30,000 loan to be repaid in equal installments at the end of each of the next 5 years. The interest rate is 6%. Set up an amortization schedule for the loan. Do not round intermediate calculations. Round your answers to the nearest cent. If your answer is zero, enter "0". Year Payment Repayment Interest Repayment of Principal Balance 1 $   $   $   $   2 $   $   $   $   3 $   $   $   $   4 $   $   $   $  ...
A $30,000 car loan has payments of $550 per month for five years. What is the...
A $30,000 car loan has payments of $550 per month for five years. What is the interest rate? Assume monthly compounding and give the answer in terms of an annual rate. N= I= PV= PMT= FV=
A loan is to be repaid in end of quarter payments of $1,000 each, with there...
A loan is to be repaid in end of quarter payments of $1,000 each, with there being 20 end of quarter payments total. The interest rate for the first two years is 6% convertible quarterly, and the interest rate for the last three years is 8% convertible quarterly. Find the outstanding loan balance right after the 6th payment.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT