Excel Modeling

Key Page & Key Contents:

1. Input - Forecast Drivers

   

2. (OPT) Monthly - Forecasting from Historical & Forecast Drivers

   1. Pull the historical data from reported with the classification

   

3. Annual - Aggregate Monthly or Forecasting from Historical & Forecast Drivers

   1. (OPT) Aggregate data from Monthly

   

   b. (OPT) Pull the historical data from reported with the classification

4. DCF - Valuation from FCF 1.

   

5. LBO - Valuation the Deals from FCF 1.

   

6. Reported - Raw Financial Data & Classification 1.

   

7. Config - Type of Classification 1.

   

Advance Customization

1. Extend the forecast

   1. Drag the excel formula (Last Column) in Monthly

   2. Drag the excel formula (Last Column) in Annual

   3. Drag the excel formula (Last Column) in DCF

   4. Drag the excel formula (Last Column) in Visualization 1.

       [Screen Recording 2025-10-24 at 1.47.20 PM.mov](attachment:c8c22a79-69ed-44b9-ae74-34e0f3c852b1:Screen_Recording_2025-10-24_at_1.47.20_PM.mov)
      

2. Add line items

   1. Add new Taxonomy/Line Items/Row-up

      1. Add the new Taxonomy/Classification in Config

      2. Change Classification in Reported

      3. Add new Line Items in Monthly&Annual 1.

          [Screen Recording 2025-10-24 at 1.57.54 PM.mov](attachment:5c2569a8-3855-4244-9b3b-981a3ead6d58:Screen_Recording_2025-10-24_at_1.57.54_PM.mov)
         

3. Add Capital IQ for Beta Calculation

   1. In DCF, Link the Capital IQ in the Beta Calculation

   2. Link Beta to WACC Calculation 1.

      

4. Input for WACC Calculation

   1. Input Risk Free Rate

   2. Input Beta

   3. Customize the Equity

   4. Customize Market Value of Debt 1.

      

Supplementary

1. Color Code

   1. Black is calculated within the same sheet

   2. Green is pulled from other sheets 1.

      

   3. Blue is customized/ Hard-code 1.

      

2. Config (List of Taxonomy)