Business Plan Modelling using Excel


Effective business planning is fundamental to success in business. This course shows how building the plan model is the first step in transforming ideas into tangible reality. It demonstrates how a well-organised plan shows if the concepts make sound business sense.

Venue details:  
Dublin, Professional Training, Unit 22 Westland Square, Pearse Street, Dublin
Start date & time:  
21 November 2019 09:30
End date & time:  
21 November 2019 17:00
Price: €468.75  (€375.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
CPD hours:  
Speaker details
First nameLast name
Damien O'Neill


Product type:  
CPD course
Information technology

Who should attend

This course is designed for accountants who have had limited involvement in business planning on Excel and require more competence in business planning techniques.Participants must have a good knowledge of Excel basics (including Excel functions such as IF, Choose, etc.). It will be assumed that participants understand the principle rules in working with Interactive Spreadsheets and have knowledge of or have attended the CAI CPD Intermediate Excel course and ideally the Advanced course.

Course overview

  • Modelling to incorporate future needs
  • Building the detailed working sheet and importing workings from subsidiary schedules
  • Dealing with capital expenditure and funding
  • Developing Profit & Loss, Balance Sheets and CashFlows and manipulating these with minimum level inputs
  • Sensitivity analyses, goal seeking and scenario setting
  • Preparing formula to relate accounting concepts in spreadsheets
  • Building checks and balances to ensure model integrity throughout workbooks

Key learning outcomes

By the end of this course, participants will be able to:

  • Maximise flexibility and business model dynamics while incorporating future needs.
  • Compete for support and resources with the aid of a convincing plan either internally or for their clients.

Speaker Bio

Professional Training is a group of experienced specialists providing focused training in IT and Management skills. Our trainers use a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation by our course participants. We have delivered a range of CPD programmes with Chartered Accountants Ireland since 1997. Website: