Hi All,
I'm trying to use a formula to breakdown say a figure of £10,000,000 over five years but add inflation of 5% to each year so the figure wouldn't just be £2,000,000 each year.
The thing is in Year 1, I won't spend anything in Quarter 1 or Quarter 2 so hypothetically speaking I'll only spend 50% of what I should do in that first year.
I want to include the remaining unspent 50% from Year 1 across the remaining 4 years of the 5 year programme as well.
Any help would be greatly appreciated.
Kind Regards,
K
Bookmarks