O'Reilly logo

Hands-On Financial Modeling with Microsoft Excel 2019 by Shmuel Oluwa

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creditor days

Finally, once management has been able to negotiate favorable credit terms with its suppliers and an efficient payment process has been put in place, the amount of time it takes to pay suppliers becomes fairly constant.

The formula for creditor days is as follows:

Here, opening creditors is the count of creditors at the beginning of the year and closing creditors is the count of creditors at the end of the year.

Once we have established our historical growth drivers, we turn to our notes from discussions with management and our own assessments in order to create assumptions of the projected behavior of the selected items and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required