Find the NPV for Project #1, which has a discount rate of 10% (0.10), an expected cash flow of $0 for year one, an expected cash flow of $100,000 for year two, and a project cost of $50,000. To find the present value, use the financial function for NPV: =NPV(discount rate, cash flow for year one, cash flow for year two) To find the net present value, use the Excel formula for subtraction: present value-cost of project 5 6 7 8 9 10 11 A Variable Discount rate (rate of return) Cash flow for year one Cash flow for year two Present value (use NPV function) Cost of project Net present value (use subtraction) Amount B