Please follow the format above to answer the questions below and use excel if possible.

a. Perform a financial analysis for the project by calculating its:

NPV, [25 marks]

ROI, [10 marks]

Payback period; [using a discount rate of 8% and a 5-year projection. Use Excel to perform the above analysis, and use formulae wherever possible.

b. According to business growth forecast, there is a need to purchase additional hardware and software in Year 3, and the costs are estimated as HK$300,000 for hardware and HK$200,000 for software.

Re-calculate the NPV, ROI and payback period for this project. Open another worksheet in the spreadsheet file for this calculation.

Note that the additional hardware and software maintenance costs will take effect from Year 4.

Ex.1 - Financial Analysis