Find the net present value-internal rate of return

Assignment Help Financial Management

Reference no: EM131055060

For the following two mutually-exclusive projects, use Excel to find the net present value (NPV), internal rate of return (IRR), and the profitability index (PI). Assume the cost of capital (discount rate) is 8%. Which project should be accepted? Is there a conflict between NPV and IRR? If the discount rate is 12%, is there a conflict between NPV and IRR? Which project should be accepted if the discount rate is 12%?

Graph the NPV profile for both projects. What is the crossover point (i.e., at what rate do the two projects have the same NPV)?

Year: Project A Cash Flows: Project B Cash Flows:

0 ($14,000) ($14,000)

1 $6000 $3000

2 $5000 $3000

3 $5000 $5000

4 $2000 $5000

5 $2000 $6000

Please use Excel to solve

Reference no: EM131055060

Questions Cloud

What is the loans effective annual rate : A loan is offered with monthly payments and a 10.75 percent APR. What’s the loan’s effective annual rate (EAR)?

What is the current price of the firm stock : Dartsch Corporation just paid a dividend of €1.45. Dartsch is expected to increase its dividend by 12 percent for the next five years, thereafter the firm’s dividends are expected to grow at a more modest rate of 4 percent indefinitely. If the requir..

Straight-line depreciation to a zero book value over life : Lewis Industries looking at a project that will require a $100,000 investment in fixed assets and another $15,000 in net working capital, which will be recovered at the end of the project. The project is expected to produce sales of $110,000 with ass..

By what factor will the moment of inertia change : By what factor will the moment of inertia change?

Find the net present value-internal rate of return : For the following two mutually-exclusive projects, use Excel to find the net present value (NPV), internal rate of return (IRR), and the profitability index (PI). Assume the cost of capital (discount rate) is 8%. Which project should be accepted? Is ..

(raw) material costs - labor costs : Which questions do we have to answer? 1) What are the relevant cash flows? Should we consider the erostion of the existing product?

What equity multiplier is required to desired rate of growth : In recent years, Lantana Enterprises has had a 40 percent dividend payout ratio and has generated a 6 percent profit margin. They would like to continue to maintain both of these while achieving a sustainable growth rate of 4.5 percent. Lantana has a..

Provide an overview of the case study- starbucks coffee : Provide an overview of the case study and Pros and Cons of the brand/product/company/industry in the case (point form).

Find the total power radiated into space by the sun : From this, determine the power per unit area arriving at the Earth, 1.5? 1011 m away.

User Account

All Pages