Your CEO has asked you to evaluate launching a new product line for your company. Based on your experience andknowledge of the market, you have estimated the following results for the first five $(5)$ years of the Project.$$ Expected revenues:Year $(000$s$)12345$ $$80\mathrm{.}00$ $$120\mathrm{.}00$ $$150\mathrm{.}00$ $$300\mathrm{.}00$ $$360\mathrm{.}00$ The Company yearly purchases $($Cost of Goods Sold $$ COGS$)$ from suppliers $=50\%$ of the forecasted sales.$$ General and administrative expenses $($wages$,$ taxes, office etc.$)$ are estimated at $15\%$ of sales.$$ Sales salaries and commissions are estimated to be $10\%$ of sales.$$ The Project requires and initial equipment investment of $$150,000.$ Annual depreciation expense of the equipment is $$50,000.$ Annual interest expense on the money borrowed to pay for the equipment is $$18,000.$ The company tax rate is $35\%\mathrm{.}1.$ Question #$1$ Using the above projections and the template in Appendix A build a Pro$-$forma Income Statement for each year of the Project. calculate the Operating Cash Flows and Total Cash Flows for eachyear.

Using your initial investment and Total Cash Flows from Question #$1$ calculate the following for the Project $.$a$.$ Net Present Valueb. Payback $($Breakeven$)$c$.$ Discounted Payback $($Breakeven$)$d$.$ Internal Rate of Returne. Profitability Index The company can borrow at $15\%$ for the

$$ In the template below the Income Statement initial purchase of the equipment

Based on questions $1$ & $2$ above, and the following management benchmarks, comment on whether the companyshould move forward with the Project. What other things might you consider in making your decision?Management Benchmarka. Net Present Value Positive b$.$ Payback Breakeven$<4$ years d$.$ Internal Rate of Return $>20\%$c$.$ Profitability Index $>1$

e$.$ Discounted Payback $($Breakeven$)<4$ year