SEVODOC

Milestones, advance and retention · €100000.00 · 20% · 12 · 5% · +6

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

This task at a glance

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

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

Change the example inputs

Total agreed price€100 000.00
Advance€20 000.00
Total retained until release€4 000.00

Advance + Stage work value = €100000.00

€80000.00 × 5% → €4000.00

Checkable payment schedule
PeriodStage work valueRetained / releasedCash paymentCumulative paidRemaining balance
0€0.00€0.00€20 000.00€20 000.00€80 000.00
1€6 666.66€333.33€6 333.33€26 333.33€73 666.67
2€6 666.66€333.33€6 333.33€32 666.66€67 333.34
3€6 666.66€333.33€6 333.33€38 999.99€61 000.01
4€6 666.66€333.33€6 333.33€45 333.32€54 666.68
5€6 666.66€333.33€6 333.33€51 666.65€48 333.35
6€6 666.66€333.33€6 333.33€57 999.98€42 000.02
7€6 666.66€333.33€6 333.33€64 333.31€35 666.69
8€6 666.66€333.33€6 333.33€70 666.64€29 333.36
9€6 666.66€333.33€6 333.33€76 999.97€23 000.03
10€6 666.66€333.33€6 333.33€83 333.30€16 666.70
11€6 666.66€333.33€6 333.33€89 666.63€10 333.37
12€6 666.74€333.37€6 333.37€96 000.00€4 000.00
18€0.00-€4 000.00€4 000.00€100 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. €100000.00 · 20% · 12 · 5% · +6

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.