Caspian Sea Drinks is considering the purchase of a plum juicer the PJX5. There is no planned increase in production. The PJX5 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 PJX5?

a. The PJX5 will cost $2.06 million fully installed and has a 10 year life. It will be depreciated to a book value of $195,615.00 and sold for that amount in year 10.

b. The Engineering Department spent $32,927.00 researching the various juicers.

c. Portions of the plant floor have been redesigned to accommodate the juicer at a cost of $24,846.00.

d. The PJX5 will reduce operating costs by $330,789.00 per year.

e. CSDs marginal tax rate is 27.00%.

f. CSD is 74.00% equity-financed.

g. CSDs 18.00-year, semi-annual pay, 5.24% coupon bond sells for $966.00.

h. CSDs stock currently has a market value of $24.18 and Mr. Bensen believes the market estimates that dividends will grow at 3.72% forever. Next years dividend is projected to be $1.71.

Answer format: Percentage Round to: 2 decimal places (Example: 9.24%, % sign required. Will accept decimal format rounded to 4 decimal places (ex: 0.0924))

Please explain the steps used and the equation (using a financial calculator if needed). Thanks

Excel is find as long as all the steps are explained beyond (C14-C13, etc.) type stuff.

Question

Caspian Sea Drinks is considering the purchase of a plum juicer the PJX5. There is no planned increase in production. The PJX5 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 PJX5?

a. The PJX5 will cost $2.06 million fully installed and has a 10 year life. It will be depreciated to a book value of $195,615.00 and sold for that amount in year 10.

b. The Engineering Department spent $32,927.00 researching the various juicers.

c. Portions of the plant floor have been redesigned to accommodate the juicer at a cost of $24,846.00.

d. The PJX5 will reduce operating costs by $330,789.00 per year.

e. CSDs marginal tax rate is 27.00%.

f. CSD is 74.00% equity-financed.

g. CSDs 18.00-year, semi-annual pay, 5.24% coupon bond sells for $966.00.

h. CSDs stock currently has a market value of $24.18 and Mr. Bensen believes the market estimates that dividends will grow at 3.72% forever. Next years dividend is projected to be $1.71.

Answer format: Percentage Round to: 2 decimal places (Example: 9.24%, % sign required. Will accept decimal format rounded to 4 decimal places (ex: 0.0924))

Please explain the steps used and the equation (using a financial calculator if needed). Thanks

Excel is find as long as all the steps are explained beyond (C14-C13, etc.) type stuff.