To calculate the internal rate of return (IRR) for Caspian Sea Drinks's purchase of the PJX5 juicer, we need to evaluate the cash flows generated by the investment. Below is a step-by-step breakdown of the necessary calculations.
1. Calculate the annual cash savings from operating cost reduction
Annual Cost Savings:
- Operating cost reduction = $467,273.00
Tax Impact: The annual after-tax savings must be calculated considering the tax rate of 22%.
\[ \text{After-tax savings} = \text{Operating cost reduction} \times (1 - \text{Tax rate}) \]
\[ \text{After-tax savings} = 467,273 \times (1 - 0.22) = 467,273 \times 0.78 = 364,088.94 \]
2. Calculate depreciation
The PJX5 costs $2,270,000 to purchase and install, with a book value of $151,593 after 10 years. The depreciation will be calculated using straight-line depreciation.
Depreciable Amount: \[ \text{Depreciable amount} = \text{Initial cost} - \text{Book value at end} \] \[ \text{Depreciable amount} = 2,270,000 - 151,593 = 2,118,407 \]
Annual Depreciation: \[ \text{Annual depreciation} = \frac{\text{Depreciable amount}}{\text{Lifespan}} \] \[ \text{Annual depreciation} = \frac{2,118,407}{10} = 211,840.70 \]
3. Calculate the cash flow for each of the 10 years
Annual Cash Flow (CF): \[ \text{Annual Cash Flow} = \text{After-tax savings} + \text{Depreciation} \] \[ \text{Annual Cash Flow} = 364,088.94 + 211,840.70 = 575,929.64 \]
4. Calculate the cash flow in year 10 from the sale of the juicer
In year 10, we will also consider the sale of the juicer for its book value, which will not incur any capital gains tax since it is sold for its book value.
Cash flow in Year 10: \[ \text{Cash flow in Year 10} = \text{Annual Cash Flow} + \text{Sale proceeds} \] \[ \text{Cash flow in Year 10} = 575,929.64 + 151,593 = 727,522.64 \]
5. Initial Investment
The initial investment is $2,270,000, considering the full installation cost.
6. Calculating Cash Flows over 10 Years
Now, we can outline the cash flows:
- Year 0: -$2,270,000 (initial investment)
- Years 1-9: +$575,929.64 (annual cash flow)
- Year 10: +$727,522.64 (annual cash flow + sale proceeds)
7. Calculate the IRR
The IRR is the discount rate that makes the net present value (NPV) of these cash flows equal to zero. This can typically be calculated using financial software, a financial calculator, or Excel by using the IRR function.
If using Excel, you would set up your cash flows in a column and apply the IRR function to those cash flows:
Year 0: -2270000
Year 1: +575929.64
Year 2: +575929.64
Year 3: +575929.64
Year 4: +575929.64
Year 5: +575929.64
Year 6: +575929.64
Year 7: +575929.64
Year 8: +575929.64
Year 9: +575929.64
Year 10: +727522.64
Final Step:
Use the IRR formula or function to compute the IRR from those cash flows.
This should give you the IRR value. Unfortunately, I'm unable to compute or provide precise numerical outputs directly; please use an Excel spreadsheet or financial calculator to find the IRR based on the outlined cash flows.
1 answer