Loading... Please wait...

Currency Converter

Choose a currency below to display product prices in the selected currency.

United Kingdom Default Currency
European Union Euros
United States US Dollars

Add to Wish List

Click the button below to add the Mastering Financial Modelling Files to your wish list.

You Recently Viewed...

Our Newsletter


Mastering Financial Modelling Files

Price:
£250.00
SKU:
MFM500
Brand:
SFL
Weight:
0.00 LBS
Shipping:
Free Shipping
Quantity:
Bookmark and Share


Product Description

Mastering Financial Modelling Files

These files are in the same order as the chapters in Mastering Financial Modelling and are unprotected and complete for further development.

Part A - Model Design

 
     

1

Overview

What is financial modelling?

   

History of spreadsheets

   

Objectives of the book - good design method and templates for further use

     

2

Design Introduction

Follow design process and method for all models

   

Set aims and objectives

   

Examine user needs and required user interface

   

Set out key variables and rules

3

Design features

 

4

Sample Model Planning

 
   

Set aims and objectives

     
     
   

Key variables and rules - Flowchart / mind map / information flow

   

Break down the calculations into manageable groups

   

Setting up individual modules

     
   

Menu structure

     
   

Program sheets and macros

   

User assistance

   

Management reports and summaries

   

Risk and multiple answers

   

Testing and trouble shooting

   

Protecting and securing

   

Help and documentation

   

Show to peers - take their advice

   

Control loop - listen, learn and modify

     

5

Example Model

Case design layout

   

Calculation

   

Formatting, functions, comments, validation and printing

   

Menus, combo boxes, macros and buttons

   

Scenarios, data tables and risk

   

Documentation, testing and protecting

   

User comment and areas for improvement

     

Part B - Applications

 
     

6

Analysing Performance

Profit and loss

   

Balance sheet

   

Key ratios - Du Pont ratios (core ratios)

   

   Profitability

   

   Operating Cycle

   

   Leverage and capital structure

   

   Coverage on interest

   

Trend analysis

   

Sustainability

     

7

Cash Flow

Deriving cash flow - NOCF, free cash flow

   

Cover ratios

     

8

Forecasting Models

Linear regression

   

Trend lines

   

Trend lines for analysis

   

Data smoothing

   

Cyclicality and seasonality

 

 

 

9

Forecast financials

Key drivers

   

Deriving financial statements

   

Analysis

     

10

Variance Analysis

Budget variances

   

Cash flow budgets

   

Monthly cash model

   

Flash' report and graphics

     

11

Break-even Analysis

Break-even

   

Operating and financial leverage

 

 

 

12

Portfolio analysis

Determining risk and return

   

Expected portfolio return

     

13

Cost of Capital

Cost of Capital - CAPM, Growth Model, WACC

   

WACC step cost of capital model

     

14

Bonds

Pricing

   

Yield measures

   

Duration and modified duration

   

Convexity and sensitivity

   

Portfolio duration

     

15

Investment analysis

Investment model revisited

   

Payback and discounted payback

   

Net present value, IRR, Profitabiity Index

   

Management tests - cash flow etc.

   

Scenarios

   

Sensitivity analysis and graphs

   

Capital rationing

     

16

Risk

Risk assessment process and analysis

   

Risk adjusted rate

   

Variation

   

Standard deviation

   

Coefficient of variation

   

Certainty equivalents

   

Real options

   

Simulation

     

17

Depreciation

Straight-line

   

Sum of Digits

   

Declining Balance

   

US MACRS

     

18

Leasing

Rental calculations

   

Lease versus purchase

   

Classification

   

Accounting

   

Settlements

     

19

Company Valuation

Assets

   

Adjusted Assets

   

Gordon's Growth Model

   

Market-Based

   

Simple Free Cash

   

Methodology - leveraging betas etc.

   

Mergers and acquisitions

     

20

Optimisation

Linear programming

   

Profit maximisation

   

Pensions

     

21

Decision Trees

Proability concepts

   

Decision tree model

     

22

Risk Management

Forward rate agreements

   

SWAPS

   

Foreign Exchange

   

Futures

   

Options

   

Black Scholes

   

Currency options

     

23

Data Functions

Dataset import

   

Datbase functions

   

Descriptive statistics

   

Histograms

   

Function tamplate

   

Box plots

     

24

Data Analysis

Sort and order

   

Filter and subtotals

   

Pivot tables and charts

   

Radar and gauge charts


Write your own product review

Product Reviews

This product hasn't received any reviews yet. Be the first to review this product!