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

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

In: Other

Don't use plagiarized sources. Get Your Custom Essay on
Calculate the present-value-of-the-investment-as-follows:
Just from \$8 /Page 0r 300 words

### Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now