Finding required growth rate
Hi,
I'm working on a pensions spreadsheet and I'm looking to find a formula that will return the required annual growth rate given the opening 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 closing balance of £60,000? Any assistance greatly appreciated. Thanks * Managed to solve this using the RATE function which I hadn't come across before. |
All times are GMT +1. The time now is 02:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com