Our Workshops

Financial Modelling With Excel

Financial Modelling With Excel



1-Day Workshop

Our Microsoft workshop presenters are Microsoft Certified Trainers as well as Microsoft Certified Technology Specialists

Successful managers can look into the past and predict the future!

The study of financial decision making is inherently a topic requiring lots of computation. On this workshop the computation is done in, and illustrated with Excel, the premier business computational tool. This powerful combination gives you the flexibility and know-how to change the elements of an example and immediately get a new answer.
Practical learning session with templates and exercises
Although this is not an “Excel Course”, your knowledge of both financial issues and Excel will be enhanced, particularly as you will be supplied with prepared Excel models for the exercises, enabling you to concentrate on the logic behind the models.

Working with an Excel model worksheet, you will gain a clear understanding of:




Goal Seek




Conditional Formatting


LOGIC and LOOKUP statements


Calculating Compound Growth Rates


Sensitivity Analysis with the Sense-It Add In

The Structure of the Model


Drawing Data into the Balance sheet, Income Statement and Cash flow statement


Maintaining balance with EXACT


Using Excel to determine the sales and cost drivers in a business


Calculating the Growth Rate you need with Goal Seek


Setting up the ratios for analysis



The four key ratios



The subsidiary ratios



Profitability ratios



Asset utilisation ratios



Financial leverage



Return on Invested Capital



Sustainable growth


Testing the sensitivity of the profit figure to changes in the budget components


Simulate the possible outcomes

Budgeting for Revenues and Expenses
Budgets are often “the same as last year, but a bit better.” Now, discover how to produce budgets which are not merely an extrapolation of the past, but are based on scientific methods.


Using Excel to analyse the historical sales trend


Different methods of forecasting the future

Budgeting for Capital Expenditure
Discover how to assess capital expenditure proposals. Become familiar with the strengths and weaknesses of the various methods used


The Payback method


Net Present Value


Discounted Payback


Internal Rate of Return


Modified Internal Rate of Return


How to determine the Required Rate of Return

Workshop Outline

Excel Data Analysis        

  • Apply Conditional Formatting    
  • Add Data Validation Criteria       
  • Locate Invalid Data         
  • Set up Scenarios              
  • Perform What-If Analysis with Goal Seek             
  • Perform What-If Analysis with Solver
  • Perform Statistical Analysis with the Analysis ToolPak
  • The IF Function
  • Lookup Functions
  • PMT      
  • FV          

Formula Auditing           

  • Trace Cell Precedents   
  • Trace Cell Dependents 
  • Locate Errors in Formulas            
  • Add a Watch     
  • Evaluate Formulas          

Financial Ratios               

  • Profitability Ratios          
  • Debt Ratios        
  • Liquidity Ratios 
  • Activity Ratios   

Sensitivity Analysis with SensIt               

  • How to Install SensIt      
  • How to Uninstall or Delete SensIt            
  • Overview           
  • Using SensIT

Budgeting and Trends  

  • The Linear Trend Model               
  • The Quadratic Trend Model       
  • Modelling Seasonality with Regression Models 

Investment Appraisal Methods               

  • A checklist of key points              
  • Using Net Present Value             
  • NPV Short Cuts
  • Setting criteria for any investment appraisal technique 
  • Ranking projects under capital constraints           
  • What discount rate should we use?        

Financial Model Guidelines      

Documenting the model                  


On-Site Workshops

  • All workshops are offered in-house at your offices to a minimum of 5 delegates
  • You provide the venue and refreshments, Front Foot supply all the workshop material – including laptops for computer-based training sessions

 Remote Workshops

  • All workshops are offered remotely to a minimum of 5 delegates
  • Front Foot supply all the electronic workshop material


Workshop Dates