Search the site search Search

Courses > Financial Modeling > Fully Integrated Financial Statement Forecasts > Building A Fully Integrated Financial Statement Forecast

Building a Fully Integrated Financial Statement Forecast
1 dayClassroomIntermediate


In this program we build a fully integrated financial statement forecast using a real case company.
Starting with a blank excel spreadsheet, participants learn how to set up a template efficiently, including setting up styles to deal with formatting issues effectively. We import the historicals into the Excel spreadsheet and "clean them up" appropriately. The next step is to understand the relationships within the financials and use these relationships to build assumptions about the future. Once this is done, we can build the forecast financial statement projections.

  • Setting up the template so that matrix integrity is preserved
  • Using Styles in excel to control formatting
  • Creating a template of styles so that this can be used again and again
  • Analyzing a company’s financial statements, management discussion and analysis and notes
  • Checking and "cleaning" historicals
  • Importing data efficiently from a PDF document
  • Documentation techniques to show other users what has been done
  • Integrity checking the historical cleaning process
  • Building the forecast assumptions
  • The trade off between detail and time constraints
  • Making the model user friendly
  • Building formulas effectively
  • Leaving audit trail
  • Getting the cash flow to work first time
  • More error diagnostics
  • Controlling your circularities

You can call Matchett on +44 (0)1295 256161 to book a course or simply discuss your training needs OR email us:

Personal information
*
*
*
*
*
*
 
*
*



submit the form

Related Courses

Go from a blank worksheet to a financial model in one day

Pre-requisites

A sound knowledge of financial statement analysis and the ability to build a financial statement forecast.
Prior attendance on Introduction to financial modeling is advised. Participants should be at the level achieved by attendance of Modeling a Real Company.

Delegate Profile

Anyone who needs to build a financial statement forecast from scratch.