Question: this course is Information systems and business analytics , please use excel to do everything and include screenshot of everything you will do in excel

this course is Information systems and business analytics , please use excel to do everything and include screenshot of everything you will do in excel , thanks this course is Information systems and business analytics , please use excel

Let's assume that you would like to establish a retirement plan. Develop a spreadsheet model that could be used to assist you with retirement planning. Your model should include the following input parameters: Your age in years Current total retirement savings Annual rate of return on retirement savings between 5%10% Current annual salary Expected annual percentage increase in salary 1%5% Annual salary contributed to retirement 46% Age of retirement between 55 - 70 years' old Annual expenses after retirement (current dollars) $50,000 $140,000 Rate of return on retirement savings after retirement 1%13% Income tax rate postretirement 1035% Assume Inflation rate is 36% Assume that your employer contributes up to 6% of your salary towards your retirement fund. Also you can make an additional annual contribution to your retirement fund before taxes (tax free) up to a contribution of more than $10,000 but less than $15,000. Assume that you contribute between $3,000$10,000 per year. Also, assume an inflation rate of 36%. The specific numbers should be displayed and explained in your paper. Note: This assignment uses turnitin, this link that shows how students can upload more than one file: https://help.turnitin.com/feedbackstudio/turnitin-website/instructor/making-a-submission/multiple-file

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!