Question

The Dilemma at eUREKA.com Comparison of Capital Budgeting Techniques eUREKA.com is trying to decide between two alterntive machines. They are aware that they have several methods to evaluate and compare the alternatives. They give the task of evaluating the two alternatives using different techniques to Tolga and Aisha. They work a day and invite the department for a meeting the next morning. That morning all department members gather together to go over the problems from beginning to the end. Tolga and Aisha go aver their calculations step by step trying to explain to the members of the department the caveats of the methods and how they should be used if chosen as the decision making criteria. Thye put the slide with the following cash flows to the screen and ask for everyone to take a very careful look at the numbers. Year Simtotech Valarium 350000 600000 650000 1. Calculate the Payback Period of each project. should make to show that the Payback Period is not appropriate in this case. Calculate the Discounted Payback Period (DPP) using 10% as the discount rate. Should Tolga and Aisha ask the Department Head to use DPP as the deciding factor? Explain. Calculate the two projects IRR. How should Tolga and Aisha convince the Department Head that the IRR measure could be misleading? Construct the NPV profile graphic for the two projects and explain the relevance of the crossover point. How should Tolga and Aisha convince the Board that the NPV method is the way to go? Explain what argument Tolga and Aisha 2. 4. S. Explain how Tolga and Aisha can show that the Modified Internal Rate of Return is the more realistic measure to use in the case of mutually exclusive projects. You may use 10% as the reinvestment rate.​​​​​​6. Calculate the Profitability Index for each proposal. Can this measure help to solve the dilemma? Explain. In looking over the documentation prepared for the two machines, it appears to you that the simtotech analysis has been somewhat more conservative in its revenue projections than the valarium team. What impact might this have on your analysis? In looking over the documentation prepared for two machines, it appears to you that the simtotech technology would require extensive development before it could be implemented whereas the valarium technology is available off-the-shelf. What impact might this have on your analysis? 7. 8.

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

1: Payback of S is 2.5 years while that of V is 1.5 years. Since the initial investment varies a lot, this is mot a suitable measure.

2: Discounted payback of S= 2.94

V= 3.92

Again due to changes in the initial investment this is not the conclusive method. This is better than the payback method since it takes into account the timing of cash flows.

3: IRR of S= 36.63%, V= 42.91%

This means that the returns of V vary. However due to scale of the project being different this cannot be the deciding factor.

4:

Disount rate NPV S NPV V
20% 453575.10 328215.02
29% 175279.12 173445.08
29% 172671.75 171948.06
29.17% 170852.05 170902.71
29.50% 162333.66 166002.76
30% 149613.65 158666.07
31% 124829.84 144301.22
32% 100888.78 130334.40
33% 77753.59 116750.25
40% -64348.19 31231.03
50% -220164.61 -67489.71

Crossover rate is that at which the NPV of two projects is equal. NPV is the better method since it takes into account the time value of money and the project which yields the most value is selected.

WORKINGS

Year S Cumulative
cash flow
Discounted CF Cumulative
discounted CF
V Cumulative
cash flow
Discounted CF Cumulative
discounted CF
0 -1000000 -1000000 -1000000 -1000000 -800000 -800000 -800000 -800000
1 350000 -650000 318181.8182 -681818.1818 600000 -200000 -181818.1818 -981818.1818
2 400000 -250000 330578.5124 -351239.6694 400000 200000 165289.2562 -816528.9256
3 500000 250000 375657.4005 24417.73103 300000 500000 375657.4005 -440871.5252
4 650000 900000 443958.746 468376.477 200000 700000 478109.4188 37237.89359
5 700000 1600000 434644.9261 903021.4032 200000 900000 558829.1908 596067.0843
Payback 2.5 1.5
Discounted payback 2.935 3.922114286
IRR 36.63% 42.91%

Book1 Excel Sign in - File InsertDrawPage Layout FormulasData Review View Tell me what you want to do & Share Home Calibri Wrap Text General 田EE Paste Merge & Center-5 . % , 4,0ナ Conditional Format as Cell Insert Delete Format . Sort & Find & 経垣 Formatting Table Styles Styles Filter Select Clipboard Font Alignment Number Cells Editing A1 Year Cumulative cash flow Discounted CF Cumulative Cumulative cash flow Year Discounted CF Cumulative discounted CF discounted CF 1000000B2 350000 C2+B3 400000 C3+B4 500000C4+B5 650000 C5+B6 700000 C6+B7 B2/1.1AA2 D2 B3/1.1A3 E2+D3 B4/1.1AA4 E3+D4 -B5/1.1 AS E4+D5 B6/1.1 A6 E5+D6 800000-F2 600000 G2+F3 400000 -G3+F4 300000G4+F5 200000 G5+F6 200000 G6+F7 -62/1.1%2 H2 -G3/1.1AA3 12+H3 -G4/1.1AA4 13+H4 6 4 G6/1.1 A6 -15+H6 9 Payback 10 Discounted payback 11 IRR 12 13 14 -2+(-C4/B5) -2+-E4/D5 IRR(B2:B7) 1+(-G3/F4) 3+(-15/H6) IRR(F2:F7) Sheet1 Sheet2 Ready + 100 C ENG 7:19 PM

Book1 Excel Sign in - File InsertDrawPage Layout FormulasData Review View Tell me what you want to do & Share Home Calibri 쿤므 wrap Text General ▼ Paste ta t. Merge & Center-5 . % , 4,04% Conditional Format as Cell Insert Delete Format . Sort & Find & Formatting Table Styles Styles Filter Select Clipboard Alignment Number Cells Editing A2 Discount rate Chart Title 2 Disount rate NPV S З 20% NPV V 453575.10 328215.02 500000.00 400000.00 7 29% 8 29% 9 29.17% 10 29.50% 11 30% 12 31% 13 32% 14 33% 15 40% 16 50% 17 175279.12 173445.08 172671.75 171948.06 170852.05 170902.71 162333.66 166002.76 149613.65 158666.07 124829.84 144301.22 100888.78 130334.40 77753.59 116750.25 -64348.19 31231.03 220164.61-67489.71 00000.00 200000.00 100000.00 0.00 100000.00 -200000.00 300000.00 400000.00 10% 400 NPV S NPVV . Linear (NPV VLinear (NPV S) Sheet1 Shet2 Ready + 100 C ENG 7:21 PM

Add a comment
Know the answer?
Add Answer to:
​​​​​​ The Dilemma at eUREKA.com Comparison of Capital Budgeting Techniques eUREKA.com is trying to decide between...
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
  • 1. The most popular capital budgeting techniques used in practice to evaluate and select projects are...

    1. The most popular capital budgeting techniques used in practice to evaluate and select projects are payback period, Net Present Value (NPV), and Internal Rate of Return (IRR). 2. Payback period is the number of years required for a company to recover the initial investment cost. 3. Net Present Value (NPV) technique: NPV is found by subtracting a project’s initial cost of investment from the present value of its cash flows discounted using the firm’s weighted average cost of capital....

  • please explain! thank you 41 Capital Budgeting Exercises: Inree independent projects are under consideration for capital...

    please explain! thank you 41 Capital Budgeting Exercises: Inree independent projects are under consideration for capital budgeting purposes. Their respective initial investment, cost of capital, and cash flows are provided below. Use the following capital budgeting techniques to evaluate all three projects and indicate which project should be undertaken, assuming there is no budget constraint A. Payback period method Discounted payback period method Net present value method IRR method B. C. D. Project 1 Project 2 Project 3 Initial Investment...

  • All techniques with NPV profile - Mutually exclusive projects Projects A and B, of equal risk,...

    All techniques with NPV profile - Mutually exclusive projects Projects A and B, of equal risk, are alternatives for expanding Rosa Company's capacity. The firm's cost of capital is 16%. The cash flows for each project are shown in the following table: PF a. Calculate each project's payback period. b. Calculate the net present value (NPV) for each project. c. Calculate the internal rate of return (IRR) for each project. d. Indicate which project you would recommend. a. The payback...

  • Case Study 3--Capital Budgeting (Comprehensive Spreadsheet Problem 11-23, page 408) Your division is considering two projects....

    Case Study 3--Capital Budgeting (Comprehensive Spreadsheet Problem 11-23, page 408) Your division is considering two projects. Its WACC is 10%, and the projects' after-tax cash flows (in millions of dollars) would be as follows: Expected Cash Flows Time Project A Project B 0 ($30) ($30) 1 $5 $20 2 $10 $10 3 $15 $8 4 $20 $6 a.   Calculate the projects' NPVs, IRRs, MIRRs, regular paybacks, and discounted paybacks. WACC = 10% Use Excel's NPV function as explained in NPVA...

  • All techniques, conflicting rankings Nicholson Roofing Materials, Inc., is considering two mutually exclusive projects, each with...

    All techniques, conflicting rankings Nicholson Roofing Materials, Inc., is considering two mutually exclusive projects, each with an initial investment of $190,000. The company's board of directors has set a 4-year payback requirement and has set its cost of capital at 8%. The cash inflows associated with the two projects are shown in the following table: a. Calculate the payback period for each project. Rank the projects by payback period. b. Calculate the NPV of each project. Rank the project by...

  • KEY TERMS Define the following terms: a. Capital budgeting; strategic business plan b. Net present value...

    KEY TERMS Define the following terms: a. Capital budgeting; strategic business plan b. Net present value (NPV) c. Internal rate of return (IRR) d. NPV profile; crossover rate e. Mutually exclusive projects; independent projects f. Nonnormal cash flows; normal cash flows; multiple IRRS g. Modified internal rate of return (MIRR) h. Payback period; discounted payback CAPITAL BUDGETING CRITERIA You must analyze two projects, X and Y. Each project costs $10,000, and the firm's WACC is 12%. The expected cash flows...

  • Alice Werd is a new project analyst; he is working on capital budgeting analysis of two...

    Alice Werd is a new project analyst; he is working on capital budgeting analysis of two mutually exclusive projects. The followings are the cash flow forecasts for both the projects years Project A Expected Cash flows Project B Expected Cash flows 0 (1000,000) ($900,000) 1 50000 650,000 2 200,000 650,000 3 600,000 550,000 4 1000,000 300,000 5 1500,000 100,000 The following metrics presents the key information based on capital budgeting indicators. For purposes of analysis, he plans to use a...

  • QUESTION 3: CAPITAL BUDGETING [30 MARKS] Swee Rien Roofing Materials, Inc., is considering two mutually exclusive...

    QUESTION 3: CAPITAL BUDGETING [30 MARKS] Swee Rien Roofing Materials, Inc., is considering two mutually exclusive projects, each with an initial investment of RM1,500,000. The company’s board of directors has set a maximum 4-year payback requirement and has set its cost of capital at 9.50 percent. The cash inflows associated with the two projects are shown in the following table. Cash inflows (CFt) Year Project A (RM) Project B (RM) 1 450,000 750,000 2 450,000 600,000 3 550,000 300,000 4...

  • You are a Financial Analyst with ABC Ltd and the chief financial officer (CFO) requests you to evaluate two new capital budgeting proposals. Specifically, you are asked to provide a recommendation and...

    You are a Financial Analyst with ABC Ltd and the chief financial officer (CFO) requests you to evaluate two new capital budgeting proposals. Specifically, you are asked to provide a recommendation and also respond to a number of questions aimed at assessing your level of competence in capital budgeting process. Instructions are as follows: Provide an evaluation of two proposed projects, both with identical initial outlays of $400,000. Both of these projects involve additions to a client’s highly successful product...

  • P10–24 All techniques: Decision among mutually exclusive investments Pound Industries is attempting to select the best...

    P10–24 All techniques: Decision among mutually exclusive investments Pound Industries is attempting to select the best of three mutually exclusive projects. The initial investment and after-tax cash inflows associated with these projects are shown in the following table. LG 2 LG 3 LG 4 LG 5 LG 6 LG 2 LG 3 LG 4 LG 5 LG 6 Project A Project B Initial investment (CF0) $130,000 $85,000 Year (t) Cash inflows (CFt) 1 $25,000 $40,000 2 35,000 35,000 3 45,000...

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