Overview
The purpose of this assignment is to develop a financial model in Excel that addresses key questions from the New Plant Planning case. This model will form the foundation for your course project, which includes a detailed paper and a screen capture video demonstrating your analysis and decision-making process.
Create a financial model in Excel that will answer the questions listed in the new plant planning case.
- Following these steps will help as you design and create your model in Excel:
- Sketch the spreadsheet.
- Organize your model into four modules or sections.
- Input Parameters
- Decisions - design for use by making it easy to change parameters that can be expected to change.
- Outputs
- Calculations
2. Start small by isolating one question at a time, then design, build, and test your model to make sure it answers that question. Then move to the next question. This way, you will begin with the simple and finish with the complex.
Notes:
- Please refer to the Financial Model Rubric in the Start Here tab.
- You will complete the new plant planning model in MS Excel and submit the Excel file for grading.