Question: 3. You are deciding between leasing or purchasing a car and you need the car for the next four years. The details of these two

 3. You are deciding between leasing or purchasing a car and

3. You are deciding between leasing or purchasing a car and you need the car for the next four years. The details of these two alternatives are discussed below. Buy The initial cost will be $35,000. There will be major maintenance every two years, costing $2,000. The annual insurance on the car will cost $3,200 annual and the gas will cost $1,800 annually. You expect to sell the car for $8,000 dollars at the end of the four years. Lease The lease will have a monthly expense of $875. You will not need to pay for major maintenance on the lease, but you will need to pay for the insurance and gas. a. Assume a MARR of 15% compounded annually. Using two different time value of money techniques (e.g., PV, FV, PMT), determine which alternative is better. Also, make sure to include a discussing explaining why one alternative is better. b. If the life was extended to 10 years, assuming you could still sell the car for $8,000 dollars at the end of the 10 years, which method would be better. Use the same time value of money techniques, resolve, and compare your results. Setup the problem in an Excel spreadsheet and solve using spreadsheet functions. Present your work in a professional manner. Label the columns on the spreadsheet, the functions should use referenced cells, and the final answer should also be labeled. The work should be clear such that you can repeat similar calculations later

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!