Contractor bid markup for bond and retainage · Calculation guide

Price a bond premium on the gross bid and simple financing cost on retained bid value until release.

Calculation guide

Apply target profit as markup on direct cost. Require positive net realization.

Required gross bid = ((Direct bid cost × (1 + (Target profit markup on cost (%) ÷ 100))) ÷ ((1 − (Bond premium on bid (%) ÷ 100)) − (((Bid retention (%) × Annual financing rate (%)) × Years retention financed) ÷ 10000))). Total markup on cost = (100 × ((Required gross bid ÷ Direct bid cost) − 1))

Inputs

Direct bid cost

Example entry 90000 (in the selected currency). Minimum 1e-06.

Target profit markup on cost (%)

Example entry 10 %. Allowed range 0.0 to 1000.0.

Bond premium on bid (%)

Example entry 1 %. Allowed range 0 to 100.

Bid retention (%)

Example entry 10 %. Allowed range 0 to 100.

Annual financing rate (%)

Example entry 10 %. Allowed range 0 to 100.

Years retention financed

Example entry 1. Allowed range 0.0 to 100.0.

Worked example

InputValue
Direct bid cost90,000
Target profit markup on cost (%)10%
Bond premium on bid (%)1%
Bid retention (%)10%
Annual financing rate (%)10%
Years retention financed1
ResultValue
Required gross bid101,020.408163
Total markup on cost12.244898%

Calculation steps

Required gross bid = ((Direct bid cost × (1 + (Target profit markup on cost (%) ÷ 100))) ÷ ((1 − (Bond premium on bid (%) ÷ 100)) − (((Bid retention (%) × Annual financing rate (%)) × Years retention financed) ÷ 10,000)))

((90,000 × (1 + (10 ÷ 100))) ÷ ((1 − (1 ÷ 100)) − (((10 × 10) × 1) ÷ 10,000))) = 101,020.408163

Total markup on cost = (100 × ((Required gross bid ÷ Direct bid cost) − 1))

(100 × ((101,020.408163 ÷ 90,000) − 1)) = 12.244898%

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Direct bid cost90,00099,000Required gross bid101,020.408163111,122.44898
Target profit markup on cost (%)10%11%Required gross bid101,020.408163101,938.77551
Bond premium on bid (%)1%2%Required gross bid101,020.408163102,061.85567
Bid retention (%)10%11%Required gross bid101,020.408163101,123.595506
Annual financing rate (%)10%11%Required gross bid101,020.408163101,123.595506
Years retention financed12Required gross bid101,020.408163102,061.85567
Contractor bid markup for bond and retainage →

Sources