# AQ&Q has EBIT of $2 million, total assets of $10 million, stockholders’ equity of $4 million, and pretax interest expense of 10 percent.

1. Find the NPV and PI of a project that costs $1,500 and returns $800 in year one and $850 in year two. Assume the project’s cost of capital is 8 percent.

5. For the following projects, compute NPV, IRR, MIRR, profitability index, and payback. If these projects are mutually exclusive, which one(s) should be done? If they are independent, which one(s) should be undertaken?

i. A B C D

Year 0 –1,000 –1,500 –500 –2,000

Year 1 400 500 100 600

Year 2 400 500 300 800

Year 3 400 700 250 200

Year 4 400 200 200 300

Discount rate 10% 12% 15% 8%

1. AQ&Q has EBIT of $2 million, total assets of $10 million, stockholders’ equity of $4 million, and pretax interest expense of 10 percent.

a. What is AQ&Q’s indifference level of EBIT?

b. Given its current situation, might it benefit from increasing or decreasing its use of debt? Explain.

c. Suppose we are told AQ&Q’s average tax rate is 40 percent. How does this affect your answers to (a) and (b)?

9. The following are balance sheets for the Genatron Manufacturing Corporation for the years 2010 and 2011:

BALANCE SHEET 2010 2011

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 weighted average cost of capital 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 there are 30,000 shares outstanding. Calculate the WACC using market value weights and the component capital costs in (a).

c. Recalculate the WACC based on both book value and market value weights assuming that 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.

## FIN350 ch 17 and ch18 solution with working in excel

body preview (0 words)

file1.xlsx preview (568 words)

# Sheet1

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx x | |||||||||

xxxx xxx NPV xxx PI xx a project xxxx xxxxx xxxxxx xxx returns xxxx xx year one xxx $850 in year xxxx Assume the project’s cost xx xxxxxxx is x xxxxxxxx | |||||||||

xxxx | xxxx xxxx | Present xxxxxx xx xx | xxxxxxx xxxxx | ||||||

1 | xxx | 0.92592592592592582 | 740.74074074074065 | ||||||

x | xxx | 0.8573388203017831 | 728.7379972565 | ||||||

xxxxxxx | |||||||||

xxxx | xxxxx | ||||||||

NPV x | xxxxxx | ||||||||

xx = PV xx xxxx FLOW/COST x xxxxxxxxxxxx x | xxxx | ||||||||

xxxxxxxx 5 | |||||||||

For xxx xxxxxxxxx projects, xxxxxxx NPV, IRR, xxxxx xxxxxxxxxxxxx index, xxx xxxxxxxx If xxxxx projects xxx xxxxxxxx xxxxxxxxxx which xxxxxx should be done? | |||||||||

If xxxx are independent, xxxxx xxxxxx should xx undertaken? | |||||||||

Project | Cumulative cash flow xxx calculating xxxxxxx xxxxxx | ||||||||

xxxx | A | x | C | x | Year | A | B | C | D |

x | -1000 | xxxxx | -500 | -2000 | x | xxxxx | -1500 | -500 | xxxxx |

1 | 400 | 500 | 100 | 600 | x | xxxx | -1000 | -400 | xxxxx |

2 | 400 | xxx | xxx | 800 | 2 | -200 | xxxx | xxxx | -600 |

3 | 400 | 700 | xxx | 200 | x | 200 | 200 | xxx | xxxx |

x | 400 | xxx | xxx | xxx | x | 600 | 400 | xxx | xxxx |

Discount xxxx | 10% | 12% | 15% | xx | |||||

xxx | x 267.95 | x (29.62) | x 92.53 | x (379.30) | xxxxxx xxxxxxxx Formula xxxxxx | ||||

xxx | 21.86% | xxxxxx | 23.13% | xxxxxx | xxxxxx Ms-Excel xxxxxxx IRR()] | ||||

MIRR | xxxxxx | 11.44% | 19.99% | 2.47% | [Using Ms-Excel xxxxxxx MIRR()] | ||||

PI | 1.27 | 0.98 | 1.19 | 0.81 | [PV of future cash flows / Initial Investment] | ||||

Payback | xxxx | xxxx | xxxx | >4 xxxxx | |||||

xxxxxxxx xxxxxxxxxx | |||||||||

For the xxxxxxxx xxxxxxxxx xxxxxxxx xxxx project xxxxxx be selected. So Project x xxxxxx be xxxxxxxx xxxxx it has | |||||||||

xxxxxxx positive NPV xxx very high IRR xxxx discount rate compared to xxxxxxx |

- - - more text follows - - -

Try it before you buy it |