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).

Solutions

Expert Solution

First we need to calculate the monthly payment that would be need to made in order to service the loan, which is also show below

Amortization Schedule is shown below:

jeff jeffy answered 1 year ago

Next > < Previous

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...

You borrow $24,000 to buy a car. The loan is to be paid off in quarterly...

You borrow $24,000 to buy a car. The loan is to be paid off in quarterly installments over four years at 10 percent interest annually. The first payment is due one quarter from today. What is the amount of each quarterly payment? a) $1,745 b) $1,794 c) $1,838 d) $1,876 I need the hand-written formula, not the calculator input.

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.

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 - $ $

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...

You want to buy a car, and a local bank will lend you $30,000. The loan...

You want to buy a car, and a local bank will lend you $30,000. The loan will be fully amortized over 5 years (60 months), and the nominal interest rate will be 5% with interest paid monthly. What will be the monthly loan payment? Do not round intermediate steps. Round your answer to the nearest cent. $ What will be the loan's EAR? Do not round intermediate steps. Round your answer to two decimal places. %

Tom has taken out a loan for college. He started paying off the loan with a...

Tom has taken out a loan for college. He started paying off the loan with a first payment of $200. Each month he pays, he wants to pay back 1.2 times as the amount he paid the month before. Explain to Tom how to represent his first 30 payments in sigma notation. Then explain how to find the sum of his first 30 payments, using complete sentences. Explain why this series is convergent or divergent.

you are taking out a loan today of 10000 dollars. it will be paid off with...

you are taking out a loan today of 10000 dollars. it will be paid off with three annual payments, and it has an interest rate of 8% . For each of the next three years, calculate the beginning balance, interest paid, principal paid, and ending balance

LOAN AMORTIZATION You want to buy a car, and a local bank will lend you $30,000....

LOAN AMORTIZATION You want to buy a car, and a local bank will lend you $30,000. The loan will be fully amortized over 7 years (84 months), and the nominal interest rate will be 6% with interest paid monthly. What will be the monthly loan payment? Round to TWO decimal places.

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=

Subjects