In: Finance
FTG commissioned a study to look into the feasibility of changing the packaging of the fruit from cans to sealed bags. The Consultant charged $54,000 for the report.
The report concluded that the new packaging will increase sales and reduce some operating costs.
The new packaging machinery will cost $1,100,000. The new machine is expected to last 5 years. The Taxation Office advise the life of the machine, for tax purposes, is 4 years.
The old canning machinery was purchased 2 years ago for $800,000 and was being depreciated at $200,000 and will be for the next 2 years. The old machine could be sold today for $260,000. In 5 years it will be worth nothing.
Installing the new machine will require staff training (a tax deductible expense) of $35,000 before production can commence. Due to the lower cost of the bags Inventory required will be reduced by $80,000 for the life of the project.
The new sales of bagged fruit is expected to be $700,000 in Year 1 rising by 15% for 2 years then 0% for the rest of the life of the project. Variable Costs associated with the new packaged fruit are 50% of sales.
Canned fruit production will be discontinued. Sales of canned fruit were static at $450,000 with variable costs of $225,000 (50% of Sales).
The new equipment is very hi-tech. Maintenance costs are expected to be higher at $44,000 per year. Maintenance costs on the old machine were $30,000 per year.
The lighter packaging will reduce annual freight cost significantly from $250,000 to $100,000 per year.
Fixed costs are expected to remain at $320,000 per year.
At the end of the project the new machinery can be sold for $275,000.
Notes:
FTG will borrow the full Year 0 funds using a secured five-year interest-only loan at an interest rate of 10% per annum to finance the new equipment.
The company tax rate is 30%.
The required rate of return is 12.5%.
Requirement:
5. The NPV of the project (5Marks)
6. The IRR of the project(5Marks)
7. The PI of the project(5Marks)
Capital Investment decision is based on the incremental cash flows from the proposed project.
To find incremental cashflow, we will compute the incremental capex, incremental sales, variable costs, freight costs, maintenance costs, and depreciation.
Cost of new machine | 1100000 |
Selling price of old machine | 260000 |
Staff training cost | 35000 |
Incremental Capex | 875000 |
Initial Investment | 1135000 |
Salvage Value | 275000 |
Depreciation expense per year | 215000 |
The appropriate discount rate is the opportunity cost of the capital for a similar risky project.It is given as , required rate of return = 12.5%
S.No | Particulars | 1 | 2 | 3 | 4 | 5 |
New machine sales | 700000 | 805000 | 925750 | 925750 | 925750 | |
Old Machine sales | 450000 | 450000 | 450000 | 450000 | 450000 | |
1 | Incremental sales | 250000 | 355000 | 475750 | 475750 | 475750 |
New machine variable costs | 350000 | 402500 | 462875 | 462875 | 462875 | |
Old machine variable costs | 225000 | 225000 | 225000 | 225000 | 225000 | |
2 | Incremental variable cost | 125000 | 177500 | 237875 | 237875 | 237875 |
New machine maintenance cost | 44000 | 44000 | 44000 | 44000 | 44000 | |
old machine maintenance cost | 30000 | 30000 | 30000 | 30000 | 30000 | |
3 | Incremetal maintenance cost | 14000 | 14000 | 14000 | 14000 | 14000 |
New Machine freight cost | 100000 | 100000 | 100000 | 100000 | 100000 | |
Old machine freight cost | 250000 | 250000 | 250000 | 250000 | 250000 | |
4 | Incremental freight cost | -150000 | -150000 | -150000 | -150000 | -150000 |
New machine depreciation | 215000 | 215000 | 215000 | 215000 | 0 | |
Old machine depreciation | 200000 | 200000 | 0 | 0 | 0 | |
5 | Incremental depreciation | 15000 | 15000 | 215000 | 215000 | 0 |
Please give thumbs up. It will help me.