From the course: Excel for Accountants
Unlock the full course today
Join today to access over 23,100 courses taught by industry experts.
Corporate financial statements in Excel - Microsoft Excel Tutorial
From the course: Excel for Accountants
Corporate financial statements in Excel
- [Instructor] In addition to the general ledger, the other major task corporate accountants will often face involves preparing financial statements for the firm. Excel is great for this task because it can embed formulas, which will dynamically change the financial statements if you end up correcting or adjusting any of the inputs. Let me show you what I mean. I'm in the 03_04_Begin Excel file. Now, what we have here are basic pieces of financial information that we've collected from the firm. We've got our revenues over time. We've got our COGS, SG&A expenses, all of the different costs that the company is going to report to us. What accountants will often have to do is to take this massive raw data and put it into an intelligible and digestible format for use by corporate decision makers. So how do we do that? Well, to start with, we need to go through and determine what our total operating expenses are. This is going to include COGS, SG&A expenses, and research and development…
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)
-
-
-