Search Ctrl K
Home / Tools
THE FEUTEX TOOLKIT

Two-Month Sales Collection Budget

Budget cash collections from current sales and prior-period receivables using collection fractions.

Finance workspace● Runs in your browser
01 Your input
02 Your result
View or copy raw result data
FormulaCash collected = v.current_sales*v.current_collection/100+v.prior_sales*v.prior_collection/100+v.older_cash ; Current sales uncollected = v.current_sales*(1-v.current_collection/100)
Sources and model references

How to use this tool

  1. Enter your own assumptions using a consistent currency and period.
  2. Review the scenario outputs and compare alternative inputs.
  3. Check the stated model limits before using the result in an operating plan.

Try this example

{
  "current_sales": 100000,
  "prior_sales": 80000,
  "current_collection": 60,
  "prior_collection": 35,
  "older_cash": 5000
}

Accuracy and scope

Deterministic planning scenario; inputs are assumptions, not forecasts. Excludes taxes, financing, legal requirements and costs not explicitly entered. Source explains the underlying planning framework; this specific scenario arithmetic is original.

Is my data uploaded?

This tool runs locally in your browser. Input and output are not sent to a processing server. Copy or download your result before leaving the page.