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

Handy Headphones is an Irish company that is manufacturing lightweight, flexible, Bluetooth[1] enabled and waterproof headphones. It is proving to be

Handy Headphones is an Irish company that is manufacturing lightweight, flexible, Bluetooth[1] enabled and waterproof headphones. It is proving to be very popular among people wanting to listen to music in the shower or while swimming on holiday or at community leisure centers lane swimming sessions (mainly because of their 159 price tag). Before the

Module 5: Discussion Forum In this week’s Required Readings from your course textbook, you have a specific and detailed example of hedging a forecasted for

Module 5: Discussion Forum In this week’s Required Readings from your course textbook, you have a specific and detailed example of hedging a forecasted foreign currency transaction to hedge an anticipated but not yet committed purchase of inventory using a foreign currency cash flow hedge (Case 3 on Pages 572-574) and hedging an unrecognized foreign

Hsjusbsbsbdhdhene

Hsjusbsbsbdhdhene sbsndndnjxjxjfkdjdjsisiiseiieiejrjdjiejeuieiejjeejgeygvwcwcwcxxqxfaajannsmsmsmsowlwbsvshsiwhejeowjsegheieududhtwiwowpwbwjeuebibjsiebuebeiebsuebwowbwiebeibsowbwo93hshshshhsbebsjsjshshdyehdhdhdrjrjdirbdjdjbdjdbejsebeiuwgdidhd8dbdbdjdbbdmmsjshejueusowowjw9qgwiehegeiehejeoejeiehe9ejejeheiehdidbsjduueehueehjeehsusjsienienbsgshduevgtwhwowpebdbjoabeheiwvueeksvejeenejdbuhdbeoe eiennejejejebsjisejeoejbdjdbebddonbsheeiejiejeijeje ejeieiehgeeiejeu9ewhe8hh

You should refer to the FASB Accounting Standards Codification (FASB ASC), specifically, when answering some of the questions below:For foreign-currency

You should refer to the FASB Accounting Standards Codification (FASB ASC), specifically, when answering some of the questions below: For foreign-currency related transactions, whether they are accounts receivable or accounts payable denominated in a foreign currency, describe briefly how such transactions are recorded and reported on the income statement when

Summative assessment There will be one summative assessment which involves a comprehensive analysis of the financial and non-financial performance of an

Summative assessment There will be one summative assessment which involves a comprehensive analysis of the financial and non-financial performance of an international organization (of your choice) and its closest competitor. You are required to select an international organization (company A), identify its closest competitor (company B), and analyse their financial