SEVODOC

Milestones, advance and retention · €40000.00 · 30% · 12 · 15% · +3

Inspect how advances, work stages and retention change cash received in each period. €40000.00 · 30% · 12 · 15% · +3

This task at a glance

Initial example result
What to clarifyExample or option on this page
Total agreed price€40000.00
Advance€12000.00
Total retained until release€4200.00

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

Change the example inputs

Total agreed price€40 000.00
Advance€12 000.00
Total retained until release€4 200.00

Advance + Stage work value = €40000.00

€28000.00 × 15% → €4200.00

Checkable payment schedule
PeriodStage work valueRetained / releasedCash paymentCumulative paidRemaining balance
0€0.00€0.00€12 000.00€12 000.00€28 000.00
1€2 333.33€349.99€1 983.34€13 983.34€26 016.66
2€2 333.33€349.99€1 983.34€15 966.68€24 033.32
3€2 333.33€349.99€1 983.34€17 950.02€22 049.98
4€2 333.33€349.99€1 983.34€19 933.36€20 066.64
5€2 333.33€349.99€1 983.34€21 916.70€18 083.30
6€2 333.33€349.99€1 983.34€23 900.04€16 099.96
7€2 333.33€349.99€1 983.34€25 883.38€14 116.62
8€2 333.33€349.99€1 983.34€27 866.72€12 133.28
9€2 333.33€349.99€1 983.34€29 850.06€10 149.94
10€2 333.33€349.99€1 983.34€31 833.40€8 166.60
11€2 333.33€349.99€1 983.34€33 816.74€6 183.26
12€2 333.37€350.11€1 983.26€35 800.00€4 200.00
15€0.00-€4 200.00€4 200.00€40 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. €40000.00 · 30% · 12 · 15% · +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.