Calculate the profitability index for each proposal

Assignment Help Finance Basics
Reference no: EM13860434

The Day-Pro Chemical Company, established in 1995, has managed to earn a consistently high rate of return on its investments. The secret of its success has been the strategic and timely development, manufacturing, and marketing of innovative chemical products that have been used in various industries. Currently, the management of the company is considering the manufacture of a thermosetting resin as packaging material for electronic products. The Company's Research and Development teams have come up with two alternatives: an epoxy resin, which would have a lower startup cost, and a synthetic resin, which would cost more to produce initially but would have greater economies of scale. At the initial presentation, the project leaders of both teams presented their cash flow projections and provided sufficient documentation in support of their proposals. However, since the products are mutually exclusive, the firm can only fund one proposal.

In order to resolve this dilemma, Tim Palmer, the Assistant Treasurer and a recent MBA from Drexel University, has been assigned the task of analyzing the costs and benefits of the two proposals and presenting his findings to the board of directors. Tim knows that this will be an uphill task, since the board members are not all on the same page when it comes to financial concepts. The Board has historically had a strong preference for using rates of return as its decision criteria. On occasions it has also used the payback period approach to decide between competing projects. However, Tim is convinced that the net present value (NPV) method is least flawed and when used correctly will always add the most value to a company's wealth.

After obtaining the cash flow projections for each project (see Tables 1 & 2), and crunching out the numbers, Tim realizes that the hill is going to be steeper than he thought. The various capital budgeting techniques, when applied to the two series of cash flows, provide inconsistent results. The project with the higher NPV has a longer payback period as well as a lower Accounting Rate of Return (ARR) and Internal Rate of Return (IRR). Tim scratches his head, wondering how he can convince the Board that the IRR, ARR and Payback Period can often lead to incorrect decisions.

Table 1. Synthetic Resin Cash Flows

Synthetic Resin

Year

0

1

2

3

4

5

 

Net Income

 

 

$150,000

 

$200,000

 

$300,000

 

$450,000

 

$500,000

 

Depreciation

 

 

$200,000

 

$200,000

 

$200,000

 

$200,000

 

$200,000

 

Net Cash Flow

 

$(1,000,000)

 

$350,000

 

$400,000

 

$500,000

 

$650,000

 

$700,000

Table 2. Epoxy Resin Cash Flows

Epoxy Resin

Year

0

1

2

3

4

5

 

Net Income

 

 

$440,000

 

$240,000

 

$140,000

 

$ 40,000

 

$ 40,000

 

Depreciation

 

 

$160,000

 

$160,000

 

$160,000

 

$160,000

 

$160,000

 

Net Cash Flow

 

$(800,000)

 

$600,000

 

$400,000

 

$300,000

 

$200,000

 

$200,000

Questions:
1. Calculate the Payback Period of each project. Explain what arguments Tim should make to show that the Payback is not appropriate in this case.

2. Calculate the Discounted Payback Period (DPP) using 10% as the discount rate (required rate of return). How is the DPP an improvement over the regular Payback Period? Should Tim ask the Board to use the DPP as the deciding factor? Explain.

3. The Accounting Rate of Return (ARR), also called the Book Rate of Return, is calculated as the project's average net income divided by average book value over the project's economic life. When choosing among mutually exclusive alternatives, the ARR rule would pick the project with the highest ARR among projects exceeding the hurdle rate. If management sets a hurdle for the accounting rate of return of 40% accounting rate of return, which project would be accepted? What is wrong with the ARR and this decision?

4. Calculate the IRR for each project. Tim wants to convince the Board that the IRR measure can be misleading when choosing between mutually exclusive alternatives. Why is the IRR decision rule unreliable in making the correct choice between the two projects? Tim's presentation should inform the board on the different reinvestment assumptions underlying IRR and NPV and how that relates to the reliability of the IRR decision rule.

5. An NPV profile graphs the relationship between a projects's NPV and the discount rate (see Figure 5.6 in Chapter 5). The NPV profiles of mutually exclusive projects highlight the possible conflict in the decisions made by NPV and IRR and the importance of the crossover point. Construct the NPV profiles for the two projects. Identify the IRR for both projects on the graph and explain the relevance of the crossover point. At the cost of capital, which projects would the NPV and IRR decision rules accept? Tim wants to point out to the board that NPV is an absolute measure of the monetary impact of a project on shareholder value and IRR is a relative value that evaluates the project's return per dollar invested. What argument can Tim advance to convince the Board that the NPV decisions are always consistent with maximizing shareholder value?

6. Given the problem of the IRR rule in evaluating mutually exclusive projects, an Incremental Internal Rate of Return is used as an alternative. Which project would the Incremental IRR accept? Although not a problem here, there could be cases in which there are multiple IRRs. In such a case, the IRR method would be inoperable as there would be no unique IRR. When would this be the case?

7. Calculate the Profitability Index for each proposal. How does the Profitability Index relate to NPV? Do the synthetic resin and epoxy resin projects significantly differ in scale? Can the Profitability Index rule be applied here? Explain?


8. In looking over the documentation prepared by the two project teams, it appears to you that the synthetic resin team has been somewhat more conservative in its revenue projections than the epoxy resin team. What impact might this have on the Payback Period, NPV, and IRR calculations for the synthetic resin project? How does this complicate comparing the synthetic resin and epoxy resin projects? Is being conservative in revenue projections a good practice? What adjustments might be made?

9. In looking over the documentation prepared by the two project teams, it appears to you that the synthetic resin technology would require extensive development before it could be implemented whereas the epoxy resin technology is available "off-the-shelf." What impact might this have on your analysis?

Reference no: EM13860434

Questions Cloud

What''s the efficiency wage theory : What's the efficiency wage theory? How can it explain the possible downward adjustment in efficiency wages especially in the recession?
Discuss whether active asset allocation among countries : Briefly discuss whether active asset allocation among countries could consistently outperform a world market index.
How much will eileen pay annually to her credit card company : Her credit card charges her 20 percent annually on outstanding balances. If Eileen does not reduce her credit card debt, how much will she pay annually to her credit card company?
What changed because of the movement from isolationism : Your essay must discuss the relationship of this person's experience to the time period/event, and must include reaction to British v. German naval battles and what changed because of the movement from isolationism.
Calculate the profitability index for each proposal : Calculate the Profitability Index for each proposal. How does the Profitability Index relate to NPV?
What was the increase in real purchasing power : What was the increase in real purchasing power associated with both 3-month Treasury bills and 30-year Treasury bonds?
Discuss impact of indias economy on the united states : Prepare a 1-2 page paper that discusses the impact of India's economy on the United States and other current world economic powers.
What would you do in the days and weeks that followed : What is your immediate response and What would you do in the days and weeks that followed? Would you continue to pursue the issue? Why or why not?"
What is the return on equity when financial leverage : What is the return on equity when financial leverage is and is not utilized?

Reviews

Write a Review

Finance Basics Questions & Answers

  Interactions between the internal operations

Bank performance and the interactions between the internal operations, external activities and the environmental factors; the statement of income, the balance sheet, the statement of earnings and the statements of cash flows

  What is expected return of following three-stock porfolio

Currently the risk free return is 3 percent and the expected market rate of return is 10 percent. What is the expected return of the following three-stock porfolio?

  Compare convertible debt to convertible preferred stock

compare convertible debt to convertible preferred stock. which of them do you think is the better way to finance a

  What is the standard deviation of a portfolio

Stock Q will return 18 percent in a boom and 9 percent in a normal economy. Stock R will return 9 percent in a boom and 5 percent in a normal economy. There is a 75 percent probability the economy will be normal. What is the standard deviation of a p..

  Normal cost of capital

Myers Business Systems is estimating the introduction of a new product. The possible levels of unit sales and the probabilities of their occurrence are given below:

  To what sort of option on the counter partys assets can the

to what sort of option on the counter partys assets can the current exposure of a credit-risky position better be

  Which of the two stocks is relatively riskier

The stocks of Spaulding (S) and Johnson (J) Corporations have the following risk and return statistics: E(rJ) = 14%, ?J = 22%; E(rS) = 16%, ?S = 25%. [Round any calculation to two decimal points]

  The finance department of biotrend industries

It is the end of 2014 and you are working in the finance department of BioTrend Industries. The CFO of the company knows that you just earned a BBA from Georgia, which is known for its rigorous education in Finance; hence, he asks you to deter..

  What is the amount of the firms ebit

Advantage First Corporation has sales of $4,354,880; income tax of $441,294; the selling, general and administrative expenses of $218,382; depreciation of $311,692; cost of goods sold of $2,528,220; and interest expense of $120,225. What is the amoun..

  What is the future value of this prize

The Idaho lottery agrees to pay the winner $252,000 at the end of each year for the next 20 years. What is the future value of this prize if each payment is put in an account earning 0.07?

  Determine the premium charges

Research indicates that the 1,000,000 cars in your city experience unrecoverable losses of $250,000,000 every year from theft, collisions, etc.

  What is the initial value of the swap

B) Create a chart showing the timing and amount of all cash flows. c) What is the initial value of the swap?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd