Question

In: Finance

You are a Financial Analyst with ABC Ltd and the chief financial officer (CFO) requests you...

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 line. The required rate of return on both projects is set at 11%. The expected after-tax cash flows from each project are as presented in the table below.

PROJECT X

PROJECT Y

Initial outlay

-$400,000

-$400,000

Inflow year 1

$80,000

$160,000

Inflow year 2

$140,000

$160,000

Inflow year 3

$130,000

$160,000

Inflow year 4

$160,000

$160,000

Inflow year 5

$160,000

Inflow year 6

$160,000

Distinguish between “required rate of return” and “internal rate of return”. Illustrate your answer with examples.

What is the payback period on each project? If ABC Ltd imposes a 2.5-year maximum acceptable payback period, which of these projects should be accepted?

What are the main limitations of the pay back method of valuation. Despite these limitations, chief financial officers (CFOs) use it. Explain why.

Determine the NPV for each of these projects? Should the projects be accepted? Explain.

Determine the IRR for each of these projects? Should the projects be accepted? Explain.

Under what circumstances will the NPV and IRR offer different recommendations, and which recommendation is preferred? Carefully explain

How would you accommodate unequal lives of the project while determining the NPVs of the project? Demonstrate using calculations.

Explain why unequal lives of projects make NPVs of the projects incomparable.

Determine the profitability index for each of these projects? Should the projects be accepted? Explain.

Clarity of Presentation.

Solutions

Expert Solution

Required rate of return is also known as the hurdle rate and is the minimum rate that a project should earn in order to make it viable. On the other hand IRR (internal rate of return) is that rate that makes the NPV (net present value) as nil. The rule is that if IRR>required rate of return then the project is viable. For example take the case of a project which has a required rate of return of 10% and whose IRR is 9%. As IRR is less than the hurdle rate the project is not financially feasible.

Payback:

Project X Project Y
Year Cash flow Cumulative cash flow Year Cash flow Cumulative cash flow
0 - 400,000.00 -                         400,000.00 0 - 400,000.00 -                         400,000.00
                    1      80,000.00 -                         320,000.00                 1    160,000.00 -                         240,000.00
                    2    140,000.00 -                         180,000.00                 2    160,000.00 -                           80,000.00
                    3    130,000.00 -                           50,000.00                 3    160,000.00                              80,000.00
                    4    160,000.00                           110,000.00                 4    160,000.00
                    5                 5    160,000.00
                    6                 6    160,000.00

Thus payback of X = 3+(50000/160000) = 3.31 years

Payback of Y = 2+(80000/160000) = 2.5 years. Thus project Y will be selected.

The main limitation of payback is that fails to consider the time value of money. Secondly cash flows beyond the payback period are not considered at all. Despite these limitations CFO use this method because the method is simple both in concept as well as in application.

NPV:

Project X Project Y
Year Cash flow 1+r PVIF PV of X = cash flow of X * PVIF Cash flow PV of Y = cash flow of Y * PVIF
0 - 400,000.00                                        1.11                  1.0000 -      400,000.00 - 400,000.00 -                         400,000.00
                    1      80,000.00                  0.9009           72,072.07    160,000.00                           144,144.14
                    2    140,000.00                  0.8116         113,627.14    160,000.00                           129,859.59
                    3    130,000.00                  0.7312           95,054.88    160,000.00                           116,990.62
                    4    160,000.00                  0.6587         105,396.96    160,000.00                           105,396.96
                    5                  0.5935    160,000.00                              94,952.21
                    6                  0.5346    160,000.00                              85,542.53
NPV -         13,848.95                           276,886.06

NPV of X = -$13,848.95 and NPV of Y = $276,888.06

Y will be selected as it has a positive NPV.

IRR of X:

Year Cash flow 1+r PVIF PV of X = cash flow of X * PVIF
0 - 400,000.00                                    1.0951                  1.0000 -      400,000.00
                    1      80,000.00                  0.9131           73,050.46
                    2    140,000.00                  0.8338         116,733.08
                    3    130,000.00                  0.7614           98,978.81
                    4    160,000.00                  0.6952         111,237.65
                    5                  0.6348
                    6                  0.5797
NPV                      0.00

IRR of X = 9.51%

Y's IRR:

Year 1+r PVIF Cash flow PV of Y = cash flow of Y * PVIF
0                                 1.32662                  1.0000 - 400,000.00 -                         400,000.00
                    1                  0.7538    160,000.00                           120,607.33
                    2                  0.5682    160,000.00                              90,913.30
                    3                  0.4283    160,000.00                              68,530.06
                    4                  0.3229    160,000.00                              51,657.67
                    5                  0.2434    160,000.00                              38,939.34
                    6                  0.1835    160,000.00                              29,352.31
NPV                                        0.00

IRR of Y = 32.66%

Y will be selected as it has a higher IRR.

The circumstances in which NPV and IRR can give different results is when there is different cash flow patterns in the two projects. One of the projects might be having conventional cash flows while the other project might be having unconventional cash flows. In such scenarios NPV and IRR will give conflicting results and the recommendation that will be preferred will be NPV method because NPV gives a single NPV value irrespective of the pattern of cash flow while the IRR method can lead to multiple rates of return.

For projects with unequal lives the NPV method is modified to compute the annual net present value. This is also known as the equivalent annual annuity. Annual net present value = net present value/annuity discount factor for the project life. For instance NPV of X = -13,848.95 and that of Y = 276,886.06. Now annuity discount factor for X = PVIFA(11%,4) = 3.102 and for Y = PVIFA(11%,6) = 4.231. Thus annual net present value of X = -13848.95/3.102 = -$4,464.52 and of Y = 276886.06/4.231 = 65442.23

Unequal lives make NPVs incomparable because the duration of cash flow is different for the two projects and hence one project gets cash inflow for a longer duration when compared to another project which has a lower life. This makes NPV not comparable.

Profitability index = present value of future cash flows/investment

X = 386,151.05/400,000 = 0.97

Y = 676,886.06/400,000 = 1.69

As profitability index of Y > 1 Y will be selected.


Related Solutions

You have been named the Chief Financial Officer (CFO) of a two year old company, ABC...
You have been named the Chief Financial Officer (CFO) of a two year old company, ABC Analytics. Financials have been prepared by a bookkeeper. As CFO, you responsible for the preparation of accurate financials, analysis and review of the financials before they are released and communication of the results of your company to banks, investors, creditors and the government, as necessary. One of the members of the board has asked you to prepare a memorandum which addresses the following points....
ABC Corporation purchased a $2million life insurance policy on their Chief Financial Officer (CFO), who was...
ABC Corporation purchased a $2million life insurance policy on their Chief Financial Officer (CFO), who was a 20 percent stockholder in the corporation. Two years later the CFO resigned and sold his stock in the corporation. Three months later, the former CFO dies and ABC Corporation files a claim with the insurer for $2 million. Can ABC Corporation collect on the policy?
First, you will prepare a memo to be reviewed by the chief financial officer (CFO) of...
First, you will prepare a memo to be reviewed by the chief financial officer (CFO) of your chosen company that summarizes the audit process conducted. Then, you will assume the role of CFO of the company and prepare a memo to the Board of Directors as to what potential issues the external audit team might find and what the company's response should be.
First, you will prepare a memo to be reviewed by the chief financial officer (CFO) of...
First, you will prepare a memo to be reviewed by the chief financial officer (CFO) of your chosen company that summarizes the audit process conducted. Then, you will assume the role of CFO of the company and prepare a memo to the Board of Directors as to what potential issues the external audit team might find and what the company's response should be.
You are the chief financial officer (CFO) for an organization and need to discuss with fellow...
You are the chief financial officer (CFO) for an organization and need to discuss with fellow C-suite executives that cost cutting is not the only answer to profitability. Prepare for the next manager's meeting by responding to the following prompts: ·Explain how a capital budget and a return on investment contribute to sustainable growth. ·Clarify the role that risk analysis plays during capital investment decision making.
Imagine you are the chief financial officer (CFO) of a corporation with plans to complete the...
Imagine you are the chief financial officer (CFO) of a corporation with plans to complete the acquisition of a key subsidiary this year. Your chief executive officer (CEO) has requested a presentation to the board of directors describing the methods available to account for the acquisition internally and the best method for the company during the acquisition year. Please assess the value of each method identified in your presentation to the board and support your recommendation with examples. Respond to...
Imagine you are the chief financial officer (CFO) of a corporation with plans to complete the...
Imagine you are the chief financial officer (CFO) of a corporation with plans to complete the acquisition of a key subsidiary this year. Your chief executive officer (CEO) has requested a presentation to the board of directors describing the methods available to account for the acquisition internally and the best method for the company during the acquisition year. Please assess the value of each method identified in your presentation to the board and support your recommendation with examples. Respond to...
Imagine you are the chief financial officer (CFO) of a corporation with plans to complete the...
Imagine you are the chief financial officer (CFO) of a corporation with plans to complete the acquisition of a key subsidiary during the current year. Your chief executive officer (CEO) has requested a presentation to the Board of Directors describing the methods available to account for the acquisition internally and the best method for the company during the acquisition year. Please assess the value of each method identified in your presentation to the Board and support your recommendation with examples....
Instructions: You are the Chief Financial Officer (CFO) of a firm that is being sued for...
Instructions: You are the Chief Financial Officer (CFO) of a firm that is being sued for damages it caused. It is the end of your fiscal year, and you are trying to determine the appropriate treatment of this matter. Your boss, the Chief Executive Officer (CEO) acknowledges (privately) that your firm is responsible for the damages and that the judgment will be made against your firm. Your legal counsel estimates that the penalty levied by the court will be in...
Christine, a newly appointed chief financial officer (CFO) at Winter Pty Ltd, is asked to evaluate...
Christine, a newly appointed chief financial officer (CFO) at Winter Pty Ltd, is asked to evaluate and report on the company's present financial condition to the board of directors at an upcoming meeting. She discovers several instances where Paul, the chief executive officer (CEO), has made excessive risky business decisions, going against company policy resulting in the current liquidity problem facing the company. Paul, Christine’s superior, is fearful of the board’s reactions to the adverse financial report, so he instructs...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT