Investment in accounts receivable: formula and example

The investment in accounts receivable formula estimates either the face value of invoices waiting for payment or the costs funded while those invoices remain unpaid. Face value uses daily credit sales multiplied by collection days; the cost-funded version applies an explicit cash-cost percentage. Keep both figures visible because they answer different questions.

Define the investment before calculating it

Estimated average receivable face value = Annual credit sales / Days in year × Average collection days

Estimated cost-funded investment = Estimated receivable face value × Relevant cash costs / Credit sales

Equivalently, cost-funded investment = Annual relevant cash costs / Days in year × Average collection days

The face-value estimate includes the margin embedded in unpaid invoices. The cost-funded estimate includes only the selected cost share. It is a management planning calculation, not an accounting adjustment to customer balances.

Receivables also differ from cash. The SEC's financial-statement guide distinguishes reported profit from generated cash; that distinction matters when a business earns revenue before receiving payment. Neither formula tells you whether the company can meet each payment on its actual due date.

A reconciled ending balance comes from the accounts receivable formula. The estimate here instead describes an average balance under stated sales and payment assumptions. Do not expect it to match a seasonal month-end snapshot exactly.

The rows and assumptions to bring

Start with a credit-sales export by customer, an invoice-and-receipt allocation file and a cost schedule tied to the same sales. You need customer ID, invoice date, invoice amount, cash applied, receipt date and the selected costs. Retain unpaid invoices when evaluating collection behavior; studying only settled invoices can hide the slowest balances.

For the example below, management supplies these assumptions:

• Sales occur evenly through a 365-day planning year.
• The collection-day assumptions describe expected payment behavior for each customer group.
• All sales shown are on credit; there are no taxes, returns, discounts or credit losses in the example.
• Relevant costs are variable cash costs paid when the corresponding sale is invoiced. There is no supplier-credit offset in this simplified estimate.

These assumptions make the arithmetic interpretable. If suppliers are paid later, or materials are purchased well before invoicing, build the cash schedule around those dates instead. If fixed cash costs change with a capacity decision, include their actual timing in the decision analysis rather than treating them as a constant sales percentage.

A worked example for a US distributor

A distributor plans customer credit for three account groups. Management has approved the annual sales, cash-cost amounts and collection days below. USD figures are hypothetical and calculated in whole dollars; percentages are exact for these inputs.

Compute each group before adding the estimates. Different payment periods put different weights on the costs sitting in receivables.

The distributor expects average invoices outstanding of $405,000. Under the stated immediate-cost-payment assumptions, $261,750 represents the selected cash costs associated with those outstanding sales. The $143,250 difference is the embedded margin excluded from that cost estimate, not cash already collected.

Two checks that prove the estimate

For each row, multiply face value by its cash-cost share. Atlas is $150,000 × 60% = $90,000; Beacon is $135,000 × 65% = $87,750; Cedar is $120,000 × 70% = $84,000. Their sum is $261,750, matching the daily-cost method.

The face-value total has another check. Sales-weighted collection days are (5,000 × 30 + 3,000 × 45 + 2,000 × 60) / 10,000 = 40.5 days. Multiply $10,000 of daily credit sales by 40.5 days to recover $405,000.

Do not multiply the total face balance by an unweighted average of customer cost percentages. The estimate requires the cost share belonging to the invoices outstanding. The AR turnover ratio explains the historical receivables relationship; retain that separate method when comparing actual performance with the planning inputs.

Change one input: Beacon pays later

Now change only Beacon's expected collection period from 45 to 60 days. Sales and cash-cost assumptions stay unchanged.

Total estimated face receivables become $405,000 + $45,000 = $450,000. The company cost-funded estimate becomes $261,750 + $29,250 = $291,000.

The $29,250 change must not be presented as the complete cash impact of delaying unchanged sales. Delaying customer payments delays the full invoice receipts: the face-value increase is $45,000. The smaller amount is the increase in this specifically defined cost-based measure. Treasury needs the actual receipt and disbursement schedule to assess financing needs.

OpenStax's receivables-management chapter describes credit terms as a decision involving both sales and financial management. This calculation supplies a funding dimension; it does not establish whether longer terms will win profitable business.

Where it goes wrong

• Treating terms as actual collection days. An invoice due date is a promise; payment history and unpaid balances show how customers behave.
• Calling the estimate cash flow. A steady-state balance does not show payroll dates, inventory purchases, supplier terms or a transition to longer customer terms.
• Including cash sales. They do not create the trade-credit exposure measured here.
• Using an unexplained cost percentage. Separate cash costs from depreciation, fixed allocations, bad debts and financing charges.
• Ignoring changing mix. A larger share of slow-paying, high-cost customers changes the cost-funded total even when company sales are flat.

Use the collection rate to review realized cash performance and an accounts receivable dashboard to organize the ongoing review. Neither replaces the assumptions behind the funding calculation.

Compare your customer-credit assumptions in Covirage

Bring your sales export, receipt history and approved cost assumptions to Covirage; it maps the columns, and its tools compute and check the supplied scenarios. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See customer profitability for the wider account economics behind the credit decision.