Rent 9780273708063 | Mastering Financial Modelling in Microsoft Excel : A Practitioner's Guide to Applied Corporate ...

Summary Table of Contents Author Biography

With every major choice we face we "run through the numbers" to guide our decision-making and legitimise the outcomes. Financial modelling helps managers to make more informed decisions and, crucially, win corporate commitment for those decisions. The ability to construct useful financial models with speed and accuracy is becoming a key skill for all executives to master. However, this is a skill few managers and businesses know how to develop. For the busy executive or finance officer, an Excel user-manual is no place to start - today's financ... MORE

Introduction - who needs this book?
Preface to the second edition
Acknowledgements
Conventions
Executive summary
Developing Financial Models
Overview
Introduction
What is financial modelling?
History of spreadsheets
Power of spreadsheets
Objectives ... MOREfor the book
Example spreadsheet
Summary
Design introduction
Introduction
Basics of design
Objectives
User interface
Key variables and rules
Layout
Individual modules
Menu structure and macros
Management reporting
Future development
Testing
Protection
Documentation
Peer group comments
Summary
Features and techniques
Introduction
Formats
Number format
Lines and borders
Colours and patterns
Specific colours for inputs and results
Data validation
Controls - combo boxes and buttons
Conditional formatting
Use of functions and types of function
Add-ins for more functions
Text and updated labels
Record a version number, author, etc.
Use names to make formulas easier to understand
Paste names as part of documentation
Comment cells
Graphics
Dynamic graphs to plot individual series
Data tables
Scenarios
Goal seek
Solver
Use of templates
Summary
Sample model
Introduction
Aims and objectives
User needs and user interface
Key variables and rules
Breaking down the calculations into manageable groups
Setting up individual modules
Menu structure
Program sheets and macros
User assistance
Summaries
Risk and multiple answers
Testing and troubleshooting
Protecting and securing
Help and documentation
Show to peers - take their advice
Control loop - listen, learn and modify
Summary
Example model
Introduction
Case study
Design
PPP 1
PPP 2
PPP 3
PPP 4
PPP 5
Documenting, testing and protecting
PPP 6
Summary
Applications
Analysing performance
Introduction
Profit and loss
Balance sheet
Ratios
Trend analysis
Sustainability
Summary
Cash flow
Deriving cash flow
Net operating cash flow (NOCF)
Free cash flow
Cover ratios
International cash flow
Summary
Forecasting models
Introduction
Historic forecasts
Trend lines
Trend lines for analysis
Data smoothing
Cyclicality and seasonality
Summary
Forecasting financials
Introduction
Key drivers
Deriving financial statements
Alternative approaches
Financial analysis
Summary
Variance analysis
Introduction
Cash flow budgets
Monthly cash model'Flash' report and graphics
Summary
Breakeven analysis
Introduction
Breakeven
Operating leverage
Financial leverage
Combined leverage
Summary
Portfolio analysis
Introduction
Formulas
Optimum portfolio
Cost of capital
Introduction
Capital Asset Pricing Model
Dividend growth model
Cost of preference shares
Cost of debt
Weighted average cost of capital
Table of Contents provided by Publisher. All Rights Reserved.

Alastair Day has worked in the finance industry for 20 years in treasury and marketing functions. He is an associate lecturer in corporate finance with the OUBS, and other publications include books such as The Financial Director?s Guide to Purchasing Leasing.

RENT TEXTBOOKS

Mastering Financial Modelling in Microsoft Excel : A Practitioner's Guide to Applied Corporate ...

Why Rent from Knetbooks?

Top 5 reasons to order all your textbooks from Knetbooks:

Related Products