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.

Connecting the fixed assets to the model

Connecting the fixed assets to the model - 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

Connecting the fixed assets to the model

“

- [Instructor] All right, so now we need to link it all together and close out this section. So the first thing, let's just bring our depreciation up to the income statements, I'm going to go up to the top. I'm just tapping Page Up to do that really quick. My depreciation is now just going to be equal to and then the ending balance on my schedule at the very bottom here. Let's hit Enter there, change my formatting to black font, drag this out to the right, Control Shift Right arrow, just like that. And now let's go check our schedules down at the bottom. First thing is my depreciation matches, which it should. I just linked to it directly. And now we can carry forward this piece in our corkscrew, which is the depreciation, it should match up. So let's go ahead and do that piece. Complete this and it's not going to make our balance sheet perfect, but it's going to help a little bit. Okay, there we go. Actually, it…

Contents