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
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 inves