ExcelFlux
← Restaurant and café

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.

MeasureSample 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?

  1. 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.
  2. Measure both due dates from the same invoice date. Check available cash for the early payment date. Funding cost uses a simple annual rate.
  3. 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.
  4. 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