Corporate Financial Modelling: Building Forecasts and Cash Flows

by Alastair Day

Using a real life Excel example, this course takes you through a process where you can learn how to develop forecasts and perform financial analysis. It leads you through a series of steps required to create your own model.

price £75+vat
cpd hours 4 CPD hours
access 120 days' access

This course will enable you to

  • Understand the different forecasting methods available to you in Excel and apply them to your own data
  • Use ratio analysis to produce a forecast
  • Generate expectations of future performance and provide forecasted statements and cash flows
  • Create a flexible model which can be used to review different scenarios, and where inputs can be quickly changed, and results quickly accessed

About the course

Financial modelling is key to every business. Financial models can inform budgeting, forecasting, investment analysis, cash flows, loan sizing, valuation – the list is endless. If your financial models aren't right, your business is going to make bad decisions.

Using a real life Excel example, this course takes you through a process where you can learn how to develop forecasts and perform financial analysis. It leads you through a series of steps required to create your own model.

Corporate Financial Modelling: Building Forecasts and Cash Flows is the second CPD course in a three-part series. Starting with, Corporate Financial Modelling: Setting up Financial Models, which set out a methodology for building models in Excel. This course helps you take a simple historic spreadsheet model and develop it by adding a financial forecast and using other forecasting techniques.

Look inside

imac
slide-1
slide-2
slide-3
slide-4
slide-5
slide-1-thumbnail
slide-2-thumbnail
slide-3-thumbnail
slide-4-thumbnail
slide-5-thumbnail

Contents

  • Forecasting
    • What are the forecasting basics?
    • What causes forecasting errors?
    • What types of charts should we use?
    • How do we review forecasts?
    • How can we appraise accuracy?
    • How do we analyse data in Excel?
  • Forecasting methods
    • How can we identify patterns?
    • What is the simple percentage plus method?
    • How do we use compound annual growth rate?
    • How are trends useful?
    • What is smoothing?
    • How do we look at seasons?
    • How do we use regression?
    • What is the inflation problem?
  • Ratios
    • What factors can affect cash flow?
    • What are the core ratios?
    • What are the profitability ratios?
    • What ratios measure operating efficiency?
    • What ratios can help with financial structure?
    • Is growth sustainable?
    • What are the market ratios?
    • What error functions and units should be considered?
    • What checks are required?
  • Forecast drivers
    • What assumptions can we make?
    • How do we generate the income statement?
    • How are balance sheet assets generated?
    • What about balance sheet liabilities?
    • Why are the workings sheets important?
    • How do we deal with divisions?
  • Accounting statements
    • What is the structure of the balance sheet?
    • How do we model the income statement?
    • How do we model the balance sheet?
    • What are the mechanics of cash flow?
    • What are the cash flow ratios?
    • How can we avoid common mistakes?
    • How should we deal with iteration?
    • What further checks are needed?

Author

Alastair Day

Alastair has worked in the finance industry for more than thirty years and has extensive experience of financial modelling, finance and leasing.

Reviews

Recommended

Why not upgrade?

Find the best way to complete your CPD

Course

Need just a few unitshourshours?

Pick n Mix

All you need for this year's CPD.

Licence

All you need for this year and more.

Team

Keep your whole team up to date.

Access to this course
Total CPD unitshourshours4 unitshourshours21 units20 hours21 hours800+ unitshourshours800+ unitshourshours
Access period120 days120 days12 months12+ months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team’s needs
Learn moreLearn moreLearn more
Recommended

Why not upgrade?

Find the best way to complete your CPD

Licence

All you need for this year and more.

Access to this course
Total CPD unitshourshours800+ unitshourshours
Access period12 months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Why not upgrade?

Find the best way to complete your CPD

Course

Need just a few unitshourshours?

Access to this course
Total CPD unitshourshours4 unitshourshours
Access period120 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs

Why not upgrade?

Find the best way to complete your CPD

Pick n Mix

All you need for this year's CPD.

Access to this course
Total CPD unitshourshours21 units20 hours21 hours
Access period120 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Why not upgrade?

Find the best way to complete your CPD

Team

Keep your whole team up to date.

Access to this course
Total CPD unitshourshours800+ unitshourshours
Access period12+ months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Why not upgrade?

Find the best way to complete your CPD

Licence

Recommended

All you need for this year and more.

Access to this course
Total CPD unitshourshours800+ unitshourshours
Access period12 months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Course

Need just a few unitshourshours?

Access to this course
Total CPD unitshourshours4 unitshourshours
Access period120 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs

Pick n Mix

All you need for this year's CPD.

Access to this course
Total CPD unitshourshours21 units20 hours21 hours
Access period120 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Team

Keep your whole team up to date.

Access to this course
Total CPD unitshourshours800+ unitshourshours
Access period12+ months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

You might also like

Take a look at some of our bestselling courses