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.19 million fully installed and has a 10 year life. It will be depreciated to a book value of $118,747.00 and sold for that amount in year 10.

b. The Engineering Department spent $34,058.00 researching the various juicers.

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

d. The PJX5 will reduce operating costs by $318,156.00 per year.

e. CSD’s marginal tax rate is 30.00%.

f. CSD is 71.00% equity-financed.

g. CSD’s 18.00-year, semi-annual pay, 6.97% coupon bond sells for $955.00.

h. CSD’s stock currently has a market value of $23.30 and Mr. Bensen believes the market estimates that dividends will grow at 4.46% forever. Next year’s dividend is projected to be $1.57. ( round percentage to 2 decimal places).

Answer #1

We first chalk out all the cash-flows in excel

Initial cost = -2190000-34058-24428

Cash-flow in year 10 = Reduced operating cost + Salvage cost = 118747+318156

We calculate the IRR using IRR function in excel

IRR = IRR(All-cash flows)

IRR of PJX5 = 7.43%

Year | Cash-flows |

0 | -2248486 |

1 | 318,156 |

2 | 318,156 |

3 | 318,156 |

4 | 318,156 |

5 | 318,156 |

6 | 318,156 |

7 | 318,156 |

8 | 318,156 |

9 | 318,156 |

10 | 436,903 |

IRR |
7.43% |

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 $1.77 million fully installed and has a 10
year life. It will be depreciated to a book value of $291,334.00...

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 NPV of the PJX5?
a. The PJX5 will cost $1.62 million fully installed and has a 10
year life. It will be depreciated to a book value of $279,549.00...

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 $1.52 million fully installed and has a 10
year life. It will be depreciated to a book value of $148,149.00...

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 NPV of the PJX5?
a. The PJX5 will cost $1.62 million fully installed and has a 10
year life. It will be depreciated to a book value of $120,755.00...

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.34 million fully installed and has a 10 year life. It will be
depreciated to a book value of $182,297.00...

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 NPV of the PJX5?
a. The PJX5 will cost $2.15 million fully installed and has a 10
year life. It will be depreciated to a book value of $200,210.00...

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 NPV of the PJX5?
a. The PJX5 will cost $2.20 million fully installed and has a 10
year life. It will be depreciated to a book value of $243,320.00...

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.44 million fully installed and has a 10
year life. It will be depreciated to a book value of $211,609.00...

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.46 million fully installed and has a 10
year life. It will be depreciated to a book value of $171,635.00...

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 NPV of the PJX5?
a. The PJX5 will cost $1.70 million fully installed and has a 10
year life. It will be depreciated to a book value of $123,084.00...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 6 minutes ago

asked 6 minutes ago

asked 25 minutes ago

asked 25 minutes ago

asked 25 minutes ago

asked 28 minutes ago

asked 35 minutes ago

asked 50 minutes ago

asked 52 minutes ago

asked 52 minutes ago

asked 52 minutes ago

asked 52 minutes ago