Financial Modelling for Budgeting and Forecasting in Excel

Description

Overview

In this course you will learn to build a financial model by working in Excel and how to perform sensitivity analysis in Excel. You will also learn the formulas, functions and types of financial analysis to be an Excel power user. By attending this course, you will be able to effectively prepare and build financial models.

Objectives

• Harness Excel's tools within a best practice framework

• Add flexibility to their models through the use of switches and flexible lookups

• Work efficiently with large data volumes

• Model debt effectively

• Approach modelling for tax, debt, pensions and disposals with confidence

• Build flexible charts and sensitivity analysis to aid the presentation of results

• Learn and apply Excel tools useful in financial forecasting

• Understand and design the layout of a flexible model

• Forecast financial statements of a public or private company

• Apply scenario analysis to the forecasted financial statements and prepare charts for data presentation