Social Security Retirement Calculator in Google Sheets

Job ID: 39215203

Budget: $250 – $750 USD

I'm looking for a freelancer who can use Google Sheets and Apps Script to create a simple Social Security retirement calculator. This tool will help determine the most beneficial age to start receiving Social Security retirement benefits.

Key Requirements:
- The calculator should NOT include disability benefits, cost of living adjustments, tax or the annual earnings test
- It should simply determine the optimal age to file for benefits.
- Data inputs are located in Columns J to O, T to X (if needed), and Y to AA (if needed). Column L indicates whether the above inputs are necessary.
- The output results should be displayed in Columns P to S.
- The script should run for a specific row when Column AF is marked as "YES".

Ideal Candidate:
- Proficient in Google Sheets and Apps Script.
- Previous experience in creating financial calculators is a plus.
- Able to deliver a clear and concise tool that meets the specified requirements.

Please note, all eligible retirement ages should be considered for this calculation, not just disability. The output values in Columns P to S should reflect the cumulative lifetime benefits received.

Successful completion includes
* ACCURATE calculator
* All social security filing strategies considered
- if married, maximize spousal boost (know that the spouse's benefits are reduced using one scale and the spousal boost is reduced using a more aggressive reduction scale)
- if widowed, consider taking own benefits vs. starting with the deceased benefits as early as 60 then switching to their own benefits as late as age 70 after receiving increases
- if divorced, consider if benefits can be received based on the other spouse's PIA

Google Sheet: https://docs.google.com/spreadsheets/d/1a85JzXwoJxT7kFkRLPanq2Nrt7RhC6ocFIgumPJRTfU/edit?usp=sharing