Skip to main content
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
TRY FOR FREEEXPLORE OUR LIBRARY

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.

GET STARTED

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
3. Calculating Gross Profit
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.

What Our Students Say

We don’t aim to satisfy, we aim to delight

Become A Data Citizen

Ready yourself for the rapidly changing world