Investment Appraisal of Paragon Systems in Chinese Banking Sector

Your task is to carry out an investment appraisal and identify the best investment opportunity based on your conclusions. 
Paragon systems is a financial technology company who has been approached by the Chinese government to offer FinTech solutions to Chinese Banking sector for the duration of 5 years. 
The data on which you will base your investment appraisal is available to download here. 
The Chinese government proposed an attractive annual payment, which includes a year-on-year increase (see student data file). 
If Paragon accepts the project, they will need to invest in creating a new operation unit in China. The hardware used in the unit will be depreciated using the straight-line method. At the end of year 5, the hardware of the unit will be sold for the amount indicated in the student data file. 
The annual operating costs will be a % (see the investment data you have downloaded for the exact %) of the annual revenues proposed by the Chinese government. 
In year 1 there will be the need for working capital investment (see the investment data). 
The working capital investment will be partially recovered at the end of the project in year 5 (see the investment data). 
Assume that all revenues and costs are received and paid in cash at the time they occur. 
Assume no cost of borrowing (no interest expense). 
The tax rate is 20%. 
The required rate of return is 11%.
Required
You are sitting at the executive board of Paragon Systems and you have been assigned to appraise the project using all available information. 
Specifically, you have been asked to do the following: 
Part A: Conduct investment appraisal using the following methods: 
NPV 
IRR 
PP 
Part B: Conduct a sensitivity analysis on the impact on NPV from: 
1.+5% the operating costs; and 
2.+5% initial investment cost. 
Part C: Write a report providing a clear recommendation as to whether Paragon Systems should accept or decline the offer made by the Chinese government. In your report, you should acknowledge the limitations of the methods used and reflect on the relevant theory. Also, you should be able to show awareness of the non-quantitative factors that might be relevant in the final decision for this potential investment opportunity. 
Technical specifications 
The word limit is 700 words max (exclusive of references). 
Parts A and B should be prepared and submitted as an MS Excel workbook. The workbook should contain formulas and you should avoid hard-coding the data. 
Part C should be completed and submitted as an MS Word document. 
You need to make sure you answer all the questions.
You should provide citations and references to support your calculations and your analysis/recommendations. 

Guidelines

Submit all three parts of your assignment by Monday 26 April 2021 before 12:00 midday (UK time). Remember: it may take several minutes to upload your file - leave yourself plenty of time. Late assignments will be penalised.
The word count for this task is a maximum of 700 words. The word count excludes footnotes and reference list. 
You should use the NTU Library Harvard Referencing System. Review the Academic Skills Guidebook in your New Student Orientation module for more information on correct referencing.
Save all three parts of this task using the following naming convention: 
Organisation_YourLastName_YourFirstName_Title_PartA.xls 
Organisation_YourLastName_YourFirstName_Title_PartB.xls 
Organisation_YourLastName_YourFirstName_Title_PartC.doc 
You must also include your name and N number on the first page of your assignment
This assignment uses plagiarism detection software. Remember to reference your work.
For more information on academic writing and how to avoid plagiarism, please review the information in your New Student Orientation module.