What is Accounts Receivable?
Accounts Receivable (A/R) is defined as payments owed to a company by its customers for products and/or services already delivered to them – i.e. an “IOU” from customers who paid on credit.
Table of Contents
- How to Calculate Accounts Receivable (Step-by-Step)
- Accounts Receivable (A/R) – Current Asset on Balance Sheet
- A/R Example: Amazon (AMZN), Fiscal Year 2022
- How to Forecast Accounts Receivable (A/R)
- Accounts Receivable Calculator – Excel Model Template
- Step 1. Historical Days Sales Outstanding (DSO) Calculation
- Step 2. Accounts Receivable Projection Analysis
How to Calculate Accounts Receivable (Step-by-Step)
Under accrual accounting, the accounts receivable line item, often abbreviated as “A/R”, refers to payments not yet received by customers that paid using credit rather than cash.
Conceptually, accounts receivable represents a company’s total outstanding (unpaid) customer invoices.
However, the amount charged to the customer is recognized as revenue once the customer is billed, despite the cash still being in the possession of the customer.
Whether cash payment was received or not, revenue is recognized and the amount to be paid by the customer can be found on the accounts receivable line item.
Accounts Receivable (A/R) – Current Asset on Balance Sheet
If a company’s accounts receivable balance increases, more revenue has been earned with payment in the form of credit, so more cash payments must be collected in the future.
On the other hand, if a company’s A/R balance declines, the payments billed to the customers that paid on credit were received in cash.
To reiterate, the relationship between accounts receivable and free cash flow (FCF) is as follows:
- Increase in Accounts Receivable → The company’s sales are increasingly paid with credit as the form of payment instead of cash.
- Decrease in Accounts Receivable → The company has successfully retrieved cash payments for credit purchases.
With that said, an increase in A/R represents a reduction in cash on the cash flow statement, whereas a decrease in A/R reflects an increase in cash.
Since an increase in A/R signifies that more customers paid on credit during the given period, it is shown as a cash outflow (i.e. “use” of cash) – which causes a company’s ending cash balance and free cash flow (FCF) to decline.
While the revenue has technically been earned under accrual accounting, the customers have delayed paying in cash, so the amount sits as accounts receivables on the balance sheet.
A/R Example: Amazon (AMZN), Fiscal Year 2022
How to Forecast Accounts Receivable (A/R)
For purposes of forecasting accounts receivable, the standard modeling convention is to tie A/R to revenue since the two are closely linked.
The days sales outstanding (DSO) metric is used in the majority of financial models to project A/R.
DSO measures the number of days on average it takes for a company to collect cash from customers that paid on credit.
The formula for days sales outstanding (DSO) is calculated as follows.
To properly forecast A/R, it’s recommended to follow historical patterns and how DSO has trended in the past couple of years, or to just take an average if there appear to be no significant shifts.
Then, the projected accounts receivable balance is equal to:
If the days sales outstanding (DSO) of a company have been increasing over time, that implies the company’s collection efforts require improvement, as more A/R means more cash is tied up in operations.
But if DSO declines, that implies the company’s collection efforts are improving, which has a positive impact on the cash flows of the company.
Accounts Receivable Calculator – Excel Model Template
We’ll now move to a modeling exercise, which you can access by filling out the form below.
Step 1. Historical Days Sales Outstanding (DSO) Calculation
In our illustrative example, we’ll assume we have a company with $250 million in revenue in Year 0.
Moreover, at the beginning of Year 0, the accounts receivable balance is $40 million but the change in A/R is assumed to be an increase of $10 million, so the ending A/R balance is $50 million in Year 0.
For Year 0, we can calculate the days sales outstanding (DSO) with the following formula:
- DSO – Year 0 = $50m / $250m * 365 = 73 Days
Step 2. Accounts Receivable Projection Analysis
As for the projection period from Year 1 to Year 5, the following assumptions will be used:
- Revenue – Increase by $20m per Year
- DSO – Increase by $5m per Year
Now, we’ll extend the assumptions until we reach a revenue balance of $350 million by the end of Year 5 and a DSO of 98 days.
Starting from Year 0, the accounts receivable balance expands from $50 million to $94 million in Year 5, as captured in our roll-forward.
The change in A/R is represented on the cash flow statement, where the ending balance in the accounts receivable (A/R) roll-forward schedule flows in as the ending balance on the current period balance sheet.
Since the DSO is increasing, the net cash impact is negative, and the company would likely need to consider making adjustments and identify the source of the growing collection issues.