Balance sheet efficiency ratios - Part 1

Python ile Finansal Tahminleme

Victoria Clark

CGMA Financial Analyst

financial statements

Python ile Finansal Tahminleme

Debtors and creditors

  • Sell now, get paid later
    • debtors
  • Buy now, pay later
    • creditors
Python ile Finansal Tahminleme

The debtor days ratio

  • How many days to receive payment from debtors

  • Lower ratio is better

  • Formula:

    • $Debtor$ $Days$ = $\frac{EndingBalanceDebtors}{Sales}$ $x$ $DaysInFinancialYear$

 

ddays_ratio = (debtors_end/sales_tot) * 365
Python ile Finansal Tahminleme

Days payable outstanding (DPO ratio)

  • How many days to pay our creditors

  • Higher ratio is better

  • Formula:

    • $DPO$ = $\frac{EndingBalanceCreditors}{TotalCostOfGoodsSold}$ $x$ $DaysInFinancialYear$

 

dpo = (creditors_end/cogs_tot)*365
Python ile Finansal Tahminleme

Let's practice!

Python ile Finansal Tahminleme

Preparing Video For Download...