Financial Modelling: Building a Model
Financial modelling is an invaluable skill for accountants but in the wrong hands, models can be confusing and misleading. This course will teach you to build robust financial models in Excel to forecast future performance, and to measure and respond to uncertainty and change.
SAVE 30% USING CODE ACPD30
This course will enable you to
- Set up financial models to forecast future performance and guide decision making.
- Model costs to help anticipate potential changes, make appropriate adjustments and remain profitable and competitive.
- Use financial models to estimate revenues, set targets and monitor progress.
- Build financial models that remain relevant over time, by factoring in inflation, indexation, interest and exchange rates.
- Present information in clear and accessible reports and visualisations, to inform decision making.
About the course
Financial modelling has become an invaluable part of finance and an indispensable skill for every accountant. But in the wrong hands, models can be confusing and misleading.
This practical course looks at the various inputs that must come together to enable you to create financial models to plan and prepare for the future. The step-by-step approach to building models, will give you the tools you need to make informed business decisions, protect against potential volatility, and deliver real value to your organisation.
Look inside
Contents
- Setting up a financial model
- Starting with the end user
- The importance of best practice
- The power of Excel
- Making the most of Excel
- Getting your Excel settings right
- What to include in a template
- Structuring your model
- Setting up the sheets: part one
- Costs
- Before you start
- Getting the right information
- Finding further information
- The importance of costs
- Modelling costs
- Revenues
- The importance of revenues
- Looking for growth
- Linear services revenue forecast: part one
- Linear services revenue forecast: part three
- Controls and checks
- Time periods, checks and balances
- The importance of time periods
- The benefits of modelling time
- Choosing the right periods
- Flags
- Checking your models
- Accounting for human error
- Keeping models up to date
- Cash balances
- Inflation, indexation and interest
- The importance of inflation and interest
- Car price inflation model: part two
- Indexation
- Interest rates
- Deposit options: part two
- Foreign exchange
- Historical rates
- Forex in Excel
- Reports and visualisations
- End users and you
- What the user wants
- Reporting to different stakeholders
- Presenting your data
- Bringing data to life
- Summary reports - gold price: part two
- Golden rules
How it works
Author
Reviews
| Recommended | ||||
Why not upgrade?Find the best way to complete your CPD | CourseNeed just a few unitshourshours? | Pick n MixAll you need for this year's CPD. | LicenceAll you need for this year and more. | TeamKeep your whole team up to date. |
|---|---|---|---|---|
| Access to this course | ||||
| Total CPD unitshourshours | 4 unitshourshours | 21 units20 hours21 hours | 800+ unitshourshours | 800+ unitshourshours |
| Access period | 120 days | 120 days | 12 months | 12+ 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 | Learn more | Learn more | ||
Why not upgrade?
Find the best way to complete your CPD
You might also like
Take a look at some of our bestselling courses
SAVE 30% USING CODE ACPD30