Days Payable Outstanding (DPO) | Formula | Calculation | Example - YouTube

Channel: WallStreetMojo

[10]
hello everyone hi welcome to the channel of WallStreetmojo or watch the video
[15]
till the end and also if you are new to this channel then you can subscribe us
[18]
by clicking the bell icon. friends today we are going to learn a topic that is a
[24]
ratio basically pays payable outstanding now this is a part of the ratio analysis
[29]
chapter so if you fall short anywhere in ratio analysis and this particular ratio
[37]
then absolutely this is the right place. Days payable outstanding is an
[41]
important concept if you are running a business or following a business as an
[45]
investor, so it is one of the most a significant part of the cash conversion
[49]
cycle it's called the CCC okay. Days payable outstanding help to measure the
[56]
a business that takes to pay off its creditors so in this specific tutorial we
[61]
will discuss days payable outstanding in detail and why it is one of the most
[64]
a significant concept in the case of business. let's get started now what is
[68]
it days payable outstanding this is the graph as you can see the of P&G and
[73]
Colgate's the days payable outstanding helps to measure time the business
[77]
takes to pay off its creditors so let's have a look at the graph here and we
[81]
know that the Colgate's days payable outstanding has been stable over the
[86]
year as you can see the graph and is currently trading at 67.24 days
[91]
that is let's consider 67 days.
[94]
however, when we you compare with Procter and Gamble we note that the P&G days
[98]
payable outstanding has been increasingly continuously since 2009
[103]
and it's currently at a very high stage of 106 so you can consider because it's
[110]
four we can consider 107 days. so we will first look at the formula of the
[114]
days payable outstanding and then we'll interpret the meaning of the ratio. So
[118]
let's understand the formula of the same the DPO that is days payable
[124]
outstanding formula is your accounts payable that's your AP divided by your
[128]
cost of sales
[135]
So, this is your accounts payable and over here you will need to divide the cost of
[141]
sales here the cost of sales will again get
[145]
divided with the number of days. this is a formula for DPO so days payable
[152]
outstanding is a great measure of how much time a company takes to pay off
[158]
its vendors and its supplies. If you look at the formula see that the DPO is
[164]
calculated through dividing them the total ending average accounts payable by
[171]
the money paid per day or per quarter or per month as you can see now for example
[177]
if a company has a DPO of let's say 40 days okay when we say hey the company is
[184]
having a dpo of 40 days to pay off its suppliers or vendors on an average and
[188]
you can have a look at the detail on a guide on the account note what does this
[192]
exactly mean so it means that the company takes around 40 days to pay off
[197]
its supplier or vendors on an average. let's take an example so that you will
[201]
have a clear idea on the same let's say there is a company called Xomic which
[205]
has a reputation of paying its vendor quickly so it has an ending account
[209]
payables balance as let's say $30,000 its cost of sales is let's say $365,000.
[216]
now you what you need to do is just need
[220]
to find out the days payable outstanding for company xomic. Now this is a very
[224]
simple example all we need to do is just to feed in the data to into the formula
[228]
so the DPO days payable outstanding is going to be your ending accounting
[234]
payables divided by the cost of sales right divided by the number of days so
[240]
the cost of sales over here is $357,000 or
[244]
$65000 divided by the total number of days that is 365
[247]
close the bracket and you have number of
[251]
days as 30 days so only computing the days payable outstanding
[254]
of a company isn't enough we need to look at it holistically as when
[257]
we look at the holistic interpretation now so how should a company look at the
[262]
payable outstanding see for a company to succeed it should look holistically by
[267]
calculating the days payable outstanding our company may get how much time it
[272]
takes to pay off its suppliers and vendors but that's not alone I mean
[278]
that's know that won't do any good until the company does few things what is what
[282]
are those things okay no issues we can start with that the
[285]
first thing firstly the company should look at the industry
[291]
industry and the average days payable outstanding in the industry okay second
[298]
thing if the companies days payable outstanding (DPO) is less than the average
[305]
days payable outstanding of the industry then in that
[313]
the particular scenario than the company may consider increasing its day's payable
[317]
outstanding but the organization should remember that doing this doesn't cause
[321]
them to a vendor I mean it doesn't cause the within the vendor or any favorable
[325]
benefits from the suppliers so keeping these two things in mind if a company
[329]
can match up with days payable outstanding with the average days
[332]
payable outstanding of the industry the company would be able to use the cash
[337]
flow for better use for a longer period of
[341]
time the third thing if the company's days
[345]
payable outstanding if if just do a opposite thing
[349]
if the DPO is greater than the ADPO okay then the company may consider
[356]
decreasing it's days payable outstanding over here increasing and
[360]
over here decreasing its days payable outstanding right so doing this well
[367]
allow them to satisfy the vendors and vendors would also be able to provide
[370]
the company a favorable terms and conditions fourthly the company should
[374]
also, look at these similar companies and how they are approaching the days payable outstanding.
[380]
now if the company notices closely then they would be able to see
[383]
the consequences of the approach and in the company can get better idea about
[387]
whether to increase the day's payable outstanding or to decrease the days
[390]
payable outstanding finally fifth along with the DPO the company should I mean
[395]
also should look at the two factors should look at the two factors of the
[402]
cash conversion cycle so there are days inventory outstanding (DIO), the DSO
[406]
which is called days sales outstanding.
[412]
outstanding since all this three are required to form the cash conversion
[416]
cycle it is important that company pays heed to all three right and it will give
[421]
them a holistic view and they would be able to improve their efficiency in the
[425]
long run now how does the whole process works see understanding the whole
[430]
process of days payable outstanding will definitely help in understanding in
[433]
detail see a company needs to first what it needs to purchase the raw material
[437]
inventory from the vendors of the supplier second these raw materials
[442]
can be sourced into two ways first the company can buy
[447]
the raw material in cash and another way you can purchase
[454]
the raw material
[457]
on credit right so if a company is purchasing a raw material
[464]
in bulk then the supplier vendor allows the company to buy on
[470]
credit and pay off the money or on a later date the difference between the
[475]
time they purchase from the supplier and the day they make the payment of the
[478]
supplier is called DPO.now whatever we explained I mean above is is a
[485]
simplification of dpo in real scenario the thing are much complex and and
[492]
company needs to deal with the multiple vendors and suppliers so depending upon
[496]
how much time a company takes to pay off the due, the supplier offers many benefits
[501]
for early payment like discount on bulk orders you can say discount on the bulk
[509]
orders the amount of pay etc these are the sector examples of the
[515]
days payable outstanding this is the the first is the airline sector as you can see
[519]
the American Airlines days payable is 35 the highest is of azul and the
[524]
Delta Airlines, JetBlue, Southwest, United Continental, China Southern Airlines, and
[531]
so on and so forth what we observe is that there is a varied payment terms and
[535]
payable days outstanding ranging from 0 to 134 close enough to know not
[540]
130 for at least in the range the airline companies have varied payment
[545]
terms and that is reflected in the payments and outstanding days the China
[549]
Southern Airlines as you can see I mean has the China not Eastern the southern
[555]
one the China Southern Airlines 13.30 it
[560]
has the least low payment outstanding days whereas if you see the latam
[564]
airlines group 60.48 it is the highest amount with the group at at
[568]
60.48 that's 61 days you can consider so that's it for this
[574]
particular topic if you have learned and enjoyed watching this video please like
[578]
and comment on this video and subscribe to our channel for the latest updates
[582]
thank you everyone Cheers