Question

You are a financial analyst for the Ubuntu Inc. The director of capital budgeting has asked you to analyse two proposed mutually exclusive capital investment projects, Projects X and Y. The cost of capital for each project is 12%The projects expected net cash flows are as follows: Expected Net Cash Flows 0 ($100,000) ($10,000) 2 4 Year Project X Project Y 60,500 30,000 30,000 10,000 5,500 4,500 3,500 3,500 a. If you apply the payback criterion, which investment will you choose? (0.5) b. If you apply the NPV criterion, which investment will you choose? (1) c. If you apply the IRR criterion, which investment will you choose? (1) d. If you apply the MIRR criterion, which investment will you choose? (0.5) e. Based on your answers from A to D, which project will you finally choose? Why?

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

Answer

Project X Computation of Net Present Value Discount Rate 12% Present Cash flowspV factor Value Year Cumulative Initial Investment Net Cash inflow before tax Net Cash inflow before tax Net Cash inflow before tax Net Cash inflow before tax Total 0 (100,000).0(100,000) 60,500 0.8928654,018 60,500 90,500 330,000 0.7117821,353 120,500 2 30,000 0.79719 23,916 4 10,000 0.63552 6,355 NPV- 30,500 5,642 15.47% 13.55% 5,642 NPV- MIRR- Payback 2.32 Years Project Y Computation of Net Present Value Discount Rate 12%) Present Cash flows PV factor Value (10,000)1.00 ,500 0.89286 Year Cumulative Initial Investment Net Cash inflow before tax Net Cash inflow before tax Net Cash inflow before tax Net Cash inflow before tax Total (10,000) 4,911 0 5,500 4,500 0.797193,58 10,0000 2 :1782,491 13,500 17,000 3,500 0.71178 3,500 0.63552 7,000 3,214 4 2,224 3,214 NPV NPV- IRR= MIRR= Payback 28.10% 20.08% 2.00 Years Since NPVis higherin case of projectx,hence project x should be accepted.

Add a comment
Know the answer?
Add Answer to:
You are a financial analyst for the Ubuntu Inc. The director of capital budgeting has asked...
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
  • You are a financial analyst for the Ubuntu Inc. The director of capital budgeting has asked...

    You are a financial analyst for the Ubuntu Inc. The director of capital budgeting has asked you to analyse two proposed mutually exclusive capital investment projects, projects X and Y. The cost of capital for each project is 1296.The projects, expected net cash flows are as follows 2. Expected Net Cash Flows Project X 0 $100,000 160,500 230,000 3 30,000 4 10,000 Required: 1. Calculate the payback period (0.5 mark) 2. Calculate the discounted payback period, (0.5 mark) 3. Calculate...

  • You are a financial analyst for the Brittle Company. The director of capital budgeting has asked...

    You are a financial analyst for the Brittle Company. The director of capital budgeting has asked you to analyze two proposed capital investments: Projects X and Y. Each project has a cost of $10,000, and the cost of capital for each is 12%. The projects' expected net cash flows are shown in the table below. Expected Net Cash Flows Year Project X Project Y 0 – $10,000 – $10,000 1 6,500 3,500 2 3,000 3,500 3 3,000 3,500 4 1,000...

  • As the director of capital budgeting for KU dairy, you are evaluating two mutually exclusive projects...

    As the director of capital budgeting for KU dairy, you are evaluating two mutually exclusive projects with the following net cash flows: Year Project A Cash Flow Project B Cash Flow 0 -100,000 -100,000 1 50,000 10,000 2 40,000 30,000 3 30,000 40,000 4 10,000 60,000 If KU’s cost of capital is 15%, examine which project you would choose?

  • As the director of capital budgeting for Denver Corporation, you are evaluating two mutually exclusive projects...

    As the director of capital budgeting for Denver Corporation, you are evaluating two mutually exclusive projects with the following net cash flows. Project X has cash flows of -100,000 in year 0, 50,000 in year 1, 40,000 in year 2, 30,000 in year 3 and 10,000 in year 4. Project Z has cash flows of -100,000 in year 0, 10,000 in year 1, 30,000 in year 2, 40,000 in year 3 and 60,000 in year 4. If Denver's cost of...

  • 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...

  • ON EXCEL The director of capital budgeting for Giant Inc. has identified two mutually exclusive projects,...

    ON EXCEL The director of capital budgeting for Giant Inc. has identified two mutually exclusive projects, L and S, with the following expected net cash flows and a required rate of return of 10 percent: Expected Net Cash Flows Year Project S Project L ($210,000) 0 ($161,000) 90,000 10,000 - 0 20,000 60,000 80,000 20,000 60,000 + 90,000 90,000 10,000 Build an automatic spread sheet that calculates: 1. the NPV of both projects with 2 different methods (NPV of excel...

  • НСМ Ноels Compогation Suppose you have recently been appointed as the financial analyst to work for...

    НСМ Ноels Compогation Suppose you have recently been appointed as the financial analyst to work for the HCM Hotel Corporation, an international hotel corporation which owns and operate renowned hotel brands all over the world. Your direct supervisor, the regional financial director (RFD) for the Asian-Pacific region has just handed you the estimated cash flows for two proposed investment projects regarding budget hotels. Project M involves constructing a new hotel in a developing area; it would take some time to...

  • Consider the following two mutually exclusive projects: Whichever project you choose, if any, you require a...

    Consider the following two mutually exclusive projects: Whichever project you choose, if any, you require a 10% return on your investment. If you apply the payback criterion, which investment will you choose? If you apply the NPV criterion, which investment will you choose? If you apply the IRR criterion, which investment will you choose? (Better help with Excel) Based on your answers (a) through (c), which project will you finally choose? Year Cash Flow (A) $170,000 30,000 20,000 15,000 380,000...

  • 11-7 CAPITAL BUDGETING CRITERIA A firm with a 14% WACC is evaluating two projects for this...

    11-7 CAPITAL BUDGETING CRITERIA A firm with a 14% WACC is evaluating two projects for this year's capital budget. After-tax cash flows, including depreciation, are as follows: 3 Project M Project N - $30,000 - $90,000 $10,000 $28,000 $10,000 $28,000 $10,000 $28,000 $10,000 $28,000 $10,000 $28,000 a. Calculate NPV, IRR, MIRR, payback, and discounted payback for each project. b. Assuming the projects are independent, which one(s) would you recommend? c. If the projects are mutually exclusive, which would you recommend?...

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

    CAPITAL BUDGETING CRITERIA A firm with a 14% WACC is evaluating two projects for this year's capital budget. After-tax cash flows, including depreciation, are as follows: 0 1 2 5 Project M Project N - $30,000 $10,000 $10,000 $10,000 $10,000 $10,000 $90,000 $28,000 $28,000 $28,000 $28,000 $28,000 a. Calculate NPV for each project. Round your answers to the nearest cent. Do not round your intermediate calculations. Project M $ Project N $ Calculate IRR for each project. Round your answers...

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