Aged Account Receivables Excel Model with Cash Flow Sensitivity Analysis

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.