Supplier terms and early-payment discounts
Compare prompt-payment discounts with the alternative cost of cash.
Restaurant and Café Pack · Excel workbook in Turkish
Results from the sample workbook
- Erken ödeme (TL)
- 26,106.57
- Faiz maliyeti (TL)
- 982.22
- Net avantaj (TL)
- 61.9
Who can use it, and for what?
Purchasing and finance teams
Compare prompt-payment discounts with the alternative cost of cash.
A worked example from the workbook
The first sample row in the baseline has the following results. Erken ödeme (TL) 26.032,5, Faiz maliyeti (TL) 998,51, Net avantaj (TL) -331,01, Nakit fazlası (TL) 3.967,5. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.
| Measure | Sample result |
|---|---|
| Erken ödeme (TL) | 26,106.57 |
| Faiz maliyeti (TL) | 982.22 |
| Net avantaj (TL) | 61.9 |
| Nakit fazlası (TL) | 3,809.06 |
How do you start with your own data?
- Start with Kılavuz (Guide). Replace the 16 fictional entries in the yellow cells on Veri (Data). Use an Excel date, a unique record ID and a branch or category. There are 64 ready-to-use input rows.
- Measure both due dates from the same invoice date. Check available cash for the early payment date. Funding cost uses a simple annual rate.
- Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Yıllık fon maliyeti”. The sample settings are %40 / %25 / %60. Changing the scenario preserves source records.
- Panel shows the three cases and the group breakdown for the selected case. On Hesap (Calculations), check input flags and row-level decisions. To rename a group, use the same name on Settings and Data.
Workbook input fields
Labels appear in Turkish in the workbook.
- Fatura (TL)
- İskonto
- Normal vade (gün)
- Erken vade (gün)
- Kullanılabilir nakit (TL)
Sample assumptions
- Yıllık fon maliyeti
- 0.4