Online Financial Modelling, Budgeting and Forecasting Course
Online Financial Modelling, Budgeting and Forecasting Course
An online financial modelling, budgeting and forecasting training course that covers all the key aspects of building financial models in Excel.
Learn Spreadsheet best practice, Budget and Forecast template design and Financial Model time value of money calculations.
- Time Req – 16 hrs
- Skill Level >6
- FAQ
- All Online Courses
- Live Course Options
- Ask a Question
Request info on Online Courses (T&C’s, discounts etc)
Modules
Spreadsheet Best Practice
Lessons
- Why should you follow best practice guidelines for financial models Free Preview
- Consistency – no hard coding numbers in excel Free Preview
- Consistency of Row and Column structures Free Preview
- Consistency of Formula across rows/ columns Free Preview
- Consistently using inbuilt Excel Formulas Free Preview
- Consistently use simple Excel formulas (even if you need to use more cells) Free Preview
- Consistently use the same formats and units throughout Free Preview
- Consistently display negative numbers clearly Free Preview
- Consistency of headers and flags Free Preview
- Separating the inputs, calculations and outputs Free Preview
- Separation- Dealing with the inputs of a Financial Model Free Preview
- Separation- Dealing with the Calculations of a Financial Model Free Preview
- Separation- Dealing with the Reports of a Financial Model Free Preview
- Spreadsheet Integrity Free Preview
Other Spreadsheet Best Practice Suggestions
Lessons
Excel related tips and tricks for Financial Modelling
Lessons
- Viewing many parts of the spreadsheet (at the same time)
- Doing Quick Calculations in a Financial Model
- Where should you start building your formula?
- Which cell should you check if there is an error?
- How to build nested formula in Excel
- Determining which Excel function to use
- The flow of a financial model
- Data Validation Free Preview
Financial Modelling Essential Knowledge
Lessons
Headers for Financial Models
Lessons
Aggregation
Lessons
Dates in Financial Models
Lessons
OFFSET in Financial Models
Lessons
Working Capital in a Financial Model
Lessons
Summary Example up to this point
Lesson
Some more Financial Modelling Tips and Tricks
Lessons
- Change many sheets at the same time Free Preview
- Protecting specific cells in Financial Models
- Handling Error Messages- IFERROR, ISERROR and AGGREGATE
- Show numbers in millions or with kg in the number
- Include a mini graph in a cell for trends
- Easily convert months into years, quarters or anything else
VLOOKUP in Financial Models
Lessons
Summary example to this point
Lesson
Comparing Budgets and Forecasts to Actuals
Lessons
- Best way to compare actuals with your budgets/ forecasts
- Conditional Formatting
- EXERCISES: Conditional Formatting
- CHOOSE function
- EXERCISE: Budget vs Actual vs Forecast Example 1
- Waterfall Chart
- EXERCISE: Budget vs Actual vs Forecast Example 2
- Variance Calculation
- EXERCISE: Budget vs Actual vs Forecast Example 3
Running What Ifs
Lessons
- Adding a last minute Sensitivity Free Preview
- Multiply inconsistent cells with a sensitivity percentage Free Preview
- Watching what happens to results when you change inputs Free Preview
- Goal seeking a solution in Excel Free Preview
- EXERCISES: Goal seeking a solution in Excel Free Preview
- Single Variable Data Table in Excel
- Two Variable Data Table in Excel
- EXERCISES: Data Table in Excel
- Excel Scenario Manager
- EXERCISES: Excel Scenario Manager
- Load Solver Add In Free Preview
- Goal Seek Multiple Cells (Solver)
Depreciation
Lessons
Time Value of Money- Debt, NPV, IRR
Lessons
- Nominal vs Effective Rates
- Debt Functions in Excel- Same as your Financial Calculator
- Calculate the Interest vs Capital portion of debt repayment
- Allow for Ad hoc Withdrawals and Prepayments
- Allow for changes in Interest rates
- EXERCISES: Debt
- NPV and IRR
- Excel NPV functions
- Excel IRR functions
- Multiple Discount rates in NPV?
- Terminal Cash Flow Discounting
- Compound Annual Growth Rates (CAGR) in Excel
- EXERCISES: NPV, IRR and Debt Examples
