Financial Modeling Projects 

This project models Procter & Gamble (PG) using a fully integrated three-statement financial model in Excel. The model forecasts the company’s income statement, balance sheet, and cash flows, and links them together to drive a Discounted Cash Flow (DCF) valuation. The DCF is based on projected free cash flows, a terminal value, and assumptions around WACC and growth.

Key drivers—including revenue growth, margins, capital expenditures, and working capital—are controlled through a dedicated input sheet. The file also includes supporting schedules, a football field chart for valuation triangulation, and WACC sensitivity tables.

Tools Used:Excel (dynamic linking, NPV, data validation, circularity management)  

Key Skills: Financial Modeling, Equity Valuation, DCF, Forecasting, Scenario Analysis