Financial Planning and Forecasting
Financial Modeling Templates
Financial Forecasting (Pro Forma Financial Statements) http://spreadsheetml.com/finance/financialplanningforecasting_proformafinancialstatements.shtml Copyright (c) 2009, ConnectCode All Rights Reserved. ConnectCode accepts no responsibility for any adverse affect that may result from undertaking our training. Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. All other product names are trademarks, registered trademarks, or service marks of their respective owners
Table of Contents
1. Financial Planning and Forecasting ................................................................................... 1-1 1.1 Pro Forma Financial Statements ............................................................................... 1-1 1.2 Financial Statements Modeling .................................................................................. 1-1 Financial Planning and Forecasting Spreadsheet ............................................................. 2-2 2.1 Financial Statements Inputs ....................................................................................... 2-2 2.1.1 Income Statement ......................................................................................... 2-2 2.1.2 Balance Sheet ............................................................................................... 2-3 2.2 Common Size Financial Statements .......................................................................... 2-4 2.2.1 Fields from the Income Statement ................................................................ 2-4 2.2.2 Fields from the Balance Sheet ...................................................................... 2-4 2.2.3 Average ......................................................................................................... 2-5 2.3 Analysis Findings ....................................................................................................... 2-5 2.4
Financial Forecasting (Pro Forma Financial Statements) http://spreadsheetml.com/finance/financialplanningforecasting_proformafinancialstatements.shtml Copyright (c) 2009, ConnectCode All Rights Reserved. ConnectCode accepts no responsibility for any adverse affect that may result from undertaking our training. Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. All other product names are trademarks, registered trademarks, or service marks of their respective owners
Table of Contents
1. Financial Planning and Forecasting ................................................................................... 1-1 1.1 Pro Forma Financial Statements ............................................................................... 1-1 1.2 Financial Statements Modeling .................................................................................. 1-1 Financial Planning and Forecasting Spreadsheet ............................................................. 2-2 2.1 Financial Statements Inputs ....................................................................................... 2-2 2.1.1 Income Statement ......................................................................................... 2-2 2.1.2 Balance Sheet ............................................................................................... 2-3 2.2 Common Size Financial Statements .......................................................................... 2-4 2.2.1 Fields from the Income Statement ................................................................ 2-4 2.2.2 Fields from the Balance Sheet ...................................................................... 2-4 2.2.3 Average ......................................................................................................... 2-5 2.3 Analysis Findings ....................................................................................................... 2-5 2.4