Financial statements in Excel can be linked together and presented effectively. Excel makes it easy to see accounting formulas for metrics like EBITDA, free cash flow (FCF), and financial ratios.
- [Instructor] Income statements are critical for the firm, … but accountants also need to be able … to create a balance sheet. … And this requires preparing asset … and liability entries in Excel. … Let's take a look. … I'm in the 03_05_Begin Excel file. … Now, what we have here is a basic balance sheet. … We've got assets, liabilities, and equity entries … that have been put together by the company. … But, the balance sheet's not quite finished, … so we need to go through and make some modifications. … In particular, we need to start by calculating … our total assets. … To do this, we're going to sum up our short-term … current assets plus all of the long-term … entries for the firm. … So this'll include the property plant equipment net … of any accumulated depreciation, … plus our goodwill intangibles, … and our long-term investments, … and then other assets. … When we do that, we can go through … and extend this across the full five-year period. … And the nice feature about this is that …
- List the most common tasks and approaches faced by accountants in their daily lives.
- Determine whether transactions can be exported from Quickbooks to Excel or not.
- Outline the structure that the SUMIF function uses.
- Explain how to measure EBITDA.
- Identify at what level the General Ledger tracks expenses.
- Break down how to construct a business valuation using a cash flow analysis.