Huffman Systems has forecasted sales for its new home alarm systems to

be $63,000$ units per year at $$38\mathrm{.}50$ per unit. The cost to produce each unit is

expected to be $42\%$ of the sales price. The new product will have an

additional $$494,000$ fixed costs each year, and the manufacturing

equipment will have an initial cost of $$2,400,000$ and will be depreciated

over eight years on a straight line basis. The company has a tax rate of $40\%.$

What is the annual operating cash flow for the alarm systems if the

projected sales and price per unit are constant of the next eight years?

using the operating cash flow information in problem $12,$ determine whetherhuffman systems should add the home alarm system to their set of products. the manufacturing equittment will be sold off at the end of eight years for $$210,000$ and he cost of capital for this project is $14\%$

please make it exccel form with the forumula with: YEAR DEP RATE DEPR EXP ACC. DEP BOOK VALUE DISPOSAL PRICE GAIN$/$ LOSS TAX AFTER TAX CF

and the

YEAR DEP RATE

$114\mathrm{.}29\%$

$224\mathrm{.}49\%$

$317\mathrm{.}49\%$

$412\mathrm{.}49\%$

$58\mathrm{.}93\%$

$68\mathrm{.}92\%$

$78\mathrm{.}93\%$

$84\mathrm{.}46\%$

give me the capital budget

YEAR OCF PV FV

$0$

$1$

$2$

$3$

$4$

$5$

$6$

$7$

$8$