课程: Financial Modeling Foundations

今天就学习课程吧！

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

Linking financial statements

Linking financial statements - Microsoft Excel教程

课程: Financial Modeling Foundations

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

Linking financial statements

“

- [Instructor] The first step in many financial models is linking the different financial statements together. In point of fact, this actually seems trivial. It doesn't seem too hard to put together the income statement with the balance sheet, right. But in reality it can be a lot trickier than you might think. Let's see how it's done. Let's take a look at the steps, shall we. So, step one in linking the financial statements, is to begin by calculating our revenue. We're gonna do this based on some kind of a forecasting approach. From there, you need to go through and fill in your other major accounting statement items, so cost of goods sold or COGs, your gross profit, your operating expenses. And then when we get done, you should have your earnings before interest, taxes, depreciation, and amortization, or EBITDA as it's more commonly known. Once you've gone through and filled out the financial statement, you're ready to begin creating your supporting schedules. In particular, we…

内容