17. You are hoping to buy a ferrari that costs $9,000. You will make monthly payments...

Question

Question

17. You are hoping to buy a ferrari that costs $9,000. You will make monthly payments for 5 years at 12% interest compounding

Answer 1

Answer #1

fac =PMT(C2,C3,-C4,C5,C6) B 1 2 RATE 3 NPER 4 PV 5 FV 6 TYPE 7 PMT 0.0100 0.12/12 60 5*12 9,000.00 Rate Per Period Total No.o

Answer 2

Similar Homework Help Questions

Suppose you want to buy a car. You’re willing to make monthly car payments of $350...

Suppose you want to buy a car. You’re willing to make monthly car payments of $350 for 5 years. If the interest rate is 12% per year, how much can you afford to borrow (to the nearest dollar)? A. $15734 B. $18472 C. $21000 D. $28584
You borrow $6,030 to purchase furniture for your house. You agree to make monthly payments for...

You borrow $6,030 to purchase furniture for your house. You agree to make monthly payments for 4 years to pay for the furniture. If the interest rate is 5 percent with monthly compounding, how much are your monthly payments? Assume the first payment is made one month after purchase. $113.38 $138.87 $113.74 $134.70 $133.42
You are looking to buy a car. You can afford $730 in monthly payments for five...

You are looking to buy a car. You can afford $730 in monthly payments for five years. In addition to the loan, you can make a $830 down payment. If interest rates are 10.00 percent APR, what price of car can you afford (loan plus down payment)? (Do not round Intermediate calculations and round your final answer to 2 decimal places.) Present value To borrow $3,700, you are offered an add-on interest loan at 9.3 percent with 12 monthly payments....

12. You decide to buy a car that costs $15.000. You want to borrow all the...

12. You decide to buy a car that costs $15.000. You want to borrow all the money at a 6.5% (annual) interest rate. You want to pay it in 4 months. Find your monthly payment and write it in the table below. a. Fill in the amortization schedule showing how much of each of your monthly payments go to interest and how much to your principal. Principal: $15,000.00 Interest Rate: 6.50% Payment Interval: Monthly # of Payments: 4 Payment: S...
In order to buy a car, you borrow $35,000 from a friend at 12%/year compounded monthly...

In order to buy a car, you borrow $35,000 from a friend at 12%/year compounded monthly for 4 years. You plan to repay the loan with 48 equal monthly payments. a. How much are the monthly payments? b. How much interest in in the 23rd payment? c. What is the remaining balance after the 37th payment?
You are looking to buy a car. You can afford $520 in monthly payments for four...

You are looking to buy a car. You can afford $520 in monthly payments for four years. In addition to the loan, you can make a $1,700 down payment. If interest rates are 8.75 percent APR, what price of car can you afford (loan plus down payment)?

Derek borrows $35,692.00 to buy a car. He will make monthly payments for 6 years. The...

Derek borrows $35,692.00 to buy a car. He will make monthly payments for 6 years. The car loan has an interest rate of 5.45%. After a 13.00 months Derek decides to pay off his car loan. How much must he give the bank?
Derek borrows $32,107.00 to buy a car. He will make monthly payments for 6 years. The...

Derek borrows $32,107.00 to buy a car. He will make monthly payments for 6 years. The car loan has an interest rate of 6.26%. After a 13.00 months Derek decides to pay off his car loan. How much must he give the bank?
You are looking to buy a car. You can afford $550 in monthly payments for four...

You are looking to buy a car. You can afford $550 in monthly payments for four years. In addition to the loan, you can make a $2,000 down payment. If interest rates are 9.50 percent APR, what price of car can you afford (loan plus down payment)? (Do not round Intermediate calculations and round your final answer to 2 decimal places.) Present value

I just need to check my answers: 17: You want to buy a house in 5...

I just need to check my answers: 17: You want to buy a house in 5 years and expect to need $35000 for a down payment. If you have $11000 to invest, how much interest do you have to earn (compounded annually) to reach your goal? (Enter your answers as a decimal rounded to 4 decimal places, not a percentage. For example, enter 0.0843 instead of 8.43%) 18: You decide that the loan in question 2 is too large for...