Build a Valuation Model in Excel

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.

Get unlimited access to ALL courses today!

Meet Your Instructor

  • Sean Griffin

    • Consultant, Boston Consulting Group
    • Strategy, The Walt Disney Co.
    • Wharton MBA

By the end of this course, you'll be able to:

  • Set up

    Set up your model in an organized template to easily display your data and output.

  • Calculate

    Calculate the potential profitability of an investment.

  • Value

    Value a business using a Discounted Cash Flow analysis.

  • Build

    Build three different kinds of models in addition to a sensitivity table using Excel's built-in tools.

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.