Build a Valuation Model in Excel

Learn to build a model in excel, step by step, to determine the financial viability of a project or the value of a business.

START FREE TRIAL

Meet Your Instructor

Sean Griffin

Consultant, BCG
Strategy, The Walt Disney Co.

START FREE TRIAL

Curriculum

01

Introduction

We introduce the course and tell you about what you will learn.

02

Build an ROI Model – Return on Investment

Learn to build your first model from scratch! In this lesson you will estimate what your return on investment (ROI) will be for a short term project of selling t-shirts to Pareto Labs customers.

03

Build an NPV Model – Net Present Value

In this lesson you will learn how to build a model for a longer term investment. You will build a model using the net present value method (NPV) to determine whether buying a t-shirt printing press would be a good investment.

04

Build a DCF Model – Discounted Cash Flow

Building on the previous lesson, in this one you will learn how to build a model to evaluate whether it makes sense to invest in a longer term business opportunity. In this case, you will be estimating whether or not Pareto Labs should start a t-shirt business, which means a much larger investment that is measured over a much longer time period.

What people are saying about this course…

"I like everything about the course, because it has taught me how to calculate ROI and how to evaluate a business."
Alexander O
"Elegantly explained; clean & simple model."
George M
"Excellent content. Made advanced topics pretty easy."
Rashik S
"It took what can be a relatively complex subject and made it very easy."
Jennifer C United Kingdom