Question

In: Finance

Problem #5: A loan of $44,000 is paid off in 36 payments at the end of...

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

Solutions

Expert Solution

Interest in any month = principal outstanding at beginning of month * 12.4% / 12

Principal portion of monthly payment = monthly payment minus interest portion of payment

principal outstanding at end of month = principal outstanding at beginning of month minus principal portion of monthly payment

First, we assume X to be $200 and calculate the principal outstanding at the end of 36 months.

Now, we use GoalSeek in Excel to find the value of X such that the principal outstanding at the end of 36 months is zero

X is calculated to be $402.90


Related Solutions

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...
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...
XYZ Corp. borrows $300,000 to be paid-off in six years. The loan payments are semiannual with...
XYZ Corp. borrows $300,000 to be paid-off in six years. The loan payments are semiannual with the first payment due in six months, and interest is at 6%. What is the amount of each payment? A) 25,750 B) 29,761 C) 30,139 D) 25,500
A person is paying back a loan at 5% effective rate, with payments at the end...
A person is paying back a loan at 5% effective rate, with payments at the end of each year for 10 years, such that the payment the first year is $200, the second year is $190, etc. until it reaches $110, on the 10th year. ,Find the loan amount. Find the principal and interest in the fifth payment.
A person is paying back a loan at 5% effective rate, with payments at the end...
A person is paying back a loan at 5% effective rate, with payments at the end of each year for 10 years, such that the payment the first year is $200, the second year is $190, etc. until it reaches $110, on the 10th year. ,Find the loan amount. Find the principal and interest in the fifth payment.
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.
Reggie takes a loan for 5 years to be repaid by level end of year payments...
Reggie takes a loan for 5 years to be repaid by level end of year payments of R. The interest paid in the third payment was 136.16 and the interest paid in the 5th payment was 47.62. Please find the amount of principal paid in the fourth payment P4. don't copy and paste
Mary takes a loan for 5 years to be repaid by level end of year payments...
Mary takes a loan for 5 years to be repaid by level end of year payments of R. The interest paid in the third payment was 136.16 and the interest paid in the 5 th payment was 47.62. Please find the amount of principal paid in the fourth payment P4.
You are the loan department supervisor for a bank. This installment loan is being paid off...
You are the loan department supervisor for a bank. This installment loan is being paid off early, and it is your task to calculate the rebate fraction, the finance charge rebate (in $), and the payoff for the loan (in $). (Round dollars to the nearest cent.) Amount Financed Number of Payments Monthly Payment Payments Made Rebate Fraction Finance Charge Rebate Loan Payoff $1,700 18 $128.89 13 - $ $
You are the loan department supervisor for a bank. This installment loan is being paid off...
You are the loan department supervisor for a bank. This installment loan is being paid off early, and it is your task to calculate the rebate fraction, the finance charge rebate (in $), and the payoff for the loan (in $). (Round dollars to the nearest cent.) Amount Financed Number of Payments Monthly Payment Payments Made Rebate Fraction Finance Charge Rebate Loan Payoff $1,800 18 $129.89 15 $ $
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT