EDUCBA

EDUCBA

MENUMENU
  • Blog
  • Free Courses
  • All Courses
  • All in One Bundle
  • Login
Home Finance Finance Resources Finance Formula Average Collection Period Formula

Average Collection Period Formula

Madhuri Thakur
Article byMadhuri Thakur

Updated August 2, 2023

average-collection-period-formula

Average Collection Period Formula

The formula for calculating Average Collection Period Formula is as follows:

Start Your Free Investment Banking Course

Download Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

Average Collection Period Formula

Alternatively, the collection period can also be calculated as –

Average Collection Period Formula1

Where,

The average collection period can be assumed as the Average number of days between the following:

  • The date at which credit sales are made, and
  • The date at which money has been received from the customers.

The average collection period can also be denoted as the Average days’ sales in accounts receivable.

Examples of Average Collection Period Formula

Let’s take an example to find out the Average Collection Period for a company:-

You can download this Average Collection Period Formula Template here – Average Collection Period Formula Template

Average Collection Period Formula – Example #1

Jagriti Group of Companies books of accounts have the following details as per its financials for the year ended 2017-18

  • Total sales = $2,00,000
  • Cash sales = $70,000
  • Closing Balance of Accounts receivables = $10,000
  • Closing Balance of Notes receivables = $5,000

We have to calculate the Average collection period for the Jagriti Group of Companies.

To calculate the Average collection period, we need the Average Receivable Turnover, and we can assume the Days in a year as 365.

We have calculated credit sales by using the below formula:

  • Credit Sales = Total Sales – Cash Sales
  • Credit Sales= $2,00,000 – $70,000
  • Credit Sales= $1,30,000

We can calculate the Receivables turnover ratio as follows:

  • Receivables turnover ratio = Net credit sales / (Receivables + Notes receivables)
  • Receivables turnover ratio = $1,30,000 / ($10,000 + $5,000)
  • Receivables turnover ratio = $1,30,000 /$15,000
  • Receivables turnover ratio = 8.7 or 9 Times

Now we can calculate the Average collection period for Jagriti Group of Companies using the below Formula.

  • Average Collection Period Formula= 365 Days /Average Receivable Turnover ratio
  • Average Collection Period = 365/9
  • Average Collection Period = 40 Days

On average, the Jagriti Group of Companies collects the receivables in 40 Days.

Average Collection Period Formula – Example #2

Anand Group of companies have decided to change their credit policy. They have asked the Analyst to compute the Average collection period to analyze the current scenario.

The following details have been shared with the Analyst for calculating the Average collection period of the company–

  • Net Credit Sales = $2,50,000
  • Opening Balance of Accounts Receivables = $25,000
  • Closing Balance of Accounts Receivables = $35,000

In the above case, the Analyst has to calculate the average accounts receivable for the Anand group of companies based on the above details.

We need the Average Receivable Turnover to calculate the Average collection period, and we can assume the Days in a year as 365.

And,

We have Opening and Closing accounts receivables Balances of $25,000 and $35,000 for the Anand Group of companies.

  • The average accounts receivables for the year = ($25,000 + $35,000) / 2
  • The average accounts receivables for the year = $60,000 / 2
  • The average accounts receivables for the year = $30,000.

Now, we can calculate Average Receivable Turnover by using the formula:

  • Accounts Receivable Turnover Ratio = Net Credit Sales / Average Accounts Receivable
  • Accounts Receivable Turnover Ratio = $2,50,000 / $30,000
  • Accounts Receivable Turnover Ratio = 8.3 or 8x.

Now, we can calculate the Average Collection period for the Anand Group of companies using the below formula:

  • Average Collection Period Formula= 365 Days /Average Receivable Turnover ratio
  • Average Collection Period = 365/ 8
  • Average Collection Period = 45.62 or 46 Days.

Anand Group of companies can change its credit term depending on the collection period policy.

Average Collection Period Formula – Example #3

For example, Jagriti Company, Inc. has accounts receivable outstanding of $50,000 for the year beginning 2017. And accounts receivable due of $60,000 at the end of the same financial year. Net Credit Sales for Jagriti Company Inc for the same financial year is $600,000.

We can calculate the Average Accounts Receivable for the year by adding the Beginning and Ending Accounts receivable and dividing the total by 2. This brings the average accounts receivable for Jagriti Company, Inc as

  • Average Accounts Receivable for the year = ($50,000+$60,000)/2
  • Average Accounts Receivable for the year = ($110,000)/2
  • Average Accounts Receivable for the year = 55,000

We can calculate the Average Collection period by using the below formula:

  • Average Collection Period = 365 Days /Average Receivable Turnover ratio
  •  Average Collection Period = 365/ ($600,000/$55,000)
  • Average Collection Period=365/11
  • Average Collection Period = 33 Days

Explanation

The average Collection Period can be calculated by using these formulas:

  • Average Collection Period Formula= 365 Days /Average Receivable Turnover ratio
  • Average Collection Period Formula= Average accounts receivable balance / Average credit sales per day

The first formula is mostly used for calculation by investors and other professionals.

In the first formula, to calculate the Average collection period, we need the Average Receivable Turnover, and we can assume the Days in a year as 365.

We can calculate the Average Accounts Receivable for the year by adding the Beginning and Ending Accounts receivable and dividing the total by 2.

We can calculate the Average Collection period by using the below formula:

Average Collection Period = 365 Days /Average Receivable Turnover ratio

For the second formula, we need to compute the average accounts receivable per day and the average credit sales per day. Average accounts receivable per day can be calculated as average accounts receivable divided by 365, and Average credit sales per day can be calculated as average credit sales divided by 365.

Significance and Use of Average Collection Period Formula

We must know the company’s Average Collection period ratio to gain valuable insight. But get a meaningful insight, we can use the Average Collection period ratio compared to other companies’ balances in the same industry or can be used to analyze the previous year’s trend. This ratio shows the ability of the company to collect its receivables, and the average period is going up or down. The company can change the collection policy to handle the business’s liquidity.

We can also compare the company’s credit policy with the competitors on the average days taken by the company from credit sale to the collection. We can judge how well a company is doing.

Suppose the company has an average collection period of 40 days but has a credit policy to collect the receivables in 30 days. There is a problem in the collection team of the company. If the average collection period is 40 days, and the company has announced a credit policy of 15 days, then this situation is significantly worse. The customers are not following the credit agreement terms, and this needs a look at your company’s credit policy and introducing measures to change the current scenario. The following measures can be taken to make the present scenario abiding:

  • Require Tightening of credit.
  • Instructing the customers on the credit terms.
  • Offering Discounts to the customers in case they are paying the credit in advance, offering a 2 % discount in case customers pay in the first ten days.
  • Follow-Up with the credit team on delinquent accounts.
  • Charging interest on delay in paying the account receivables.

Average Collection Period Calculator

You can use the following Average Collection Period Calculator

365 Days
Average Receivable Turnover Ratio
Average Collection Period Formula
 

Average Collection Period Formula
365 Days
=
Average Receivable Turnover Ratio
365
= 0
0

Average Collection Period Formula in Excel (With Excel Template)

Here we will do the same example of the Average Collection Period formula in Excel. It is very easy and simple. You need to provide the only one inputs, i.e., Average Receivable Turnover ratio

You can easily calculate the Average Collection Period using Formula in the template provided.

In this template, we have to solve the Average Collection Period Formula

First, we have calculated the Average Account Receivable

average accounts receivables2.1

Here we have to Find out the Receivables Turnover Ratio

Receivables turnover ratio

Here we have calculated the Average Collection Period

Average Collection Period Formula1.33

Recommended Articles

This has been a guide to Average Collection Period Formula. Here, we discuss its uses along with practical examples. We also provide the Average Collection Period calculator and a downloadable Excel template.

  1. Calculation of Net Profit Margin Formula
  2. How to Calculate Price to Earnings Formula?
  3. Calculate Marginal Cost Using Formula
  4. Examples of Weighted Average Formula
All in One Excel VBA Bundle
500+ Hours of HD Videos
15 Learning Paths
120+ Courses
Verifiable Certificate of Completion
Lifetime Access
Financial Analyst Masters Training Program
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
All in One Data Science Bundle
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
All in One Software Development Bundle
5000+ Hours of HD Videos
149 Learning Paths
1050+ Courses
Verifiable Certificate of Completion
Lifetime Access
Primary Sidebar
Financial Analyst Masters Training Program2000+ Hours of HD Videos | 43 Learning Paths | 550+ Courses | Verifiable Certificate of Completion | Lifetime Access
All in One Data Science Bundle2000+ Hour of HD Videos | 80 Learning Paths | 400+ Courses | Verifiable Certificate of Completion | Lifetime Access
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Investment Banking Jobs Offer
  • Finance Formula
  • All Tutorials
Certification Courses
  • All Courses
  • Financial Analyst All in One Bundle
  • Investment Banking Training
  • Financial Modeling Course
  • Equity Research Course
  • Private Equity Training Course
  • Business Valuation Course
  • Mergers and Acquisitions Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

Download Average Collection Period Formula Template

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA
Free Investment Banking Course

Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

डाउनलोड Average Collection Period Formula Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more