Question

In: Finance

4. Calculate the payments and amortization table of a 3-year car loan for $12,000 at a...

4. Calculate the payments and amortization table of a 3-year car loan for $12,000 at a 6% rate of interest. The loan will be repaid with three annual payments.

Solutions

Expert Solution

The formula for calculating the payment amount is shown below:

A = P * (r * (1 + r)ⁿ / (1 + r)ⁿ - 1)

where, A is the annual amount. P is the initial loan amount = $12000, r is the rate of interest = 6% and n is the time period = 3 years

Now, putting these values in the above formula, we get,

A = $12000 * (0.06 (1 + 0.06)³ / (1 + 0.06)³ - 1)

A = $12000 * (0.06 (1.06)³ / (1.06)³ - 1)

A = $12000 * (0.06 *1.191016) / (1.191016 - 1)

A = $12000 * (0.07146096 / 0.191016)

A = $12000 * 0.37410981279

A = $4489.31

So, the annual payments will be of $4489.31

Loan amortization schedule:

1st year:

Total payment = $4489.31

Interest = $12000 * 6% = $720

Principal repayment = $4489.31 - $720 = $3769.31

Outstanding principal = $12000 - $3769.31 = $8230.69

2nd year:

Total payment = $4489.31

Interest = $8230.69 * 6% = $493.84

Principal repayment = $4489.31 - $493.84 = $3995.48

Outstanding principal = $8230.69 - $3995.48 = $4235.21

3rd year:

Total payment = $4489.31

Interest = $4235.21 * 6% = $254.11

Principal repayment = $4489.31 - $254.11 = $4235.21

Outstanding principal = $4235.21 - $4235.21 = $0

jeff jeffy answered 1 month ago

Next > < Previous

Related Solutions

Complete the first 4 months of an amortization table for the 30 year loan. Include payment...

Complete the first 4 months of an amortization table for the 30 year loan. Include payment number, amount applied to interest, amount applied to principal, balance, and equity (%) as columns in your table. Repeat for the 15 year loan given in the same exercises.

Amortization with Equal Payments. Prepare an amortization schedule for a three-year loan of $57,000. The interest...

Amortization with Equal Payments. Prepare an amortization schedule for a three-year loan of $57,000. The interest rate is 8 percent per year, and the loan calls for equal annual payments. How much interest is paid in the third year? How much total interest is paid over the life of the loan?

Prepare a schedule showing the amortization of a $12,000 loan to be repaid in 10 end-of-year...

Prepare a schedule showing the amortization of a $12,000 loan to be repaid in 10 end-of-year installments that include interest at a rate of 6%. Jared and Courtney Jill own a parcel of fertile farm land which a local farmer has offered to rent for a period of 10 years. He is willing to make a payment of $20,000 today or pay an ordinary annuity of $3,400 at the end of each of the next 10 years. Which payment method...

Prepare an amortization sxhedule for a three-year loan of $12,000. The interest rate is 7% per...

Prepare an amortization sxhedule for a three-year loan of $12,000. The interest rate is 7% per year, and the loan calls for equal annual end-of-year payments.

Calculate the monthly payments on a car loan of $25,000 financed at an APR of 6.5%...

Calculate the monthly payments on a car loan of $25,000 financed at an APR of 6.5% for 36 months, rounded to nearest cent.

$100,000 Amortizing Loan 9% stated rate 20-year amortization 5-year balloon Annual Payments a) Calculate annual payment...

$100,000 Amortizing Loan 9% stated rate 20-year amortization 5-year balloon Annual Payments a) Calculate annual payment b) Calculate balloon payment c) Value at 12% yield d) Prepare an amortization table

Loan Amount: $10,000,000.00 Interest Rate: 6-3/4% Amortization: &nbsp

Loan Amount: $10,000,000.00 Interest Rate: 6-3/4% Amortization: 30 years Term: 10 years A homeowner obtains a $500,000.00 loan at an interest rate of 6-1/8% based on a 30 year amortization schedule. What is the monthly payment? What is the total amount of interest that would be paid over the life of the loan? Assume that after the 48th payment, the homeowner pays an additional $200.00 per month. At what month would the loan be paid in full? How many years...

Loan Amount: $20,000,000.00 Interest Rate: 6-3/4% Amortization: &nbsp

Loan Amount: $20,000,000.00 Interest Rate: 6-3/4% Amortization: 30 years Term: 10 years Assume the above loan is interest only for the first three (3) years. What is the Annual Debt Service (ADS) in the first year? How much interest (cumulative) will have been paid at the end of year 3? How much principal will be due at maturity? How much interest will have been paid over the 10 year term?

calculate a loan amortization schedule for a $10,000 loan, 5% annual interest, one payment a year...

calculate a loan amortization schedule for a $10,000 loan, 5% annual interest, one payment a year for 10 years, starting on 1/1/2010. All calculations must be shown, i.e., do not use a “package” to complete this question. Loan period starts from 1/1/2010. I mean the first payment is to be made on 1/1/2010.

Create a loan amortization schedule in excell for a $27,000 car loan that will be repaid...

Create a loan amortization schedule in excell for a $27,000 car loan that will be repaid over 48 months at an annual interest rate of 6%. What is your monthly payment? _$_ What is the total dollar amount of payments made over the life of this loan? $____ What is the total dollar amount of interest paid over the life of this loan? $___________ How many months will it take to pay off the loan if you pay an extra...

Subjects