Financial Modelling in Excel

Financial Modelling in Excel

Do you have a financial model for your business?

A highly empowering, self-paced series of videos specifically directed at SME business owners. The purpose of the series is to provide you with the skills and understanding you’ll need to develop a practical business finance model in Excel. Even a simple model can be very powerful and you don’t need an accounting degree to put one together. It’s self-paced so you can watch when you have time and revisit parts if you need to. The series is split into 5 parts and by the end, the series will provide you with a good basis to understand:

  • The basics of Excel
  • Simple Financial statements
  • How to build and maintain a financial model of your business
  • Attributing costs to products
  • Cash flow modelling
  • Predicting net profits

Introduction

The Introduction looks at the basic ideas behind using Excel to Financial Modelling

 

Part 1 – Excel Basics

Part 1 looks at the basics of Excel, from opening and saving a file to what a cell is, using formulas, and more. Even if you are a seasoned user you’ll know that there are many ways to do the same thing in Excel. If you’re already a confident excel user or simply can’t spend the time, you can skip to part 2.

 

Part 2 – What is a Business Model?

Part 2 steps through the fundamentals of what makes a business model. You’ll look at the basic terms of accounting (revenue, expenses, fixed and variable costs, etc) and put them into everyday language with some worked examples, and introduce a basic model.

 

Part 3 – Fact Finding

Part 3 delves into the process of sourcing information about your business. Where should you look for all the information you need? We’ll introduce the concept of a “data vault”, which is somewhere to store all the bits and pieces of information you’ll need to compile your model and make it specific to your business. Then we’ll look at how you link information in different formats (for example litres of milk to cups of coffee) and subsequently attribute costs to products

 

Part 4 – Cashflow

Part 4 is a brief look at cashflow modelling. Where is all your money going!?

Cash flow management records all the cash coming in and out of your business over a fixed period, which then allows you to make predictions about the future and track your performance against those predictions. You can get ready for lean times before they hit and more importantly, show when you’ll be flush!

 

Part 5 – Price Modelling

Linking the cost of production, overheads, pricing, and sales volume to revenues and predicting net profits. You can then use your model to look at the effects of changes to pricing, cost of ingredients and materials, labour, etc. It will give you the power to confidently deal with change.

 

Other Webinars & Events

Check out our Webinars & Events page for upcoming events that may be useful to you.

View here

About the Presenter

BEC Business Advisor Chris Mckee

BEC Business Advisor Chris Mckee

Chris McKee has a diverse background spanning operational, leadership and strategic roles across 25 years in the global corporate business and government arenas. He has a wealth of experience in technical manufacturing, product development, continuous process improvement and business management frameworks, including customer engagement, risk control and quality management. As comfortable and capable at leading cross functional teams on the shop floor as at the senior leadership table, he has a strong project management background and an applied, holistic understanding of driving growth through targeted strategic thinking. He is a highly motivated and sincere person who strives his best to develop practical solutions for his customers.

Specialities: Technical manufacturing & new product scale up, Continuous improvement & business excellence, Statistical process control & modelling, Quality & risk management, Strategy development, Brand development, Team leadership & coaching.

Enquiries

Chris McKee MBA
Business Advisor – BEC Business Advice
T: 0460 028 753
E: [email protected]

Thanks

Special thanks to Adam Bannister from Pyrus for recording these sessions.

Leave a Reply

Your email address will not be published. Required fields are marked *