Corporate Financial Modelling: Setting up Financial Models

by Alastair Day

This course provides an introduction to applied financial modelling and shows you how to design, develop and build corporate financial models. It demonstrates the benefits of solid model planning and design, and how to build models in accordance with international best practice.

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

This course will enable you to

  • Establish the ground rules for building a spreadsheet model, including guiding principles and the core elements
  • Build a model including input data, intermediate calculation and output data
  • Put together an executive summary of your model along with any appendices necessary
  • Use a range of different techniques to assess the impact of potential changes in inputs or variables

About the course

Financial modelling is essential to any business. You may need to build models for financial analysis, loan sizing, debt restructuring, valuation – the list is endless. Even though financial models are an integral part of business, many models fail due to a lack of planning and poor structure.

This course provides an introduction to applied financial modelling and shows you how to design, develop and build corporate financial models. In particular, it demonstrates the benefits of solid model planning and design, and how to build models in accordance with international best practice.

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

  • Modelling and model planning
    • What is a financial model?
    • What is a spreadsheet?
    • What are your outputs?
    • What are your standards?
    • What are your individual components?
    • What are the user requirements?
    • Why is it important to plan?
    • What can happen if you don't plan?
  • Model errors
    • Why is it important to check for errors?
    • How are errors made?
    • What are input errors?
    • What are calculation errors?
    • What are output errors?
    • How do you test for errors?
    • How do you test for inconsistencies?
  • Model templates
    • How do you set up a template?
    • How do you define a new style?
    • How do you create a custom format?
    • How do you set up data validation?
    • How do you name cells and ranges?
    • What are the advantages and disadvantages of named cells?
    • How do you input notes?
    • How do you set up a timeline?
    • How do you use masks?
    • How should you label sheets?
  • Excel shortcuts
    • Why use shortcut keys?
    • What function keys can you use?
    • What letters can you use?
    • What number shortcuts can you use?
    • Why use operators?
    • What do alternative keys do?
    • What about Apple shortcuts?
  • Entering data
    • What are the outputs of the case?
    • What are the individual components of the model?
    • Where can you find the necessary accounts information?
    • What does the income statement look like?
    • What does the balance sheet look like?
    • How do you use charts?
    • How do you use line numbers?

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 hours1,000+ unitshourshours1,000+ 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 unitshourshours1,000+ 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 unitshourshours1,000+ 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 unitshourshours1,000+ 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 unitshourshours1,000+ 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