Question

Caspian Sea Drinks is considering the production of a diet drink. The expansion of the plant and the purchase of the equipment necessary to produce the diet drink will cost $27.00 million. The plant and equipment will be depreciated over 10 years to a book value of $3.00 million, and sold for that amount in year 10. Net working capital will increase by $1.35 million at the beginning of the project and will be recovered at the end. The new diet drink will produce revenues of $8.96 million per year and cost $1.58 million per year over the 10-year life of the project. Marketing estimates 13.00% of the buyers of the diet drink will be people who will switch from the regular drink. The marginal tax rate is 26.00%. The WACC is 14.00%. Find the IRR (internal rate of return).

Answer 1

Answer :- IRR = 17.27%

.

Explanations:-

Net cash flow in year 0 = initial investment + increase in working capital

Net cash flow in years 1 to 9 = income after taxes + depreciation

Depreciation = Purchase price - salvage value / Number of useful life

   = (27 Million - 3 Million) / 10

= $24 Million / 10

   = $2.4 Million

Net cash flow in year 10 = income after taxes + depreciation + recovery of working capital

the percentage of buyers shifting from regular to diet drink is irrelevant for this project

IRR is calculated using the IRR function in Excel, with the inputs of values being the array of cells containing the net cash flows

K J13 fx EIRR(12:J12) A B C D E F G 1 Year Investment Revenue Cost Depreciation Income before Taxes Taxes 2 0 -2,70,00,000.00 3 1 89,60,000.00 15,80,000.00 24,00,000.00 49,80,000.00 12,94,800.00 4 2 89,60,000.00 15,80,000.00 24,00,000.00 49,80,000.00 12,94,800.00 5 3 89,60,000.00 15,80,000.00 24,00,000.00 49,80,000.00 12,94,800.00 6 4 89,60,000.00 15,80,000.00 24,00,000.00 49,80,000.00 12,94,800.00 7 5 89,60,000.00 15,80,000.00 24,00,000.00 49,80,000.00 12,94,800.00 8 6 89,60,000.00 15,80,000.00 24,00,000.00 49,80,000.00 12,94,800.00 9 7 89, 60,000.00 15,80,000.00 24,00,000.00 49,80,000.00 12,94,800.00 10 8 89,60,000.00 15,80,000.00 24,00,000.00 49,80,000.00 12,94,800.00 11 9 89,60,000.00 15,80,000.00 24,00,000.00 49,80,000.00 12,94,800.00 12 10 89,60,000.00 15,80,000.00 24,00,000.00 49,80,000.00 12,94,800.00 H J Income after Taxes Change in working Capital Net Cash Flow -13,50,000.00 -2,83,50,000.00 36,85,200.00 60,85,200.00 36,85,200.00 60,85,200.00 36,85,200.00 60,85,200.00 36,85,200.00 60,85,200.00 36,85,200.00 60,85,200.00 36,85,200.00 60,85,200.00 36,85,200.00 60,85,200.00 36,85,200.00 60,85,200.00 36,85,200.00 60,85,200.00 36,85,200.00 13,50,000.00 74,35,200.00 IRR 17.27% 13 14