Spreadsheet: 64687d1265479350-waterfall_calculation-waterfall-forecasting-model1
Sheet: Overview

 | <Company Name>
 | Waterfall Forecasting Model Overview
 | <Date>
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total | % of Plan
 | Plan Targets | Plan | Plan | Plan | Plan | Plan | Plan | Plan | Plan | Plan | Plan | Plan | Plan | Plan: Full Year | %
 | Jan | Actual | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast* | %
 | Feb | Actual | Actual | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast* | %
 | Mar | Actual | Actual | Actual | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast* | %
 | Apr | Actual | Actual | Actual | Actual | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast* | %
 | May | Actual | Actual | Actual | Actual | Actual | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast* | %
 | Jun | Actual | Actual | Actual | Actual | Actual | Actual | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast* | %
 | Jul | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast* | %
 | Aug | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Forecast | Forecast | Forecast | Forecast | Forecast* | %
 | Sep | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Forecast | Forecast | Forecast | Forecast* | %
 | Oct | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Forecast | Forecast | Forecast* | %
 | Nov | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Forecast | Forecast* | %
 | Dec | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual: Full Year | %
 |  | Actual | 100 |  |  |  |  |  |  | *Sum of month-to-date actuals and forecast numbers through year-end.
 |  | Forecast | 500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total | % of Plan
 | Plan Targets | Plan | Plan | Plan | Plan | Plan | Plan | Plan | Plan | Plan | Plan | Plan | Plan | Plan: Full Year | %
 | Jan | 100 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | Forecast* | %
 | Feb | 100 | 100 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | Forecast* | %
 | Mar | 100 | 100 | 100 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | Forecast* | %
 | Apr | 100 | 100 | 100 | 100 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | Forecast* | %
 | May | 100 | 100 | 100 | 100 | 100 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | Forecast* | %
 | Jun | 100 | 100 | 100 | 100 | 100 | 100 | 500 | 500 | 500 | 500 | 500 | 500 | Forecast* | %
 | Jul | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 500 | 500 | 500 | 500 | 500 | Forecast* | %
 | Aug | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 500 | 500 | 500 | 500 | Forecast* | %
 | Sep | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 500 | 500 | 500 | Forecast* | %
 | Oct | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 500 | 500 | Forecast* | %
 | Nov | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 500 | Forecast* | %
 | Dec | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | Actual: Full Year | %
 |  | Actuals |  | Need to calculate this based some formulae in excel
 |  | Forecast |  | Need to calculate this based some formulae in excel |  |  |  |  |  |  |  |  |  | 7800
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 39000