Can someone tell me how to do these questions in excel chapter 15 questions 8 & 9 MAST 1110. Accounting fundamentals for health care. They go all the way to time period 40

174 Chapter 15 Investment Analysis-What Should We Do Next? 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? (Hint: What is the net present value of the costs of buying and operating the van over its lifetime, less the payments that will be received from the county? Are the payments from the county sufficient? If not, how much must be raised in grants before the van is purchased?) Community Health Center (CHC) is considering spending $50,000 on a blood analyzer. The annual cash profits from the machine will be $7,000 for each of the 7 years of its useful life. The board of directors wants to pursue this investmert because they think the $49,000 CHC will receive is close to the $50,000 cost. What is wrong with the board's logic? What is the IRR on the investment? How much will $5,000 invested at 3% interest be worth in 4 years if it is com- pounded annually? Quarterly? How 6. much if the interest rate is 6%? Suppose you were offered $10,000 every year at the same point in time for 10 years and you could earn a 5% inter- est rate every year. How much would 7. these cash flows be worth today? 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 neigh- borhood. The van will last 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, which includes 9. 10. Why can the IRR method lead to subopt decision-making by organizations