PLEASE HELP ASAP!!!

QUESTION: OBTAIN DEPRECIATION AND BOOK VALUE FOR EACH OF THE $12$ PERIODS

Ford Motors has decided to shift its strategy away from fully electric vehicles $($ NY Times article$).$ To promote the quality of its hybrid cars, Jim Farley $($CEO$)$ plans to launch a special edition hybrid $2025$ Mustang. Sales for this new model would begin in October $2024$ and end in September $2025.$

Ford plans to sell this new vehicle for $$45,000$ and can manufacture each car for $$30,000$ as variable costs. Fixed costs are estimated at $15$ million dollars per month. The necessary equipment can be purchased for $250$ million dollars and depreciated on a MACRS schedule $($depreciation table in the data file$).$ You predict that the equipment can be sold at the end of the project for $200$ million dollars.

Jim Farley has asked his team to carefully study whether Ford should produce this new version of the Mustang. He understands the new product will define the brand's public perception, at least for the next decade. Because of this, Ford spent $5$ million dollars on a marketing study over the previous year and another $20$ million dollars developing the new vehicle's engine over the last five years.

This special edition will undoubtedly affect the sales of the current models, particularly the Ford Mach$-$E $($SUV version of the Mustang$).$ Currently, the Mach$-$E is sold at $$40,000,$ with variable costs of $$23,000,$ and forecasted sales following the "Mach$-$E sales" table in the data file. If Ford produces the new vehicle, the price of the Mach$-$E will need to be reduced to $$35,000,$ and sales for the Mach$-$E are estimated to be reduced by $10\%$ relative to the current forecast.

Ford's policy is to set net working capital requirements at $15\%$ of sales, which will occur with the timing of the cash flows for October $2024($Month $1).$ This means there is no initial outlay for NWC$,$ but changes in NWC will first occur in Month $1.$ The corporate tax rate is $21\%,$ and the required rate of return is $20\%$ per year with annual compounding.

Due to the difficulty of predicting market reactions to new products, Ford analysts are not sure about the predicted $10\%$ decrease in sales for the Mach$-$E$,$ as well as the new price for the Mach$-$E if the Mustang project is approved and would like you to focus your sensitivity analysis on these variables. They have provided you with some bounds for these variables. They believe the decrease in sales for the Mach$-$E will

most likely be between $20\%$ and $5\%$ and that the sale price for the Mach$-$E if the Mustang is approved, will be between $$33,000$ and $$37,000.$

As an external consultant, your task is to evaluate this project. You are required to write a report and give your recommendation to accept or reject it$.$ Your recommendation must be technical and based on a thorough analysis of the techniques studied in this course.

You must include estimated cash flows, three investment criteria measures $($NPV$,$ IRR, and one of your choice$),$ and a project analysis based on a case scenario and sensitivity analysis. You are required to analyze and interpret your results $($points will be deducted if your numerical answers don't have a written interpretation of the results$).$