Question

In: Accounting

You are a senior manager at Airbus and have been authorized to spend up to €200,000...

You are a senior manager at Airbus and have been authorized to spend up to €200,000 for projects. The three projects you are considering have the following characteristics:

Project A: Initial investment of €158,000. Cash flow of €52,000 at year 1 and €108,000 at year 2. This is a plant expansion project, where the required rate of return is 9 per cent.

Project B: Initial investment of €200,000. Cash flow of €200,800 at year 1 and €113,000 at year 2. This is a new product development project, where the required rate of return is 19 per cent.

Project C: Initial investment of €104,000. Cash flow of €104,400 at year 1 and €102,000 at year 2. This is a market expansion project, where the required rate of return is 19 per cent. Assume the corporate discount rate is 9 per cent.

Required; Please offer your recommendations following your investment appraisal using Payback period, IRR, Incremental IRR, PI and NPV backed by your analysis of 1000 words. All calculations should be attached in an appendix at the end of your report (and do not form part of the word count).

Solutions

Expert Solution

1). NPV analysis:

NPV = sum of all cash flows discounted at the project required return

Project A ==> -158,000 + 52,000/(1+9%) + 108,000/(1+9%)^2

==> -19,392.14

Project B ==>-200,000 + 200,800/(1+19%) + 113,000/(1+19%)^2

==> 48,536.12

Project C ==>-104,000 + 104,400/(1+19%) + 102,00/(1+19%)^2

==> 55,759.90

On the basis of NPV, Project A should be rejected as it has a negative NPV so it is loss making. Either Project B or Project C can be chosen since both have positive NPVs.

2). IRR analysis:

Using IRR function,Project A IRR ==>0.75%

Using IRR function,Project B IRR ==>40.59%

Using IRR function,Project C IRR ==>61.22%

On the basis on IRR, again Project A is rejected as its IRR is less than the required return of 9%. Other two projects have IRR greater than the respective required return so either can be chosen. Based solely on IRR, Project C should be chosen as it has the highest IRR out of the three projects.

3). Payback period analysis:

It is the time period required for a project to break-even or in other words, to recover its initial investment.

Project A payback period ==>1.98 years

Project B has a payback period of (200,000/200,800) ==> 0.996 years (its CF1 ia greater than its initial investment CF0 so it breaks even under one year's time.)

Project C payback period is (104,000/104,400) ==> 0.996 years (same case as Project C).

Projects B and C have shorter payback period than Project A so either can be accepted based only on the payback period criteria.

4). Incremental IRR analysis:

We start with arranging the projects in the ascending order of initial investments, so we get C, A , B.

First we compare C and A by taking the cash flows of (A-C) and calculating the IRR.

We find that the IRR of (A-C) cannot be calculated as the cash flows are such that the project will not break even at any discount rate. We calculate the NPV of (A-C) at the corporate required return (MARR) of 9% to get an NPV of -97,023.31. This tells us that the IRR will be less than MARR which is why NPV at MARR is negative. So, Project A (higher investment) is rejected and Project C is accepted.

Next, we compare Project C with Project B, to get cash flows (B-C) and compute the IRR to compare with the MARR. IRR of (B-C) is 10.76% (higher than MARR) so Project B is accepted and Project C is rejected.

Thus, on the basis of incremental IRR, Project B should be accepted.

-------------------------------

-------------------------------


Related Solutions

You are a senior manager at Airbus and have been authorized to spend up to €200,000...
You are a senior manager at Airbus and have been authorized to spend up to €200,000 for projects. The three projects you are considering have the following characteristics: Project A: Initial investment of €158,000. Cash flow of €52,000 at year 1 and €108,000 at year 2. This is a plant expansion project, where the required rate of return is 9 per cent. Project B: Initial investment of €200,000. Cash flow of €200,800 at year 1 and €113,000 at year 2....
You are a senior manager at Poeing Aircraft and have been authorized to spend up to...
You are a senior manager at Poeing Aircraft and have been authorized to spend up to $400,000 for projects. The three projects you are considering have the following characteristics: Project A: Initial investment of $280,000. Cash flow of $190,000 at year 1 and $170,000 at year 2. This is a plant expansion project, where the required rate of return is 10%. Project B: Initial investment of $390,000. Cash flow of $270,000 at year 1 and $240,000 at year 2. This...
There are a senior manager at Zambia Airways and have been authorized to spend up to...
There are a senior manager at Zambia Airways and have been authorized to spend up to K400,000 FOR THE PROJECTS. The three projects you are considering have the fillowing characterics; Project Details Project A Intial investment of K280,000 .Cash flow of K190,000 at year 1 and K 170,000 at yr 2. This is a plant expansion project Project B Intial investment of K390,000. Cash flow of K270,000 at year 1 and K 240,000 at year 2. this is a new...
Congratulations! You have just been hired as a senior IT portfolio and project manager at a...
Congratulations! You have just been hired as a senior IT portfolio and project manager at a traditional large finance company. The company is looking to invest in new financial products and services. You are now in charge of all new strategic IT projects to enable and support these new products and services. In your team, you have many subject matter experts, analysts, product and project managers, either directly or indirectly working for you . (a) Describe all areas of the...
Factual Background Congratulations. You have just been promoted to a Senior Manager position in the Finance...
Factual Background Congratulations. You have just been promoted to a Senior Manager position in the Finance Department. You now supervise five (5) employees who process payroll for a large successful publishing company. You have worked for the company for six (6) years and you’ve worked alongside the employees you now supervise the entire time. You consider these coworkers who are now your subordinates as some of your closest friends. You often socialized after work, attended events together, and truly got...
Q5: Imagine that YOU have just been appointed the Senior Brand Manager of Al Ain brand...
Q5: Imagine that YOU have just been appointed the Senior Brand Manager of Al Ain brand of dairy products in the UAE. Part of your job responsibility is the training of new graduates employed in the company as brand management trainees. If YOU were approached to prepare lesson details for the next batch of new trainees; provide detailed answers to the following questions and give examples with Al Ain and other dairy products where necessary: (a) Discuss 4 ways that...
Congratulations! You have been promoted to a senior leadership role and have been charged with improving...
Congratulations! You have been promoted to a senior leadership role and have been charged with improving financial performance in your organization. To do this, you will work with your team to create an environment of sustainable excellence – an environment which is committed to driving a shift from pay-for-service to pay-for-value. In the coming months, you will take a closer look at operating and capital budgets. You will also examine how costs are allocated and charged, and how the revenue...
You have been asked to replace the project manager who was heading up your firm’s new...
You have been asked to replace the project manager who was heading up your firm’s new compensation and benefits system. One of the reasons the project manager is being replaced is because the project schedule had the wrong resources assigned (e.g., resources who do not fully understand compensation and benefits). You have been asked to solve this problem quickly by either replacing the resources or getting the resources up-to-speed on compensation and benefits. Present your recommendation for solving this critical...
You are a senior adviser to the EPA. You have been assigned the task of creating...
You are a senior adviser to the EPA. You have been assigned the task of creating an oversight board which will be in charge of the creation and enforcement of regulations relating to mining. Your plan calls for the appointment of ten (10) members. To attract the best possible board members you are considering adding a provision that no member may be terminated except "only for good cause." What are the arguments both for and against the "only for good...
As a senior analyst for the company you have been asked to evaluate a new IT...
As a senior analyst for the company you have been asked to evaluate a new IT software project. The company has just paid a consulting firm $100,000 for a test marketing analysis. After looking at the project plan, you anticipate that the project will need to acquire computer hardware for a cost of $450,000. The Australian Taxation Office rules allow an effective life for the computer hardware of five years. The equipment can be depreciated on a straight-line (prime cost)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT