Fruit-To-Go (FTG) processes fruit for shipping overseas. 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%.
Requirements: 1. The cash flows at the start (15Marks) 2. The cash flows over the life (20Marks) 3. The cash flows at the end (10 Marks) 4. The appropriate discount rate (5 Marks)
| 1 | The cash flows at the start are: | ||||
| Cost of machine | -$1,100,000 | ||||
| Proceeds from sale of old machine | $260,000 | ||||
| Cost of staff training | -$35,000 | ||||
| Working capital release | $80,000 | ||||
| Proceeds from Loan | $1,100,000 | ||||
| Net cash flows at start | $305,000 | ||||
| 2 | Cash flows over the life: | ||||
| Year | 1 | 2 | 3 | 4 | |
| Sales | $700,000 | $805,000 | $925,750 | $925,750 | |
| Variable costs | $350,000 | $402,500 | $462,875 | $462,875 | |
| Maintenance cost | $44,000 | $44,000 | $44,000 | $44,000 | |
| Freight costs | $100,000 | $100,000 | $100,000 | $100,000 | |
| Fixed costs | $320,000 | $320,000 | $320,000 | $320,000 | |
| Depreciation | $275,000 | $275,000 | $275,000 | $275,000 | |
| Interest | $110,000 | $110,000 | $110,000 | $110,000 | |
| Income before tax | -$499,000 | -$446,500 | -$386,125 | -$386,125 | |
| Tax | $149,700 | $133,950 | $115,838 | $115,838 | |
| Income after tax | -$349,300 | -$312,550 | -$270,288 | -$270,288 | |
| Add: Depreciation | $275,000 | $275,000 | $275,000 | $275,000 | |
| Cash Flows | -$74,300 | -$37,550 | $4,712 | $4,712 | |
| 3 | The cash flows at the end | ||||
| 5 | |||||
| Sales | $925,750 | ||||
| Less: Variable costs | $462,875 | ||||
| Maintenance cost | $44,000 | ||||
| Freight costs | $100,000 | ||||
| Fixed costs | $320,000 | ||||
| Depreciation | - | ||||
| Interest | $110,000 | ||||
| Add: Salvage value | $275,000 | ||||
| Income before tax | $163,875 | ||||
| Tax | -$49,163 | ||||
| Income after tax | $114,713 | ||||
| Add: Depreciation | $0 | ||||
| Cash Flows | $114,713 | ||||
| 4 | Appropriate discount rate = 12.5% |
Fruit-To-Go (FTG) processes fruit for shipping overseas. FTG commissioned a study to look into the feasibility...
AAI specializes in production of music equipment. The firm incurred $3.2 million to do feasibility study of the new equipment. The projected sales volume of a new seven-octave voice emulation implant is as follow Year 1 2 3 4 5 Sales volume (Millions) 10 12 16 14 12 Production of the implants will require $15 million in net working capital (NWC) immediately. Thereafter, NWC investment will equal to 20% of projected sales revenue. Each implant is priced to sell at...
XYZ Company’s machine was purchased 5 years ago for $55,000. It had an expected life of 10 years when it was bought, and its remaining depreciation is $5,500 per year for each year of its remaining life and can be sold for $20,000 at the end of its useful life. A new machine can be purchased for $120,000, including the installation costs. During its 5-year life, it will reduce cash operating expenses by $30,000 per year. Sales revenue will not...
YZ Company’s machine was purchased 5 years ago for $55,000. It had an expected life of 10 years when it was bought, and its remaining depreciation is $5,500 per year for each year of its remaining life and can be sold for $20,000 at the end of its useful life. A new machine can be purchased for $120,000, including the installation costs. During its 5-year life, it will reduce cash operating expenses by $30,000 per year. Sales revenue will not...
Anchor Ltd paid $15,000 last quarter for a feasibility study regarding the demand for motor-boat replacement parts which would require the purchase of a new metal-shaping machine. Today, they wish to conduct an analysis of the proposed project. The machine costs $250,000 and will operate for five years and tax rules allow the machine to be depreciated to zero over a five-year life. The machine is expected to produce sales of $135,000 annually for the five years. Anchor has already...
Anchor Ltd paid $15,000 last quarter for a feasibility study regarding the demand for motor-boat replacement parts which would require the purchase of a new metal-shaping machine. Today, they wish to conduct an analysis of the proposed project. The machine costs $250,000 and will operate for five years and tax rules allow the machine to be depreciated to zero over a five-year life. The machine is expected to produce sales of $135,000 annually for the five years. Anchor has already...
The Darlington Equipment Company purchased a machine 5 years ago at a cost of $90,000. The machine had an expected life of 10 years at the time of purchase, and it is being depreciated by the straight-line method by $9,000 per year. If the machine is not replaced, it can be sold for $5,000 at the end of its useful life. A new machine can be purchased for $180,000, including installation costs. During its 5-year life, it will reduce cash...
Incremental Cash Flows The Supreme Shoe Company is considering the purchase of a new, fully automated machine to replace a manually operated one years old, originally had an expected life of 10 years, is being depreciated using the straight-line method from $40,000 down to $0, and can now be sold for $22,000. It takes one person to operate the machine, and he earns $29,000 per year in salary and benefits. The annual costs of maintenance and defects on the old...
Incremental Cash Flows The Supreme Shoe Company is considering the purchase of a new, fully automated machine to replace a manually operated one. The machine being replaced, now five years old, originally had an expected life of 10 years, is being depreciated using the straight-line method from $40,000 down to $0, and can now be sold for $22,000. It takes one person to operate the machine, and he earns $29,000 per year in salary and benefits. The annual costs of...
Case study expanding into the fruit juice business with a new fresh lemon juice Allied Food Products is considering expanding into the fruit juice business ntly hired as assistant to the director of capital budgeting, and you product. Assume that you were recently hired as assistant to the director of must evaluate the new project. The lemon juice w e produced in an unused building adiacent to Allied's Fort Myers plant; Allied owns the building lant: Allied owns the building,...
please use excel to answer the questions and show all
outputs
E3) The Erley Equipment Company purchased a machine 5 years ago at a cost of $100,000. The machine had an expected life of 10 years at the time of purchase, and an expected salvage value of $10,000 at the end of the 10 years. It is being depreciated by the straight line method toward a salvage value of $10,000, or by $9,000 per year. A new machine can be...