Menu

DCF using a Three Statement Financial Model

Developed a three statement model of Alphabet's operations to determine enterprise and equity value using both FCFF and FCFE. Explored sensitivity tables, WACC determination, amortization/revolvers and built a model which determined metrics based on either broker or independently determined forecasts for financial items. DCF using a Three Statement Financial Model - image 1 - student projectDCF using a Three Statement Financial Model - image 2 - student project