Are you ready to learn financial statement analysis using real-world data? This course will guide you through a hands-on case study of Facebook’s 2021 Annual Report, helping you build critical finance skills with practical tools like Excel and PowerPoint.You will start by building a company's Profit & Loss statement and Balance Sheet from scratch. Then, we’ll break down the numbers and extract valuable insights using key financial ratios—including liquidity, solvency, profitability, and growth metrics. You'll understand not only how to calculate these ratios, but what they actually mean in the context of a real business.We’ll dive into important topics such as timing of revenue and cost recognition, industry benchmarking, and the fundamentals of business valuation. You’ll also learn to perform Net Present Value (NPV) analysis for project decisions and create a loan amortization schedule to understand the impact of different financing options.This course is ideal for students, business owners, and professionals who want to apply financial knowledge to real companies. By the end, you’ll be confident reading and interpreting annual reports, evaluating business performance, and building professional reports.No prior finance experience is required. If you know basic Excel and want to understand how businesses are evaluated financially, this course is for you.What You’ll LearnBuild a complete Profit & Loss statement and Balance Sheet from scratchAnalyze Facebook’s 2021 financial statements (based on public SEC filings)Understand and calculate Liquidity, Solvency, Profitability, and Growth ratiosAssess company performance using actual business d
What you'll learn
Build a Profit & Loss statement and Balance Sheet from scratch
Analyze Facebook’s 2021 financial statements
Calculate Liquidity, Solvency, Profitability, and Growth ratios
Understand revenue and cost recognition timing
Perform NPV analysis for project decisions
Create a loan amortization schedule
Course objectives
To equip students with the ability to read and interpret annual reports
To enhance skills in evaluating business performance
To develop proficiency in financial analysis tools like Excel and PowerPoint