Visit and subscribe our YouTube Channel: YouTube

Tuesday, 20 February 2018

Key Financial Ratio - Cash Conversion Cycle in Excel

Cash Conversion Cycle Calculator




To Find the Average Inventory

Enter Monthly Closing Stock in Yellow Cells. If Monthly Closing Stock is not available Just Enter Yearly Opening and closing stock in Yellow Cells (April & March)

To Find the Average Creditors

Enter Monthly Closing Sundry Creditors in Yellow Cells. If Monthly Closing Sundry Creditors is not available Just Enter Yearly Opening and closing Creditors in Yellow Cells             (April & March)


To Find the Average Debtors

Enter Monthly Closing Sundry Debtors in Yellow Cells. If Monthly Closing Sundry Debtors is not available Just Enter Yearly Opening and closing Debtors in Yellow Cells                       (April & March)

Enter Total Sales Turnover, Gross Profit and Credit Sales turnover Details in Appropriate Cells.



You will Get Following Details

Days Inventory Outstanding (DIO)

Days Sales Outstanding (DSO)

Days Payable Outstanding (DPO)

Cash Conversion Cycle Details (DIO+DSO-DPO)


Any Further Queries please feel Free to Contact us:

goodwilllearningworld@gmail.com


goodwilllearningworld@outlook.com


To Download the Cash Conversion Cycle Calculator Click Here

No comments:

Post a Comment