Click here to send this to a colleague or friend.

Financial Modelling with Excel

Build a successful financial & business strategy

Successful managers can look into the past and predict the future

Financial decision-making inherently requires a plethora of data and lots of computation.

This exciting workshop offering will teach you how utlise MS Excel - the premier business computational tool - for this process, giving you the flexibility and know-how you need to quickly and efficiently change data elements - and immediately provide new answers.

Use Financial Modelling to create your own user-friendly financial models and translate business concepts into a structured format to identify weaknesses and predict future performance.

 shadow

Accreditation:

Front Foot Strategic Consulting has been awarded accreditation status as a provider of Education and Training in terms of the South African Qualification Authority Act.

All Front Foot Microsoft workshop presenters are Certified Master Microsoft Application Specialists.
shadow

shadow
Register now for this workshop

WHAT WILL BE COVERED ON THIS ONE-DAY WORKSHOP?Working with an Excel model worksheet, you will gain a clear understanding of:

The Excel Basics

  • 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
 shadow

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
shadow shadow

Who should attend?

  • Financial Modelling is for anyone that needs to forecast revenues and expenses, model changes in any of the business inputs and analyze business performance. 

    Good Excel skills are required.

Training approach

Our courses use interactive tools that allow learners to learn by doing.

The experience for learners is fun, rewarding, lasting and integrative, whilst employers are assured of a high return on investment in training.
Event Information:
Date: 8th February 2012 at Benvenuto Conference Centre in Randburg

6th March 2012 at Benvenuto Conference Centre in Randburg

9th May 2012 at Benvenuto Conference Centre in Randburg

10th July 2012 at Benvenuto Conference Centre in Randburg

11th September 2012 at Benvenuto Conference Centre in Randburg
Time: 08:30 AM
Venue: Benvenuto Conference Centre in Randburg
Map: View map
Duration: 1 Day
Cost: R2 350.00 excl VAT
R2 679.00 incl VAT
Surcharge: R50 (incl VAT) per delegate, per day for Strict Halaal and Kosher Meals

Upcoming Events:
Visit our events calendar for more information.

Upcoming Workshops:
Visit our workshops calendar for more information.
shadow
Discount:
Group Bookings:
Group Bookings of 2 or more delegates from the same company qualify for a 10% discount
shadow
Out-of-town Delegates:
If you attending from out-of-town, we will give you a 15% discount on the cost of the workshop.
Contact us to find out more
shadow

Bookings:

Contact Adele on
011 880 4808 or email for
Bookings and Enquiries
Website | Email
Screenshot: http://www.frontfoot.co.za
shadow
Microsoft workshop presenters are Certified Microsoft Office Specialists; We offer on-going email support after attending any Microsoft workshop for an unlimited period of time; Workbooks and workshops are aligned to the prevailing Unit Standard; Front Foot provide business training to business people; Training is held at premium training venues.
© Copyright Frontfoot & The Decision Makers Database 2011. All rights reserved.
Confidentiality Note: This message is for the sole use of the intended recipient(s) and may contain confidential and legally privileged information. Any unauthorised review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by replying and destroy all copies of the original message.