Question
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
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started