PLEASE WRITE DOWN THE FORMULAS YOU USE
PLEASE WRITE DOWN THE FORMULAS YOU USE 8. The purchase of a car requires a $12,000...
11.9 The purchase of a car requires a $25,000 loan to be repaid in monthly installments for four years at 9% interest compounded monthly. If the general inflation rate is 4% compounded monthly, find the actual-and constant-dollar value of the 20th payment.
The Purchase of a car requires a $25,000 loan to be repaid in monthly installments for four years at 12% interest compounded monthly and the general inflation is 6% compounded monthly. a) Find the actual & constant dollar value of the 20th payment. b) The total loan payback amount in constant & actual dollars.
Ricardo purchase a used car for $10,000 He wrote a check for $2,000 as a down payment for the car and financed the $23,681 balance. The annual percentage rate (APR) is 9% compounded monthly, and the loan is to be repaid in equal monthly installments over the next four years. How much is Ricardo's monthly car payment?
You are looking at buying a car. You negotiate the price of the car down to $16,000. You have $6,000 in cash, so you’ll borrow $10,000 to purchase the car. The dealer offers you a loan that has an APR of 4%, compounded monthly, with monthly payments starting next month and lasting 5 years. What would be the monthly payment?
A car is purchased for $6,801.95 with $2,000 down and a loan to be repaid at $100 a month for 2 years followed by a balloon payment. If the interest rate is 6% compounded monthly, how large will the balloon payment be? The balloon payment will be $ . (Round to the nearest cent as needed.)
10) You have just taken out an 8-year, $14,000 loan to purchase a new car. This loa is to be repaid in 96 equal end-of-month installments. If each of the monthly installments is $200.00, what is the effective annual interest rate on this car loa
The purchase price of a car is $60,000. Mr. Posey makes a down payment of $30,000 and borrows the balance from a bank at 6% APR interest, compounded monthly, for 5 years. Calculate the nearest value of the required monthly payments to pay off the loan a) $ 400 b) 580 c) $600 d) $1,160
13) The purchase price of a car is $60,000. Mr. Posey makes a down payment of $30,000 and borrows the balance from a bank at 6% APR interest, compounded monthly, for 5 years. Calculate the nearest value of the required monthly payments to pay off the loan. a) $ 400 b) $ 580 c) $ 600 d) $1,160
Show all excel formulas used
Ex. 3 JIf a dealer offers you a car at $275 monthly payment for 5 years plus $5,000 down. If you can get a similar loan from a bank at APR of 12%, what is the price that you're paying? Down payment Monthly payment Loan period months APR No. of compounding times per year Monthly rate Present Value Book formula Excel function Ex. 4 If you take out an $10,000 car loan that call for...
You will compare 2 different amortization schedules
when buying a car. The purchase price is $17,500.
Bank A requires a 20% down payment and has an annual interest rate
of 3.6%. Bank B wants only 10%
down payment but the annual interest rate is 4.8%. In both banks,
the loan will be paid off in 3 years.
Formulas: A.First you need to set up the formula to find the
monthly payment. Use the PMT function under
FINANCIAL FORMULAS.
B. After...