Hey bud. I know this is a bit late, but I'll chime in.
You're on the right track, but you need to use cumulative inflation rather than just the annual inflation rate.
I have found this one by far the hardest out of the past questions I have tried so far, so I have included my full worked solution at https://www.dropbox.com/s/9zerxyi8rw...ta-2.xlsx?dl=0
Cheers
Marcus
Like this thread? Share it with others