课程: Financial Modeling Foundations

今天就学习课程吧！

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

Getting started with the project

Getting started with the project - Microsoft Excel教程

课程: Financial Modeling Foundations

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

Getting started with the project

“

- [Instructor] Building a financial model requires getting your hands dirty by actually demonstrating what will happen in a scenario, using figures and projections in Excel. Throughout this course, I will try to keep us all on the same page by using partially prebuilt Excel examples. Let's dive in to one of those examples, shall we? I'm in the 01_07.Begin Excel file. Now what you're going to see here is that we have an income statement, a balance sheet, and a statement of cash flows for a firm. All three of these are linked together based on different formulas. So some portions of any financial statements will be driven by data from the firm, something like COGS, as an example, or SG&A, particularly on a historical basis. These won't be projections or calculations; they'll be derived directly from what the firm actually reports. Other items, like Operating Income or Net Income, might be derived from various subsections of the income statement, the balance sheet, or the cashflow…

内容