Overview

Google, IBM & Meta Certificates – 40% Off

One plan covers every Professional Certificate on Coursera.

Master the practical skills of financial modeling by building and analyzing a complete valuation model using Apple Inc. as a real-world case study. In this course, you will learn how to interpret financial statements, forecast revenue and costs, analyze balance sheets, model working capital, estimate capital expenditures, and construct dynamic financial models that support informed business and investment decisions. As you progress, you will calculate earnings per share (EPS), evaluate receivables, depreciation, debt structures, and equity, then apply core valuation techniques including Discounted Cash Flow (DCF), Weighted Average Cost of Capital (WACC), FCFF, FCFE, Net Present Value (NPV), sensitivity analysis, and terminal value estimation. You will also explore risk-return concepts, beta, equity risk premium, and target share price modeling to strengthen your financial analysis capabilities. Designed for learners interested in corporate finance, financial analysis, equity research, investment banking, and valuation, this course combines structured instruction with practical application using Apple Inc.'s financial data. By the end of the course, you will be able to build professional financial models, forecast financial performance, value companies with confidence, interpret financial information, and make data-driven valuation decisions using industry-recognized financial modeling techniques.

Syllabus

Foundations of Financial Modeling

This module introduces the fundamentals of financial modeling, using Apple Inc. as the case study. Learners will explore how to read annual reports, forecast revenues, calculate costs, and connect data to income statements. The lessons also cover earnings and share-related calculations to set a strong foundation for advanced modeling.

Balance Sheet and Working Capital Mastery

This module focuses on the structure and application of balance sheets with emphasis on working capital. Learners will examine receivables, build key assumptions, and forecast capital expenditures. Lessons include advanced topics such as depreciation waterfalls and calculating ending net PP&E.

Debt, WACC, and Valuation Fundamentals

This module explores debt, equity, and valuation fundamentals critical to financial modeling. Learners will examine dividends, liabilities, and debt linking, then progress to discounted cash flow mechanics, WACC, and risk-return analysis. The lessons connect theoretical finance with practical applications.

Valuation and Advanced Analysis

This module covers advanced valuation methods and free cash flow analysis. Learners will calculate FCFF and FCFE, estimate growth rates, and model share price targets. The module concludes with sensitivity analysis, terminal value, and final valuation insights for practical decision-making.