Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Applied Equity Analysis and Portfolio Management Tools to Analyze and Manage Your Stock Portfolio

Authors: Robert A.Weigand

1st edition

978-111863091, 1118630912, 978-1118630914

More Books

Students also viewed these Finance questions

Question

Differentiate tan(7x+9x-2.5)

Answered: 1 week ago

Question

Explain the sources of recruitment.

Answered: 1 week ago

Question

Differentiate sin(5x+2)

Answered: 1 week ago

Question

Compute the derivative f(x)=1/ax+bx

Answered: 1 week ago