Meet Your Instructor
• Consultant, Boston Consulting Group
• Strategy, The Walt Disney Co.
• Wharton MBA
By the end of this course, you'll be able to:
Set up your model in an organized template to easily display your data and output.
Calculate the potential profitability of an investment.
Value a business using a Discounted Cash Flow analysis.
Build three different kinds of models in addition to a sensitivity table using Excel's built-in tools.
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.