10-Year DCF Forecast Valuation for Large Public Company
Anh Nguyen
Financial Advisor
Financial Analyst
Business Analyst
Microsoft Excel
Python
▶️ My Role
I built the entire model from scratch.
▶️ Project Description
Project begins with 8 years of audited financial statement.
It is a large public company with 4 Revenue Streams operating in multiple industries including retails commercial, real estate, energy and water distribution.
The company firstly requires deep operating analysis.
▶️ Project Outcome
The end Result came out spectacularly with Company Valuation from multiple angles including FCFE, FCFF Valuation, PE Multiple Reference and more.