Question

Go-to-the-Investment-worksheet. This worksheet-should-show.the-returns-potential investors-could-realize-ifthey invested $165,000-in-the-Neighborhood Nurse program.. Pranjali-figures-a-desirable rate-of-return-would-be-7.3.percent. She estimates the investment-would-pay different amounts-each-year-(range-C7:C12) and wants to calculate the present.value-of-the-investment

 

Calculate the present-value-of-the-investment-as-follows:

a. In cell-C15, enter a formula that uses the NPV-function to calculate the present value-of-the-investment-in-a-medical-van-for-the-Neighborhood-Nurse-program. 

b. Use the desired-rate-of-return value (cell-C14).as-the-rate argument. 

c. Use the payments-in-Years 1-6 (range 07:C12) as the returns paid to investors. (Hint: If a Formula Omits. Adjacent-Cell error warning appears, Ignore-it.)

Answer 1

In case of any query do comment. Please rate answer as well. Thanks

Answer:

Use below formula:

=NPV(C14,C7:C12)

where your rate is in cell C14 and returns paid to the investors are in range C7:C12

Below is the output: Here data is assumed, you have to use your own data which you got from the Neighborhood Nurse program