Finance unit 6

profilecl152293
finance4070u6a1.docx
Home>Business & Finance homework help>Accounting homework help>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%.

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