Overview

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 driversCalculate Net Present Value (NPV) to evaluate investmentsBuild a loan amortization schedule and compare fixed vs variable interestUnderstand the timing of revenue and cost recognitionPerform industry analysis and benchmark financialsPresent your findings using Microsoft PowerPointThis Course Is Ideal ForFinance, business, and accounting studentsEntrepreneurs who want to understand company financialsAnalysts and professionals preparing for interviews or upskillingAnyone curious about how large businesses are evaluatedTools You'll UseExcel for building and analyzing statementsFacebook's 2021 Annual Report for real data analysis

Skills

Reviews