Question

You want to buy a new sports coup for $76,500, and the finance office at the...

You want to buy a new sports coup for $76,500, and the finance office at the dealership has quoted you an APR of 5.8 percent for a 72 month loan to but the car. What will your monthly payment be?
what is the effective annual rate on this loan?

Homework Answers

Answer #1

Monthly loan payment is calculated using PMT function in Excel :

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

nper = 72 (72 month loan)

pv = 76500 (loan amount)

PMT is calculated to be $1,260.62

Monthly loan payment is $1,260.62

Effective annual rate (EAR) = (1 + (APR/n))n - 1

where n = number of compounding periods per year

Effective annual rate (EAR) = (1 + (5.8%/12))12 - 1

Effective annual rate (EAR) = 5.9567%

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
You want to buy a new sports coupe for $75,500, and the finance office at the...
You want to buy a new sports coupe for $75,500, and the finance office at the dealership has quoted you a loan with an APR of 7.9 percent for 72 months to buy the car. a. What will your monthly payments be? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What is the effective annual rate on this loan? (Do not round intermediate calculations and enter your answer as a percent rounded...
You want to buy a new sports coupe for $74,200, and the finance office at the...
You want to buy a new sports coupe for $74,200, and the finance office at the dealership has quoted you a loan with an APR of 6.6 percent for 60 months to buy the car. 1.What will your monthly payments be? (Round 2 decimals) 2. What is the effective annual rate on this loan? (Round 2 decimals)
You want to buy a new sports coupe for $71543, and the finance office at the...
You want to buy a new sports coupe for $71543, and the finance office at the dealership has quoted you a 8.5 percent APR loan for 70 months to buy the car. What is the effective annual rate on this loan? (Enter your answer as a percentage, omit the "%" sign in your response, and round your answer to 2 decimal places. For example, 0.12345 or 12.345% should be entered as 12.35.)
You want to buy a new pickup for $42,854, and the finance office at the dealership...
You want to buy a new pickup for $42,854, and the finance office at the dealership has quoted you an 8.4% APR loan for 6 years of monthly payments. What is the effective annual rate on this loan? (Do not include the percent sign (%). Enter rounded answer as directed, but do not use the rounded numbers in intermediate calculations. Round your answer to 2 decimal places (e.g., 32.16).)
You want to buy a new sports coupe for $43,685, and the finance office at the...
You want to buy a new sports coupe for $43,685, and the finance office at the dealership has quoted you an 8.4% APR loan for 4 years with monthly payments. What will your monthly payments be? (Do not include the dollar sign ($). Enter rounded answer as directed, but do not use the rounded numbers in intermediate calculations. Round your answer to 2 decimal places (e.g., 32.16).)
You want to purchase a new pickup truck for $69,500, and the finance office at the...
You want to purchase a new pickup truck for $69,500, and the finance office at the dealership has quoted you a 6 percent APR loan for 60 months to buy the truck. Complete the first month of the amortization schedule. BGN BAL PAYMENT INTEREST PRINCIPL END BAL
1. What is the future value of P2,100 in 17 years assuming an interest rate of...
1. What is the future value of P2,100 in 17 years assuming an interest rate of 8.4 percent compounded semiannually? 2. You want to buy a new sports coupe for P68,500, and the finance office at the dealership has quoted you a 6.9 percent APR loan for 60 months to buy the car. What will your monthly payments be? What is the effective annual rate on this loan?
You want to buy a new sports car from Muscle Motors for $59,000. The contract is...
You want to buy a new sports car from Muscle Motors for $59,000. The contract is in the form of a 72-month annuity due at a 7.25 percent APR. What will your monthly payment be? A) $1,027.04 B) $986.77 C) $1,012.99 D) $956.56 E) $1,006.91
Answer these 2 separate questions: 1) You want to buy a new sports car from Muscle...
Answer these 2 separate questions: 1) You want to buy a new sports car from Muscle Motors for $36,000. The contract is in the form of a 72-month annuity due at a 6.50 percent APR.    Required: What will your monthly payment be? 2) You are looking at a one-year loan of $15,000. The interest rate is quoted as 9 percent plus 3 points. A pointon a loan is simply 1 percent (one percentage point) of the loan amount. Quotes...
You want to buy a new sports car from Muscle Motors for $86,000. The contract is...
You want to buy a new sports car from Muscle Motors for $86,000. The contract is in the form of a 72-month annuity due at an APR of 6.8 percent. What will your monthly payment be? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)