Introduction to Financial Statements

Booking Information

Once you have booked your course, you will receive a confirmation email containing an access link and passcode. Use these to set up your account on the Chartered Accountants Ireland Portal within the Kubicle site

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 statement

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
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

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.