Question

You purchased a car. The car dealership allows you to defer payments for 12 months, and...

You purchased a car. The car dealership allows you to defer payments for 12 months, and you make 48 end-of month payments thereafter. If the original loan is for $28,000 and interest in 8% per year on the unpaid balance
* What will your payment be?
* What is the effective rate of interest?

Homework Answers

Answer #1

Loan amount after 12 months = loan amount today * (1 + (r/12))12

Loan amount after 12 months = $28,000 * (1 + (8%/12))12

Loan amount after 12 months = $30,323.99

Monthly loan payment is calculated using PMT function in Excel :

rate = 8% / 12   (converting annual rate into monthly rate)

nper = 48 (48 month loan)

pv = 30323.99 (loan amount)

PMT is calculated to be $740.30

Effective rate of interest is calculated using RATE function in Excel :

nper = 48

pmt = -740.30

pv = 28000

The RATE calculated is the monthly rate. To get annual rate, we multiply by 12.

Effective rate of interest is 12.21%

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Chloe Colburn purchased home appliances for her new apartment. Store allowed her to defer payments (interest...
Chloe Colburn purchased home appliances for her new apartment. Store allowed her to defer payments (interest is still being charged even though payments are deferred) for six months and to make 36 equal end-of-month payments thereafter. The original note was for $15,000, with interest at 9% per annum compounded monthly. After 26 monthly payments, Chloe considers getting a loan from the bank to pay her debts in one lump sum. She would pay the bank $186 per month for the...
A car dealership is ready to give you a $25,000 car on a lease for 48...
A car dealership is ready to give you a $25,000 car on a lease for 48 months at 6% interest rate per year (or 6% divided by 12 = 0.5% per month). What will be your monthly lease payments which are made at the beginning of the months, if you agree to make a lumpsum payment of $6,500 at the end of the lease term to own the car after the lease term is over? $486.75 $478.24 $466.97 $464.65 (I...
Furniture to Go is offering new customers an opportunity to defer their furniture purchase payments for...
Furniture to Go is offering new customers an opportunity to defer their furniture purchase payments for 3 months before their first payment is due. You purchased furniture costing $8,000 and want to take advantage of the 3 months’ deferral before making your first payment. You agree to pay the loan in monthly payments over a 3-year period after the deferral period. If the interest rate is 12% per year and interest accrue monthly during the 3 months’ deferral period. Draw...
An auto dealership is advertising that a new car with a sticker price of $34,848 is...
An auto dealership is advertising that a new car with a sticker price of $34,848 is on sale for $25,995 if payment is made in full, or it can be financed at 0% interest for 72 months with a monthly payment of $484. Note that 72 payments × $484 per payment = $34,848, which is the sticker price of the car. By allowing you to pay for the car in a series of payments (starting one month from now) rather...
2. An auto dealership is advertising that a new car with a sticker price of $19,140...
2. An auto dealership is advertising that a new car with a sticker price of $19,140 is on sale for $16,999 if you pay in cash, or you get a finance for 60 months with a monthly payment of $319. Note that 60 payments × $319 per payment = $19,140, which is the sticker price of the car. By allowing you to pay in a series of payment (starting one month from now) instead of $16,999 in cash, the dealer...
Using Microsoft Excel: Suppose you are in the market for a new car worth $22,000. You...
Using Microsoft Excel: Suppose you are in the market for a new car worth $22,000. You are offered a deal to make a $2,000 down payment now and to pay the balance in equal end-of-month payments of $505.33 over a 48-month period. Consider the following situations. (a) Instead of going through the dealer’s financing, you want to make a down payment of $1,800 and take out an auto loan from a bank at 9.2% compounded monthly. What would be your...
a. [3 pts] Consider the simple loan case. Suppose that the dealership allows you to pay...
a. [3 pts] Consider the simple loan case. Suppose that the dealership allows you to pay the car off in four installments of $5,000, with each installment due once a year. The first payment is due the day that you purchase the car; the remaining installments are then paid on the same date each consecutive year, for the remaining three years. What is the present discounted value of the payments you make for the car? b. [5 pts] Now suppose...
A commercial bank will loan you $30,981 for 8 years to buy a car. The loan...
A commercial bank will loan you $30,981 for 8 years to buy a car. The loan must be paid in equal monthly payments at the end of the month. The annual interest rate on the loan is 16.41 percent of the unpaid balance. What is the amount of the monthly payments?
A car dealership offers you no money down on a new car. You may pay for...
A car dealership offers you no money down on a new car. You may pay for the car for 5 years by equal monthly end-of-the-month payments of $621 each, with the first payment to be made one month from today. If the discount annual rate is 3.82 percent compounded monthly, what is the present value of the car payments?
A car dealer offers payments of $522.59 per month for 48 months on a $25,000 car...
A car dealer offers payments of $522.59 per month for 48 months on a $25,000 car after making a $4,000 down payment. What is the loan’s APR? (in % terms)