SEVODOC

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

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

This task at a glance

Initial example result
What to clarifyExample or option on this page
Total agreed price€20000.00
Advance€4000.00
Total retained until release€800.00

Initial example inputs: Initial amount, EUR: 20000.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€20 000.00
Advance€4 000.00
Total retained until release€800.00

Advance + Stage work value = €20000.00

€16000.00 × 5% → €800.00

Checkable payment schedule
PeriodStage work valueRetained / releasedCash paymentCumulative paidRemaining balance
0€0.00€0.00€4 000.00€4 000.00€16 000.00
1€1 333.33€66.66€1 266.67€5 266.67€14 733.33
2€1 333.33€66.66€1 266.67€6 533.34€13 466.66
3€1 333.33€66.66€1 266.67€7 800.01€12 199.99
4€1 333.33€66.66€1 266.67€9 066.68€10 933.32
5€1 333.33€66.66€1 266.67€10 333.35€9 666.65
6€1 333.33€66.66€1 266.67€11 600.02€8 399.98
7€1 333.33€66.66€1 266.67€12 866.69€7 133.31
8€1 333.33€66.66€1 266.67€14 133.36€5 866.64
9€1 333.33€66.66€1 266.67€15 400.03€4 599.97
10€1 333.33€66.66€1 266.67€16 666.70€3 333.30
11€1 333.33€66.66€1 266.67€17 933.37€2 066.63
12€1 333.37€66.74€1 266.63€19 200.00€800.00
15€0.00-€800.00€800.00€20 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. €20000.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.