From the course: Financial Modeling Foundations

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Build the balance sheet

Build the balance sheet

From the course: Financial Modeling Foundations

Start my 1-month free trial Buy for my team

Build the balance sheet

“

- [Instructor] Now, that we're done with our income statement, it's time to go through and build out the balance sheet. That's the next step in building our model. I'm here in the 02_05_Begin Excel file. Now, we've built out the income statement, I wanna turn our attention to the balance sheet. And some of this isn't gonna make sense quite yet until we fill out all the financial statements. But we're gonna go through and build out the short-term investment section in our cash and cash equivalents, and that'll then give us the cash and short-term investments. And you'll see, of course, that that is just a sum of these two values. And I'm gonna take this all the way over, 'cause it's not gonna change even in our forecasted period. But we can see that our short-term investments are going to be essentially last year's minus this year's short-term investment. So we see, for instance, let's take a look down here, that…

Contents