Investment Analysis for Kipper Limited's CNC Machine - Example

Investment Analysis for Kipper Limited's CNC Machine

Kipper Limited is considering an investment in a new CNC machine. This blog post presents an in-depth analysis of the project's financial implications, including the Net Present Value (NPV) and Internal Rate of Return (IRR). The goal is to provide clear insights into the financial viability of the investment, helping Kipper Limited make an informed decision.

Investment Details

• Initial Cost: £470,000 (paid upfront in Year 0)
• Operational Start: After one year
• Annual Cash Inflows: £150,000 for five years
• Maintenance Costs: £30,000 annually in Years 4 and 5
• Residual Value: £100,000 at the end of Year 5 (used in one scenario)
• Scrap Costs: £30,000 at the end of Year 5 (used in another scenario)
• Discount Rate: 10%
• Hurdle Rate: 14.5%

Step-by-Step Financial Calculations

a) NPV with Cash Inflows and Maintenance Costs

The Net Present Value (NPV) is the sum of the present value of future cash flows minus the initial investment. It helps determine whether the investment is profitable. The formula for NPV is:

$$NPV = \sum \frac{C_t}{(1 + r)^t} - I$$

Where:

• $C_t$ = Cash flow at time $t$
• $r$ = Discount rate (10%)
• $t$ = Time period (in years)
• $I$ = Initial investment

Cash Flows:

• Years 1–3: £150,000 per year
• Years 4–5: £120,000 per year (after subtracting £30,000 maintenance costs)

Discounted Cash Flows: Using a Present Value Factor (PVF) for a 10% discount rate:

Year	Cash Flow (£)	PVF (10%)	Discounted Cash Flow (£)
0	-470,000	1.000	-470,000
1	150,000	0.909	136,350
2	150,000	0.826	123,900
3	150,000	0.751	112,650
4	120,000	0.683	81,960
5	120,000	0.621	74,520
Total	N/A	N/A	59,380

The NPV is the total discounted cash flow minus the initial investment:

$$NPV=59,380\text{(total discounted cash flow)}-470,000\text{(initial investment)}=59,380$$

NPV ≈ £61,000

b) NPV with Residual Value

Incorporating the equipment's residual value of £100,000 at the end of Year 5 significantly impacts the investment's value. In this scenario, we add the residual value to the cash inflow in Year 5.

Adjusted Cash Flow: The cash inflow in Year 5 is now £120,000 (from cash inflows) + £100,000 (from residual value) = £220,000.

Discounted Cash Flows: Applying the Present Value Factor for a 10% discount rate:

Year	Cash Flow (£)	PVF (10%)	Discounted Cash Flow (£)
0	-470,000	1.000	-470,000
1	150,000	0.909	136,350
2	150,000	0.826	123,900
3	150,000	0.751	112,650
4	120,000	0.683	81,960
5	220,000	0.621	136,620
Total	N/A	N/A	121,480

Updated NPV = £121,480 ≈ £123,000

Impact of the Residual Value 

Adding the residual value at the end of Year 5 increases the NPV significantly, suggesting that the investment becomes more attractive. A higher NPV indicates a greater potential for profitability and financial gain.

Residual Value refers to the estimated value of an asset at the end of its useful life. It is the amount that can be expected from selling or disposing of the asset once it is no longer in active use or operation. In investment analysis, the residual value is important because it represents an additional cash inflow or benefit at the end of the investment period.

NPV with £30,000 Scrap Cost

In this scenario, instead of the residual value, the machine is scrapped at the end of Year 5 with a cost of £30,000. Let's proceed with recalculating the Net Present Value (NPV) while accounting for this £30,000 scrap cost.

Adjusted Cash Flows with Scrap Cost:

• Year 4 Cash Flow: £150,000 (Annual Cash Inflow) - £30,000 (Maintenance Cost) = £120,000
• Year 5 Cash Flow: £150,000 (Annual Cash Inflow) - £30,000 (Maintenance Cost) - £30,000 (Scrap Cost) = £90,000

Discounted Cash Flows:

Using the Present Value Factor (PVF) at a 10% discount rate, we calculate the discounted cash flows for each year:

Year	Cash Flow (£)	PVF (10%)	Discounted Cash Flow (£)
0	-470,000	1.000	-470,000
1	150,000	0.909	136,350
2	150,000	0.826	123,900
3	150,000	0.751	112,650
4	120,000	0.683	81,960
5	90,000	0.621	55,890
Total	N/A	N/A	42,000

NPV at 10% with £30,000 Scrap Cost = £42,000 (Total Discounted Cash Flow) - £470,000 (Initial Investment) = £42,000

Thus, the NPV at a 10% discount rate with a £30,000 scrap cost is approximately £42,000. 

NPV at 15% Discount Rate with £30,000 Scrap Cost

Now let's calculate the NPV at a higher discount rate of 15%, which is typically used as the hurdle rate to assess if the investment is viable.

Using the same approach with a 15% discount rate:

Year	Cash Flow (£)	PVF (15%)	Discounted Cash Flow (£)
0	-470,000	1.000	-470,000
1	150,000	0.870	130,500
2	150,000	0.756	113,400
3	150,000	0.657	98,550
4	120,000	0.571	68,520
5	90,000	0.497	44,730
Total	N/A	N/A	-12,000

NPV at 15% with £30,000 Scrap Cost = -£12,000

At a 15% discount rate, the NPV becomes negative, which means that the investment is not financially viable at this higher rate. A negative NPV indicates that the project's expected returns do not justify the initial investment when accounting for the cost of capital. 

Conclusion

• NPV at 10% with £30,000 Scrap Cost = £42,000: This is a positive NPV, indicating that the investment is financially viable.
• NPV at 15% with £30,000 Scrap Cost = -£12,000: At this higher discount rate, the project becomes unprofitable, as the NPV turns negative.

c) Estimating the Internal Rate of Return (IRR) with Linear Interpolation

We already know the NPVs at two different discount rates:

• At 10%, the NPV is £42,000.
• At 15%, the NPV is -£12,000.

To estimate the IRR, which is the discount rate that makes the NPV equal to zero, we can use linear interpolation. The formula for linear interpolation is:

$$\text{IRR} = 15\% - \frac{(15\% - 10\%)}{(42,000 - (-12,000))} \times (42,000)$$

Substituting the values:

$$\text{IRR} = 15\% - \frac{(15\% - 10\%)}{(42,000 - (-12,000))} \times (42,000 - 0)$$ $$\text{IRR} = 15\% - \frac{5\%}{54,000} \times 42,000$$ $$\text{IRR} = 15\% - \left(\frac{5\% \times 42,000}{54,000}\right)$$ $$\text{IRR} = 15\% - 3.89\% = 14.1\%$$

Thus, the estimated IRR is approximately 14.1%.

Interpretation of the IRR

• The estimated IRR of 14.1% is slightly below the hurdle rate of 14.5% (by 0.4%).
• This means that, at first glance, the project might not meet the threshold set by the company for investment.

Consideration of Accounting Assumptions

However, it’s important to note that the IRR estimate is based on prudent accounting practices:

• Scrap costs: The £30,000 scrap cost, which reduces the Year 5 cash flow, is a conservative estimate. In reality, the company may not incur such a high cost and could recover more from selling or recycling the machine.
• Conservative sales volume: The sales volume assumption might be on the lower end, and in practice, the company might achieve higher returns than projected. 

Finance Director's Perspective

• Prudent Decisions: Finance directors typically take cost-based decisions (i.e., considering costs such as scrap and maintenance) rather than focusing purely on opportunity-based decisions (i.e., considering potential upsides like higher sales or residual value).
• In this case, the inclusion of scrap costs instead of estimating income from the machine's sale aligns with a cautious approach to ensure that the financial analysis accounts for potential risks.

Strategic and Non-Financial Factors

While the financial analysis is essential, the company should also consider non-financial factors when evaluating this investment:

1. Strategic Growth: The CNC machine might be part of a broader strategy to expand operations, enter new markets, or improve production capabilities.
2. Improved Quality: The new machine could enhance product quality, leading to higher customer satisfaction and potentially better pricing.
3. Better Trained Staff: Investing in new technology could provide training opportunities for employees, which may lead to increased productivity and employee satisfaction. 

Conclusion

Although the estimated IRR of 14.1% is slightly below the hurdle rate of 14.5%, this analysis is based on conservative assumptions and prudent accounting. In practice, the project may exceed expectations, especially if the scrap cost is lower and sales volume is higher.

Therefore, the company should consider the cost-benefit analysis not just from a financial perspective, but also by incorporating strategic benefits, growth opportunities, and potential quality improvements. This broader view will help in making a more informed decision on the investment in the CNC machine. 

Pooja Mattapalli