Suppose a beverage company is considering adding a new product line.

Currently the company sells packaged drinks and they are considering selling a new coffee drink.

The coffee drink will have a selling price of $$4\mathrm{.}89$ per can. The plant has excess capacity in a

fully depreciated building to process the coffee drink. The coffee drink will be discontinued in four years.

The new equipment is depreciated to zero using straight line depreciation. The new coffee drink requires

an increase in working capital of $$30,000$ and $$5,000$ of this increase is offset with accounts payable.

Projected sales are $80,000$ cans of coffee drink the first year, with a $7$ percent growth for the following years.

Variable costs are $46\%$ of total revenues and fixed costs are $$129,000$ each year. The new equipment costs

$$385,000$ and has a salvage value of $$20,000.$

The corporate tax rate is $21$ percent and the company currently has $100,000$ shares of stock outstanding

at a current price of $$11\mathrm{.}50.$ The company also has $1200$ bonds outstanding, with a current price of $$995.$ The

bonds pay interest annually at the coupon rate is $3\%.$ The bonds have a par value of $$1,000$ and will

mature in twenty years.

Even though the company has stock outstanding, it is not publicly traded. Therefore, there is no publicly

available financial information. However, management believes that given the industry they

are in$,$ the most reasonable comparable Beta would be approximately $1\mathrm{.}25.$

The current risk free rate in the market has been volatile with interest rate changes, but it now sits at $3\mathrm{.}86\%$

Management also believes the S&P $500$ is a reasonable proxy, so the expected market return is $9\mathrm{.}62\%.$

Therefore, the cost of equity is calculated using CAPM, and the market risk premium based on the

S&P $500$ annual expected rate of return, along with the risk free rate and the given beta.

The WACC is then calculated using this information and the other information provided

above. Clearly show all your calculations for these calculations on the Blank Template tab

$1.$ Calculate the WACC for the company.

$2.$ Calculate the rate of debt for the company.

$3.$ Calculate the cost of equity for the company.

$4.$ Using the information from the problem $($above$),$ create a partial income statement incremental cash flows from this project in the

Blank Template worksheet using the tab below.

Final Case Project

I. Given the folloving data on proposed capital budgeting project.

Spreadsheet for determining Cash Flows $($in Thousands$]$

Timelin

Year

II$.$ Net Investment Outlay $=$ Initial CFs

Frice

Increase in $NWC$

III. Cash Flows from Operations

Total Revenues

Variable Costs

Fived Costs

Depreciation

Earnings Before Takes

Taxes

Net Income

Depreciation

Net operating CFs

IY$.$ Terminal Cash Flows

Salwage Value

Tax on Saluage value

Return of N$\text{'}$C

Cash Flows

Present Value of CFs

Calcula

NPY

NPY