Financial Modelling using Excel - Day 3

Importing data to work with

Reformat data to Excel friendly format

Enhancing Your Spreadsheets with a Little VBA

Use Historical Financial Statements to Calculate Free Cash Flow
• Ratio Analysis
• Transposing Data
• Check the Annual Compounded Rate
• Trend Analysis

Project Future Cash Flow

Valuation
• Discount Cash Flow to Present Value
• Terminal Value
• Enterprise Value

Sensitivity Analysis
• Using What-If Analysis

Goal Seek
• Using Goal Seek
• Applying Goal Seek

Data Tables
• Using Data Tables
• Creating a one-variable Data Table
• Creating a two-variable Data Table
• Speeding up calculations with Data Tables

Scenario Manager
• Using Scenario Manager
• Adding a Scenario
• Showing a Scenario
• Deleting a Scenario
• Editing an existing Scenario
• Summarising Scenarios

Solver
• Using Solver
• Installing Solver
• Applying Solver
• Changing a Constraint
• Deleting a Constraint

Using the Formula Auditing toolbar
• Tracing Precedents
• Removing Precedent Arrows
• Tracing Dependents
• Removing Dependent Arrows
• Adding a new comment
• Evaluating Formulas one step at a time

Using the Watch Window
• Adding a Watch to a cell
• Adding a Watch to all the cells with Formulas
• Displaying a cell in the Watch Window
• Deleting a Watch
• Hiding the Watch Window

Protecting your work

Creating Reports

Print Areas