Financial Modeling Essentials
Introduction to Financial Statements
Understanding financial statements is a critical skill for all management executives. This course provides a brief overview of the three financial statements and how to perform some financial analysis in Excel.
Intermediate    14 Lessons    120 Minutes    CPD Credits
About This Course
There are many ways to create and analyze a company’s financial statements, and Excel has got the answer for you. In this course, you’ll explore how to create income statements, balance sheets, and a statement of cash flow, to suit your company’s needs.
Across 14 lessons, you’ll drill deeper into each of the three financial statements, to understand just what is required from each.
By the end of the course, you’ll feel confident in preparing your company’s statements through Excel, knowing your data has solid foundations.
Learning Outcomes
-
List the main financial statements used in business
-
Determine when revenue should be recognized
-
Calculate cost of goods, expenses, taxes, and profits
-
Explain the components of a Balance Sheet
-
Develop a common-size Income Statement and Balance Sheet
-
Explain the components of a statement of cash flows
-
Calculate ratios to analyze financial statements
Lessons
1. Introducing Financial Statements
2. Revenue and Revenue Recognition
4. Operating Expenses
5. Interest, Taxes and Net Profit
6. Common-Size Income Statement
Read More
7. Current Assets
8. Current Liabilities and Liquidity Ratios
9. Long-Term Assets
10. Long-Term Liabilities and Shareholders' Equity
11. Common-Size Balance Sheet
12. Cashflows from Operating Activities
13. Cashflows from Investing and Financing Activities
14. Additional Financial KPIs
Learning Certificates
Showcase Your Skills
Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.
When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.
