33%(6)2 out of 6 people found this document helpful
This preview shows page 1 - 4 out of 8 pages.
Introduction:You have recently been hired as a Financial Analyst in the Finance Department of Zeta Auto Corporation which is seeking to expand production. The CFO asks you to help decide whether the firm should set up a new plant to manufacture the roadster model, the Zeta Spenza.Deliverables:Write a report providing the CFO with your recommendation whether Zeta should set up the plant to produce the Spenzas and support your recommendation by in-depth analysis in Excel. In your report, explain the results of each portion of your analysis (represented by the tabs on the Excel template).Submit all the completed Excel worksheets with the completed responses to the questions posed to support your report and recommendation. Report should include a one-page Executive Summary summarizing the results of your analysis and recommendation.Project DataTo assess the suitability of the project you begin by listing the various cash flows. A consultant has been paid $50,000 todo a market survey. She reports back that Zeta can price Spenzas at $80,000 per car and sell 5,000 cars next year (in year 1), then sales will peak at 7,000 in year 2 and after that they will start declining with 6,000 Spenzas sold in year 3, 4,000 in year 4, and 3,000 in year 5. After that the sales decline won't make manufacturing of Spenzas profitable. The consultant also estimates that introduction of Spenza model
will cannibalize the sale of an existing model, the Zeta Monza, resulting in 1,000 fewer units of the Monza sold in each of the 5 years. Monzas are priced at $65,000.�After 5 years it is expected the Spenza will be phased out, and the plant will be put to other uses generating cash flow of$15 M annually.The cost of setting up the plant is to be $250 M with annual manufacturing capacity of 10,000 cars. It is a one-time capital investment made at the very beginning of the project.