Question: Please show how to solve in Excel. I only need the discounted cash flow from queston 8. All others are completed. 65 Input Current age

Please show how to solve in Excel. I only need the discounted cash flow from queston 8. All others are completed.

65 Input Current age Retirement age Number of years until retirement Annual withdrawal (S) Number of years to withdraw Interest rate (%) 150,000 7.00% Calculation & Output Question 7 Present value of withdrawals at age 65 Annual deposit until retirement $1,366,187 $6,843 Question 8 Present value of lump sum $91,234 Discounted Cash Flow I only need the answer to this question. I have calculated all of the others

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 show how to solve in Excel. Thank you. Input Current age Retirement age Number of years until retirement Annual withdrawal ($) Number of years to withdraw Interest rate (%) Please help solve...

Please show how to solve using Excel. Input Current age Retirement age Number of years until retirement Annual withdrawal ($) Number of years to withdraw Interest rate (%) Please help solve using...

Please show how to solve in Excel. ATTENTION: jiddukrishnan & Deepureddy Please do not answer this question again. NOTE: If you have already answered this for me, please do not respond. Also, please...

Please show how to solve in Excel. NOTE: If you have already answered this for me, please do not respond. Also, please do not copy an answer that I was previoulsy given and use it as your answer, I...

Please show how to solve in Excel =150000/12 026 Input Current age Retirement age Number of years until retirement Annual withdrawal ($) Number of years to withdraw Interest rate (%) 150,000 15 7.00%...

Note: Please show how to solve in Excel and provide formulas. You have been appointed as a human resource support staff intem at SunShine company. Your first project is to develop a retirement plan...

please show formulas to use in excel for the calculations your workbook named "Investment Analysis". Please include an input area and an answer area for each problem. You will have an answer for each...

Attached is the assignment requirement and 2 previous assignments as example 1- the assignment should be zero plagiarism and similarity (no copy ans paste is accepted) 2- should be completed in the...

accounting project, need some help. got most of the answers, just would like a second look UNITED STATES SECURITIES AND EXCHANGE COMMISSION Washington, D.C. 20549 FORM 10-K ANNUAL REPORT PURSUANT TO...

1. What are the advantages and disadvantages of Rosetta Stone going public? 2. What do you think the current value of a share of Rosetta Stone is (at the time of the case)? Justify your valuation on...

The investments of Harlon Enterprises included the following cost and fair value amounts ($ in millions): Harlon accounts for its equity investment portfolio at fair value through net income. Harlon...

Consider three bonds: Alpha, Beta and Epsilon, as follows: Alpha Beta Maturity 2 1.9 4.1 Epsilon 10 7.5 Suppose an investor has constructed a portfolio Gamma consisting of $7,500 of Alona and $5,000...

13-2 A tobacconist sells four blends of pipe tobacco. Each of these blends contains three types of tobacco in the following proportions: Type of tobacco Blend K L M A 20% 50% 30% B 35 40 25 C 50 30...

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

1. Do you think that chief executives should still receive an enormous bonus even if the organisation that they have led has performed badly? List the arguments for and against.

explain the role of various people and groups in health and safety and wellbeing at work

explain the key points in the main legislation relating to health, safety and wellbeing at work