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.

Initial groundwork and freeze frames

Initial groundwork and freeze frames - Microsoft Excel Tutorial

From the course: Excel for Finance: Building a Three-Statement Operating Model

Start my 1-month free trial Buy for my team

Initial groundwork and freeze frames

“

- [Instructor] Okay, so now that we've received the email from the CFO and we have the attachment here, let's just open it up and take a look. We've got clearly an Excel file. That's what I was expecting. And we have only two tabs in the file, which is nice. We have the financials with the CFO notes, which makes sense. That's what he talked about on the call. And then we also have a headcount schedule here which looks like it is just a list of the positions of the people that work at the company. So this is something that we will bring into our model at the right time. Let's just take a look, though, at the financials that the CFO sent over. So if we're starting at the left, it looks like nicely labeled. We have an income statement. It works its way down through revenue, cost of goods, some gross profit information, as well as the operating expenses all the way down here to net income. That makes sense. That's…

Contents