retirement

Hello, I need help moving an arrow shape in my worksheet. My Workbook has 2 Sheets: One is a Grid to display the users Current and Projected Retirement Percentage. The other is a Setup-sheet where the user enters their (Birth Date, Hire Date, Current Hourly Wage, Planned Retirement Date). When...

I'm trying to find the required corpus for the following: Present Value = 200,000 20 years to retirement 30 years total retirement Projected inflation = 2% Projected growth = 6% Annual withdrawal will be $115,000 To meet the $115,000 with 2% inflation and 6% growth requires a corpus of...

Hello, I am trying to figure out why Excel is giving me errors about the new formulas that I am creating. I have an original formula that works and gives me updates: =IF($B$3="(All)",CONCATENATE("Code ",$B$2," - Top Skills & Retirement Eligibility as of "&'Date for Charts'!C1),CONCATENATE("Code...

Hi All, I need some help to calculate earliest retirement date. I have DOB (A1) and Date of Hire (B1) earliest retirement requires age of 60 plus 10 years service. Would like to have a date return from the formula. Thank you all!

How can I insert rows automatically up to the date of retirement in the case given in the link:https://drive.google.com/file/d/1D_vjMb6vhozjY0av8jyMAt5Q70OawnhU/view?usp=drivesdk

Is there a way to create an IF formula holding the false value constant until the IF formula is false? Then after the IF formula is false, remove the constant cell reference? This may sound confusing so I will explain further. I am currently showing a retirement plan graph showing...

Creating a retirement spreadsheet. I need to get the annual average of other income (2 columns) from retirement age through life expectancy. Of course the retirement age is variable depending on the client. I couldn't figure out how to attach a sample, so I'll attempt to describe it here...

Hello MrExcel world! I am new to the forum. I wanted to get some advice on a project I am working on. The intent is to calculate current seniority percentile and then also forecast percentile change based on known retirement date. The data will look something like this: EmpId - Hire Date -...

I'm afraid to even ask this because I know someone is going to answer in a coding language that I don't understand. I have built a pretty intricate retirement calculator in excel with lots of =IF, =VLOOKUP, =SUMIF, etc. formulas. I don't know anything about macro or VGA, etc. I'm gonna try to...

This sounds simple. There are 365 days in a year so YearValue*365, right? Unfortunately no. There is not 365 days in every year, this in itself makes me sad. But I digress. So I am trying to figure out what a persons "mandatory retirement date" would be based off of certain criteria. The...

Hello all, I'm trying to calculate expected retirement dates of aircraft. The calculation is dependent on the delivery date, aircraft status, status change date, and usage. I have spent the morning working on it and thought I had it setup correctly. However, I am getting the following error...

Hello all Help needed with updating table data with dynamic range. i have two sheets. Sheet1 has data with four columns A. Seniority No B. Rank C. DOB D. DOR (Retirement) - Seniority is sequential 1 - 3000 - Ranks are say A to G - DOR - incase of retirement if rank is A or B or C then DOB + 60...