Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

1. How do most insects respire ?

Answered: 1 week ago

Question

Who is known as the father of the indian constitution?

Answered: 1 week ago

Question

1.explain evaporation ?

Answered: 1 week ago

Question

Who was the first woman prime minister of india?

Answered: 1 week ago

Question

Explain the concept of going concern value in detail.

Answered: 1 week ago

Question

1. Who will you assemble on the team?

Answered: 1 week ago