INDUSTRIAL ECONOMIC ANALYSISChapter 11 HomeworkAutomobile Replacement AnalysisYou are considering the purchase of a new car. You presently own a red 2014 Chevrolet Camaro 2door LS Coupe with 55,000 miles. It has 3.6 liter V6 engine with manual 6 speed transmission. It is in clean condition with all optional equipment. You purchased the car in January 2014 for $35,750. The loan for the car has been paid off. You estimate your current operating expenses to be $290 per month for gas, $170 per month for insurance, and annual maintenance and repair costs average approximately $1150. You think that you will need a brake job next year at a cost of $575, and then three years from now you would have to rebuild the transmission at a cost of $3300. If you performed these repairs, the car would last five more years after the transmission rebuild without any other major expenses. You estimate you would sell the car six years from now and the trade-in value of this current vehicle will be 50% of todays trade-in value.You are considering trading in this present car for a new 2016 car (you decide what car you want, but the challenger car cannot cost more than $25,000). You estimate that you could sell the new car in six years for 50% of the purchase price. You must develop estimates for annual operating costs for the new car, which include estimates for the monthly cost of gas and insurance and annual maintenance and repair cost. You can Google several Internet sites to get estimates of maintenance and repair costs. Interest rates for new car loans are available at www.bankrate.com. You must pick an interest rate from this website and use this rate in your analysis. Do not round the Bankrate interest rate. Use all the decimals (i.e. 3.84%).ASSIGNMENT1. Go to edmunds.com and determine the purchase price of the new car and the trade-in value of the current car, which is in clean condition. This information is available from. Attach documentation (hard copy printouts) from the websites on the following values/costs: (8 points) Trade-in value of the Camero. Show all the detailed costs, not just the final value. Purchase price of the new car. Show the price of the options that you have chosen for your new car. Cost of gas, insurance etc. for the challenger Interest rate that you obtained from bankrate.com 2. Perform a replacement value analysis of the two alternatives. (10 points) Show all calculations (not Excel formulas).3. Based on the replacement value analysis, what is the trade-in value that you would have to receive for the Camaro to make the deal economical? What is your decision based on your analysis? (2)4. Submit a table that shows all the costs for the defender and challenger. (5)To get full credit you must show all manual (hand written not Excel) calculations for item #2, including all equations and solutions. REMEMBER, ALL COSTS MUST BE DOCUMENTED BY PRINTOUTS (hard copies) FROM THE WEBSITES. EVERYTHING MUST BE SUBMITTED IN HARDCOPY PLEASE DO NOT SEND ANYTHING TO ME BY EMAIL. If you have computer or printer problems, you can use the computers in the Roesch library.THIS IS AN INDIVIDUAL ASSIGNMENT.