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.

Build the annual balance sheet

Build the annual balance sheet - 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

Build the annual balance sheet

“

- [Speaker 1] Okay, so now we're going to do the same kind of annual aggregation exercise before our Balance Sheet. And so unlike the Income Statement that takes a total across a entire year, the Balance Sheet just takes a balance at a given point in time. And so we're going to be using the index match formula combo to get that done. You can also use X lookup if you prefer. I still prefer index match just because the control bracket functionality allows me to reference my lookup range first as opposed to my lookup indicator. So let's start by building it actually out here in the forecast actual section because I want to know what is actual and what is forecast based on the changes that I make in the monthly section? So let's build out the index match. The first is the index, which means where am I going to look? I'm going to look in this entire top row, again I'm going back to the beginning, out to the end, grabbing my…

Contents