Escalation from Base Years to Current Year by Country

[SpartacusTNT]

Problem! I am attempting to Escalate costs from multiple base years by Country using the Countries escalation table to the Current Year (2026) then forward escalate into the future. Any assistance would be greatly appreciated.

 

[vletm]

Escalation-sheet has years and % - okay.
WBS-sheet's below has has currencies (without decimals) - okay.
What would be connection with those?
= You should able to show - Your valid expected values below 2026 with 'some-kind-of-formula' or so.
... as well as 2027 values.

 

[SpartacusTNT]

Thanks for your response. I would like to from the base year costs in WBS (1990-2025) to escalate using the %ages in the Escalation sheet by country ie: France uses Column C in the escalation sheet to escalate the costs from D2:AM2 (Years 1990 - 2025). Hope that’s makes sense. Thanks

 

[vletm]

Did You noticed below writings?
You should able to show - Your valid expected values below 2026 with 'some-kind-of-formula' or so.
... as well as 2027 values.
And ... as You know, if those Your current values has NO decimals then it will affect results!

 

[SpartacusTNT]

Hi yes I saw the response. I also realise that I need ‘some kind of formula’ that’s the problem though, if I knew what formula I needed I wouldn’t really be asking for help. Good point about the decimal places though and will adjust to 2 Thanks

 

[vletm]

Okay, You saw ...
but You seems to skip below part of it.
You should able to show - Your valid expected values below 2026
Above means that You should also have some kind of great idea - what are those values?
Without that ... of course, eg I could give some kind of formula - which gives some kind of results.
Eg ... You could test with results £1 in 2026. Would it help You?