Thread: retirement plan

I’d like a function,NOT macro, to calculate whether taking early retirement <60 but >55 is economically viable. Assuming the U.K. GNP is decreasing by 5% per annum, the RPI is increasing by 6% (forecast) and property prices are falling by 10% every 3 months. This to be based on my average annual salary + or -about 10 -15 hours a week overtime (Mondays to Friday @ X 1.3 sat and Sunday @ X 1.5. Please offset cost of private vehicle against public transport which can be calculated with convenience/time X comfort.
This should all go into call H1 as a rating of X/10000 where the higher the X the better it will be for me. I expect to put salary in A1 and age in B2 and excel will calculate the rest. A look up will be required to determine what car I have from a list of 60 or so and give the rating of value based on Glass’s guide. Obviously my salary will remain confidential but let’s for calculation purposes put it in D1 and assume its >£1 and < £100,000.
A graph (bar chart not acceptable) should appear whenever cell AZ6503 is selected
Thanx in advance
MDW

very interesting and helpful sir,works exactly as stated.
however just one further question porcine aviation not being in my (ever decreasing , i must admit)skill set .how would i change this formula to include a possible lottery win?