Consider again Lindsay's investment in Problem 7. The real value of Lindsay's account after 30 years of
Question:
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.
Net Present ValueWhat is NPV? The net present value is an important tool for capital budgeting decision to assess that an investment in a project is worthwhile or not? The net present value of a project is calculated before taking up the investment decision at... Discount Rate
Depending upon the context, the discount rate has two different definitions and usages. First, the discount rate refers to the interest rate charged to the commercial banks and other financial institutions for the loans they take from the Federal...
Step by Step Answer:
Essentials of Business Analytics
ISBN: 978-1305627734
2nd edition
Authors: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson