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.

Meet Your Instructor

Sean Griffin

Consultant, BCG
Strategy, The Walt Disney Co.




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


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.


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.


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