a$.$ In cell C$15,$ 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 C$14)$ as the rate argument.

c$.$ Use the payments in Years $16($range C$7$:C$12)$ as the returns paid to investors. $($Hint: If a Formula Omits Adjacent Cell error warning appears, ignore it$.)$