Question

The Third National Bank of Haslett has agreed to give you a 4 year loan to...

The Third National Bank of Haslett has agreed to give you a 4 year loan to buy a Dacia Sandero, priced at $11,000. The annual interest rate is 9%. If the bank requires you to make a 10% down payment on the car, how much will your monthly payments be if you make the purchase? Please show using excel

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Number of Years Annual Rate Periods per year Periodic Rate Number of Periods Car Price Downpayment (%) Loan 4 4 9% 12 0.75% 4

Number of Years Annual Rate Periods per year Periodic Rate Number of Periods Car Price Downpayment (%) Loan 4 4 0.09 12 C5/C6

Add a comment
Know the answer?
Add Answer to:
The Third National Bank of Haslett has agreed to give you a 4 year loan to...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Amortization Table. You wish to buy a $40,000 car. The bank can finance you with a 3-year loan at a 4 percent APR. If yo...

    Amortization Table. You wish to buy a $40,000 car. The bank can finance you with a 3-year loan at a 4 percent APR. If you make a $7,000 down payment on the purchase. What are the monthly payments on your loan? How much will you pay in interest each year? Show the amortization table (use monthly payments).

  • Part 1. Create a loan amortization table (50 points) You are considering purchasing a SUV with...

    Part 1. Create a loan amortization table (50 points) You are considering purchasing a SUV with a sticker price of $42,270 (nonnegotiable, with a 20% down payment required). You have cash to cover the down payment and you want to make monthly payments over five years to cover the remainder of the cost. The highest monthly payment that you can afford is $700. The credit union has agreed to loan you the money at a 4.23% annual interest rate la:...

  • You borrowed $1,200 to buy a new computer and agreed to pay the loan back 3...

    You borrowed $1,200 to buy a new computer and agreed to pay the loan back 3 years later; if the loan has a 10 percent interest rate, what is the balance you will owe at that time? You recently purchased a new car for 18,000 by agreeing to make equal annual payments for 5 years. If the interest rate on your loan is 8 percent, how much is each payment?

  • a commercial bank will loan you 54567 for 4 years to buy a car. the loan...

    a commercial bank will loan you 54567 for 4 years to buy a car. the loan must be repaid in equal monthly payments at the end of the month . the annual interest rate on the loan is 5-98% of the unpaid balance. what is the amount of the monthly payments?

  • A commercial bank will loan you $33,732 for 4 years to buy a car. The loan...

    A commercial bank will loan you $33,732 for 4 years to buy a car. The loan must be repaid in equal monthly payments at the end of the month. The annual interest rate on the loan is 7.29 percent of the unpaid balance. What is the amount of the monthly payments? Round the answer to two decimal places.

  • A commercial bank will loan you $47,497 for 8 years to buy a car. The loan...

    A commercial bank will loan you $47,497 for 8 years to buy a car. The loan must be repaid in equal monthly payments at the end of the month. The annual interest rate on the loan is 10.16 percent of the unpaid balance. What is the amount of the monthly payments?

  • 72. Currently, you owe the bank $19,600 for a car loan. The loan has an interest...

    72. Currently, you owe the bank $19,600 for a car loan. The loan has an interest rate of 7.75 percent and monthly payments of $620. Your financial situation recently changed such that you can no longer afford these payments. After talking with your banker and explaining the situation, he has agreed to lower the monthly payments to $450 while keeping the interest rate at 7.75 percent. How much longer will it take you to repay this loan than you had...

  • If you invest $17,500 per year for 17 years (all payments made at the beginning of each year)

    Calculate all of the problems in the document below in an Excel spreadsheet or on a financial calculator. Please show your work in order to get credit. For each problem, state the inputs given, what you are being asked to find (the missing input), and then use the Finance function to get the correct answer (if using Excel).17. If you invest $17,500 per year for 17 years (all payments made at the beginning of each year), you will have accumulated...

  • a. You want to buy a $170,000 house. The loan requires 10% down, has a 7.75%...

    a. You want to buy a $170,000 house. The loan requires 10% down, has a 7.75% fixed APR, and a term of 30 years. You will make monthly mortgage payments. How much will your monthly payments be? b. You want to buy a $170,000 house. The loan requires 10% down, has a 7.75% fixed APR, and a term of 30 years. You will make monthly mortgage payments. What is the total interest you will pay over the life of the...

  • A commercial bank will loan you $27,817 for 3 years to buy a car. The loan...

    A commercial bank will loan you $27,817 for 3 years to buy a car. The loan must be repaid in equal monthly payments at the end of the month. The annual interest rate on the loan is 13.32 percent of the unpaid balance. What is the amount of the monthly payments? Round the answer to two decimal places.

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT