Using Excel, and using Excel functions and formulas to perform all necessary calculations, provide answers to items A, B, and C in the exercise. Submissions with only numbers and no formulas or functi

Using Excel, and using Excel functions and formulas to perform all necessary calculations, provide answers to items A, B, and C in the exercise. Submissions with only numbers and no formulas or functions will not receive credit for this assignment. Your submission must be neatly organized and must clearly present your work and results. This week, you will finish working on the Excel Master It! Problem at the end of Chapter 5 on page 166 of your text. This problem is a classic retirement problem that utilizes Time Value of Money principles. It is due at the end of the week.

You will need to provide answers to items a, b, and c in the exercise, using Excel to present your calculations. You must use functions and formulas to perform all necessary calculations. Submissions with only numbers and no formulas or functions will not receive credit for this assignment. Your submission must be neatly organized and must clearly present your work and results.

This is a classic retirement problem. A friend is celebrating her birthday and wants to start saving for her anticipated retirement. She has the following years to retirement and retirement spending goals:

Years until retirement:

Amount to withdraw each year:

$90,000

Years to withdraw in retirement:

Interest rate:

Because your friend is planning ahead, the first withdrawal will not take place until one year after she retires. She wants to make equal annual deposits into her account for her retirement fund.

If she starts making these deposits in one year and makes her last deposit on the day she retires, what amount must she deposit annually to be able to make the desired withdrawals at retirement?

Suppose your friend just inherited a large sum of money. Rather than making equal annual payments, she decided to make one lump-sum deposit today to cover her retirement needs. What amount does she have to deposit today?

Suppose your friend’s employer will contribute to the account each year as part of the company’s profit-sharing plan. In addition, your friend expects a distribution from a family trust several years from now. What amount must she deposit annually now to be able to make the desired withdrawals at retirement?

Employer’s annual contribution:

$ 1,500

Years until trust fund distribution:

Amount of trust fund distribution:

$25,000

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

In this assignment, you will be asked to find specific information related to the area and perimeter of a backyard you are designing. Access the Unit IV Assignment worksheet. Be sure to carefully read

In this assignment, you will be asked to find specific information related to the area and perimeter of a backyard you are designing. Access the Unit IV Assignment worksheet. Be sure to carefully read all instructions given, and incorporate all work into the worksheet. Once you have answered all of the questions

As a person, you have most likely cast a vote for something at some point in your life. Discuss the following with the class: In your past experiences, describe three instances where a voting meth

As a person, you have most likely cast a vote for something at some point in your life. Discuss the following with the class: In your past experiences, describe three instances where a voting method was used. What was being voted on? What or who were your options? Which voting method

This course contains a Course Project, which will be due at the end of Week 7. There is a template for the project: Link to Course Project TemplateLinks to an external site.Open this document with Rea

This course contains a Course Project, which will be due at the end of Week 7. There is a template for the project: Link to Course Project TemplateLinks to an external site.Open this document with ReadSpeaker docReader Links to an external site. The key information and instructions related to the project

This course contains a Course Project, which will be due at the end of Week 7. There is a template for the project: Link to Course Project TemplateLinks to an external site.Open this document with Rea

This course contains a Course Project, which will be due at the end of Week 7. There is a template for the project: Link to Course Project TemplateLinks to an external site.Open this document with Rea This course contains a Course Project, which will be due at the end of

This course contains a Course Project, which will be due at the end of Week 7. There is a template for the project: Link to Course Project TemplateLinks to an external site.Open this document with Rea

This course contains a Course Project, which will be due at the end of Week 7. There is a template for the project: Link to Course Project TemplateLinks to an external site.Open this document with Rea This course contains a Course Project, which will be due at the end of

determine the equation of a line through the points (3,6) that is perpendicular to 3x-7y=8.

Question content area topPart 1Find the area of the figure.12 yd4 yd8 yd7 yd9 ydQuestion content area bottomPart 1Use the following formula.Total areaTotal areaequals=area of a parallelogramplus+area

Question content area topPart 1Find the area of the figure.12 yd4 yd8 yd7 yd9 ydQuestion content area bottomPart 1Use the following formula.Total areaTotal areaequals=area of a parallelogramplus+area of trapezoidequals=1212times•enter your response hereplus+one half12times•enter your response heretimes•(enter your response hereplus+88)equals=enter your response hereplus+8484equals=enter your response here yd squared

Learning Outcome 2.1-2.6: Exploring COVID-19 Data Graphically Recall the initial steps to a statistical investigation: Devise a research questionProduce dataExplore the dataIn this activity, we will p

Learning Outcome 2.1-2.6: Exploring COVID-19 Data Graphically Recall the initial steps to a statistical investigation: Devise a research question Produce data Explore the data In this activity, we will practice the crucial step of making some initial sense of data so that it can be usefully interpreted. You will also

The following question will give you a chance to self-evaluate, to think about what you’ve been learning in this course, and to draw your own conclusions about how you can apply your results driven sk

The following question will give you a chance to self-evaluate, to think about what you’ve been learning in this course, and to draw your own conclusions about how you can apply your results driven skill in your life. Please respond in a paragraph of at least 5-7 sentences to fully

Your team will write a paper collaboratively. The paper must be typed and including the following items: Project titleList of team membersIntroduction: You will discuss why the topic is interesting to

Your team will write a paper collaboratively. The paper must be typed and including the following items: Project title List of team members Introduction: You will discuss why the topic is interesting to you and why it is important to study. Then you need to explain your question of interest pertaining

Math 125 Survey of special topics in mathematics Topic: research an ancient or contemporary mathematician or scientist. Format Directions: 1. A single page, single space, or no more than two pages

Math 125 Survey of special topics in mathematicsTopic: research an ancient or contemporary mathematician or scientist. Format Directions: 1. A single page, single space, or no more than two pages single or doubleSpace. The Paper should contain an introduction that includes the nameof the Mathematician or scientist being researched, The

PROBLEM SET 2 Directions The file linked below is to Problem Set 2.ONLY do the questions that correspond to your assigned number.To post your response, select the button below and then select the “St

PROBLEM SET 2 Directions The file linked below is to Problem Set 2. ONLY do the questions that correspond to your assigned number. To post your response, select the button below and then select the “Start a New Thread” button. Finally, title your response with your assigned number. Place your solutions

PROBLEM SET 3 Directions The file linked below is to Problem Set 3.ONLY do the questions that correspond to your assigned number.To post your response, select the button below and then select the “S

PROBLEM SET 3 Directions The file linked below is to Problem Set 3. ONLY do the questions that correspond to your assigned number. To post your response, select the button below and then select the “Start a New Thread” button. Finally, title your response with your assigned number. Place your solutions

PROBLEM SET 2 Directions The file linked below is to Problem Set 2.ONLY do the questions that correspond to your assigned number.To post your response, select the button below and then select the “St

Each answer must have all the steps that you used to arrived to each answer

Directions The file linked below is to Problem Set 3.ONLY do the questions that correspond to your assigned number.To post your response, select the button below and then select the “Start a New Thre

Directions The file linked below is to Problem Set 3. ONLY do the questions that correspond to your assigned number. To post your response, select the button below and then select the “Start a New Thread” button. Finally, title your response with your assigned number. Place your solutions to your questions

Directions The file linked below is to Problem Set 3.ONLY do the questions that correspond to your assigned number.To post your response, select the button below and then select the “Start a New Thre