Finding required growth rate

[raith99]

Hi,

I'm working on a pensions spreadsheet and I'm looking to find a formul
that will return the required annual growth rate given the openin
balance, closing balance, period and deductions.

For example,
The opening balance is £100,000
Annual deductions at start of each year - £5,000
Period - 10 years
Required closing balance - £60,000

How do I calculate the annual growth rate required to get the closin
balance of £60,000?

Any assistance greatly appreciated.

Thank