Table of Content
 

 

Week 1

  • Creating A Layout For Integrated Model
  • Excel Shortcuts - I
  • Excel Shortcuts - II
  • EMI Basic Case
  • Custom Formatting In Excel
  • Referencing Framework In Excel

Week 2

  • Company overview 1
  • Company overview 2
  • Company overview 3
  • Company overview 4
  • Stage-1 1
  • Stage-1 2
  • Stage-1 3
  • Stage-1 4

Week 3

  • Assumptions 1
  • Assumptions 2
  • Assumptions 3
  • Assumptions 4
  • Assumptions 5

Week 4

  • Production 1
  • Production 2
  • Production 2A
  • Production 2B
  • Production 2C
  • Production 2D
  • Production 2E
  • Production 2F
  • Production 3
  • Production 3A
  • Production 4
  • Production 5

Week 5

  • CAPEX and DDA 1
  • CAPEX and DDA 2
  • CAPEX and DDA 3
  • CAPEX and DDA 4
  • CAPEX and DDA 5
  • CAPEX and DDA 6
  • CAPEX and DDA 7

Week 6

  • E and P 0
  • E and P 1
  • E and P 2
  • E and P 3
  • E and P 4
  • E and P 5
  • E and P 6
  • E and P 7
  • E and P 8
  • E and P 9
  • E and P 10
  • Reserves Data 1
  • Reserves Data 2

Week 7

  • R and M 1
  • R and M 2
  • R and M 3
  • R and M 4
  • R and M 5
  • R and M 6
  • R and M 7

Week 8

  • Balance Sheet 1
  • Cash flow 1
  • Cash flow 2
  • P and L 1
  • P and L 2
  • P and L 3
  • P and L 4

Week 9

  • COC Valuation
  • PE Analysis 1
  • PE Analysis 2
  • Quarterly 1
  • Quarterly 2
  • WACC

Week 10

  • CVX performance relative to SPX and WTI
  • M and A-1
  • M and A-2
  • Relative Valuation 1
  • Relative Valuation 2
  • Relative Valuation 3
  • Sensitivity Analysis 1
  • Sensitivity Analysis 2

 

Apply for certification

https://www.vskills.in/certification/accounting-banking-and-finance/Financial-Modeling-for-Equity-Researcher