DCF Modeling and Company Valuation

About this course

Master DCF Modeling in Excel and learn how to value companies like a financial analyst. Build real-world valuation skills using practical, step-by-step techniques. This course is designed to help you understand and apply Discounted Cash Flow (DCF) modeling using Microsoft Excel. You will learn how to forecast financial performance, calculate cost of equity using CAPM, determine cost of debt, and compute WACC for accurate discounting. Through hands-on examples, you will build a complete DCF model from scratch, estimate terminal value using the Gordon Growth Model, and calculate intrinsic value to compare with market price. Whether you're a finance student, aspiring investment banker, or professional looking to upgrade your skills, this course provides practical, job-ready knowledge in financial modeling and valuation. By the end of the course, you will confidently analyze companies, make data-driven investment decisions, and apply DCF modeling in real-world scenarios.