Financial Modeling & Valuation: Analyze & Forecast

This course is a comprehensive, step-by-step learning journey into the practical construction and interpretation of financial models, designed around the real-world case of Big Books Corp. Participants will learn how to analyze historical data, calculate key financial drivers, and forecast segment-wise revenues, expenses, and cash flows. The course guides learners through constructing income statements, balance sheets, and cash flow statements, progressing into evaluating capital expenditures, depreciation schedules, and working capital cycles. As the course advances, learners will compute valuation metrics such as Net Present Value (NPV), Free Cash Flow to the Firm (FCFF), and Free Cash Flow to Equity (FCFE), culminating in the creation of a Discounted Cash Flow (DCF) model. They will then apply relative valuation techniques, including EV/Revenue and EV/EBITDA multiples, to compare peer companies, and interpret share prices under multiple forecast scenarios. This course not only builds technical modeling expertise using Excel, but also strengthens the learner’s ability to evaluate financial performance, interpret valuation outputs, and apply strategic thinking to real business contexts. By the end, learners will be able to confidently design, construct, and assess comprehensive valuation models used in investment banking, equity research, and corporate finance.