Question

6. Savings Payment Dean is planning to purchase a new Nissan Altima which costs $26,865. He has saved up $3,200 to put toward

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

The monthly deposit is calculated using PMT function in Excel :

rate = 1.2%/2 (converting annual rate into monthly rate)

nper = 12 * 5 (5 years of deposits with 12 monthly deposits each year)

pv = -3200 (Amount put into account now. This is entered with a negative sign because it is a cash outflow)

fv = 26865 (Required value of account after 5 years)

PMT is calculated to be $379.70.

The monthly deposit is  $379.70.

A1 fac =PMT(1.2%/12,12*5,-3200,26865) D E F G B C i ($379.70

Add a comment
Know the answer?
Add Answer to:
6. Savings Payment Dean is planning to purchase a new Nissan Altima which costs $26,865. He...
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
  • estion Completion Status: QUESTION 7 . Total Cost for Savings Dean is planning to purchase a...

    estion Completion Status: QUESTION 7 . Total Cost for Savings Dean is planning to purchase a new Nissan Altima which costs $26,865. He has saved up $3,200 to put toward it. He is thinking about getting a loan for it from his credit union, but he could also keep driving his beat-up old car for a while onger and save up cash for the new one. Dean would like to get the car soon, but he wants to at least...

  • QUESTION 5 5. Loan Interest Paid Dean is planning to purchase a new Nissan Altima which costs $26,865. He has saved up $...

    QUESTION 5 5. Loan Interest Paid Dean is planning to purchase a new Nissan Altima which costs $26,865. He has saved up $3,200 to put toward it. He is thinking about getting a loan for it from his credit union, but he could also keep driving his beat-up old car for a while longer and save up cash for the new one. Possibility One: A Loan Dean qualifies for a 5-year loan from his credit union with a 6.4% APR....

  • 9,10,11,12 9. Steve buys a new car for $18,399. If he puts $3,000 down, what will...

    9,10,11,12 9. Steve buys a new car for $18,399. If he puts $3,000 down, what will be his car payment if his credit union offers him a 1.9% simple interest add-on car loan for 5 years? $287.03 10. If Steve hears about a new program that offers 1.5% on a 5 year amortized simple interest loan, should he stay with the credit union loan or try the new program? New program payment $266.55 11. Assuming Steve goes with the new...

  • Karou is considering different options for financing the $15,000 balance on her planned new car purchase....

    Karou is considering different options for financing the $15,000 balance on her planned new car purchase. The cheapest advertised rate among the local banks is 6.25 percent for 48-month car loan. The current rate on her revolving home equity line is 8.75 percent. Karou is in the 25 percent federal tax bracket and the 5.75 percent state tax bracket. Calculate​ Karou's monthly car payment using your financial calculator. Compare the payment amount if she uses the 48-month car loan through...

  • WUSUI Rei Finance Charges. Bill wants to purchase a new car for $50,000. Bill has no...

    WUSUI Rei Finance Charges. Bill wants to purchase a new car for $50,000. Bill has no savings, so he needs to finance the entire purchase amount. With no down payment, the interest rate on the loan is 8% and the maturity of the loan is six years. His monthly payments will be $876.66. Bill's monthly net cash flows are $686. Bill also has a credit card with a $9,365 limit and an interest rate of 12%. If Bill uses all...

  • Dean Farmer recently won the lottery, and used his winnings to purchase a farm in 2018....

    Dean Farmer recently won the lottery, and used his winnings to purchase a farm in 2018. Dean did not go to college, but rather grew up on a farm, worked as a cabinet maker for 10 years, and then won the lottery. He was able to generate a beginning balance sheet, however he did not have experience with depreciation or market adjustments. Beginning Cost Basis Balance Sheet In addition to the original $75,000 operating loan at the beginning of the...

  • 2. You want a new car that costs $32,000. Figure out the following: ______________ What would...

    2. You want a new car that costs $32,000. Figure out the following: ______________ What would the monthly payment be if you borrowed $32,000 from a credit union at 4% for 5 years? ______________ What would be the total of monthly payments (the amount you would actually pay for the car)? ______________ How much interest would you pay if you did this? ______________ How much would you have to save each month if you decided to save for 5 years...

  • Jason Thomas has saved $3,500 towards a down payment on a new truck. He wants to...

    Jason Thomas has saved $3,500 towards a down payment on a new truck. He wants to have a total of $20,000 and plans to buy in 3 years. How much will he have to save at the end of each month if he can earn 2.5% on his savings? Multiple Choice $433.64 $635.25 $636.58 $434.55

  • Time Value of Money Keenan has won the lottery for $10,000,000. He is offered a cash...

    Time Value of Money Keenan has won the lottery for $10,000,000. He is offered a cash payment now of $7,500,000, or 10 annual payments of $1,000,000. _____________ What is the interest rate that makes these two amounts equal? _____________ If you can invest at 8% how much would you have after 10 years if you invested the $7,500,000? You want a new car that costs $32,000. Figure out the following: ______________ What would the monthly payment be if you borrowed...

  • Roland Ratzenberger is planning to purchase a restaurant from its current owner. He will have to...

    Roland Ratzenberger is planning to purchase a restaurant from its current owner. He will have to borrow £250,000 at 9% interest to buy the business. Once he has paid for the business, he will have £40,000 in cash to start trading. From the following information draw up his cash budget for the next 6 months. Sales per month of £33,350, of which 25% will be on one month's credit. His purchases will be £13,340 per month, of which £5,250 will...

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