Financial Modeling

Only available on StudyMode
  • Download(s) : 41
  • Published : January 25, 2013
Open Document
Text Preview
Financial
Statements

Working
Capital
Operational

Taxation

Capital

Checks
Assets

Outputs

Financial Modelling Fundamentals

Financial Modelling
Fundamentals

FINANCIAL MODELLING FUNDAMENTALS TRAINING COURSE
This document is based on the Financial Modelling Fundamentals training course which is provided by BPM via www.bestpracticemodelling.com. All copyright in this document and any derivation of this document is owned by BPM Analytical Empowerment Pty Ltd.

Copyright © BPM Analytical Empowerment Pty Ltd and associated entities. This is a Best Practice Modelling publication. These standards are the subject of ongoing development with updates being made available at www.bestpracticemodelling.com and www.ssrb.org. To stay informed about updates and amendments to the standards, this commentary and examples book and other best practice modelling resources, join the Best Practice Modelling Network at www.bestpracticemodelling.com/network/overview).

SPREADSHEET STANDARDS REVIEW BOARD
The Spreadsheet Standards Review Board (‘SSRB’) is the body that develops and maintains the Best Practice Spreadsheet Modelling Standards. The SSRB was established by BPM Analytical Empowerment Pty Ltd during 2003 to bring together the best spreadsheet modelling skills from around the world in order to develop and gain general acceptance for comprehensive and universally applicable Best Practice Spreadsheet Modelling Standards. The SSRB can be contacted as follows: Address:

Telephone:
Email:
Website:

Spreadsheet Standards Review Board
Level 8, 330 Collins Street
Melbourne, Victoria 3000, Australia
+61 3 9244 9800
enquiries@ssrb.org
www.ssrb.org

BEST PRACTICE MODELLING (BPM)
Best Practice Modelling (BPM) is a business modelling organisation that specialises in the provision of best practice modelling resources including tools, training and consulting services. BPM is the founding member of the SSRB and remains committed to overseeing the ongoing maintenance, development and adoption of the Best Practice Spreadsheet Modelling Standards. BPM is also responsible for maintaining and updating this commentary and examples book. BPM can be contacted as follows: Address:

Telephone:
Email:
Website:

Best Practice Modelling
Level 8, 330 Collins Street
Melbourne, Victoria 3000, Australia
+61 3 9244 9800
info@bpmglobal.com
www.bestpracticemodelling.com

IMPORTANT NOTICES
Many of the examples provided throughout this commentary and examples book have been created within Microsoft Excel using bpmToolbox® – a best practice add-in available from Best Practice Modelling (www.bestpracticemodelling.com). The SSRB is of the opinion that the use of bpmToolbox within Microsoft Excel is the most efficient and effective means of implementing the Best Practice Spreadsheet Modelling Standards. A free trial of bpmToolbox may be downloaded from the Best Practice Modelling website at www.bestpracticemodelling.com/software/bpmToolbox.

www.bestpracticemodelling.com

Financial Statements Modelling

Table of Contents
Chapter 1.

Introduction & Overview .................................................................... 3 1.1.

Overview ..................................................................................... 3 1.1.1.
1.1.2.

Financial Statements Modules Types .................................. 3

1.1.3.
1.2.

Financial Statements Module Area ..................................... 3

Financial Statements Module Location ................................ 4

Financial Statements Modelling Overview ........................................ 5 1.2.1.

Links Between The Financial Statements ............................ 6

1.2.2.

Financial Statement Impacts ............................................ 7

-

Income Statement & Balance Sheet Impact ................... 8

-

Income Statement & Cash Flow Statement Impact .......... 9

-

Balance Sheet & Cash Flow Statement Impact...
tracking img