Building a fully integrated financial statement forecast intermediate

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