Balance sheet efficiency ratios - Part 1

Peramalan Keuangan dengan Python

Victoria Clark

CGMA Financial Analyst

financial statements

Peramalan Keuangan dengan Python

Debtors and creditors

  • Sell now, get paid later
    • debtors
  • Buy now, pay later
    • creditors
Peramalan Keuangan dengan Python

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
Peramalan Keuangan dengan Python

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
Peramalan Keuangan dengan Python

Let's practice!

Peramalan Keuangan dengan Python

Preparing Video For Download...