Identifier: 75376004

Duration:

Subscription Period: 365 Days

Language: English

Cost: SGD 50.00

 

Action

Add To Cart

Overview

This recorded webinar will show you a practical approach to designing scalable, flexible and reusable forecasting models.

During the webinar, you will create a complete forecasting model in Excel using the Excel templates provided.

Key topics:

  • The theory behind financial modelling
  • Build of a sensitivity page which will hold all model assumptions
  • The creation of an asset depreciation schedule
  • Creation of the Income Statement associated 5 year forecast
  • The development of a robust calculations page which will be used to feed a summary sheet

Objectives

  • Building assumptions to generate what if scenarios.
  • Generating a predictive P&L template in a format which can be easily consolidated.
  • The model will be interactive to allow for what if analysis during budget presentation meetings.
  • Work through the detailed tasks accompanying the webinar to test your knowledge

Audience

Professionals working in SME or Corporate entities in specialist or analyst and mid-level career roles in job functions such as external reporting, financial control and management accounting.

loading...