Aged Account Receivables Excel Model with Cash Flow Sensitivity Analysis
Originally published: 25/03/2019 07:24
Last version published: 28/03/2019 21:10
Publication number: ELQ-73878-2
View all versions & Certificate
certified

Aged Account Receivables Excel Model with Cash Flow Sensitivity Analysis

Calculates the impact of the structure of your receivables from customers on the liquidity of your business and your cas

Description
The goal of this model is to help Small Business to calculate their Cash Flow on a monthly basis as well as to make some scenarios by using CF Sensitivity Aged AR. We also wanted to point to the importance of collecting receivables and how they affect liquidity. This model will help you do two things by using the data from your customer credit record and that is:

1.to get the structure of your customer's receivables by the number of days your customers are lagging (delay of up to 30 days, up to 60 days, and so on ...)
2.By entering the basic assumptions that are your choice, you will have a cash flow with a sensitivity analysis for a period of 12 months.

By using these simple but still useful apps, you'll find it very easy to see how great the impact of your customer's claims on your business's liquidity is.Within the basic assumptions of the model, you can enter data on the percentage of changes in cash inflows or the percentage of changes in cash outflows. One of the model assumptions is also setting the cost structure of a business as a percentage of total operating income (total sales).

Likewise, by introducing the basic assumptions of the model, you will see how this information affects the liquidity of your business.

This small model is free to use and I sincerely hope you will benefit from using it.

This Best Practice includes
This business tool includes One Cash Flow Sensitivity Analisiys Excel Template

Amir Ganic offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

Calculates the impact of the structure of your receivables from customers on the liquidity of your business


4.5 / 5 (10 votes)

please wait...