Analize case and submit your answer with calculations in an Excel file

Nicole, a Financial Policy & Strategy student, lives in a house on Carretera Norte a short distance from the railway. She commutes to work located outside the city at a cost of $$180$ per month. She also rents a car every weekend, which costs her $$600$ a month, including insurance and fuel. She is considering buying a new car for cash to replace transportation and rental costs. His study partner, Louis, advises her to visit a car dealer where a new car would cost her $$20,000,$ give her $28$ miles per gallon, and sell for $$10,000$ after five years with proper maintenance and normal wear and tear. The cost of maintenance and repairs is estimated at $$2,000$ per year, insurance of $$1,500$ per year and fuel costs of $$1\mathrm{.}50$ per gallon and she would drive $15,000$ miles per year.

The management of the car dealer asks Elizabeth to make an economic analysis of Nicole's case assuming that all costs occur at the end of the year and that she sells the car at the end of the fifth year. If Nicole's discount rate is $12$ percent after taxes, what would Elizabeth advise Nicole? What would be the minimum price Nicole would agree to sell the car in $5$ years?