Using Excel, complete the following problems from chapters 17 and 18 in the textbook:
- P17-11. Find the net present value (NPV) and profitability index (PI) of aproject that costs $1,500 and returns $800 in year one and $850 inyear two. Assume the project’s cost of capital is 8 percent.P17-5
- P17-6
6. The Sanders Electric Company is evaluating two projects for
possible inclusion in the fi rm’s capital budget. Project M will
require a $37,000 investment while project O’s investment will be
$46,000. After-tax cash inflows are estimated as follows for the two
projects:
YEAR PROJECT M PROJECT O
1 $12,000 $10,000
2 12,000 10,000
3 12,000 15,000
4 12,000 15,000
5 15,000
a. Determine the payback period for each project.
b. Calculate the NPV and PI for each project based on a 10
percent cost of capital. Which, if either, of the projects is
acceptable?
c. Determine the IRR and MIRR for Projects M and O.
- P17-10
10. A machine can be purchased for $10,500, including transportation
charges, but installation costs will require $1,500 more. The
machine is expected to last four years and produce annual cash revenues
of $6,000. Annual cash operating expenses are expected to be
$2,000, with depreciation of $3,000 per year. The fi rm has a 30
percent tax rate. Determine the relevant after-tax cash flows and
prepare a cash flow schedule.
- P17-11
11. Use the information in Problem 10 to do the following:
a. Calculate the payback period for the machine.
b. If the project’s cost of capital is 10 percent, would you
recommend buying the machine?
c Estimate the IRR for the machine.
- P18-3
3. Stern’s Stews, Inc., is considering a new capital structure. Its
current and proposed capital structures are the following:
CURRENT PROPOSED
Total assets $150 million $150 million
Debt 25 million 100 million
Equity 125 million 50 million
Common stock price $50 $50
Number of shares 2,500,000 1,000,000
Interest rate 12% 12%
Stern’s Stews’ president expects next year’s EBIT to be $20 million, but
it may be 25 percent higher or lower. Ignoring taxes, perform an EBIT/
eps analysis. What is the indifference level of earnings before interest
and taxes? Should Stern’s Stews change its capital structure? Why?
- P18-7
7. Here are the income statements for Genatron Manufacturing
Corporation for 2013 and 2014:
INCOME STATEMENT 2013 2014
Net sales $1,300,000 $1,500,000
Cost of goods sold 780,000 900,000
Gross profi t $520,000 $600,000
General and administrative 150,000 150,000
Marketing expenses 130,000 150,000
Depreciation 40,000 53,000
Interest 45,000 57,000
Earnings before taxes $155,000 $190,000
Income taxes 62,000 76,000
Net income $93,000 $114,000
Assuming one-half of the general and administrative expenses are fi xed
costs, estimate Genatron’s DOL, DFL, and DCL in 2013 and 2014.
- P18-8
8. The Nutrex Corporation wants to calculate its weighted average
cost of capital (WACC). Its target capital structure weights are 40
percent long-term debt and 60 percent common equity. The beforetax
cost of debt is estimated to be 10 percent and the company is in
the 40 percent tax bracket. The current risk-free interest rate is 8
percent on Treasury bills. The expected return on the market is 13
percent and the fi rm’s stock beta is 1.8.
a. What is Nutrex’s cost of debt?
b. Estimate Nutrex’s expected return on common equity using
the security market line (SML).
c. Calculate the after-tax weighted average cost of capital (WACC).
- P18-9
9. The following are balance sheets for the Genatron Manufacturing
Corporation for the years 2013 and 2014:
BALANCE SHEET 2013 2014
Cash $50,000 $40,000
Accounts receivable 200,000 260,000
Inventory 450,000 500,000
Total current assets 700,000 800,000
Fixed assets (net) 300,000 400,000
Total assets $1,000,000 $1,200,000
Bank loan, 10% $90,000 $ 90,000
Accounts payable 130,000 170,000
Accruals 50,000 70,000
Total current liabilities $270,000 $330,000
Long-term debt, 12% 300,000 400,000
Common stock, $10 par 300,000 300,000
Capital surplus 50,000 50,000
Retained earnings 80,000 120,000
Total liabilities and equity $1,000,000 $1,200,000
a. Calculate the WACC based on book value weights. Assume an
after-tax cost of new debt of 8.63 percent and a cost of
common equity of 16.5 percent.
b. The current market value of Genatron’s long-term debt is
$350,000. The common stock price is $20 per share and
30,000 shares are outstanding. Calculate the WACC using
market value weights and the component capital costs in (a).
c. Recalculate the WACC based on book value and market
value weights assuming the before-tax cost of debt will be
18 percent, the company is in the 40 percent income tax
bracket, and the after-tax cost of common equity capital is
21 percent.