Financial Modelling & Analysis with Microsoft Excel

---

Course Content

1. Introduction to Financial Modelling
   • Understanding financial models and their business uses
   • Financial modelling vs financial analysis
   • Understanding inputs, calculations and outputs
   • Structuring a clear and maintainable Excel model
   • Separating assumptions from calculations
   • Using consistent formatting and model conventions
   • Understanding model integrity and transparency
   • Building models that can be reviewed and updated easily
2. Financial Calculations & Time Value of Money
   • Understanding present value and future value
   • Simple and compound interest
   • Discounting future cash flows
   • Understanding discount rates
   • Using PV() and FV()
   • Understanding periodic cash flows
   • Using PMT() for loan and payment calculations
   • Building simple time-value-of-money models
3. Building Financial Forecasts
   • Setting up financial assumptions
   • Forecasting revenue
   • Forecasting operating costs
   • Fixed vs variable costs
   • Using growth rates and business drivers
   • Creating monthly and annual forecasts
   • Working with percentages and margins
   • Creating linked assumptions and forecast schedules
   • Understanding forecast uncertainty
4. Profit, Cash Flow & Financial Performance
   • Revenue, costs and profit
   • Gross profit and operating profit
   • Understanding cash flow vs profit
   • Creating a simple cash-flow forecast
   • Operating, investing and financing cash flows
   • Understanding working capital at a practical level
   • Calculating margins and growth rates
   • Creating financial KPIs
   • Comparing actuals, budget and forecast values
5. Investment Appraisal & Discounted Cash Flow
   • Understanding investment appraisal
   • Discounted Cash Flow (DCF)
   • Understanding Net Present Value (NPV)
   • Using NPV() and XNPV()
   • Understanding Internal Rate of Return (IRR)
   • Using IRR() and XIRR()
   • Calculating payback period
   • Comparing alternative investment projects
   • Interpreting investment appraisal results
6. Scenario & What-If Analysis
   • Understanding financial uncertainty
   • Creating Base, Best and Worst Case scenarios
   • Changing assumptions dynamically
   • Using Scenario Manager
   • Using Goal Seek
   • Using one-variable Data Tables
   • Using two-variable Data Tables
   • Evaluating the impact of changing revenue, costs and discount rates
   • Using scenarios to support business decisions
7. Sensitivity & Risk Analysis
   • Understanding sensitivity analysis
   • Identifying key financial model drivers
   • Testing changes in assumptions
   • Analysing changes in price, volume and cost
   • Testing different discount rates
   • Understanding break-even analysis
   • Creating simple sensitivity tables
   • Recognising model risks and limitations
8. Financial Analysis & Decision Support
   • Comparing actual and forecast performance
   • Variance analysis
   • Analysing revenue and cost drivers
   • Identifying trends and exceptions
   • Using financial ratios and KPIs
   • Evaluating alternative business decisions
   • Interpreting financial results rather than only calculating them
   • Turning financial analysis into management insights
9. Financial Reporting & Visualisation
   • Designing clear financial reports
   • Creating charts for revenue, costs and profit
   • Creating cash-flow visualisations
   • Displaying Actual vs Budget vs Forecast
   • Creating KPI summaries
   • Using conditional formatting to highlight performance
   • Designing a simple financial dashboard
   • Presenting financial information clearly to decision-makers
10. Practical Financial Modelling Project
    • Build a financial model from business assumptions
    • Create revenue and cost forecasts
    • Build a cash-flow forecast
    • Calculate profitability and financial KPIs
    • Perform DCF analysis
    • Calculate NPV and IRR
    • Create Base, Best and Worst Case scenarios
    • Perform sensitivity analysis
    • Create charts and a management summary
    • Present conclusions and recommendations

---

Course Dates, Prices & Enrolment

---

Price Calculator & Booking Request Form

Calculate prices for Corporate, 1-on-1 or group training and request a booking.

Do you have a special training requirement or unable to find any suitable training date? Please complete and submit the booking request form, if you want to:

The price person is less when you book a course for more people. You can find the price per person and the total cost by changing the values of the training hours and the number of people below: