The balance sheet must follow the basic accounting equation formula of Assets = Liabilities + Stockholder's Equity, meaning that the total balance from all accounts on the left side of the balance sheet must equal the total balance from all the accounts on the right side of the balance sheet.
The formula for net credit sales is = Sales on credit – Sales returns – Sales allowances. Average accounts receivable is the sum of starting and ending accounts receivable over a time period (such as monthly or quarterly), divided by 2.
(average accounts receivable balance ÷ net credit sales ) x 365 = average collection period. You can also essentially reverse the formula to get the same result: 365 ÷ (net credit sales ÷ average accounts receivable balance) = average collection period.
The formula is fairly simple: AR Turnover Ratio = Net Credit Sales/Average Accounts Receivable. For more context, net credit sales are those made on credit minus any returns or allowances.
Gross accounts receivable represents the total amount of outstanding invoices or the sum owed by customers. It's perhaps the easiest to calculate, too - you simply add up all the outstanding invoices at a given time!
The AR Turnover Ratio is calculated by dividing net sales by average account receivables. Net sales is calculated as sales on credit - sales returns - sales allowances.
The accounts receivable turnover ratio is a simple metric that is used to measure how effective a business is at collecting debt and extending credit. It is calculated by dividing net credit sales by average accounts receivable. The higher the ratio, the better the business is at managing customer credit.
The pro forma accounts receivable (A/R) balance can be determined by rearranging the formula from earlier. The forecasted accounts receivable balance is equal to the days sales outstanding (DSO) assumption divided by 365 days, multiplied by 365 days.
The days sales in accounts receivable is a financial metric that measures the average number of days it takes for a company to collect payments from its customers after a sale has been made. It is calculated by dividing the total accounts receivable balance by the average daily sales.
Average accounts receivable is calculated as the sum of starting and ending receivables over a set period of time (generally monthly, quarterly or annually), divided by two. In financial modeling, the accounts receivable turnover ratio is used to make balance sheet forecasts.