PO.ECON.Capex.Phasing


Description

Spreads a capital total over periods in proportion to a phasing profile. Each period gets total × weight / sum of weights, so the profile can be written as percentages, fractions or any relative weights, and the spread always adds back to the total. The result has the shape of the profile: a column profile gives a column of spend by period, ready to subtract from a monthly cash flow. A zero weight leaves that period without spend.

Formula

=LAMBDA(total,profile,total*profile/SUM(profile))

Parameters

Parameter Unit Description
total currency Capital to spread
profile - Phasing weights by period, first period first (a column or a row)

Examples

Invocation Expected
=PO.ECON.Capex.Phasing(10, {1;2;2;5}) [1, 2, 2, 5]
=PO.ECON.Capex.Phasing(12, {0.25;0.5;0;0.25}) [3, 6, 0, 3]

Need a custom LAMBDA? Suggest a New Lambda