Using Excel, and using Excel functions and formulas to perform all necessary calculations, provide answers to items A, B, and C in the exercise.

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:

30    

Amount to withdraw each year:

$90,000    

Years to withdraw in retirement:

20    

Interest rate:

8%

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:

20

Amount of trust fund distribution:

$25,000

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

Please discuss similarities and differences between U.S. GAAP and IFRS regarding one of the following:The recognition, measurement, and disposition of

Please discuss similarities and differences between U.S. GAAP and IFRS regarding one of the following: The recognition, measurement, and disposition of receivables. Accounting and reporting for plant assets and intangible assets. Accounting and reporting for current liabilities. Accounting and reporting for long-term liabilities such as bonds and notes. Accounting and

Using the list below, select ONE company and review their ESG-related reporting. Using this information and your own opinion, write a 400+ word memo that a

Using the list below, select ONE company and review their ESG-related reporting. Using this information and your own opinion, write a 400+ word memo that addresses the following questions. Using the ESG Reporting, explain how the company addresses each aspect – Environmental, Social and Governance In your personal opinion, does information reported

Instructions This  assignment will help students understand interface implementation as a  crucial software engineering component. You will implement the

Instructions This  assignment will help students understand interface implementation as a  crucial software engineering component. You will implement the given  interface in JAVA. Overall interface coding This assignment requires you  to write the Utilities211Code.java class which implements the  Utilities211Interface.java interface shown below. After you have written  the code for the

About an Accounting Internship  Introduction (1 paragraph).  Briefly inform the reader of the Experiential Learning Activity you took part in by

About an Accounting Internship  Introduction (1 paragraph).  Briefly inform the reader of the Experiential Learning Activity you took part in by describing:   The name, date(s), and location(s) of the experiential learning event you participated in A brief overview of the organization’s mission and how it fits with your goals. A description