Financial Planning and Forecasting

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 are a financial analyst, investment banker or accounting personnel.

Or whether you are a student aspiring to join the finance world or an entrepreneur needing to understand finance, we hope that you will find this package useful as we have spent our best effort and a lot of time in developing them. ConnectCode Pg iii Financial Planning and Forecasting Version 1. 0 1. 1. 1 Financial Planning and Forecasting Pro Forma Financial Statements Financial statements projections and forecasting are very common in corporate financial analysis. The reason is that it is very useful and important to forecast how much financing a company will require in future years.

The projections are achieved by using historical sales, accounting data and assumptions on future sales and costs. These financial statements projections are known financial modeling as Pro Forma financial statements. 1. 2 Financial Statements Modeling This spreadsheet provides a template for financial statements forecasting. It requires simple financial statements inputs from the past 5 years and will automatically generate all the necessary Pro Forma Financial Statements projections outputs. The following diagram illustrates the process of using this template for financial statements forecasting.