SEVODOC

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

Inspect how advances, work stages and retention change cash received in each period. €20000.00 · 30% · 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€6000.00
Total retained until release€700.00

Initial example inputs: Initial amount, EUR: 20000.00; Advance from price, %: 30; 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€6 000.00
Total retained until release€700.00

Advance + Stage work value = €20000.00

€14000.00 × 5% → €700.00

Checkable payment schedule
PeriodStage work valueRetained / releasedCash paymentCumulative paidRemaining balance
0€0.00€0.00€6 000.00€6 000.00€14 000.00
1€1 166.66€58.33€1 108.33€7 108.33€12 891.67
2€1 166.66€58.33€1 108.33€8 216.66€11 783.34
3€1 166.66€58.33€1 108.33€9 324.99€10 675.01
4€1 166.66€58.33€1 108.33€10 433.32€9 566.68
5€1 166.66€58.33€1 108.33€11 541.65€8 458.35
6€1 166.66€58.33€1 108.33€12 649.98€7 350.02
7€1 166.66€58.33€1 108.33€13 758.31€6 241.69
8€1 166.66€58.33€1 108.33€14 866.64€5 133.36
9€1 166.66€58.33€1 108.33€15 974.97€4 025.03
10€1 166.66€58.33€1 108.33€17 083.30€2 916.70
11€1 166.66€58.33€1 108.33€18 191.63€1 808.37
12€1 166.74€58.37€1 108.37€19 300.00€700.00
15€0.00-€700.00€700.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 · 30% · 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.