how do i do this on excel?

Ft C. 10 percent! b. What is the value of the stream at the end of year 5 if the cash flows are in vested in an account that pays 10 percent annually? What cash flow today (time o), in lieu of the $2,000 cash flow, would be needed to accumulate $20,000 at the end of year 5? (Assume that the cash flows for years 1 through 5 remain the same.) 9.4 Better Health Inc. is evaluating two capital investments, each of which requires an up-front (time o) expenditure of $1.5 million. The projects are expected to produce the following net cash inflows: Year 1 Project A ($) Project B ($) 500,000 2,000,000 1,000,000 1,000,000 2,000,000 600,000 N 3 a. What is each project's IRR? b. What is each project's NPV if the opportunity cost of capital is 10 percent? 5 percent? 15 percent? 9.5 Capital Healthplans Inc. is evaluating two different methods for providing home health services to its members. Both methods involve contracting out for services, and the health outcomes and revenues are not affected by the method chosen. Therefore, the net cash flows for the decision are all outflows. Here are the project- ed flows