How to Build a Financial Model to Support Business Decisions

Past Locations for this Workshop

How to Build a Financial Model to Support Business Decisions

Past Locations for this Workshop

About this workshop

Models mean different things to different people, but they are basically a simplified representation of a system built to support predictions and/or decision making. In this class, we’ll talk about first steps in building a model, how to define the purpose/use of the model, and how to determine what business questions you’re trying to solve. The class will be hands-on and students will work in groups to build several different types of models, which we will review as a class.

Takeaways

  • Understand in which situations a model will be a helpful tool to support decision making
  • Quickly build a basic model (financial or otherwise) using a simple 6 step process that ensures you “build it right” the first time
  • Apply model building “best practices” to reduce errors and improve usability of model
  • Understand and leverage models to apply basic analysis techniques (e.g., break even analysis, growth rate calculations, simple scenario analysis)

Prereqs & Preparation

Comfort with basic excel commands: “if” statements, copy and paste, addition, subtraction. If you need to brush up on Excel “if” statements, check out this article

You will need a laptop with excel for class.

Coming up near you

Let’s Keep You Updated

Enter your email to start following

By providing us with your email, you agree to the terms of our Privacy Policy and Terms of Service.

Join our community and receive 50% off an introductory workshop up to $100.

Never Stop Learning

Join our community and receive half off any of our offerings priced below $100. (First-time subscribers only; excludes full-time courses, part-time courses, and Circuits).

Clear some room in your inbox!

We aim to be relevant. To start us off right, tell us a little more about yourself.