Manufacturing Project Modeling

Description

Many professionals build models to assess the impact and feasibility of undertaking new projects. This course reviews project economic concepts and focuses on the skills required to design and create a financial model to help a company decide whether it should invest in a new project. Various intermediate Excel tools along with helpful keyboard shortcuts will also be covered throughout the course.

Prerequisites

Participants should have a basic working knowledge of Excel and the manufacturing sector prior to taking this course.

Time

8 - 16 hours, depending on the amount of material to be covered

Learning Topics

Review Project Economics Concepts

Discuss key business concepts that impact a project

Design and Structure a Financial Model

Design a clear and logical financial model
Discuss the need for a model to serve as a marketing tool
Create clearly defined inputs and assumptions sections
Connect strings of data to create assumptions and footnotes

Build Scenarios and Financial Forecasts

Use switches to create effective scenarios and value drivers
Forecast the project’s revenues and expenses
Develop a cash flow projection for the project
Incorporate financial and arithmetic functions
Use logical functions to create complex formulas

Evaluate the Project

Incorporate a schedule to evaluate the project’s returns
Build a strong summary page to display the results
Use various tools to sensitize the project’s returns
Conditionally format output tables to highlight specified results
Set up print ranges to optimize the appearance of printed output