Pandora is considering a new development project that costs RM2.1 m, which will have a tenure of 6 years. The company spends 30% of the project cost to acquire fixed assets which can be disposed at the end of the project for 50% of the value. The cash flow of the project is as follows:

Year 1: RM800,000

Year 2: RM1,000,000

Year 3: RM1,000,000

Year 4: RM1,500,000

Year 5: RM700,000

Year 6: RM250,000

The company's cost of capital is 6.03%.

1.The payback period of the project

2.The PV of cash flow year 2 is RM

3.The PV of cash flow year 4 is RM

4.Total Present Value of the project is RM

5.The FV of cash flow year 3 is RM

6.Total FV of the project is RM___________.

7. Discounted payback period is ________.

8. NPV is RM____________,

9. PI is __________.

10. IRR is ________%.

11. MIRR is _______%.

Can help me do in form of excel worksheet.