Consider again Lindsay's investment in Problem 7. The real value of Lindsay's account after 30 years of investing will depend on inflation over that period. In the Excel function = NPV(rate, value1, value2, ...), rate is called the discount rate, and value1, value 2, etc. are incomes (positive) or expenditures (negative) over equal periods of time. Update your model from Problem 7 using the NPV function to get the net present value of Lindsay's retirement fund. Construct a data table that shows the net present value of Lindsay's retirement fund for various levels of return and inflation (discount rate). Use a data table to vary the return from 0 to 12% in increments of 1% and the discount rate from 0 to 4% in increments of 1% to show the impact on the net present value.
This question was answered on: Jul 11, 2017
Need a similar solution fast, written anew from scratch? Place your own custom order
We have top-notch tutors who can help you with your essay at a reasonable cost and then you can simply use that essay as a template to build your own arguments. This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student. New solution orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.