USING EXCEL AND MAKE ALL FORMULAS VIEWABLE

A stock analyst has obtained the following information about J-Mart, a large pharmacy chain:

- The company has noncallable bonds with 20 years maturity remaining and a maturity value of $1,000. The bonds have a 12 percent annual coupon and currently sell at a price of $1,273.86.

- Over the past four years, the returns on the market and on J-Mart were as follows:

Year	Market	J-Mart
1	12.0%	14.5%
2	17.2%	22.2%
3	-3.8%	-7.5%
4	20.0%	24.0%

- The risk-free rate is 6.35 percent, and the expected return on the market is 11.35 percent. The company's tax rate is 35 percent.

The company anticipates that its proposed investment projects will be financed with 70 percent debt and 30 percent equity. What is the company's estimated corporate cost of capital (CCC)? (Hint: Refer to Chapter 5 Model to see how to estimate beta (b).)

	Spreadsheet solution:
Number of periods (nper)		20
Coupon rate		12%
Maturity value (i.e. FV)		$1,000
Annual coupon payment (pmt)		$120.00
Current Price (PV)		$1,273.86
	R(Rd)
	RF	6.35%
	R(Rm)	11.35%
	b	0.7%
	R(Re)
	wd =
	R(Rd) =		=C27
	T =	35%
	we =	0.3%
	R(Re) =		=C32
	CCC =