Categories

Our Workshops

Financial Modelling With Excel

Microsoft Office Suite

Financial Modelling With Excel

Description

 

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:

 

Scenarios

 

Goal Seek

 

Solver

 

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