Vienna Technology LLC is a subsidiary of SAP Corporation based in central Germany. The firm is working on a project that has a time horizon of 10 years. The table below contains the expected cash flow (in $000) over the next 10 years. The initial cost is $1,990 (in $000). Assume an 8% discount rate.

1). Calculate the projects IRR, MIRR and NPV using Excels financial functions.

2). Sensitivity analysis using Excel data table: Use the Excel to draw a chart of the NPV as a function of discount rate. The discount rates should range between 6-18%, with 1% increments.

A B 1 2 Year 3 1 4 2 5 3 6 4 75 8 6 97 10 8 11 9 12 10 13 Cash flow (5000) 320 350 350 400 400 420 375 350 375 350