课程: Excel Modeling Tips and Tricks

免费学习该课程！

今天就开通帐号，24,600 门业界名师课程任您挑！

Projections in financial models

Projections in financial models - Microsoft Excel教程

课程: Excel Modeling Tips and Tricks

开始一个月试用 购买团队方案

Projections in financial models

“

- [Instructor] Once you have the data that you need and you understand the mechanics, you actually need to go through and build the model. So let's take a look at this process. I'm in the 03_07_Begin Excel file. So I have here my forecast model and we've added a few more variables, and we've also gone through and hidden a couple of sheets, just to make things kind of easier to read. So we've hidden our different assumption sheets and our outside data sheet, and we're simply pulling from those sheets when we change the assumptions. So, it kind of looks like magic, right, because you can't even see those sheets. But I've got to go through and I've got to build out a few more assumptions along the way. So I'm going to use my historical values for cash relative to sales, and that'll give me my assumption on cash. And we're going to do the same thing with accounts receivable and with inventory. And from here, and we'll kind of clean this up a little bit and make it easier to read, and I…

内容