Worksheet: Cost of Capital

cost_of_Capital_Worksheet.xlsx

STudent_Fill_In

Your Name (type over this)		Note:	use full numbers not 000s or millions
Name of Company (type over this)			enter all % as decimal (10%=.10)
	type below	type below
cost of debt:		source of information
Book Value Long Term Debt	fill in	fill in
Bk Value Current Maturity Long Term Debt	fill in	fill in
total cost of long term debt	ERROR:#VALUE!
Interest Expense	fill in	fill in
calculated interest rate	ERROR:#VALUE!	<= or you may type in average interest rate given in statements
interest rate before tax, most recent debt issue	fill in	fill in
Earnings Before Tax	fill in	fill in
Income Tax Expense	fill in	fill in
Income Tax Rate	ERROR:#VALUE!
After Tax cost of debt	ERROR:#VALUE!
cost of equity
risk free rate	fill in	fill in
market rate	fill in	fill in
equity risk premium	ERROR:#VALUE!
number of common shares outstanding	fill in	fill in	if annual report, include page number
market price per share	fill in	fill in
value of common stock	ERROR:#VALUE!
total value of capital	ERROR:#VALUE!
firm's beta	fill in	fill in
weighted cost of capital	ERROR:#VALUE!

here you will type in your interpretation of what all you did means. How will the company use the cost of capital?