Question: steps through excel would be appreicated (Present value of complex cash flows) How much do you have to deposit today so that beginning 11 years

steps through excel would be appreicated

(Present value of complex cash flows) How much do you have to deposit today so that beginning 11 years from now you can withdraw $12,000 a year for the next 8 years (periods 11 through 18) plus an additional amount of $24,000 in the last year (period 18)? Assume an interest rate of 12 percent. The amount of money you have to deposit today is $ (Round to the nearest cent.)

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!

Please answer ALL questions: 2. (Calculating rates of return) The S&P stock index represents a portfolio comprised of 500 large publicly traded companies. On December 24, 2007, the index had a value...

present value of complex cash flows 12 of 12 (10 complete) HW Score: 77.78%, 9.33 of 12 pts Score: 0 of 1 pt P6-52 (similar to) Question Help (Present value of complex cash flows) How much do you...

I need help with these questions (Related to Checkpoint 6.4) (Present value of a perpetuity) What is the present value of a $95 perpetuity discounted back to the present at 9 percent? EGOOD The...

Please do not use ChatGPT to try and answer this question, it does not work. Here is the feedback given from class on previous attempts to answer. Thank you in advance. (Present value of complex cash...

Let's try to answer this question again with the addition of the feedback given for solving the problem. Please keep in mind this is a multi-part question. Thank you in advance (Present value of...

(Present value of complex cash flows) How much do you have to deposit today so that beginning 11 years from now you can withdraw $11,000 a year for the next 4 years (periods 11 through 14) plus an...

(Present value of complex cash flows) How much do you have to deposit today so that beginning 11 years from now you can withdraw $13,000 a year for the next 6 years (periods 11 through 16) plus an...

(Present value of complex cash flows) How much do you have to deposit today so that beginning 11 years from now you can withdraw $12,000 a year for the next 6 years (periods 11 through 16) plus an...

( Present value of complex cash flows ) How much do you have to deposit today so that beginning 1 1 years from now you can withdraw $ 1 4 , 0 0 0 a year for the next 8 years ( periods 1 1 through 1 8...

The Harding Company manufactures skates. The company's income statement for 2013 is as follows: Sales (10,500 skates @ $60 each).....................$630,000 Less: Variable costs (10,500 skates at...

Today's world is very different from the world in which your grandparents lived. Tremendous advancements in technology have led to significant changes in the economy and in society. Imagine you are...

Product Cost in Total and Per Unit Refer to the information for Grin Company. Grin Company manufactures digital cameras. In January, Grin produced 4,000 cameras with the following costs: Direct...

Chapter 12 Responsibility Accounting, Operational Performance Measures, and the Balanced Scorecard em 12-41 ng Responsibility Hotel The following partial organization chart is an extension of Exhibit...