Some Excel Basics and the Basics of Design

• 10 essential Excel shortcuts
• Design principles
• Key elements of model structure
• Group edit tools

Building the Framework

• Set up the model structure
• Input vs formulae conventions
• Absolute vs relative references

Building the Schedules

• Using naming conventions
• Using ‘Corkscrews’ and ‘BASE’ calculations
• Using IF to create flexibility
• Operations schedule
• Fixed asset schedule

Building the Debt Schedule

• A simple approach to debt
• Using IF to solve more complex problems
• Using the Function Wizard

Balancing - Straight Away

• Integrating the financials and balancing the balance sheet as we go - a stepwise approach
• Building in a balance check
• A structured approach to model development

Cash Flows

• Linking cash from operations
• Linking fixed assets and financing
• Implementing some simple checking calculations

Tax and Valuation

• Modelling UK corporate tax in more detail
• Tax loss schedules
• Valuation and related functions
• Building the valuation module

Analysis and Presentation

• Dynamic labelling
• Excel's handy analytical tools - data tables
• Goal seek
• Print management