TRANSCRIPT
Click any timestamp to jump
Okay, let's take one final walkthrough of the model to see what it looks like now that
it's done.
First thing I'm going to do is print preview it and look at all of the entire workbook
and scroll through and notice how everything that we have is so beautifully laid out with
our headers and our footers and our consistency across our column widths and our formatting
so that we have an Assumptions page on page one, then we get to our visual Dashboard on
page two, which has the header and footer and our logo again.
Page three now is an Income Statement.
When we get to page four, it looks like the Balance Sheet and then page five, our statement
of Cash Flows.
So everything just looks consistent and professional and aesthetically pleasing.
Let's look at a couple of things that show how it works.
So if I highlight between columns G and J and then navigate to home and format and hide
and unhide, let's unhide these columns and remind ourselves that the values that we got
for Baseline versus Optimistic are hidden over here so that when I click a drop down
from Baseline, it should pick up that Optimistic of 12% and then even more fun when we go to
the Dashboard.
Now look at how the Dashboard is showing us that our revised projections in blue give
us a much higher Net Sales of 23 million that we can corroborate over here on the income
statement where on our Income Statement, we now see that $23 million number in 2030 where
if we go back to the Assumptions and we change that back to Baseline of 5%, our Dashboard
evens itself back out and resets and then we can see that both are revised as well as
our Baseline is now that $17 million Net Sales number showing the functionality then of that
Dashboard.
So let's go back to our Assumptions and we'll hide that again and under home we'll go to
format and we will hide and unhide and hide those columns.
We have a legend over here which reminds us that these drop down selectors can be used.
We know that our input data is in blue, our actuals appear in this gray and then our projections
appear anywhere you see the italics.
As a reminder too, if I right mouse click on the bottom of the page and ask it to unhide,
we have two sheets that are currently are hidden where if we went into them we would
see that those are the static versions of our income and Balance Sheet versus if you
look at the formula bar as I click along, these are the formulaic versions of it which
is also interesting to see if we go to formulas.
There's a show formulas area where actually demonstrate to us all those different formulas
that we did.
So let me hide that Income Statement too back again.
Let me hide that Balance Sheet too back again.
Let's put our cursor up into cell A1 on the Balance Sheet and the Statement of Cash Flows
and the Income Statement and the Dashboard and the Assumptions and then we save it and
now we have something that is perfectly available to print as well so that if I wanted to do
a file and save it as a PDF and add all of those in there and convert it to a PDF and
save it on my desktop for example right now, after a few seconds of processing it's going
to take that Financial Model that we built in Excel and make it into a beautifully printable
five page document that you could take into a meeting that's worthy of an executive putting
eyes on a set of projections that are perfectly done.
So that brings us to the end of the Financial Model build.
In the next video we'll go ahead and summarize the entire exercise
and bring this series to a close.
We'll see you then.
50 segments