Finance unit 6

Using a spreadsheet program like Excel, calculate the NPV and IRR of the following scenario:

•Cost (Year 0): 10,000.

•Year 1 Return: 3,000.

•Year 2 Return: 3,000.

•Year 3 Return: 5,000.

•Discount Rate: 10%.

Using a spreadsheet program like Excel, calculate the NPV and IRR of the following scenario:

•Cost (Year 0): 10,000.

•Year 1 Return: 3,000.

•Year 2 Return: 3,000.

•Year 3 Return: 5,000.

•Discount Rate: 10%.