Use the data the answer the questions.

Source	Price	Units	Total Market Value	% of Total	After-tax Cost (With FC)
Debt	$ 904.53	400	$ 361,812	31.14%
Preferred	100.00	1,000	100,000	8.61%
Common	70.00	10,000	700,000	60.25%
Totals			$ 1,161,812	100.00%
Additional Bond Data		Additional Preferred Data		Additional Common Data
Tax Rate	30%	Dividend	$ 10.00	Dividend 0	$ 3.96
Coupon Rate (Annual)	8%	Flotation Cost	2.00%	Growth Rate	6%
Face Value	$ 1,000.00			Flotation Cost	3.50%
Maturity	10
Flotation Cost	1.50%

----------------------------------------------------------------------------------

1. What is the after-tax cost of debt (with FC) using the =rate() function? Don't forget to include float cost (FC).

2. What is the after-tax cost of preferred stock (with FC)? Kps=D/(P-FC)

3. What is the after-tax cost of common stock (with FC)?

4. What is the firm's WACC (with FC)?

5. Assume that new equipment with a 10-year anticipated life costs $100,000 and after 10 years the equipment is expected to be sold for $20,000. Using the =SLN() function, what is depreciation expected to be on an annual basis?