13 Week Cash Flow – Help Center

Model Overview

The 13 Week Cash Flow Model projects short-term cashflows of a company over a 13-week horizon.

Key factors driving cash increase/decrease

Weekly cash flow trends

Forecast based on last 6 week actual average

The model is best used for projecting short-term cash flow and balance of companies under distressed situation or for short-term liquidity management.

Overall Structure of 13 Week Cash Flow Model

Input pages are displayed in the same structure, from left to right are: Accounts → Weekly Actual financials → Weekly Forecasted Financials

Some financials are hidden by default, click “+” on the top to reveal.

Input/adjustable cells are displayed in blue font with a blue background.

Main Features

Analysis section

Summary

Shows weekly cash flow trends and forecast charts.

Variance Analysis

Shows the key accounts that drives cash increase/decrease.

Input section

Cash Forecast

Detailed historical 6 week cash flow breakdown.

Forecast by default uses last 6 week average.

Adjustment of model

Select the latest actual end date as the starting point.

Toggle between the drop-down to switch to Manual Input forecast.

If selected “Manual Input”, enter your own forecast figures for each line item in the Blue Cells at the right most side of the tab.

Last Week Forecast

By default using historical average, can be replaced by manually paste your last week’s forecasted data into the Blue Cells for more accurate comparison.