CH 12
CH 12
CH 12
Discussion Questions
12-1.
12-2.
Why does capital budgeting rely on analysis of cash flows rather than on net
income?
Cash flow rather than net income is used in capital budgeting analysis because
the primary concern is with the amount of actual dollars generated. For
example, depreciation is subtracted out in arriving at net income, but this noncash deduction should be added back in to determine cash flow or actual dollars
generated.
12-3.
12-4.
What is normally used as the discount rate in the net present value method?
The cost of capital as determined in Chapter 11.
12-5.
12-6.
How does the modified internal rate of return include concepts from both the
traditional internal rate of return and the net present value methods?
The modified internal rate of return calls for the determination of the interest
rate that equates future inflows to the investment as does the traditional internal
rate or return. However, it incorporates the reinvestment rate assumption of the
net present value method. That is that inflows are reinvested at the cost of
capital.
S12-1
12-7.
If a corporation has projects that will earn more than the cost of capital, should
it ration capital?
From a purely economic viewpoint, a firm should not ration capital. The firm
should be able to find additional funds and increase its overall profitability and
wealth through accepting investments to the point where marginal return equals
marginal cost.
12-8.
What is the net present value profile? What three points should be determined
to graph the profile?
The net present value profile allows for the graphic portrayal of the net present
value of a project at different discount rates. Net present values are shown
along the vertical axis and discount rates are shown along the horizontal axis.
The points that must be determined to graph the profile are:
a. The net present value at zero discount rate.
b. The net present value as determined by a normal discount rate.
c. The internal rate of return for the investment.
12-9.
How does an asset's ADR (asset depreciation range) relate to its MACRS
category?
The ADR represents the asset depreciation range or the expected physical life
of the asset. Generally, the midpoint of the range or life is utilized. The longer
the ADR midpoint, the longer the MACRS category in which the asset is
placed. However, most assets can still be written off more rapidly than the
midpoint of the ADR. For example, assets with ADR midpoints of 10 years to
15 years can be placed in the 7-year MACRS category for depreciation
purposes.
S12-2
Chapter 12
Problems
1.
Assume a corporation has earnings before depreciation and taxes of $90,000, depreciation
of $40,000, and that it is in a 30 percent tax bracket. Compute its cash flow using the
format below.
Earnings before depreciation and taxes
Depreciation
Earnings before taxes
Taxes @ 30%
Earnings after taxes
Depreciation
Cash flow
_____
_____
_____
_____
_____
_____
_____
12-1. Solution:
Earnings before depreciation and taxes
Depreciation
Earnings before taxes
Taxes @ 30%
Earnings after taxes
Depreciation
Cash flow
S12-3
$90,000
40,000
50,000
15,000
$35,000
+40,000
$75,000
2.
a.
b.
In problem 1, how much would cash flow be if there were only $10,000 in
depreciation? All other factors are the same.
How much cash flow is lost due to the reduced depreciation between problems
1 and 2a?
12-2. Solution:
a.
$90,000
10,000
$80,000
24,000
$56,000
+10,000
$66,000
$75,000
66,000
$ 9,000
Assume a firm has earnings before depreciation and taxes of $200,000 and no depreciation.
It is in a 40 percent tax bracket.
a. Compute its cash flow.
b. Assume it has $200,000 in depreciation. Recompute its cash flow.
c.
How large a cash flow benefit did the depreciation provide?
12-3. Solution:
a.
S12-4
$200,000
0
200,000
80,000
120,000
0
$120,000
12-3. (Continued)
b. Earnings before depreciation and taxes
Depreciation
Earnings before taxes
Taxes @ 40%
Earnings after taxes
Depreciation
Cash flow
$200,000
200,000
0
0
0
200,000
$200,000
Bob Cole, the president of a New York Stock Exchange-listed firm, is very short term
oriented and interested in the immediate consequences of his decisions. Assume a project
that will provide an increase of $3 million in cash flow because of favorable tax
consequences, but carries a three-cent decline in earning per share because of a write-off
against first quarter earnings. What decision might Mr. Cole make?
12-4. Solution:
Bob Cole
Being short term oriented, he may make the mistake of
turning down the project even though it will increase cash flow
because of his fear of investors negative reaction to the more
widely reported quarterly decline in earnings per share. Even
though this decline will be temporary, investors might interpret it
as a negative signal.
S12-5
5.
Assume a $100,000 investment and the following cash flows for two alternatives.
Year
1
2
3
4
5
Investment A
$30,000
50,000
20,000
60,000
Investment B
$40,000
30,000
15,000
15,000
50,000
Which of the two alternatives would you select under the payback method?
12-5. Solution:
Payback for Investment X
$100,000$30,000
70,00050,000
20,00020,000
1 year $100,00040,000
2 years
60,00030,000
3 years
30,00015,000
15,00015,000
1 Year
2 years
3 years
4 years
S12-6
6.
Assume a $40,000 investment and the following cash flows for two alternatives.
Year
1
2
3
4
5
Investment X Investment Y
$ 6,000
$15,000
8,000
20,000
9,000
10,000
17,000
20,000
Which of the alternatives would you select under the payback method?
12-6. Solution:
Payback for Investment X
$40,000$ 6,000
34,0008,000
26,0009,000
17,00017,000
1 year
2 years
3 years
4 years
1 year
2 years
.5 years
Referring back to problem 6, if the inflow in the fifth year for Investment X were
$20,000,000 instead of $20,000, would your answer change under the payback method?
12-7. Solution:
The $20,000,000 inflow would still leave the payback period for
Investment X at 4 years. It would remain inferior to Investment
Y under the payback method.
S12-7
8.
Electric Co.
$70,000
15,000
15,000
10,000
Water Works
$15,000
15,000
70,000
10,000
12-8. Solution:
Short-Line Railroad
a. Payback for Electric Co.
$100,000$70,000
30,00015,000
15,00015,000
1 year
2 years
3 years
1 year
2 years
3 years
S12-8
9.
X-treme Vitamin Company is considering two investments, both of which cost $10,000.
The cash flows are as follows:
Year
1 ...................
2 ...................
3 ...................
a.
b.
c.
Project A
$12,000
8,000
6,000
Project B
$10,000
6,000
16,000
Which of the two projects should be chosen based on the payback method?
Which of the two projects should be chosen based on the net present value method?
Assume a cost of capital of 10 percent.
Should a firm normally have more confidence in answer a or answer b?
12-9. Solution:
X-treme Vitamin Company
a.
Payback Method
Payback for Project A
10,000
= .83 years
12,000
Payback for Project B
10,000
= 1 year
10,000
Under the Payback Method, you should select Project A
because of the shorter payback period.
S12-9
12-9. (Continued)
b. Net Present Value Method
Project A
Year
1
2
3
Cash Flow
PVIF at 10%
Present Value
$12,000
$ 8,000
$ 6,000
.909
.826
.751
$10,908
$ 6,608
$ 4,506
$22,022
10,000
$12,022
Project B
Year
1
2
3
Cash Flow
PVIF at 10%
Present Value
$10,000
$ 6,000
$16,000
.909
.826
.751
$ 9,090
$ 4,956
$12,016
$26,062
10,000
$16,062
S12-10
10.
You buy a new piece of equipment for $16,980, and you receive a cash inflow of $3,000
per year for 12 years. What is the internal rate of return?
12-10.
Solution:
Appendix D
PVIFA =
$16,980
= 5.660
$3,000
IRR = 14%
For n = 12, we find 5.660 under the 14% column.
11.
12-11.
Solution:
Warner Business Products
Appendix D
PVIFA = $11,070/$2,000 = 5.535
IRR = 9%
For n = 8, we find 5.353 under the 9% column.
The machine should not be purchased since its return is under
13 percent.
S12-11
12.
Elgin Restaurant Supplies is analyzing the purchase of manufacturing equipment that will
cost $20,000. The annual cash inflows for the next three years will be:
Year
Cash Flow
1................. $10,000
2.................
9,000
3.................
6,500
a.
b.
12-12.
Solution:
Elgin Restaurant Supplies
a. Step 1 Average the inflows.
$10,000
9,000
6,500
$25,500 3 = $8,500
Step 2 Divide the inflows by the assumed annuity in Step 1.
Investment $20,000
=
= 2.353
Annuity
8,500
Step 3 Go to Appendix D for the 1st approximation.
The value in Step 2 (for n = 3) falls between
13% and 14%.
S12-12
12-12. (Continued)
Step 4 Try a first approximation of discounting back the
inflows. Because the inflows are biased toward
the early years, we will use the higher rate of 14%.
Year Cash Flow
1
$10,000
2
9,000
3
6,500
19,781........... PV @ 15%
298
79
S12-13
12-12. (Continued)
If the student skipped from 14% to 16%, the calculations to
find the IRR would be as follows:
Year Cash Flow
1
$10,000
2
9,000
3
6,500
$20,079........... PV @ 14%
19,474........... PV @ 16%
605
79
S12-14
13.
Aerospace Dynamics will invest $110,000 in a project that will produce the following cash
flows. The cost of capital is 11 percent. Should the project be undertaken? (Note that the
fourth years cash flow is negative.)
Year
1.................
2.................
3.................
4.................
5.................
12-13.
Cash Flow
$36,000
44,000
38,000
(44,000)
81,000
Solution:
Aerospace Dynamics
Year
1
2
3
4
5
Cash Flow
$36,000
44,000
38,000
(44,000)
81,000
PVIF at 11%
.901
.812
.731
.659
.593
Present Value
$ 32,436
35,728
27,778
(28,996)
48,033
$114,979
110,000
$ 4,979
S12-15
14.
The Horizon Company will invest $60,000 in a temporary project that will generate the
following cash inflows for the next three years.
Year
1.................
2.................
3.................
Cash Flow
$15,000
25,000
40,000
The firm will also be required to spend $10,000 to close down the project at the end of the
three years. If the cost of capital is 10 percent, should the investment be undertaken?
12-14.
Solution:
Horizon Company
Present Value of Inflows
Year
1
2
3
$60,000
10,000
1.000
.751
$60,000
7,510
$67,510
$64,325
67,510
($ 3,185)
The net present value is negative and the project should not be
undertaken.
Note, the $10,000 outflow could have been subtracted out of
the $40,000 inflow in the third year and the same answer
would result.
S12-16
15.
Skyline Corp. will invest $130,000 in a project that will not begin to produce returns until
after the 3rd year. From the end of the 3rd year until the end of the 12th year (10 periods),
the annual cash flow will be $34,000. If the cost of capital is 12 percent, should this project
be undertaken?
12-15.
Solution:
Skyline Corporation
Present Value of Inflows
Find the Present Value of a Deferred Annuity
A
PVA
PVA
= $192,100, n = 2, i = 12%
= FV PVIF (Appendix B)
= $192,100 .797 = $153,104
$153,104
130,000
$ 23,104
S12-17
16.
The Ogden Corporation makes an investment of $25,000, which yields the following
cash flows:
Year
1.................
2.................
3.................
4.................
5.................
a.
b.
c.
Cash Flow
$ 5,000
5,000
8,000
9,000
10,000
What is the present value with a 9 percent discount rate (cost of capital)?
What is the internal rate of return? Use the interpolation procedure shown in this
chapter.
In this problem would you make the same decision in parts a and b
12-16.
Solution:
Ogden Corporation
a.
Year
1
2
3
4
5
S12-18
12-16. (Continued)
Year
1
2
3
4
5
11% +
$1,274
(2%) = 11% + .883 (2%) = 11% + 1.77% = 12.77%
$1,443
S12-19
17.
The Danforth Tire Company is considering the purchase of a new machine that would
increase the speed of manufacturing and save money. The net cost of this machine is
$66,000. The annual cash flows have the following projections.
Year
1 ................
2 ................
3 ................
4 ................
5 ................
a.
b.
c.
Cash Flow
$21,000
29,000
36,000
16,000
8,000
12-17.
Solution:
The Danforth Tire Company
a.
S12-20
Present Value
$19,089
23,954
27,036
10,928
4,968
$85,975
66,000
$19,975
12-17. (Continued)
b. Internal Rate of Return
We will average the inflows to arrive at an assumed annuity.
$ 21,000
29,000
36,000
16,000
8,000
$110,000/5 = $22,000
We divide the investment by the assumed annuity value.
$66,000
= 3 = PVIFA
$22,000
Using Appendix D for n = 5, 20% appears to be a reasonable
first approximation (2.991). We try 20%.
Year
1
2
3
4
5
Since 20% is not high enough, we try the next highest rate
at 25%.
Year
1
2
3
4
5
12-17. (Continued)
The correct answer must fall between 20% and 25%. We
interpolate.
$69,391 .......... PV @ 20%
62,976 ........... PV @ 25%
$ 6,415
20% +
c.
18.
3,391
(5%) = 20% + .529 (5%) = 20% + 2.645% = 22.65%
6,415
The project should be accepted because the net present value
is positive and the IRR exceeds the cost of capital.
You are asked to evaluate two projects for Adventures Club, Inc. Using the net present
value method combined with the profitability index approach described in footnote 2 on
page ____, which project would you select? Use a discount rate of 12 percent.
Project X (trips to Disneyland)
($10,000 investment)
Year
1 ..............................
Cash Flow
$4,000
Year
1 .................................
Cash Flow
$10,800
2 ..............................
5,000
2 .................................
9,600
3 ..............................
4,200
3 .................................
6,000
4 ..............................
3,600
4 .................................
7,000
S12-22
12-18.
Solution:
Adventures Club, Inc.
NPV for Project X
Year
1
2
3
4
Cash Flow
PVIF at 12% Present Value
$4,000
.893
$ 3,572
5,000
.797
3,985
4,200
.712
2,990
3,600
.636
2,290
Present value of inflows
$12,837
Present value of outflows (Cost) 10,000
Net present value
$ 2,837
S12-23
12-18. (Continued)
You should select Project X because it has the higher
profitability index. This is true in spite of the fact that it has a
lower net present value. The profitability index may be
appropriate when you have different size investments. It tells
you that for every dollar of outflows, the present value of the
inflows is worth x dollars. For project X we get 1.2837 vs
1.1827 for project Y. Project X has the higher internal rate of
return but project Y will add more value to the firm.
19.
Cablevision, Inc., will invest $48,000 in a project. The firms discount rate (cost of capital)
is 9 percent. The investment will provide the following inflows.
1 ................
2 ................
3 ................
4 ................
5 ................
$10,000
10,000
16,000
19,000
20,000
b.
c.
If the reinvestment assumption of the net present value method is used, what will be
the total value of the inflows after five years? (Assume the inflows come at the end of
each year.)
If the reinvestment assumption of the internal rate of return method is used, what will
be the total value of the inflows after five years?
Generally is one investment assumption likely to be better than another?
S12-24
12-19.
Solution:
Cablevision, Inc.
a.
Inflows Rate
$10,000 9%
10,000 9%
16,000 9%
19,000 9%
20,000
No. of
Future
Periods Value Factor
4
1.412
3
1.295
2
1.188
1
1.090
0
1.000
Value
$14,120
12,950
19,008
20,710
20,000
$86,788
Inflows
$10,000
10,000
16,000
19,000
20,000
Rate
15%
15%
15%
15%
No. of
Future
Periods Value Factor
4
1.749
3
1.521
2
1.323
1
1.150
0
1.000
Value
$17,490
15,210
21,168
21,850
20,000
$95,718
S12-25
20.
The 21st Century Corporation uses the modified internal rate of return. The firm has a cost
of capital of 8 percent. The project being analyzed is as follows ($20,000 investment):
Year
1.................
2.................
3.................
a.
b.
Cash Flow
$10,000
9,000
6,800
12-20.
Solution:
21st Century Corporation
Terminal Value (end of year 3)
a.
Year 1
Year 2
Year 3
Period of
Growth
$10,000
2
9,000
1
6,800
0
FV factor (8%)
1.166
1.080
1.000
Terminal Value
Future
Value
$11,660
9,720
6,800
$28,180
PVIF =
=
PV
= (Appendix B)
FV
$20,000
= .7097
28,180
S12-26
12-20. (Continued)
b. The modified internal rate of return (MIRR) is lower than the
traditional internal rate of return because with the MIRR you
are assuming inflows are being reinvested at the cost of
capital (8%) whereas with the traditional internal rate of
return, you are assuming inflows are being reinvested at the
IRR (14.9 percent).
21.
Oliver Stone and Rock Company uses a process of capital rationing in its decision making.
The firms cost of capital is 12 percent. It will invest only $80,000 this year. It has
determined the internal rate of return for each of the following projects.
Project
A ..........................
B ..........................
C ..........................
D ..........................
E ..........................
F...........................
G ..........................
H ..........................
a.
b.
Project Size
$15,000
25,000
30,000
25,000
20,000
15,000
25,000
10,000
Percent of
Internal Rate of
Return
14%
19
10
16.5
21
11
18
17.5
S12-27
12-21.
Solution:
Oliver Stone and Rock Company
You should rank the investments in terms of IRR.
Project
E
B
G
H
D
A
F
C
IRR
21%
19
18
17.5
16.5
14
11
10
Project Size
$20,000
25,000
25,000
10,000
25,000
15,000
15,000
30,000
Total Budget
$ 20,000
45,000
70,000
80,000
105,000
120,000
135,000
165,000
S12-28
22.
Miller Electronics is considering two new investments. Project C calls for the purchase of a
coolant recovery system. Project H represents an investment in a heat recovery system.
The firm wishes to use a net present value profile in comparing the projects. The
investment and cash flow patterns are as follows:
a.
b.
c.
d.
e.
Year
Cash Flow
1 ...........................
$ 6,000
2 ...........................
7,000
3 ...........................
9,000
4 ...........................
13,000
Year
1 ..............................
2 ..............................
3 ..............................
Cash Flow
$20,000
6,000
5,000
Determine the net present value of the projects based on a zero discount rate.
Determine the net present value of the projects based on a 9 percent discount rate.
The internal rate of return on Project C is 13.01 percent, and the internal rate of return
on Project H is 15.68 percent. Graph a net present value profile for the two
investments similar to Figure 12-3. (Use a scale up to $10,000 on the vertical axis,
with $2,000 increments. Use a scale up to 20 percent on the horizontal axis, with
5 percent increments.)
If the two projects are not mutually exclusive, what would your acceptance or
rejection decision be if the cost of capital (discount rate) is 8 percent? (Use the net
present value profile for your decision; no actual numbers are necessary.)
If the two projects are mutually exclusive (the selection of one precludes the selection
of the other), what would be your decision if the cost of capital is (1) 5 percent,
(2) 13 percent, (3) 19 percent? Use the net present value profile for your answer.
S12-29
12-22.
Solution:
Miller Electronics
a.
Outflow
Inflows
Outflow
$25,000
b. 9% discount rate
Project C
Year
1
2
3
4
Cash Flow
PVIF at 9%
$ 6,000
.917
7,000
.842
9,000
.772
13,000
.708
Present value of inflows
Present value of outflows
Net present value
Present Value
$ 5,502
5,894
6,948
9,204
$27,548
25,000
$ 2,548
Cash Flow
PVIF at 9%
$20,000
.917
6,000
.842
5,000
.772
Present value of inflows
Present value of outflows
Net present value
Present Value
$18,340
5,052
3,860
$27,252
25,000
$ 2,252
Project H
Year
1
2
3
S12-30
12-22. (Continued)
c. Net Present Value Profile
Net present value
10,000
Project C
8,000
6,000
4,000
2,000
Project H
IRRH = 15.68%
0
5%
10%
15%
20%
IRRC = 13.01%
Discount rate (%)
d. Since the projects are not mutually exclusive, they both can
be selected if they have a positive net present value. At an
8% rate, they should both be accepted. As a side note, we can
see Project C is superior to Project H.
e. With mutually exclusive projects, only one can be accepted.
Of course, that project must still have a positive net present
value. Based on the visual evidence, we see:
(i) 5% cost of capitalselect Project C
(ii) 13% cost of capitalselect Project H
(iii) 19% cost of capitaldo not select either project
S12-31
23.
Cash Flow
$11,000
9,000
5,800
You are going to use the net present value profile to approximate the value for the internal
rate of return. Please follow these steps:
a. Determine the net present value of the project based on a zero discount rate.
b. Determine the net present value of the project based on a 10 percent discount rate.
c.
Determine the net present value of the project based on a 20 percent discount rate
(it will be negative).
d. Draw a net present value profile for the investment. (Use a scale up to $6,000 on the
vertical axis, with $2,000 increments. Use a scale up to 20 percent on the horizontal
axis, with 5 percent increments.) Observe the discount rate at which the net present
value is zero. This is an approximation of the internal rate of return on the project.
e.
Actually compute the internal rate of return based on the interpolation procedure
presented in this chapter. Compare your answers in parts d and e.
12-23.
Solution:
Software Systems
a.
S12-32
Present Value
$ 9,999
7,434
4,356
$21,789
20,000
$ 1,789
12-23. (Continued)
c. 20% Discount Rate
Year
1
2
3
Present Value
$ 9,163
6,246
3,358
$18,767
20,000
($ 1,233)
10%
15%
20%
Present Value
$ 9,570
6,804
3,816
$20,190
12-23. (Continued)
The second approximation is at 16%.
Year
1
2
3
Present Value
$ 9,482
6,687
3,718
$19,887
PV @ 15%
PV @ 16%
$20,190
20,000
$ 190
PV @ 15%
Cost
Howell Magnetics Corporation is going to purchase an asset for $400,000 that will produce
$180,000 per year for the next four years in earnings before depreciation and taxes. The
asset will be depreciated using the three-year MACRS depreciation schedule in Table 12-9.
(This represents four years of depreciation based on the half-year convention.) The firm is
in a 34 percent tax bracket. Fill in the schedule below for the next four years. (You need to
first determine annual depreciation.)
Earnings before depreciation and taxes
Depreciation
Earnings before taxes
Taxes
Earnings after taxes
+ Depreciation
Cash flow
S12-34
_____
_____
_____
_____
_____
_____
_____
12-24.
Solution:
Howell Magnetics Corporation
First determine annual depreciation.
Year
1
2
3
4
Percentage
Depreciation
(Table 12-9)
.333
.445
.148
.074
Depreciation
Base
$400,000
400,000
400,000
400,000
Annual
Depreciation
$133,200
178,000
59,200
29,600
$400,000
2
$180,000
178,000
2,000
680
1,320
178,000
$179,320
S12-35
3
$180,000
59,200
120,800
41,072
79,728
59,200
$138,928
4
$180,000
29,600
150,400
51,136
99,264
29,600
$128,864
25.
Assume $80,000 is going to be invested in each of the following assets. Using Tables 12-8
and 12-9, indicate the dollar amount of the first years depreciation.
a. Computers
b. Petroleum refining product
c.
Office furniture
d. Pipeline distribution
12-25.
Solution:
a.
S12-36
26.
The Keystone Corporation will purchase an asset that qualifies for three-year MACRS
depreciation. The cost is $60,000 and the asset will provide the following stream of
earnings before depreciation and taxes for the next four years:
Year 1 ..................
Year 2 ..................
Year 3 ..................
Year 4 ..................
$27,000
30,000
23,000
15,000
The firm is in a 36 percent tax bracket and has an 11 percent cost of capital. Should it
purchase the asset?
12-26.
Solution:
The Keystone Corporation
Year
1
2
3
4
Percentage
Depreciation
(Table 12-9)
.333
.445
.148
.074
Depreciation
Base
$60,000
60,000
60,000
60,000
Annual
Depreciation
$19,980
26,700
8,880
4,440
$60,000
1
$27,000
19,980
7,020
2,527
4,493
19,980
$24,473
2
$30,000
26,700
3,300
1,188
2,112
26,700
$28,812
S12-37
3
$23,000
8,880
14,120
5,083
9,037
8,880
$17,917
4
$15,000
4,440
10,560
3,802
6,758
4,440
$11,198
12-26. (Continued)
Then determine the net present value.
Year
1
2
3
4
Cash Flow
(inflows)
PVIF @ 11%
$24,473
.901
28,812
.812
17,917
.731
11,198
.659
Present value of inflows
Present value of outflows
Net present value
Present
Value
$22,050
23,395
13,097
7,379
$65,921
60,000
$ 5,921
S12-38
27.
Oregon Forest Products will acquire new equipment that falls under the five-year MACRS
category. The cost is $300,000. If the equipment is purchased, the following earnings
before depreciation and taxes will be generated for the next six years.
Year 1 .....................
Year 2 .....................
Year 3 .....................
Year 4 .....................
Year 5 .....................
Year 6 .....................
$112,000
105,000
82,000
53,000
37,000
32,000
The firm is in a 30 percent tax bracket and has a 14 percent cost of capital. Should
Oregon Forest Products purchase the equipment? Use the net present value method.
12-27.
Solution:
Oregon Forest Products
First determine annual depreciation.
Year
1
2
3
4
5
6
Depreciation
Base
$300,000
300,000
300,000
300,000
300,000
300,000
S12-39
Percentage
Depreciation
(Table 12-9)
.200
.320
.192
.115
.115
.058
Annual
Depreciation
$ 60,000
96,000
57,600
34,500
34,500
17,400
$300,000
12-27. (Continued)
Then determine the annual cash flow.
Annual Cash Flow
1
2
3
4
5
6
EBDT
$112,000 $105,000 $82,000 $53,000 $37,000 $32,000
D
60,000
96,000 57,600 34,500 34,500 17,400
EBT
52,000
9,000 24,400 18,500
2,500 14,600
T (30%)
15,600
2,700
7,320
5,550
750
4,380
EAT
36,400
6,300 17,080 12,950
1,750 10,220
+D
60,000
96,000 57,600 34,500 34,500 17,400
Cash Flow $ 96,400 $102,300 $74,680 $47,450 $36,250 $27,620
Then determine the net present value.
Year
1
2
3
4
5
6
Cash Flow
(inflows)
PVIF @ 14%
$ 96,400
.877
102,300
.769
74,680
.675
47,450
.592
36,250
.519
27,620
.456
Present value of inflows
Present value of outflows
Net present value
S12-40
Present
Value
$ 84,543
78,669
50,409
28,090
18,814
12,595
$273,120
300,000
($ 26,880)
28.
12-28.
Solution:
The Thorpe Corporation
Because the manufacturing equipment has a 10-year midpoint
of its asset depreciation range (ADR), it falls into the sevenyear MACRS category as indicated in Table 12-8.
Furthermore, we see that most types of manufacturing
equipment fall into the seven-year MACRS category.
With seven-year MACRS depreciation, the asset will be
depreciated over eight years (based on the half-year
convention). Also, we observe that the equipment will produce
earnings for 10 years, so in the last two years there will be no
depreciation write-off.
We first determine the annual depreciation.
Year
1
2
3
4
5
6
7
8
Depreciation
Base
$80,000
80,000
80,000
80,000
80,000
80,000
80,000
80,000
S12-41
Percentage
Depreciation
(Table 12-9)
.143
.245
.175
.125
.089
.089
.089
.045
Annual
Depreciation
$11,440
19,600
14,000
10,000
7,120
7,120
7,120
3,600
$80,000
12-28. (Continued)
Then determine the annual cash flow:
Annual Cash Flow
S13-42
EBDT
D
EBT
T (34%)
EAT
+D
Cash Flow
1
$28,000
11,440
$16,560
5,630
$10,930
11,440
$22,370
2
$28,000
19,600
$ 8,400
2,856
$ 5,544
19,600
$25,144
3
$28,000
14,000
$14,000
4,760
$ 9,240
14,000
$23,240
4
$12,000
10,000
$ 2,000
680
$ 1,320
10,000
$11,320
5
$12,000
7,120
$ 4,880
1,659
$ 3,221
7,120
$10,341
6
$12,000
7,120
$ 4,880
1,659
$ 3,221
7,120
$10,341
7
8
9
10
$12,000 $12,000 $12,000 $12,000
7,120
3,600
0
0
$ 4,880 $ 8,400 $12,000 $12,000
1,659
2,856
4,080
4,080
$ 3,221 $ 5,544 $ 7,920 $ 7,920
7,120
3,600
0
0
$10,341 $ 9,144 $ 7,920 $ 7,920
12-28. (Continued)
Next determine the net present value.
Year
1
2
3
4
5
6
7
8
9
10
Cash Flow
(inflows)
PVIF @ 12%
$22,370
.893
25,144
.797
23,240
.712
11,320
.636
10,341
.567
10,341
.507
10,341
.452
9,144
.404
7,920
.361
7,920
.322
Present value of inflows
Present value of outflows
Net present value
Present
Value
$19,976
20,040
16,547
7,200
5,863
5,243
4,674
3,694
2,859
2,550
$88,646
80,000
$ 8,646
The Spartan Technology Company has a proposed contract with the Digital Systems Company
of Michigan. The initial investment in land and equipment will be $120,000. Of this amount,
$70,000 is subject to five-year MACRS depreciation. The balance is in nondepreciable property.
The contract covers six years; at the end of six years, the nondepreciable assets will be sold for
$50,000, which is their original cost. The depreciated assets will have zero resale value.
The contract will require an additional investment of $55,000 in working capital at the
beginning of the first year and, of this amount, $25,000 will be returned to the Spartan
Technology Company after six years.
The investment will produce $50,000 in income before depreciation and taxes for each of
the six years. The corporation is in a 40 percent tax bracket and has a 10 percent cost of capital.
Should the investment be undertaken? Use the net present value method.
12-29.
Solution:
Spartan Technology Company
Although there are some complicating features in the problem,
we are still comparing the present value of cash flows to the
total initial investment.
The initial investment is:
Land and equipment .........
Working capital ................
Initial investment ..............
$120,000
55,000
$175,000
Year
1
2
3
4
5
6
Depreciation
Base
$70,000
70,000
70,000
70,000
70,000
70,000
Percentage
Depreciation
(Table 12-9)
.200
.320
.192
.115
.115
.058
Annual
Depreciation
$14,000
22,400
13,440
8,050
8,050
4,060
$70,000
12-29. (Continued)
Then determine the annual cash flow.
Annual Cash Flow
1
2
3
4
5
$50,000 $50,000 $50,000 $50,000 $50,000
14,000 22,400 13,440
8,050
8,050
36,000 27,600 36,560 41,950 41,950
14,400 11,040 14,624 16,780 16,780
21,600 16,560 21,936 25,170 25,170
14,000 22,400 13,440
8,050
8,050
6
$50,000
4,060
45,940
18,376
27,564
4,060
EBDT
D
EBT
T (40%)
EAT
+D
+ Sale of non
Depreciable
assets
50,000
+ Recovery
of working
capital
25,000
Cash Flow $35,600 $38,960 $35,376 $33,220 $33,220 $106,624
We then determine the net present value.
Year
1
2
3
4
5
6
Cash Flow
(inflows)
PVIF @ 10%
$ 35,600
.909
38,960
.826
35,376
.751
33,220
.683
33,220
.621
106,624
.564
Present value of inflows
Present value of outflows
Net present value
Present
Value
$ 32,360
32,181
26,567
22,689
20,630
60,136
$194,563
175,000
$ 19,563
30.
An asset was purchased three years ago for $140,000. It falls into the five-year category for
MACRS depreciation. The firm is in a 35 percent tax bracket. Compute the:
a. Tax loss on the sale and the related tax benefit if the asset is sold now for $15,320.
b. Gain and related tax on the sale if the asset is sold now for $58,820. (Refer to footnote 3.)
12-30.
Solution:
First determine the book value of the asset.
Depreciation
Year
Base
1
$140,000
2
140,000
3
140,000
Total depreciation to date
Purchase price
Total depreciation to date
Book value
Percentage
Depreciation
(Table 12-9)
.200
.320
.192
$140,000
99,680
$ 40,320
$40,320
15,320
$25,000
$25,000
35%
$ 8,750
$58,820
40,320
18,500
35%
$ 6,475
Annual
Depreciation
$28,000
44,800
26,880
$99,680
31.
Amount
$85,000
75,000
60,000
52,500
45,000
40,000
The tax rate is 30 percent. The cost of capital must be computed based on
the following (round the final value to the nearest whole number):
Debt ............................................................
Preferred stock ...........................................
Common equity (retained earnings). ..........
a.
b.
c.
d.
Kd
Kp
Ke
Cost (aftertax)
7.0%
10.0
16.0
Weights
40%
10
50
12-31.
Solution:
Polycom technology
a.
Year
1
2
3
4
5
6
b.
EBDT
D
EBT
T (30%)
EAT
+D
+ Recovery
of working
capital
Cash Flow
Depreciation
Base
$ 110,000
110,000
110,000
110,000
110,000
110,000
Percentage
Depreciation
(Table 12-9)
.200
.320
.192
.115
.115
.058
Annual
Depreciation
$ 22,000
35,200
21,120
12,650
12,650
6,380
$110,000
6
$40,000
6,380
33,620
10,086
23,534
6,380
15,000
$44,914
12-31. (Continued)
c.
40%
10%
50%
2.80%
1.00%
8.00%
11.80%
Round to 12%
d.
Cash Flow
(inflows)
PVIF @ 12%
$66,100
.893
63,060
.797
48,336
.712
40,545
.636
35,295
.567
44,914
.507
Present value of inflows
*Present value of outflows
Net present value
Present
Value
$59,027
50,258
34,415
25,787
20,012
22,771
212,270
170,000
$42,270
32.
Graphic Systems purchased a computerized measuring device two years ago for $80,000.
It falls into the five-year category for MACRS depreciation. The equipment can currently
be sold for $28,400.
A new piece of equipment will cost $210,000. It also falls into the five-year category
for MACRS depreciation.
Assume the new equipment would provide the following stream of added cost savings
for the next six years.
Year
1 ................
2 ................
3 ................
4 ................
5 ................
6 ................
Cash Flow
$76,000
66,000
62,000
60,000
56,000
42,000
12-32.
Solution:
Replacement Decision Analysis Graphic Systems
a.
Depreciation
Year
Base
1
$80,000
2
80,000
Total depreciation to date
Purchase price
Total depreciation to date
Book value
Percentage
Depreciation
(Table 12-9)
.200
.320
Annual
Depreciation
$16,000
25,600
$41,600
$80,000
41,600
$38,400
b. Book value
Sales price
Tax loss on the sale
$38,400
28,400
$10,000
$10,000
34%
$ 3,400
$28,400
3,400
$31,800
$210,000
31,800
$178,200
12-32. (Continued)
f.
Year
1
2
3
4
5
6
Depreciation
Base
$210,000
210,000
210,000
210,000
210,000
210,000
Percentage
Depreciation
(Table 12-9)
.200
.320
.192
.115
.115
.058
Annual
Depreciation
$ 42,000
67,200
40,320
24,150
24,150
12,180
$210,000
Year
1
2
3
4
Depreciation
Base
$80,000
80,000
80,000
80,000
Percentage
Depreciation
(Table 12-9)
.192
.115
.115
.058
Annual
Depreciation
$15,360
9,200
9,200
4,640
* The next four years represent the last four years on the old
equipment.
12-32. (Continued)
h. Incremental depreciation and tax shield benefits.
(1)
(2)
(3)
(4)
Depreciation Depreciation
on new
on old
Incremental
Equipment Equipment Depreciation
$42,000
$15,360
$26,640
67,200
9,200
58,000
40,320
9,200
31,120
24,150
4,640
19,510
24,150
24,150
12,180
12,180
Year
1
2
3
4
5
6
i.
(5)
Tax
Rate
.34
.34
.34
.34
.34
.34
Savings
$76,000
66,000
62,000
60,000
56,000
42,000
After tax
(1-Tax Rate) Savings
.66
$50,160
.66
43,560
.66
40,920
.66
39,600
.66
36,960
.66
27,720
(6)
Tax
Shield
Benefits
$ 9,058
19,720
10,581
6,633
8,211
4,141
12-32. (Continued)
j.
(2)
(3)
(4)
(5)
(6)
Tax Shield
Present
Benefits
After
Total
Value
from
Tax Cost Annuity Factor Present
Year Depreciation Savings Benefits
12%
Value
1
$ 9,058
$50,160 $59,218 .893
$ 52,882
2
19,720
43,560
63,280 .797
50,434
3
10,581
40,920
51,501 .712
36,669
4
6,633
39,600
46,233 .636
29,404
5
8,211
36,960
45,171 .567
25,612
6
4,141
27,720
31,861 .507
16,154
Present value of incremental benefits
$211,155
k. Present value of incremental benefits
Net cost of new equipment
Net present value
$211,155
178,200
$ 32,955
COMPREHENSIVE PROBLEM
The Woodruff Corporation purchased a piece of equipment three years ago for $230,000. It has
an asset depreciation range (ADR) midpoint of eight years. The old equipment can be sold for
$90,000.
A new piece of equipment can be purchased for $320,000. It also has an ADR of eight years.
Assume the old and new equipment would provide the following operating gains (or losses)
over the next six years.
1 .............
2 .............
3 .............
4 .............
5 .............
6 .............
New Equipment
$80,000
76,000
70,000
60,000
50,000
45,000
Old Equipment
$25,000
16,000
9,000
8,000
6,000
(7,000)
The firm has a 36 percent tax rate and a 9 percent cost of capital. Should the new equipment
be purchased to replace the old equipment?
CP 12-1. Solution:
Woodruff Corporation
Book Value of Old Equipment
(ADR of 8 years indicates the use of the 5-year MACRS
schedule)
Year
1
2
3
Percentage
Depreciation Depreciation
Annual
Base
(Table 12-9) Depreciation
$230,000
.200
$ 46,000
230,000
.320
73,600
230,000
.192
44,160
Total depreciation to date
$163,760
163,760
$ 66,240
$ 90,000
66,240
23,760
36%
$ 8,554
$90,000
-8,554
$81,446
CP 12-1. (Continued)
Depreciation Schedule of the New Equipment.
(ADR of 8 years indicates the use of 5-year MACRS Schedule)
Year
1
2
3
4
5
6
Depreciation
Base
$320,000
320,000
320,000
320,000
320,000
320,000
Percentage
Depreciation
Annual
(Table 12-9) Depreciation
.200
$ 64,000
.320
102,400
.192
61,440
.115
36,800
.115
36,800
.058
18,560
$320,000
Year*
1
2
3
Depreciation
Base
$230,000
230,000
230,000
Percentage
Depreciation
Annual
(Table 12-9) Depreciation
.115
$26,450
.115
26,450
.058
13,340
*The next three years represent the last three years of the old
equipment.
CP 12-1. (Continued)
Incremental Depreciation and Tax Shield Benefits.
(1)
(2)
(3)
(4)
(5)
Depreciation Depreciation
on New
on Old
Incremental Tax
Year Equipment Equipment Depreciation Rate
1
$ 64,000
$26,450
$37,550
.36
2
102,400
26,450
75,950
.36
3
61,440
13,340
48,100
.36
4
36,800
36,800
.36
5
36,800
36,800
.36
6
18,560
18,560
.36
(6)
Tax
Shield
Benefits
$13,518
27,342
17,316
13,248
13,248
6,682
Cost
Savings
$55,000
60,000
61,000
52,000
44,000
52,000
(1 Tax
Rate)
.64
.64
.64
.64
.64
.64
Aftertax
Savings
$35,200
38,400
39,040
33,280
28,160
33,280
CP 12-1. (Continued)
Present value of the total incremental benefits.
(1)
(2)
(3)
(4)
(5)
Tax Shield
Present
Benefits
After Tax
Total
Value
from
Cost
Annuity
Factor
Year Depreciation Savings
Benefits
9%
1
$13,518
$35,200
$48,718
.917
2
27,342
38,400
65,742
.842
3
17,316
39,040
56,356
.772
4
13,248
33,280
46,528
.708
5
13,248
28,160
41,408
.650
6
6,682
33,280
39,962
.596
Present value of incremental Benefits
(6)
Present
Value
$ 44,674
55,355
43,507
32,942
26,915
23,817
$227,210