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% |
The Dilemma at eUREKA.com Comparison of Capital Budgeting Techniques eUREKA.com is trying to decide between...
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 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, 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. 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 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 (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 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 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 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 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...