Question: please Calculate the following using the appropriate functions in Excel. At retirement, a client has two payment options: a 20-year annuity at 50,000 per year

please Calculate the following using the appropriate functions in Excel.

At retirement, a client has two payment options: a 20-year annuity at 50,000 per year starting after one year or a lump sum of 500,000 today. If the clients required rate of return on retirement fund investments is 6% per year, which plan has the higher present value and by how much?

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 Finance Questions!

Calculate the following using the appropriate functions in Excel. At retirement, a client has two payment options: a 20-year annuity at 50,000 per year starting after one year or a lump sum of...

Calculate the following using the appropriate functions in Excel.1 1. Maria has been offered a future payment of $750 two years from now. If she can earn an annual rate of 6.5%, compounded daily, on...

alculate the following using the appropriate functions in Excel.1 1. Maria has been offered a future payment of $750 two years from now. If she can earn an annual rate of 6.5%, compounded daily, on...

1. Your client is evaluating between the following two retirement options: Option 1: Pays a lump sum of $2.5 million today. Option 2: A 25-year annuity at $180,000 per year starting today. If your...

TOTAL SECTION A: 18 MARKS SECTION B (33 marks) PLEASE ANSWER ALL QUESTIONS IN SECTION B IN THE 4 PAGE BOOK AVAILABLE Question 1 (16 marks) You have been recently employed as a junior analyst at Ultra...

I really need some help on my homework assignment please. Please review the attached instructions and all that is highlighted in green is not complete. Thank you very much! IST 204: Excel Essentials...

Myob software required Note: background information at the bottom (starting form page 10) PART 1: Self-Reection 10 Marks do this rt last This reflection asks students to attend to the following two...

Personal Finance Using Discrete Dynamical Systems This project is an individual effort, but you may discuss your final answers. You should, however, do your own Excel work and prepare your own...

I need help solving my accounting project. i did 4-7 workbook which i have attached below. but 7-10 are incorrect. could someone help me correct from 7-10 quickly please. MI5965 I SEE THE LIGHT...

Nanner Corporation is trying to determine how long it takes for one product to pass through the production process. The following information was gathered regarding how many days the product spent in...

Calculate the present worth of a 4.5%, $5000 bond with interest paid semiannually. The bond matures in 10 years, and the investor desires to make 8% per year compounded quarterly on the investment.

Zara is describing a square to Marcus. Has Zara given Marcus enough information for him to work out that the quadrilateral is a square? Explain your answer. My quadrilateral has two pairs of parallel...

Discuss the policy statement concept and identify three focus areas / procedures where a clearpolicy statement / operating procedure

One important source of person needs assessment information is the potential trainees own opinions about their developmental needs. What are the advantages and disadvantages of relying on such...

Why is needs assessment so often not performed in many organizations? How could an HRD professional encourage a reluctant manager or executive to approve the time and resources necessary for a needs...

What is your response to The attack on ISD (presented in the boxed insert)? If you were an HRD professional seeking to conduct a needs assessment, how would you respond to each of these issues?