课程: Using Data in Financial Analysis

今天就学习课程吧！

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

Tying data to financial statements

Tying data to financial statements - Microsoft Excel教程

课程: Using Data in Financial Analysis

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

Tying data to financial statements

“

- [Instructor] In addition to long-term forecasts, in an FP&A, or financial planning and analysis type role, you'd often be asked to go through and build out a budget model showing what, as an example, daily, weekly, or monthly cash flows and sales might look like. Monthly is probably the most common that you'd run into. So let's take a look at an example. I'm in the 02_02_Begin Excel file. Now what you see here is a hypothetical set of projections for a hypothetical startup that I've put together, and we've got data running from July, 2023 through the end of the year and then into 2024. So this is basically kind of an 18 month budget forecast for the firm. Now we start with our cash position and we see that this is a small firm, it's a startup company. So in this case, we've got starting cash of 55,000. We have zero users at the time. Now, and this is one of the nice things about Excel, we can go through and we can kind…

内容