Financial Analysis

Financial Analysis

Course information:

Max. length:
4 months
20 credits
Online Course
390 USD

Course description:

This course covers several topics, which are fundamental for every aspiring Financial Analyst:

  • Microsoft Excel for Beginner and Intermediate Users: Become Proficient with the world’s #1 productivity software
  • Accounting, Financial Statements, and Financial Ratios: Making Sense of Debits and Credits, Profit and Loss statements, Balance Sheets, Liquidity, Solvency, Profitability, and Growth Financial Ratios
  • Finance Basics: Interest Rates, Financial Math Calculations, Loan Calculations, Time Value of Money, Present and Future Value of Cash Flows
  • Business Analysis: Understanding what drives a Business, Key Items to be Analyzed and their Meaning, the Importance of Industry Cycles, Important Drivers for the Business of Startup, Growth, Mature and Declining Companies, Important Drivers for an Industry
  • Capital Budgeting: Decide whether a company's project is feasible from a financial perspective and be able to compare between different investment opportunities
  • Microsoft PowerPoint for Beginner and Intermediate Users: The #1 tool for visual representation of your work, a necessary skill for every Financial Analyst
Table of Contents

Microsoft Excel

  1. Quick Introduction
  2. Useful Tools
  3. Best Practices That Will Make a Difference
  4. Beginner, Intermediate & Advanced Functions
  5. Financial functions in Excel
  6. Practical Exercise Build a P&L From Scratch
  7. Building Professional Charts in Excel
  8. Working with Pivot Tables in Excel

Pivot Tables & Slicers in Practice

Modeling in Excel

  1. Building a complete 3-statement model
  2. Let's build a flexible model with multiple scenarios
  3. We are almost there! Completing the 3-statement model


  1. Introduction to Accounting & Bookkeeping
  2. Types of revenues, costs, assets, and liabilities
  3. Revenue recognition
  4. Cost recognition
  5. Understanding the Big Picture Why, What, When, and How Much
  6. The Core Principles of Accounting
  7. Practical Exercise The Accounting Transactions of a Lemonade Stand
  8. Preparing a Cash Flow Statement Understanding Cash Flow Analysis
  9. The Importance of Timing

Advanced Accounting

  1. Trade receivables
  2. Inventory
  3. Fixed Assets
  4. Trade payables
  5. Financial liabilities
  6. Leasing Liabilties
  7. Using leverage
  8. Raising equity, types of equity, and dividend payments

Financial Statement Analysis

  1. An Introduction
  2. Subtleties
  3. Practical Case Study Analyzing P&G's Financials
  4. Tesla exercise

Working Capital Management

Fundamentals of Business & Financial Analysis


  1. The Time Value of Money and Interest Rate Components
  2. The Value of Cash Flows with Different Timing
  3. Loan Calculations

Capital Budgeting

  1. Basic notions
  2. A Complete Case Study

Practical Case Study

  1. Building a financial planning model


  1. Introduction to PowerPoint
  2. Tips & Tricks That Will Transform You Into An Advanced User

Get this course

Start your education today to receive an e-certificate for completing this course.

By clicking on the button below, you will be redirected to the PayPal gateway, where you can complete the payment via your credit/debit card or bank account.