Question: please show calculations and excell spreadsheet. Question #5. TVM - Future Value & Payments Suppose you want to start saving on a monthly basis so

please show calculations and excell spreadsheet. please show calculations and excell spreadsheet. Question #5. TVM - Future Value

Question #5. TVM - Future Value & Payments Suppose you want to start saving on a monthly basis so that you can purchase a $60,000 car using cash 60 months from today (starting with $0 saved). (4) A. How much do you need to save each month, earning 6.0% interest annually, in order to accumulate a Future Value (FV) of $60,000 in five years' time? (4) B.1 Suppose you don't wait and purchase the $60,000 car today. If you financed the entire $60,000 (no fees or taxes added), how much would the monthly payments be if you pay 10% interest annually and pay off the $60,000 loan in GO month's time? 1/Y-10%/12 B.2. What is the total interest paid over the life of the loan? (2) C.1. In total, how much do you save if you "saved" the money (scenario A) versus taking a loan and making monthly payments over the five years (scenario B)? C.2. Explain in 30 words or less, why does that occur & what forces are at play? Note: Both savings and loan payments are compounded monthly

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!