1. Introduction to the Main Model
Okay, by now, you should have downloaded our main
Business Valuation Model, we've already worked through some exercises in
Excel and we will do a few more
going forward, but this is the main valuation model, so let's just take
a quick tour through it. As always, we have a table of contents
with hyper links, so that we can click and just go directly to
that sheet, you can see the DCF model.
So we have our three main financial statements, the income statement,
the cash flow statement, the balance sheet, it's not a full,
fully dynamic three statement model, but we wanted the three statements
in there, so that we can show you
where a lot of the data comes from, when we do a DCF.
So we have some DCF calculations below our three statement model,
then we have our relative valuation, so we'll do a comparable company analysis,
we'll also do a precedent transaction analysis, and then we'll finish off
with the football field chart. Now, this football field chart will auto
populate as we work through this model, but I'll also show you how
to build one of these from scratch when we get there.
So let's dive into our Business Valuation Model.
2. Let's practice!