SEVODOC

Milestones, advance and retention · €50000.00 · 20% · 12 · 5% · +3

Inspect how advances, work stages and retention change cash received in each period. €50000.00 · 20% · 12 · 5% · +3

This task at a glance

Initial example result
What to clarifyExample or option on this page
Total agreed price€50000.00
Advance€10000.00
Total retained until release€2000.00

Initial example inputs: Initial amount, EUR: 50000.00; Advance from price, %: 20; Number of work stages: 12; Retention on work after advance, %: 5; Periods after completion until release: 3

Change the example inputs

Total agreed price€50 000.00
Advance€10 000.00
Total retained until release€2 000.00

Advance + Stage work value = €50000.00

€40000.00 × 5% → €2000.00

Checkable payment schedule
PeriodStage work valueRetained / releasedCash paymentCumulative paidRemaining balance
0€0.00€0.00€10 000.00€10 000.00€40 000.00
1€3 333.33€166.66€3 166.67€13 166.67€36 833.33
2€3 333.33€166.66€3 166.67€16 333.34€33 666.66
3€3 333.33€166.66€3 166.67€19 500.01€30 499.99
4€3 333.33€166.66€3 166.67€22 666.68€27 333.32
5€3 333.33€166.66€3 166.67€25 833.35€24 166.65
6€3 333.33€166.66€3 166.67€29 000.02€20 999.98
7€3 333.33€166.66€3 166.67€32 166.69€17 833.31
8€3 333.33€166.66€3 166.67€35 333.36€14 666.64
9€3 333.33€166.66€3 166.67€38 500.03€11 499.97
10€3 333.33€166.66€3 166.67€41 666.70€8 333.30
11€3 333.33€166.66€3 166.67€44 833.37€5 166.63
12€3 333.37€166.74€3 166.63€48 000.00€2 000.00
15€0.00-€2 000.00€2 000.00€50 000.00€0.00

The calculation is a local example. This action saves no customer document and makes no payment.

Example assumptions and limits

Continue in the actual tool

Common questions

What can I verify in this example?

Inspect how advances, work stages and retention change cash received in each period. €50000.00 · 20% · 12 · 5% · +3

Which assumptions should I change for my transaction?

Retention is an assumed contractual percentage of work after the advance. The release row assumes agreed conditions are met; it is not evidence of an actual release.

Will opening a template produce an approved document?

Hypothetical calculation. It does not save a document, prove payment or post a journal entry.