Daily Financial Liquidity Projection Excel Model

All Industries, Financial Model, General Excel Financial Models

Calculator, Cash Flow Projections, Cost Projections, Excel, Financial Analysis, Financial Model, Financing, Forecast, Forecasting

PURPOSE OF MODEL

User-friendly Excel model for the preparation of a 1-year daily cash flow forecast to manage / pre-empt liquidity requirements within a new or existing business.

The model allows the user to project cash flow movements and balances across 5 bank/cash operating accounts, individually or on a total basis, with functionality to model recurring receipts and payments, settlement of aged debtors and creditors, and receipts/payments from forecast purchases and sales in an automated manner.

The model follows best practice financial modeling principles and includes instructions, checks, and input validations.

KEY OUTPUTS

The model is generic and not industry-specific. The key outputs include:
– Projected cash flow breakdown of balances and movements presented on a daily and monthly basis.
– Dashboard which includes the following:
o Summarised projected cash flow movement and balances
o Chart showing net cash movement by month by category
o Line Graph showing cash balances on a total basis and by account

KEY INPUTS

Assumption Inputs include:
– Name of business
– Currency
– First projection date
– Bank / Cash account details including Name, Account number, latest balance, and minimum thresholds
– Public holidays
– Recurring receipt / payment details
– Debtor and creditor details including credit terms aged balances and forecast purchases and sales.

MODEL STRUCTURE

The model contains, 11 tabs split into input (‘i_’), calculation (‘c_’), output (‘o_’) and system tabs. The tabs to be populated by the user are the input tabs (‘i_Assumptions’). The calculation tab uses the user-defined inputs to calculate and produce the projection outputs which are presented in ‘o_Total CF’ and ‘o_Dashboard’

System tabs include:
– A ‘Front Sheet’ containing a disclaimer, instructions and contents;
– A Checks dashboard containing a summary of checks by tab.

KEY FEATURES

Other key features of this model include the following:
– The model follows best practice financial modeling guidelines and includes instructions, checks, and input validations to help ensure input fields are populated accurately;
– The model allows for a 12-month rolling projection on a daily basis and summarized on a monthly basis;
– The model is not password protected and can be modified as required following download;
– The model allows for the following number of categories for each line item (these can be easily expanded if required):
o Bank/Cash accounts – 5 accounts
o Recurring receipts and payments – 20 items on a monthly, quarterly, or yearly recurring basis.
o Debtor categories – 25 categories;
o Creditor categories – 25 categories;
– The model allows the user to model 3 separate revenue streams on a Price x Volume basis;
– Costs are split into: variable and other costs for better driver-based forecasting;
– Business Name, currency, starting projection period are fully customizable;
– Debtor, Creditor, recurring receipts, and payments descriptions are fully customizable;
– The model includes a checks dashboard that summarises all the checks included in the various tabs making it easier to identify any errors.

MODIFICATIONS

If you require any bespoke modifications to the tool, we are more than happy to assist with this. Please send us a message through the Eloquens site or contact us at: [email protected]

ABOUT PROJECTIFY

We are a small team of financial modeling professionals with experience working in big 4 business modeling teams and strong experience supporting businesses with their financial planning and decision support needs. Our aim is to provide robust and easy-to-use tools that follow good practice financial modeling guidelines and assist individuals and businesses with common financial planning and analysis processes.

We are keen to ensure our customers are satisfied with any tools/models purchased and are happy to assist with any questions or support required following or in advance of purchase.

We are keen to receive feedback so please do let us know what you think of our models by sending us a message or submitting a review.

You must log in to submit a review.