Financial Planning and Forecasting

Only available on StudyMode
  • Download(s) : 555
  • Published : August 24, 2010
Open Document
Text Preview
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 Statements Forecast .................................................................................. 2-5 2.4.1 Assumptions.................................................................................................. 2-5 2.5 Financial Ratio Analysis ............................................................................................. 2-5 2.5.1 Inputs ............................................................................................................ 2-6 2.5.2 Liquidity Ratios .............................................................................................. 2-6 2.5.3 Leverage Ratios ............................................................................................ 2-6 2.5.4 Profitability Ratios ......................................................................................... 2-6 2.5.5 Turnover Ratios............................................................................................. 2-6

2.

Pg ii Financial Planning and Forecasting Version 1.0

ConnectCode’s Financial Modeling Templates
Have you thought about how many times you use or reuse your financial models? Everyday, day after day, model after model and project after project. We definitely have. That is why we build all our financial templates to be reusable, customizable and easy to understand. We also test our templates with different scenarios vigorously, so that you know you can be assured of their accuracy and quality and that you can save significant amount of time by reusing them. We have also provided comprehensive documentation on the templates so that you do not need to guess or figure out how we implemented the models. All our template models are only in black and white color. We believe this is how a professional financial template should look like and also that this is the easiest way for you to understand and use the templates. All the input fields are marked with the ‘*’ symbol for you to identify them easily. Whether you...
tracking img