aratio.py

Created on June 22, 2025
1.31 KB
RATIO
CAS ORCHEST
FRPatrim LIQUIDITE
TAUX ENDETTEMENT
DETTE/CP EMPLOYES
DEFINITIONS
FRP = actifs courants
en net - dettes CT
TAUX ENDETT =
(det nettes) / CP
det nettes =
passif fin LT + passif fin CT

DETTE/EMPLOYES =
(dettes LT + CT - treso)
/ (capitaux employes)
capitaux employes =
(DMLT + DCT - treso)

DONNEES
FRP N-1
72550 - 73416 = -866
FRP N
89311 - 91970
= -2659
DET NETTES N-1
(18853 + 40915 - 4214)
/ 46644
= 1.191
DET NETTES N
(14535 + 50162 - 2684)
/ 51539
= 1.203
DETTE/EMP N-1
(18853 + 40915 - 4214)
/ (55554 + 46644)
= 54.36%
DETTE/EMP N
(14535 + 50162 - 2684)
/ (62013 + 51539)
= 54.61%
ANALYSE
FRP NEGATIF =
besoin treso
degradation si diminution
TAUX ENDETT >1 =
fort endettement
risque élevé
attention retournement CA
DETTE/EMP >50% =
bcp de dette
leger dégrad si augmentation

Cout endett net/CA(activité ordinaire pas autre) =
charges interets net
/ CA
objectif < 4%
cout endett brut/REX(on peut prendre EBE/EBITDA) =
charges interets brut
/ RO courant
ou EBITDA
DONNEES
CA N-1 = 126871
CA N = 131602
cout endett net N-1
3094 / 126871
= 2.44%
cout endett net N
3080 / 131602
= 2.34%
cout endett brut/REX
N-1 = 3094 / 5848
= 52.91%
N = 3649 / 12837
= 28.43%
ANALYSE
reste < 4% sur CA
si baisse = bon signe
si > 4% : risque dett
baisse % sur REX =
charges expl baissent
prod CA augmente
effet positif