From the course: Excel for Accountants
Unlock the full course today
Join today to access over 23,100 courses taught by industry experts.
Financial statement links in Excel - Microsoft Excel Tutorial
From the course: Excel for Accountants
Financial statement links in Excel
- [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 will include the property, plant, and equipment net of any accumulated depreciation, plus our goodwill and 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 if we have an error of some…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
(Locked)
General ledger overview4m 16s
-
(Locked)
Recording transactions in a GL4m 54s
-
(Locked)
GL strings3m 39s
-
(Locked)
Corporate financial statements in Excel4m 19s
-
(Locked)
Financial statement links in Excel3m 25s
-
(Locked)
Key corporate accounting ratios4m 14s
-
(Locked)
International accounting standards vs. the US2m 14s
-
(Locked)
XBRL, Edgar, and corporate financial reporting3m 55s
-
(Locked)
-
-
-