Question

The CFO of a major corporation is trying to decide on what project to pursue using different investment criteria Net Present Value (NPV), Payback Period, Discounted Payback Period, Internal Rate of Return (IRR), and the Profitability Index (PI). The CFO has four projects to choose between: Project W (which is a strip mine -see problem 6), Project X, Project Y, and Project Z. Additional information about each project is summarized below You can use the workspace provided to help answer questions 6-11 appropriate dscom rene is 60% Project W 200 S X Costs $8C0M today (T- appropriate dscom rote it 60% YEAR 10 appropriate dscourt rate is 8.0% YEAR Project Y appropriate dacourt farte İl 7.0% Project Z

6. Project W is a strip mine which requires you to clean up environmental damage when retiring the mine; this is why cash flows in year 5 and year 6 are negative. The NPV of Project W is closest to:

  1. $442

  2. $600

  3. $640

  4. $1440

  5. $1500

7. The CFO decides to pursue only one project, but the project is required to have an NPV greater than or equal to $500M. If more than one project satisfies this criteria, the CFO will make the decision to pick the project with the highest PI. Which project would you choose:

  1. W

  2. X

  3. Y

  4. Z

  5. None of the projects

8. For this problem only, assume the CFO only has $2000 to invest today, the CFO cannot borrow any additional funds, and any remaining funds (not invested in the projects) earns 0.0% interest. The CFO wants to maximize NPV by pursuing as many projects possible. Which project (s) would the CFO choose:

  1. W,X,Y,Z

  2. W&Y

  3. W&Z

  4. X & Z

  5. Y & Z

9. The IRR of Project X is closest to:

  1. 10.0%

  2. 12.5%

  3. 15.0%

  4. 20.0%

  5. 25.0%

10. For this problem only, assume the CFO only has $2000 to invest today, the CFO cannot borrow any additional funds, and any remaining funds (not invested in the projects) earns 0.0% interest. The CFO is considering picking the project with the highest IRR. You are hired as a consultant; how would you advise the CFO to proceed?

  1. Pick Project W because it has the highest IRR

  2. Pick Project X because it has the highest IRR

  3. Pick Project Y because it has the highest IRR

  4. Don’t use IRR to rank mutually exclusive projects, use a different criteria to pick the best project

  5. Don’t pick Project W because it has unconventional cash flows; instead, Pick Project X because it has the

    second highest IRR

11. For Project X, the discounted payback period is about _____ longer than the payback period.

  1. 3 months

  2. 4 months

  3. 6 months

  4. 7 months

  5. 10 months

0 0
Add a comment Improve this question Transcribed image text
Answer #1

The capital investment evaluation criteria –

1.         Payback Period (PBP)

            One of the most popular and widely recognized traditional methods of evaluating capital investment proposal is the payback period. It is the number of years it takes a firm to recover its original investment from net cash flows. The payback period of an investment is the length of time required for the cumulative total net cash flows from the investment to equals to total initial cash outlays.

General Rule – Earlier the better.

2.         Net Present Value (NPV)

            It is the Present value of the projects net cash flows discounted at the company’s cost of capital to the time of the initial capital outlay, minus that initial capital outlay.

General Rule – Higher the NPV, better it is.

3.         Internal rate of Return (IRR)

            IRR is the rate of return at which present value of cash inflows equals to present value of cash outflows.

General Rule – Higher the better.

4.         Profitability Index (PI)

            It is ratio of present value of cash inflows and outflows.

General Rule – Higher the better.

5.         Discounted Payback period

            It refers to the period to the period within which the present value of cash inflows completely recovers the present value of cash outflows.

General rule – Earlier the better.

Computation of NPV,IRR,PI,PBP for all Projects W,X,Y,Z

Project-W

851 Project Ww cumulative cash flows Present Cumulative value (PV Year Cash flows PVF (6%) PV $ (900.00) 1.0000 (900.00) $ (900.00) 0.9434 $ 283.02 ( 0.8900 $ 445.00$ (171.98 0 900.00 300.00 $ (600.00) 500.00 S (100.00) 800.00 $ 700.00 200.00 $ 900.00 (100.00)$ 800.00 200.00) $ 600.00 616.98 2 671.70 $ 499.71 0.7921 $ 158.42658.13 0.7473 $ (74.73)$583.41 0.7050 S (140.99) $442.4 4 10 1 Payback Period 2 Net Present value 3 Internal rate of return 4 Profitability Index 5 Discounted Payback Period 12 13 2.125 years $ 442.41 29.46% 1.40 2.26 years 16 17

Formula reference -

K1 Project W Year Cash flows cumulative cash flows PVF (696) Present value (PV) -C4 E4 C5 E5 -C6*E6 Cumulative PV 900 300 500 800 200 1/(1+0.06)AB4 1/( 1 +0.06)^B5 1/(1+0.06) B6 1/(1+0.06)AB7 -1/(1+0.06)AB8 1/(1+0.06) ΛΒ9 -G4+F5 -G6+F7 -G7+F8 100 -1/(1+0.06)B10 C10 E10 10 12 13 14 200 -G9+F10 2+0-D6)/C7 SUMI(F4:F10) IRR(C4:C10 SUM(FS:F8)/-SUM(F4,F9:F10 2+(-G6/F k Period ars Net Present value Internal rate of return Profitability Index Discounted Pa 16 k Period

Project-X

K37 18 2 Project X cumulative cash flows Present Cumulative value (PV Year Cash flows PVF(636) 19 PV ) $ (800.00) 1.0000 $ (800.00)| $ (800.00) 0.9434 0.8900 213.60 0.8396 201.51 0.7921 $ 190.10$31.63 0.7473 $ 0.7050 $ 169.19$380.16 0 800.00 240.00 S (560.00) 240.00 S (320.00) 240.00$ (80.00) 240.00 $ 160.00 240.00 $ 400.00 240.00 $ 640.00 226.42$ (573.58 $ (359.99) 158.48 2 23 4 25 179.34 210 27 1 Payback Period 2 Net Present value 3 Internal rate of return 4 Profitability Index 5 Discounted Payback Period 3.33 years $ 380.16 30 19.91% 1.48 32 3.79 years

formula reference -

17 18 2 Project X Year Cash flows cumulative cash flows PVF (636) Present value (PV) Cumulative PV 19 20 21 1/1+0.06) B20 1/(1+0.06)AB21 1/(1+0.06) B22 1/1+0.06)B23 1/(1+0.06) B24 -1/(1+0.06) B25 800 -C20 E20 -C21*E21 -C22*E22 -C23 E23 -C24 E24 -C25*E25 F20 -D20+C21 -D21+C22 -D22+C23 D23+C24 -D24+C25 -0254C26 -G20+F21 23 24 25 26 27 G21+F22 -G22+F23 -G23+F24 -G24+F25 -625+F 26 /( 1+0.06)ng2б Payback Period Net Present value Internal rate of return Profitability Index Discounted Pa 2+-D22)/C23 SUM(F20:F26) IRR(C20:C26) SUM(F21:F26)/-F20 29 31 32 G22/F23)

Project Y & Z

Project Y 35 Year Cash flows 0 1,000.00 60.00 37 till row(g) at Cost of capital (k 38 4% $ 500.00 1 Net Present value 2 Internal rate of return 10.00% 42 43 4 Project Z Present Year Cash flows PVAF(7%.30) value (PV 1.00 $ (800.0 12.409 $ 1,489.1 45 0 800.00 47 48 49 50 1-30 $ 120.00 $ 689.08 1 Net Present value 2 Internal rate of return 14.76%

formula reference-

K1 34 3 Project Y 35 Year Cash flows 0 1000 37 38 till grow(g) at Cost of capital (k) 0.04 0.08 Net Present value Internal rate of return C37/(D39-D38)+C36 (C37/-C36)+D38 43 Project Z Year Cash flows PVAF(7%.30) Present value (PV) 45 0 800 C46 D46 47 1-30 120 12.4090411835059 C47 D47 49 Net Present value Internal rate of return -SUM(E46:E47) IRR(D52:D82) 50

Add a comment
Know the answer?
Add Answer to:
6. Project W is a strip mine which requires you to clean up environmental damage when...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • No need for Explanation The CFO of a major corporation is trying to decide on what...

    No need for Explanation The CFO of a major corporation is trying to decide on what project to pursue using different investment criteria: Net Present Value (NPV), Payback Period, Discounted Payback Period, Internal Rate of Return (IRR), and the Profitability Index (PI). The CFO has four projects to choose between: Project W (which is a strip mine - see problem 6), Project X, Project Y, and Project Z. Additional information about each project is summarized below. You can use the...

  • The CFO of a major corporation is trying to decide on what project to pursue using...

    The CFO of a major corporation is trying to decide on what project to pursue using different investment criteria: Net Present Value (NPV), Payback Period, Discounted Payback Period, Internal Rate of Return (IRR), and the Profitability Index (PI). The CFO has four projects to choose between: Project W (which is a strip mine - see problem 6), Project X, Project Y, and Project Z. Additional information about each project is summarized below You can use the workspace provided to help...

  • E11-12 Ranking Capital Investment Projects Using Different Criteria [LO 11-2, 11-3,11-5,11-6] Jill Harrington, a manager at...

    E11-12 Ranking Capital Investment Projects Using Different Criteria [LO 11-2, 11-3,11-5,11-6] Jill Harrington, a manager at Jennings Company, is considering several potential capital investment projects. Data on these projects follow: Project X ProjectY Project Z $40,000 $20,000$50,000 25,400 70,000 Initial investment Annual cash inflows PV of cash inflows 25,000 45,000 10,000 33,000 Required 1. Compute the payback period for each project and rank order them based on this criterion. (Round your answers to 2 decimal places.) Payback Period Rank Project...

  • Question 2 Year DKW Inc., has two projects offering Project X and Project Y. They are...

    Question 2 Year DKW Inc., has two projects offering Project X and Project Y. They are mutually exclusive, and both require $350,000 for investment. The cost of capital is 10%. The following table are expected cash flow Project X ($) Project Y ($) 90,000 180,000 90,000 120,000 90,000 60000 90,000 50,000 90,000 50,000 90,000 2.1 Calculate Project X's the internal rate of return (IRR). Use formula of Time Value of Money to illustrate 23 Calculate payback period of both projects,...

  • CAPITAL BUDGETING CRITERIA A firm with a 13% WACC is evaluating two projects for this year's...

    CAPITAL BUDGETING CRITERIA A firm with a 13% WACC is evaluating two projects for this year's capital budget. After-tax cash flows, including depreciation are as follows 0 1 2 3 4 5 Project -$27.000 $9.000 59.000 9,000 $9.000 $9,000 Project-581,000 $25,200 $25,200 $25,200 $25,200 $25.200 - Calculate NPV for each project. Round your answers to the nearest cent. Do not round your intermediate calculations. Projects Proiect N $ Calculate IRR for each project. Round your answers to two decimal places....

  • Table Tools References Mailings Review View Help Design Layout Tell me Problem 3 Assume that you...

    Table Tools References Mailings Review View Help Design Layout Tell me Problem 3 Assume that you are the CFO at Porter Memorial Hospital The CEO has asked you to analyze two proposed capital investments: Project X and Project Y. Each project requires a net investment outay of $10,000, and the cost of capital for each project is 12 percent The projects expected net cash flows are as follows: Pr t Y Year Project X $10,000 $3,000 $1,000 $10,000 $3,000 $3,000...

  • Most Company has an opportunity to invest in one of two new projects. Project Y requires...

    Most Company has an opportunity to invest in one of two new projects. Project Y requires a $340,000 investment for new machinery with a five-year life and no salvage value. Project Z requires a $340,000 investment for new machinery with a four-year life and no salvage value. The two projects yield the following predicted annual results. The company uses straight-line depreciation, and cash flows occur evenly throughout each year. (PV of $1. FV of $1. PVA of $1, and EVA...

  • ​​​​​​ Problem 1) Take the difference between the payback period of Projects A and B, i.e.,...

    ​​​​​​ Problem 1) Take the difference between the payback period of Projects A and B, i.e., calculate: X = Payback Period of Project A - Payback Period of Project B. Select one: a)-3 b)-2 c)-1 d)0 e)1 f)2 g)3 h)Insufficient information Problem 1) What is (are) the posiive IRR(s) of Project C? Select one: a)0% b)100% c)104.3% is one of the IRRs and another IRR exists d)0% is one of the IRRs and another IRR exists e)7.7% only f)56.3% is...

  • Most Company has an opportunity to invest in one of two new projects. Project Y requires...

    Most Company has an opportunity to invest in one of two new projects. Project Y requires a $315,000 investment for new machinery with a five-year life and no salvage value. Project Z requires a $315,000 investment for new machinery with a four-year life and no salvage value. The two projects yield the following predicted annual results. The company uses straight-line depreciation, and cash flows occur evenly throughout each year. (PV of $1. FV of $1. PVA of $1. and FVA...

  • Suppose Omni Consumer Products's CFO is evaluating a project with the following cash inflows. She does...

    Suppose Omni Consumer Products's CFO is evaluating a project with the following cash inflows. She does not know the project's initial cost; however, she does know that the project's regular payback period is 2.5 years. If the project's weighted average cost of capital (WACC) is 7%, what is its NPV? Cash Flow Year $422,788 $350,000 Year 1 $330,878 Year 2 $450,000 $367,642 Year 3 $450,000 $441,170 $400,000 Year 4 Which of the following statements indicate a disadvantage of using the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT