Please group each chapter onto ONE TAB in Excel.
CHAPTER 9, 9-2, 9-5, 9-6, 9-8
(9-2) LL Incorporated’s currently outstanding 11% coupon bonds have a yield to maturity of
8%. LL believes it could issue new bonds at par that would provide a similar yield to maturity. If its marginal tax rate is 35%, what is LL’s after-tax cost of debt?
(9-5) Summerdahl Resort’s common stock is currently trading at $36 a share. The stock is
expected to pay a dividend of $3.00 a share at the end of the year (D1 = $3.00), and the
dividend is expected to grow at a constant rate of 5% a year. What is its cost of commonequity?
(9-6) Booher Book Stores has a beta of 0.8. The yield on a 3-month T-bill is 4%, and the yield
on a 10-year T-bond is 6%. The market risk premium is 5.5%, and the return on an
average stock in the market last year was 15%. What is the estimated cost of common equity using the CAPM?
(9-8) David Ortiz Motors has a target capital structure of 40% debt and 60% equity. The yield to
maturity on the company’s outstanding bonds is 9%, and the company’s tax rate is 40%.
Ortiz’s CFO has calculated the company’s WACC as 9.96%. What is the company’s cost ofequity capital?
CHAPTER 10, 10-1, 10-2, 10-3, 10-4, 10-5, 10-6, 10-8
(10-1) A project has an initial cost of $40,000, expected net cash inflows of $9,000 per year for 7
years, and a cost of capital of 11%. What is the project’s NPV? (Hint: Begin byconstructing a time line.)
(10-2) Refer to Problem 10-1. What is the project’s IRR?
(10-3) Refer to Problem 10-1. What is the project’s MIRR?
(10-4) Refer to Problem 10-1. What is the project’s PI?
(10-5) Refer to Problem 10-1. What is the project’s payback period?
(10-6) Refer to Problem 10-1. What is the project’s discounted payback period?
(10-8) Edelman Engineering is considering including two pieces of equipment, a truck and anoverhead pulley system, in this year’s capital budget. The projects are independent. The
cash outlay for the truck is $17,100 and that for the pulley system is $22,430. The firm’s
cost of capital is 14%. After-tax cash flows, including depreciation, are as follows:
Year Truck Pulley
1 $5,100 $7,500
2 $5,100 $7,500
3 $5,100 $7,500
4 $5,100 $7,500
5 $5,100 $7,500
Calculate the IRR, the NPV, and the MIRR for each project, and indicate the correct accept–reject decision for each.
CHAPTER 11, 11-1, 11-2, 11-3, 11-4, 11-6
(11-1) Talbot Industries is considering launching a new product. The new manufacturing
equipment will cost $17 million, and production and sales will require an initial $5 million
investment in net operating working capital. The company’s tax rate is 40%.
a. What is the initial investment outlay?
b. The company spent and expensed $150,000 on research related to the new product
last year. Would this change your answer? Explain.
c. Rather than build a new manufacturing facility, the company plans to install the
equipment in a building it owns but is not now using. The building could be sold for
$1.5 million after taxes and real estate commissions. How would this affect youranswer?
(11-2) The financial staff of Cairn Communications has identified the following information for
the first year of the roll-out of its new proposed service:
Projected sales: $18 million
Operating costs (not including depreciation): $9 million
Depreciation: $4 million
Interest expense: $3 million
The company faces a 40% tax rate. What is the project’s operating cash flow for the first
year (t = 1)?
(11-3) Allen Air Lines must liquidate some equipment that is being replaced. The equipment
originally cost $12 million, of which 75% has been depreciated. The used equipment can
be sold today for $4 million, and its tax rate is 40%. What is the equipment’s after-tax net
salvage value?
(11-4) Although the Chen Company’s milling machine is old, it is still in relatively good workingorder and would last for another 10 years. It is inefficient compared to modern standards,though, and so the company is considering replacing it. The new milling machine, at acost of $110,000 delivered and installed, would also last for 10 years and would produceafter-tax cash flows (labor savings and depreciation tax savings) of $19,000 per year. Itwould have zero salvage value at the end of its life. The firm’s WACC is 10%, and itsmarginal tax rate is 35%. Should Chen buy the new machine?
(11-6) The Campbell Company is considering adding a robotic paint sprayer to its
production line. The sprayer’s base price is $1,080,000, and it would cost another
$22,500 to install it. The machine falls into the MACRS 3-year class, and it would be
sold after 3 years for $605,000. The MACRS rates for the first three years are 0.3333,
0.4445, and 0.1481. The machine would require an increase in net working capital
(inventory) of $15,500. The sprayer would not change revenues, but it is expected to
save the firm $380,000 per year in before-tax operating costs, mainly labor.
Campbell’s marginal tax rate is 35%.
a. What is the Year 0 net cash flow?
b. What are the net operating cash flows in Years 1, 2, and 3?
c. What is the additional Year-3 cash flow (i.e., the after-tax salvage and the return of
working capital)?
d. If the project’s cost of capital is 12%, should the machine be purchased?
CHAPTER 12, 12-1, 12-2
(12-1) Broussard Skateboard’s sales are expected to increase by 15% from $8 million in
2013 to $9.2 million in 2014. Its assets totaled $5 million at the end of 2013.
Broussard is already at full capacity, so its assets must grow at the same rate as
projected sales. At the end of 2013, current liabilities were $1.4 million, consisting
of $450,000 of accounts payable, $500,000 of notes payable, and $450,000 of
accruals. The after-tax profit margin is forecasted to be 6%, and the forecasted
payout ratio is 40%. Use the AFN equation to forecast Broussard’s additional funds
needed for the coming year.
(12-2) Refer to Problem 12-1. What would be the additional funds needed if the company’s yearend2013 assets had been $7 million? Assume that all other numbers, including sales, arethe same as in Problem 12-1 and that the company is operating at full capacity. Why is
this AFN different from the one you found in Problem 12-1? Is the company’s “capital
intensity” ratio the same or different?