Ashish Agarwal – Company Valuation & Financial Modeling (Download)
Master the Skills That Make Analysts Indispensable
Finance professionals face intense pressure to deliver accurate company valuations from day one—whether in investment banking, equity research, private equity, or consulting. Yet many graduates and career-changers lack the hands-on modeling and forecasting expertise employers demand. The ability to build comprehensive valuation models, analyze financial statements, and perform discounted cash flow analysis separates job-ready analysts from those who struggle in demanding professional environments.
Course Overview and Instructor
Ashish Agarwal delivers this practical, job-focused training designed to make you immediately productive as a financial analyst. Using real-world examples centered on Walmart’s financials, the course provides step-by-step guidance through every component of professional valuation work—from understanding business models to sensitivity analysis.
Perfect for aspiring investment bankers, equity researchers, private equity professionals, venture capitalists, business analysts, and finance managers, this comprehensive training emphasizes hands-on application over theoretical concepts.
What You’ll Master
Valuation Foundations
Understand what valuation truly means, explore different valuation philosophies, and learn where analyst skills apply across financial services. Build a complete valuation framework covering business model analysis, historical financials, forecast financials, valuation techniques, and sensitivity analysis.
Business Model Analysis
Learn to dissect any company’s business model across five dimensions: products, costs, operations, financing, and strategy. Practice extracting this information from annual reports and applying the framework to Walmart’s actual business structure.
Financial Statement Preparation
Master the three core financial statements—income statement, balance sheet, and cash flow statement. Learn standardization techniques, understand minority interests, and capture historical financials from annual reports into usable formats for analysis.
Financial Forecasting
Follow a systematic five-step process to forecast future financial statements. Calculate critical ratios including revenue growth, COGS margin, depreciation rate, interest rate, effective tax rate, working capital ratios, and dividend payout. Learn to extrapolate these ratios logically, then build complete forecasted income statements, balance sheets, and cash flow statements for future periods.
Discounted Cash Flow Valuation
Understand free cash flows (FCFF), operating cash profits, operating cash investments, and discounting mechanics. Calculate Weighted Average Cost of Capital (WACC), determine present value of explicit cash flows, estimate terminal value, and derive both enterprise value and equity value per share. Compare valuations against current market prices to identify gaps.
You may also be interested in these courses:
- Amal Jayasinghe – AML Case Investigation Skills (Download)
- George Levy – Blockchain and Bitcoin Fundamentals (Download)
Sensitivity Analysis
Recognize that valuation is both art and science. Learn to test how changes in key assumptions impact valuation estimates, providing ranges rather than single-point estimates for more robust analysis and decision-making.
Practical Application
All concepts are illustrated using downloadable Excel templates. Work alongside the instructor building Walmart’s complete valuation model from scratch, gaining muscle memory for the processes you’ll use professionally. Practice assignments with varying difficulty levels test your mastery.
Why This Training Works
The course eliminates the theory-practice gap by teaching exactly what analysts do daily. You receive the same spreadsheet setups used by the instructor, experiencing guided step-by-step modeling that feels like on-the-job training. The engaging teaching style and manually edited captions enhance learning accessibility.
