ALPHABET 5-Year Annual Financial Model
A balanced and detailed 5-year annual financial model (3-statement & DCF) of the publicly listed company ALPHABET.
A balanced and detailed 5-year annual financial model (3-statement & DCF) of the publicly listed company ALPHABET.
A balanced and detailed 5-year annual financial model (3-statement & DCF) of the publicly listed company ALPHABET.
The Model Includes: a Cover Sheet, an Income Statement, a Balance Sheet, a PPE Schedule, a Debt Schedule, a Projected Cashflow Statement, a DCF Sheet, a Ratios Sheet, a Supplementary Sheet, a Credit Spread Sheet, & a Historical Input Overview Sheet (11 total sheets).
The Models Are Used By:
Analysts to determine the fair value of the company
Teachers to teach students how to use a model or to have them practice stock pitches in groups (see www.autolyst.io for a suggested group project exercise for corporate finance/valuation classes)
Corporate Managers/Executives to analyze an industry or competition
Model Highlights:
Fully balanced model
Easy to understand and use, with designated input fields for the analyst
Standardized layout across all models by Autolyst
Note: The model does NOT include any suggested financial projections. The financial projections are made on a straight-line basis and/or are entirely arbitrary. The financial projections must be changed by the model user to properly determine the fair value of the company.