Find the NPV for Project #1, which has a discount rate of 10% (0.10), an expected...

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

SOLUTION To calculate the net present value NPV for Project 1 well ... View the full answer