Watertown, Inc. was founded in May, 2000 by Lawrence Rollins, who was employed f
ID: 2655712 • Letter: W
Question
Watertown, Inc. was founded in May, 2000 by Lawrence Rollins, who was employed for the last 20 years as a river rafting guide. Mr. Rollins received an unexpected inheritance of $2,000,000 in January, 2000. Soon after, he decided to leave his lifelong career in river rafting and use his inheritance as seed capital for Watertown. During the first few years of its existence, Watertown experienced steady sales growth, although the company has only recently shown positive net income.
It is March, 2016 and the company is considering two alternative processes for manufacturing inflatable tubes to service demand in a rapidly growing market. Management intends to make the initial investment in the project at the end of April, 2016 and expects any cash flows associated with the project to arrive yearly, beginning at the end of April, 2017.
The first manufacturing process has a higher start-up cost than the second, but greater economies of scale. The expected cash flows associated with this process are presented below in Table 1.
Table 1:
Cash Flow Projections for Process 1
0
1
2
3
4
5
EBIAT*
150,000
200,000
300,000
470,000
500,000
Depreciation
200,000
200,000
200,000
200,000
200,000
Initial Investment
(1,000,000)
The second manufacturing process requires a smaller initial investment than the first, and because of this it is appealing to some members of the board. The expected cash flows associated with this process are presented in Table 2 below.
Table 2:
Cash Flow Projections for Process 2
0
1
2
3
4
5
EBIAT*
440,000
240,000
175,000
40,000
40,000
Depreciation
160,000
160,000
160,000
160,000
160,000
Initial Investment
(800,000)
*EBIAT is Earnings Before Interest and After Tax (i.e., EBIT x (1-tax rate))
After careful assessment of the risk associated with this project, you conclude that the appropriate cost of capital for both processes is 9.75%.
At the initial presentation, project leaders of both teams presented their cash flow projections. However, since the processes are mutually exclusive, the firm can only accept one proposal.
You have been asked to evaluate the two production processes and present your findings to the board of directors. Your CEO Charlie learned good capital budgeting techniques and you are confident that he is able to distinguish among competing investment decision rules and use the appropriate criteria for decision-making. However, the founder and Chairman of the Board has never taken a finance class. In fact, he is a self-made man who does not have a college degree. He prefers the second process because it costs less money up-front. In addition, several influential old-timers on the board are intrigued with the payback decision rule.
Compute the Net Present Value, Internal Rate of Return, Incremental IRR, Profitability Index, Payback Period, and Discounted Payback Period for each of the two processes. Fill in the table below with your answers.
Process 1
Process 2
Net Present Value (NPV)
Internal Rate of Return (IRR)
Incremental IRR
Profitability Index
Payback Period
Discounted Payback Period
Which process would management choose if they used only payback as the decision criteria?
What argument(s) would you make to convince the board that the payback period is not an appropriate decision rule? Should the board use discounted payback as the deciding factor? Explain why or why not.
Which process would management choose if they used IRR as the decision criteria? What arguments would you make to show the board that the IRR measure could be misleading in this case? Is the modified IRR a helpful measure in this case? Explain why or why not.
Explain the meaning of the incremental IRR. Based on the incremental IRR, which process should you choose? Should the board use incremental IRR as a decision rule? Explain why or why not.
Plot the NPV profiles for the two projects and present the graph as an Exhibit in your report (see figure 5.6 on page 153 of the RWJ text for an example of how to do this). Explain the relevance of the crossover point. How would you convince the board that the NPV method is best?
Is the profitability index helpful in this case? Explain why or why not.
0
1
2
3
4
5
EBIAT*
150,000
200,000
300,000
470,000
500,000
Depreciation
200,000
200,000
200,000
200,000
200,000
Initial Investment
(1,000,000)
Explanation / Answer
We need to compute project cash flows, defined as EBIAT plus depreciation.
(1) PROCESS - 1 NPV & IRR analyses as follows.
(2) PROCESS - 1 PBP & Discounted PBP as follows.
From above table, PBP lies between years 2 & 3.
So, PBP = 2 + (Absolute cumulative CFAT of year 2 / CFAT for year 3)
= 2 + (250,000 / 500,000) = 2.5 years
Discounted PBP lies between years 2 & 3.
So, PBP = 2 + (Absolute cumulative discounted CFAT of year 2 / Discounted CFAT for year 3)
= 2 + (349,007 / 378,230) = 2.92 years
(3) PROCESS - 1 Profitability Index = PV of future cash inflows / initial investment
= 1,930,644 / 1,000,000 = 1.93
(4) PROCESS - 2 NPV & IRR analyses as follows.
(5) PROCESS - 2 PBP & Discounted PBP as follows.
From above table, PBP lies between years 1 & 2.
So, PBP = 1 + (Absolute cumulative CFAT of year 1 / CFAT for year 2)
= 1 + (200,000 / 400,000) = 1.5 years
Discounted PBP lies between years 1 & 2.
So, PBP = 1 + (Absolute cumulative discounted CFAT of year 1 / Discounted CFAT for year 2)
= 1 + (253,303 / 332,086) = 1.76 years
(6) PROCESS - 2 Profitability Index = PV of future cash inflows / initial investment
= 1,395,654 / 800,000 = 1.74
(7) Finally, incremental IRR calculations as follows.
(8) If only PBP is chosen, process 2 should be chosen since it has a lower PBP (1.5 years).
NOTE: This is a huge question with many sub-questions. The 1st 8 questions have been answered in full.
NPV & IRR Analysis Year Investment EBIAT Depreciation CFAT Discount Factor @9.75% Discounted CFAT 0 -10,00,000 -10,00,000 1.0000 -10,00,000 1 1,50,000 2,00,000 3,50,000 0.9112 3,18,907 2 2,00,000 2,00,000 4,00,000 0.8302 3,32,086 3 3,00,000 2,00,000 5,00,000 0.7565 3,78,230 4 4,70,000 2,00,000 6,70,000 0.6893 4,61,803 5 5,00,000 2,00,000 7,00,000 0.6280 4,39,618 IRR 37% NPV 9,30,644Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.