From the course: Excel for Finance: Building a Three-Statement Operating Model
Unlock the full course today
Join today to access over 23,200 courses taught by industry experts.
Quick cleanup - Microsoft Excel Tutorial
From the course: Excel for Finance: Building a Three-Statement Operating Model
Quick cleanup
- [Instructor] All right, so I know we need to model out the debt schedule next, but what we're going to do first is actually just zoom out and take a little bit of a break and check our model as a whole, to make sure that we are in the right place before we move on to the final section. And so we're just going to do that by working our way up from the bottom, which is a good way to check your model in reverse and make sure that we have everything captured. And also, another good idea sometimes is just to walk away from the computer in general. A lot of times I'll think of what I need to do or need to add to a model by just taking a break. And so, doing that in combination with just zooming out and checking your work is a great habit and practice to get into before you keep just going down into the weeds and building more of the model. So, perfect example here. I just left out some notes for this section, right?…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
(Locked)
An overview of CapEx and depreciation4m 22s
-
(Locked)
How to lay the fixed assets schedule2m 50s
-
(Locked)
Building the CapEx forecast4m 36s
-
(Locked)
Building the depreciation waterfall8m 40s
-
(Locked)
Modeling existing depreciation3m 16s
-
(Locked)
Connecting the fixed assets to the model4m 16s
-
(Locked)
Quick cleanup3m 48s
-
(Locked)
How to lay the debt schedule4m 45s
-
(Locked)
Groundwork of the cash flow sweep6m 30s
-
(Locked)
Finishing the cash flow sweep4m 56s
-
(Locked)
Modeling the revolver4m 59s
-
(Locked)
Getting started with term debt3m 3s
-
(Locked)
Setting up term debt amortization4m
-
(Locked)
Modeling the term debt amortization4m 38s
-
(Locked)
Connecting the debt schedule to the model5m 26s
-
(Locked)
-
-
-