Annuities Interest Rates Analysis Tool
$30-250 USD
Paid on delivery
I help people with indexed annutities. The index annuity earns interest based on the sp500 and can vary signifcantly based on dates. One way it is measured is point to point, so if your annuiversay date is sept 5th, the only two dates of the year that matter for the sp500 is sept 5. if you choose the monthly avg, there are 12 dates that matter and that would be the 5th of every month.
The problem I am running into is I am not sure how to make a formula where I can write the date in of their policy, and it shows for the past five years what each option has done on average to see which one would could possible earn more (not a gurantee but more data to help inform the client of any changes they may make).
I am able to do it manually where I pick out which dates I want, but I have literally no idea what to do to stream line this process. I guess it would be a combination QUERY and IF formulas. Any guidance would be appricated. I have the start of a google sheet going with the progress and raw data ive made
[login to view URL]
Project ID: #38740816
About the project
Awarded to:
Hello, I have carefully reviewed your project regarding the Annuities Interest Rates Analysis Tool. I understand the complexity of the data analysis required for indexed annuities based on different measurement method More
15 freelancers are bidding on average $110 for this job
I am damn sure that I can complete this project "Annuities Interest Rates Analysis Tool" beyond your expectations and within your given time and budget. I am a specialized writer who has been providing professional w More
Hello, Google Sheets and Finance expert here. I can perfectly assist in developing an Annuities Interest Rates Analysis Tool and and can start on an immediate basis. To make your hiring decision easier, I can share the More
I am going to start your project right now. I understand the complexities of indexed annuities and can create a streamlined formula in your Google Sheet to analyze SP500 performance based on anniversary dates. By utili More
I have read and understood all your project details "Annuities Interest Rates Analysis Tool" and I feel my self the best candidate to complete this project with 100 percent accuracy. I am Faisal Mahmood, I have more More
Annuities Interest Rates Analysis Tool My name is "Usama Safdar" and I am a Ph.D degree holder which means I am highly-capable to tackle this project "Content Editor " with 100 percent accuracy. I am a professional More
As an experienced data analyst, proficient in Google Sheets and Statistical Analysis, I can provide the efficient solution you need for your indexed annuity analysis. By leveraging my expertise in navigating the Excel More
Hello Sir/Mam I am excited to offer my expertise in Data Analysis to assist . With a robust background in making case studies and projects, proficiency in R, spreadsheet tools, an More
With over 14 years of extensive experience in data science and machine learning, I possess the expertise you need to build a streamlined annuities interest rates analysis tool. My proficiency in Python and its librarie More
Annuities Interest Rates Analysis Tool I am a seasoned content writer with nearly a decade of expertise, I empower entrepreneurs, startups, and established businesses to articulate their unique value proposition. My p More
Annuities Interest Rates Analysis Tool My name is Rabia Faisal, I am working in the writing industry since 2011. During this time, I have served countless clients with a full amount of satisfaction by providing them w More
As someone who has dedicated his career to crunching numbers and extracting valuable insights from data, I am confident in my ability to assist with your Annuities Interest Rates Analysis tool. With deep skills in Pyth More
