Barfly Inc. manufactures and markets a line of non$-$alcoholic mixers sold to restaurants and bars. Barfly$$s Creative Bartender has recently experimented with making alcoholic versions with the intention of bottling and marketing these directly to the public through appropriate retail outlets. Prior spending on R&D was $$1\mathrm{.}5$ million and Barfly anticipates spending half of that again during the first year of the project to conclude R&D $($for total R&D of $$2\mathrm{.}25$ million$).$ The cost of building the manufacturing line is estimated at $$1,175,000.$

Marketing projects revenues from the new product line will be $800,000$ units in the first year, growth in years $2$ and $3$ at $15\%,$ growth in year $4$ at $10\%,$ and $5\%$ for year $5.$ While Barfly anticipates the product will have a longer life than $5$ years, their initial projections are for a $5$ year time horizon, fully depreciating the cost of plant and equipment over that time on a straight$-$line basis.

Revenue per unit is projected to be $$2\mathrm{.}50$ in the first year, with prices rising by $3\%$ per year thereafter. COGS are projected to be $68\%$ of revenues, SG&A $7\%$ of revenues, and the company$$s marginal tax rate is $32\%.$ Net working capital required for the project is expected to be $2\%$ of revenues annually once the project is fully online in year $1.$

Barfly$$s balance sheet includes $$3,000,000$ in total capital, of which $$980,000$ is debt. The market yield to maturity on debt is $3\mathrm{.}75\%,$ the risk free rate on a $5-$year Treasury is $3\%,$ and the market risk premium is $6\mathrm{.}5\%.$ The company$$s beta is $1\mathrm{.}3$ and the CFO uses the CAPM to estimate cost of equity.

$1)$ What is the project$$s NPV$?$

$2)$ What is the project$$s IRR?

$3)$ Should the project be accepted?

Management has been studying the company$$s capital structure and is considering using a small secondary offering of stock to pay down debt. The following data is used to determine the cost of debt under varying capital structures.

Debt ratio Spread to Treasuries Yield on Debt

$0\%-<10\%0\mathrm{.}00\%3\mathrm{.}000\%$

$10\%-<20\%0\mathrm{.}15\%3\mathrm{.}150\%$

$20\%-<30\%0\mathrm{.}30\%3\mathrm{.}300\%$

$30\%-<40\%0\mathrm{.}50\%3\mathrm{.}500\%$

$40\%-<50\%0\mathrm{.}75\%3\mathrm{.}750\%$

$50\%-<60\%1\mathrm{.}05\%4\mathrm{.}050\%$

$60\%-<70\%1\mathrm{.}35\%4\mathrm{.}350\%$

$70\%-<80\%1\mathrm{.}90\%4\mathrm{.}900\%$

$80\%-<90\%2\mathrm{.}50\%5\mathrm{.}500\%$

$90\%-<100\%3\mathrm{.}10\%6\mathrm{.}100\%$

$100\%-<110\%3\mathrm{.}80\%6\mathrm{.}800\%$

$110\%-<120\%4\mathrm{.}70\%7\mathrm{.}700\%$

$120\%-<130\%6\mathrm{.}00\%9\mathrm{.}000\%$

$130\%-<140\%7\mathrm{.}20\%10\mathrm{.}200\%$

$140\%-<150\%9\mathrm{.}00\%12\mathrm{.}000\%$

$150\%-<160\%11\mathrm{.}00\%14\mathrm{.}000\%$

$4)$ If Barfly issues $$180,000$ in new equity and uses the proceeds to repurchase $($and defease$*)$ existing debt, what would the resulting weighted average cost of capital be$?$

$5)$ Should management move towards this capital structure? Why or why not?