background
Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street Prep Certificates
Now Enrolling for May 2024 for May 2024
:
Private EquityReal Estate Investing
Buy-Side InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for May 2024 is Open
Wall Street Prep

Accounts Receivable (A/R)

Step-by-Step Guide to Understanding Accounts Receivable (A/R)

Last Updated March 29, 2024

Learn Online Now

Accounts Receivable (A/R)

What is the Definition of Accounts Receivable?

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.

Given the fact that the customer has not yet paid the company, the question becomes: “Is accounts receivable an asset or a liability?”

Since the unmet payment obligation represents a future economic benefit to the company, the accounts receivables line item is categorized as a current asset on the balance sheet, i.e. the company anticipates receiving the owed payment in cash soon.

However, as part of the revenue recognition policy established under accrual accounting standards, the amount charged to the customer is recognized as revenue once the customer is billed, irrespective of the fact that the cash still remains under the possession of the customer.

Whether cash payment was received or not, revenue is still recognized on the income statement and the amount to be paid by the customer can be found on the accounts receivable line item.

Accounts Receivable Formula (A/R)

For purposes of forecasting accounts receivable in a financial model, the standard modeling convention is to tie A/R to revenue, since the relationship between the two is closely linked.

More specifically, 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.

Days Sales Outstanding (DSO) = Accounts Receivable ÷ Revenue x 365 Days

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 can be determined using the following formula.

Projected Accounts Receivable (A/R) = (DSO Assumptions Assumption ÷ 365) x Revenue
  • Increasing Days Sales Outstanding (DSO) → 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.
  • Decreasing Days Sales Outstanding (DSO) → But if a company’s days sales outstanding (DSO) declines, that implies the company’s collection efforts are improving, which has a positive impact on the cash flows of the company.

How to Interpret Accounts Receivable?

If a company’s accounts receivable balance increases, more revenue must have 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 invoices billed to customers that paid on credit were completed and the money was received in cash.

To reiterate, the relationship between accounts receivable and free cash flow (FCF) is as follows:

  • Increase in Accounts Receivable (A/R) → The company’s sales are increasingly paid with credit as the form of payment instead of cash.
  • Decrease in Accounts Receivable (A/R) → The company has successfully retrieved cash payments for credit purchases.

With that said, an increase in accounts receivable represents a reduction in cash on the cash flow statement, whereas a decrease reflects an increase in cash.

On the cash flow statement (CFS), the starting line item is net income, which is then adjusted for non-cash add-backs and changes in working capital in the cash from operations (CFO) section.

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.

What is the Difference Between Accounts Receivable vs. Accounts Payable?

The difference between accounts receivable and accounts payable is as follows.

  • Accounts Receivable (A/R) → Accounts receivable is a current asset recorded on the balance sheet that captures the outstanding cash payments still owed from customers, i.e. the money owed from customers that paid using credit.
  • Accounts Payable (A/P) → In contrast, accounts payable is a current liability recognized on the balance sheet that reflects the cash payments that the company owes to suppliers and vendors, i.e. the company paid using credit as the form of payment.

What is an Example of Accounts Receivable?

Suppose an electronic components supplier received an order from a manufacturer. The manufacturer placed an order and the requested components were delivered based on the purchase agreement.

Therefore, the supplier sent the customer, i.e. the manufacturer, an invoice for the amount owed, which we’ll assume to be $50k.

However, the manufacturer is a long-time customer with an agreement that provides them with 60 days to pay post-receipt of the invoice.

In the 60-day period, the $50k that the manufacturer still owes is recorded as accounts receivable on the books because the outstanding invoice represents an unmet obligation, in which the customer has not yet paid for the goods that were delivered.

On the income statement, the $50k is recognized as revenue per accrual accounting policies but recorded as accounts receivable too since the payment has not yet been received.

Until the manufacturer issues the payment to complete the invoice, the accounts receivable remains on the balance sheet.

What is the Journal Entry for Accounts Receivable?

Using the same assumptions as the prior section, the journal entry to reflect the purchase made on credit is as follows.

Credit Sale

  • Debit (DR) → Accounts Receivable Account: $50k
  • Credit (CR) → Revenue Account: $50k

The journal entry reflects that the supplier recognized the transaction as revenue because the product was delivered, but is waiting to receive the cash payment. Hence, the debit to the accounts receivable account, i.e. the manufacturer owes money to the supplier.

Cash Payment

  • Debit (DR) → Cash Account: $50k
  • Credit (CR) → Accounts Receivable: $50k

The adjusting journal entry here reflects that the supplier received the payment in cash.

The debit to the cash account causes the supplier’s cash on hand to increase, whereas the credit to the accounts receivable account reduces the amount still owed.

How to Find Accounts Receivable on the Balance Sheet

The screenshot below is from the latest 10-K filing by Amazon (AMZN) for the fiscal year ending 2021.

Accounts Receivable Example - Amazon (AMZN)

Amazon.com, Inc. 10-K Filing, 2022 (Source: AMZN 10-K)

Accounts Receivable Calculator | Excel Template

We’ll now move to a modeling exercise, which you can access by filling out the form below.

dl

Get the Excel Template!

By submitting this form, you consent to receive email from Wall Street Prep and agree to our terms of use and privacy policy.

Submitting...

1. Historical Days Sales Outstanding Calculation (DSO)

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 x 365 = 73 Days

2. Accounts Receivable Calculation Example (A/R)

As for the projection period from Year 1 to Year 5, the following assumptions will be used:

  • Revenue Step Function = Increase by $20m per Year
  • DSO Step Function = 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 accounts receivable balance, i.e. the collection issues.

Accounts Receivable Calculator (A/R)

Step-by-Step Online Course

Everything You Need To Master Financial Modeling

Enroll in The Premium Package: Learn Financial Statement Modeling, DCF, M&A, LBO and Comps. The same training program used at top investment banks.

Enroll Today
Comments
2 Comments
most voted
newest oldest
Inline Feedbacks
View all comments
Sandeep
July 27, 2023 11:20 am

What does it mean if receivables are in negative and increasing.
I mean more negative.
From -100 to -200.

Brad Barlow
July 31, 2023 11:12 pm
Reply to  Sandeep

Hi, Sandeep,

Receivables cannot be negative, but net working capital can, if liabilities are greater than assets and growing at a constant rate along with assets.

BB

Learn Financial Modeling Online

Everything you need to master financial and valuation modeling: 3-Statement Modeling, DCF, Comps, M&A and LBO.

Learn More

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.