$1.$ Caspian Sea Drinks is considering the purchase of a plum juicer $$ the PJX$5.$ There is no planned increase in production. The PJX$5$ will reduce costs by squeezing more juice from each plum and doing so in a more efficient manner. Mr$.$ Bensen gave Derek the following information. What is the NPV of the PJX$5?$

a$.$ The PJX$5$ will cost $$2\mathrm{.}08$ million fully installed and has a $10$ year life. It will be depreciated to a book value of $$130,652\mathrm{.}00$ and sold for that amount in year $10.$

b$.$ The Engineering Department spent $$34,614\mathrm{.}00$ researching the various juicers.

c$.$ Portions of the plant floor have been redesigned to accommodate the juicer at a cost of $$21,731\mathrm{.}00.$

d$.$ The PJX$5$ will reduce operating costs by $$309,902\mathrm{.}00$ per year.

e$.$ CSD$$s marginal tax rate is $34\mathrm{.}00\%.$

f$.$ CSD is $58\mathrm{.}00\%$ equity$-$financed.

g$.$ CSD$$s $11\mathrm{.}00-$year, semi$-$annual pay, $5\mathrm{.}06\%$ coupon bond sells for $$1,006\mathrm{.}00.$

h$.$ CSD$$s stock currently has a market value of $$24\mathrm{.}33$ and Mr$.$ Bensen believes the market estimates that dividends will grow at $4\mathrm{.}14\%$ forever. Next year$$s dividend is projected to be $$1\mathrm{.}77.($The correct answer should be: $-$$$202,609\mathrm{.}68)$ Show me how in excel

$2.$ Caspian Sea Drinks is considering the purchase of a plum juicer $$ the PJX$5.$ There is no planned increase in production. The PJX$5$ will reduce costs by squeezing more juice from each plum and doing so in a more efficient manner. Mr$.$ Bensen gave Derek the following information. What is the IRR of the PJX$5?$

a$.$ The PJX$5$ will cost $$1\mathrm{.}91$ million fully installed and has a $10$ year life. It will be depreciated to a book value of $$164,020\mathrm{.}00$ and sold for that amount in year $10.$

b$.$ The Engineering Department spent $$18,537\mathrm{.}00$ researching the various juicers.

c$.$ Portions of the plant floor have been redesigned to accommodate the juicer at a cost of $$19,314\mathrm{.}00.$

d$.$ The PJX$5$ will reduce operating costs by $$342,610\mathrm{.}00$ per year.

e$.$ CSD$$s marginal tax rate is $37\mathrm{.}00\%.$

f$.$ CSD is $58\mathrm{.}00\%$ equity$-$financed.

g$.$ CSD$$s $10\mathrm{.}00-$year, semi$-$annual pay, $6\mathrm{.}65\%$ coupon bond sells for $$965\mathrm{.}00.$

h$.$ CSD$$s stock currently has a market value of $$21\mathrm{.}75$ and Mr$.$ Bensen believes the market estimates that dividends will grow at $3\mathrm{.}85\%$ forever. Next year$$s dividend is projected to be $$1\mathrm{.}77.$

$**$USE EXCEL AND SHOW ALL THE CALULATIONS$/$ FORMULAS$**$