#### Question Details

##### (Solution) - Consider again Lindsay s investment in Problem 7 The real value

Brief item decscription

Solution download

Item details:

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.

About this question:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Jul 11, 2017

Solution~000261588411.zip (18.37 KB)

Buy this answer for only: \$15

Pay using PayPal (No PayPal account Required) or your credit card. All your purchases are securely protected by PayPal.

### 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.