Question

In: Accounting

The formula m = 12,000 + 12,000rt 12t  gives Keri's monthly loan payment, where r is...

The formula m = 12,000 + 12,000rt 12t  gives Keri's monthly loan payment, where r is the annual interest rate and t is the length of the loan, in years. Keri decides that she can afford, at most, a $275 monthly car payment. Give an example of an interest rate greater than 0% and a loan length that would result in a car payment Keri could afford. Provide support for your answer.

Solutions

Expert Solution

The Given Formula is m = [ 12,000 + (12,000rt) ] / 12t

This given the monthly payment of loan (m) provided we have the interest rate (r) and term in years (t)

In the question we were asked to give the examples of an interest rate greater than 0% and length that would result in monthly car payment that Keri can afford.

We can arrive at the answer by trial and error method. We subtitute random interest rates and term and check at the possible combinations

Preparing a table with the results of Trial and Error method combinations

Interest Rate Term (years) Monthly payment
5% 5 250
5% 4 300

4%

5 240
4% 4 290
3% 5 230
3% 4 280

From the above, it is clear that Keri can afford a loan repayment with Interest rate of 5% or 4% or 3% with 5 year term where the monthly payments would be 250 or 240 or 230 respectively

Working Note :

Taking 5% interest rate and 5 years

m = [ 12000 + (12000*5%*5) ] / 12(5)

= [ 12000 + 3000 ] / 60

= [ 15000 ] / 60

= 250

The remaining trial and error combinations are also done similar way and results are posted in the above table


Related Solutions

The monthly payment on a loan may be calculated by the following formula: Payment =    Rate *...
The monthly payment on a loan may be calculated by the following formula: Payment =    Rate * (1 + Rate)N ((1 + Rate)N -1) Rate is the monthly interest rate, which is the annual interest rate divided by 12. (12 percent annual interest would be 1 percent monthly interest.) N is the number of payments, and L is the amount of the loan. Write a program that asks for these (Input) values then displays a report similar to: Loan Amount:            $...
5)What is the monthly payment on a 15 year, $350,000 mortgage loan, where interest rate is...
5)What is the monthly payment on a 15 year, $350,000 mortgage loan, where interest rate is 3% per year, Compounded annually Compounded monthly Compounded daily What are effective annual rates for 1,2, and 3 above?
Compute the monthly payment for a $133,440 home loan. The stated interest of the loan is...
Compute the monthly payment for a $133,440 home loan. The stated interest of the loan is 5% with monthly payments. The loan amortization is over 25 years.
What will be the monthly payment on a loan of $602, amortizedover 29 years ,...
What will be the monthly payment on a loan of $602, amortized over 29 years , at an annual interest rate of 9%
Calculate the table factor, the finance charge, and the monthly payment (in $) for the loan...
Calculate the table factor, the finance charge, and the monthly payment (in $) for the loan by using the APR table, Table 13-1. (Round your answers to the nearest cent.) Amount Financed Number of Payments APR Table Factor Finance Charge Monthly Payment $9,400 36 13% $ $ $
An loan is paid in 3 years with monthly payment starting one month after the loan...
An loan is paid in 3 years with monthly payment starting one month after the loan is made. The payments are 540 each in the first year, and 900 per month in the second year, and 700 each in the last year. Interest is at a nominal rate of 7.8 percent convertible monthly. What is the outstanding balance after the 15th payment. Keep 4 decimal places only.
Using the ENGR 315 Automobile Loan Payment Calculator posted, calculate the monthly payment required for a...
Using the ENGR 315 Automobile Loan Payment Calculator posted, calculate the monthly payment required for a 60-month new automobile loan made by the lender at 4.74% annual percentage rate (APR) if the car buyer borrowed $35,742. Save the resulting Excel spreadsheet file, as a PDF, presenting your payment calculations
      4. Calculate the new monthly payment given a $150,000 loan for 6%, 30 years (monthly)...
      4. Calculate the new monthly payment given a $150,000 loan for 6%, 30 years (monthly) with a lump-sum pay down of $20,000 made after 12 years have lapsed. New MP: Calculate the upfront fees that needs to be charged by the lender given a loan for $150,000 with terms 6%, 30 years (monthly compounding). The lender wants to earn a 6.6% yield. Assume a holding period of 12 years. Calculate the total payments and total interest expense for a...
Abdalla took a $12,000 loan at an interest of 12 % compounded bi-monthly. He needs to...
Abdalla took a $12,000 loan at an interest of 12 % compounded bi-monthly. He needs to pay it over 5 years. Construct the amortization schedule on this loan for the first three bi-monthly payments.
Ann took a $12,000 loan at an interest of 12 % compounded bi-monthly. He needs to...
Ann took a $12,000 loan at an interest of 12 % compounded bi-monthly. He needs to pay it over 5 years. Construct the amortization schedule on this loan for the first three bi-monthly payments.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT