Use Template $16$

which is a template to create a net present value NPV analysis. Answer all the questions asked in Problem $8$ on your Excel file. problem $8$: The Ward County Hospital Center $($WCHC$)$ wants to buy a new mobile primary care van to use in screening residents in an underserved local neighborhood. The van will last for $5$ years and costs $$68,000.$ WCHC will pay for the acquisition and maintenance of the van partially from foundation grants and partially from receipts from the county health department. The county has agreed to reimburse WCHC $$15$ for each patient it screens using the new van. They expect to have $800$ patients per year with the van. It will cost $$3,000$ per year to maintain the vehicle, and includes all relevant costs. WCHC uses a discount rate of $5\%.$ How much will WCHC need in foundation grants this year to make the purchase break$-$even financially?