Parameters: Your car is getting old and more and more costly to maintain. Its estimated annual maintenance costs for this coming year and for the next year are given in the file attached. Its resale value is zero. You are considering buying a new car. Its price, annual maintenance costs (constant), and resale value after the end of warranty in five years are given in the file attached.

Calculate the NPV and EAC, showing all work in excel. When should you buy a new car - now, in a year, or even later? (please do this in excel and show all work and learn from that) Thank you so so much!!!

8% Cost of capital Old Car Annual cost this year (maintenance + gas + taxes) Annual cost next year (maintenance + gas + taxes) Zero resale value Ignore taxes $7,000 $9,500 New Car Price annual cost (maintenance + gas + taxes) Warranty (in years) Resale value at the end of warranty $30,000 $2,500 5 years $20,000 NPV EAC