SEVODOC

Milestones, advance and retention · €40000.00 · 20% · 12 · 15% · +1

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

This task at a glance

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

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

Change the example inputs

Total agreed price€40 000.00
Advance€8 000.00
Total retained until release€4 800.00

Advance + Stage work value = €40000.00

€32000.00 × 15% → €4800.00

Checkable payment schedule
PeriodStage work valueRetained / releasedCash paymentCumulative paidRemaining balance
0€0.00€0.00€8 000.00€8 000.00€32 000.00
1€2 666.66€399.99€2 266.67€10 266.67€29 733.33
2€2 666.66€399.99€2 266.67€12 533.34€27 466.66
3€2 666.66€399.99€2 266.67€14 800.01€25 199.99
4€2 666.66€399.99€2 266.67€17 066.68€22 933.32
5€2 666.66€399.99€2 266.67€19 333.35€20 666.65
6€2 666.66€399.99€2 266.67€21 600.02€18 399.98
7€2 666.66€399.99€2 266.67€23 866.69€16 133.31
8€2 666.66€399.99€2 266.67€26 133.36€13 866.64
9€2 666.66€399.99€2 266.67€28 400.03€11 599.97
10€2 666.66€399.99€2 266.67€30 666.70€9 333.30
11€2 666.66€399.99€2 266.67€32 933.37€7 066.63
12€2 666.74€400.11€2 266.63€35 200.00€4 800.00
13€0.00-€4 800.00€4 800.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 · 20% · 12 · 15% · +1

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.