3. The cash flows for three different alternatives are given in table below. If MARR is set at 8%, use incremental analysis between (Y and Z), (Y and X) to determine which is the best alternative? Data Alt. X Alt. Y Alt. Z Initial Cost, S Net Benefits/ Year, S 528 Life, Years 12,500 7,500 1,063 9,000 510 25 25 25

3. The cash flows for three different alternatives are given in table below. If MARR is set at 8%, use incremental analysis between (Y and Z), (Y and X) to determine which is the best alternative? Data Alt. X Alt. Y Alt. Z Initial Cost, S Net Benefits/ Year, S 528 Life, Years 12,500 7,500 1,063 9,000 510 25 25 25

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter12: Capital Investment Analysis

Section: Chapter Questions

Problem 1CMA

See similar textbooks

Similar questions

Assume a company is going to make an investment in a machine of $825,000 and the following are the cash flows that two different products would bring. Which of the two options would you choose based on the payback method?
For the cash flows shown, determine: (a) the number of possible i* values (b) the i* value displayed by the IRR function (c) the external rate of return using the MIRR method if ii = 18% per year and ib = 10% per year. Year 0 1 2 3 4 Revenues, $ 0 25,000 19,000 4000 18,000 Costs, $ −6000 −30,000 −7000 −6000 −12,000
Calculate/estimate the IRR(s) for a 6-year project with the following cash flows: CF0 = -50, CF1 =28 = CF2 = CF3 = CF4 = CF5, and CF6 = -93. In Excel, plot the NPV (= Y axis) against r (= discountrate), using r = 0%, 2%, and so on until you find all IRRs in the chart. Identify/estimate all IRRs.
Net Cash Flows and NPVs for different discount rate for projects S and L are given below Net Cash Flows ($) Discount Rate (%) NPVS NPVL Year (t) Project S Project L 0% $800 $1100 0 $(3000) $(3000) 5 554.32 1 1500 400 10 161.33 2 1200 900 15 (90.74) (259.24) 3 800 1300 20 (309.03) (565.97) 4 300 1500 ii) NPVS at 10%: d) What is the IRR for S? (Write down the equation for IRR and then Use an excel worksheet to calculate IRR Equation: Answer:
refer to below table ,Conduct a sensitivity analysis to determine the sensitivity of NPV to changes in the sales price, number of units sold, the variable costs per unit, fixed costs and the cost of capital. Set these variables’ values at 10% above and 10% below their base-case values. 2. Include a graph in your analysis with below table? 10% above Year Net Cash Flow (RM) Discount Rate (13.20%) Present Value (RM) 0 -1,217,800.00 1 -1217800 1 328,750.00 0.883392 290415.19 2 337,330.00 0.780382 263246.2 3 346,423.15 0.689383 238818.31 4 355,195.10 0.608996 216312.32 5 614,461.20 0.537982 330569.16 NPV 121561.19 10% below Year Net Cash Flow (RM) Discount Rate (10.80%) Present Value (RM) 0 -1,145,800.00 1 -1145800 1 184,000.00 0.902527 166064.98 2 185,395.00 0.814555 151014.45 3 189,459.85 0.735158 139282.93 4 193,936.89 0.6635 128677.14 5 448,143.25 0.598827 268360.17…
What is the NPV of the following cash flows if the required rate of return is 0.13? Year 0 1 2 3 4 CF -3,241 2,952 1,242 3,310 1,616 Enter the answer with 2 decimals (e.g. 1000.23).
What is the payback period for the following set of cash flows? (Round answer to two decomals, i.e. 32.16) Period Cash Flow 0 -6700 1 2200 2 3800 3 1000 4 4000
Net Cash Flows and NPVs for different discount rate for projects S and L are given below Net Cash Flows ($) Discount Rate (%) NPVS NPVL Year (t) Project S Project L 0% $800 $1100 0 $(3000) $(3000) 5 554.32 1 1500 400 10 161.33 2 1200 900 15 (90.74) (259.24) 3 800 1300 20 (309.03) (565.97) 4 300 1500 e) What is the IRR for L? (Write down the equation for IRR and then Use an excel worksheet to calculate IRR Equation: Answer: f) What is the cross-over rate? (Write down the equation for IRR and then Use an excel worksheet to calculate IRR Equation: ANSMER:
Project A has the following estimated cash flows and present values:Year Cash flow $ Discount factor@ 12% Present value $0 Cost (95 000) 1.0 (95 000) 1–5 Contributionper annum 50 000 3.605 180 250 1–5 Fixed costsper annum (25 000) 3.605 (90 125) 5 Residual value 20 000 0.567 11 340 The benefit of using sensitivity analysis in an investment appraisal would be:
Project Y has following cash flows: C0 = -800, C1 = +6,000, and C2 = -6,000. Calculate the IRRs for the project: For what range of discount rates does the project have positive NPV (Plot a graph with NPV on the vertical axis and discount rate on the horizontal axis).
Incremental cash flow is calculated as (cash flowB− cash flowA), where B represents the alternative with the larger initial investment. If the two cash flows were switched wherein B represents the one with the smaller initial investment, which alternative should be selected if the incremental rate of return is 20% and the MARR is 15%? Explain.
Solve, a. Calculate the IRR for each of the three cash-flow diagrams that follow. Use EOY zero for (i) and EOY four for (ii) and (iii) as the reference points in time. What can you conclude about “reference year shift” and “proportionality” issues of the IRR method? b. Calculate the PW at MARR=10 % per year at EOY zero for (i) and (ii) and EOY four for (ii) and (iii). How do the IRR and PW methods compare?