Financial Modeling & Valuation in Excel

A hands-on programme in Excel for finance staff and accountants who need to build models that others can trust. You build a linked three-statement model from assumptions to income statement, balance sheet and cash flow, then use it for scenarios and sensitivities. The valuation part covers discounted cash flow, the discount rate, terminal value, and market multiples, with the judgement calls each method requires. Throughout, the focus is on model structure, checks and presentation, so the model survives review by management, banks and investors.

What you will learn

• Structure a model: inputs, calculations and outputs kept apart
• Link the income statement, balance sheet and cash flow
• Build scenarios and sensitivity tables
• Value a business with discounted cash flow and market multiples
• Add checks and present the model for review