case 26 Star River Electronics LTD.

This assignment requires one excel file for submission.

Based on the memorandum in Exhibit 4, please create a table for the capital budgeting of the case using Excel.

Case26 Ster Beni EXHIBIT 4 | Lim's Memo Regarding New Packaging Equipment MEMORANDUM TO PROM DATE SUBJECT: Adeline Koh President and CEO, Star River Electronics Esmond Lim, Plant Manager June 30, 2001 New Packaging Equipment Amrough our CD packson equipment is adequate at current production levels, his tembly inefficient. The new machinery on the market can give us significantlabor savings as well as increased fodbilly with respect to me type d packaging used. I recommend that we go with the new technology. Should we decide to do so me now machine can be acquired immediately. The considerations relevant to the decision are included in this momo Our current packaging equipment was purchased the years ago as used equipment in a liquidation soe ola shall company. Although the equipment was inexpensive, it is slow, requires constant monitoring and is frequently shut down for repairs. Since the packaging equipment is significantly lower than the production equipment, we routinely have to use overtime labor to allow packaging to catch up with production. When the packager is down for repairs, the problem is exacerbated and we may spend several two-shin days catching up with production cannot say that we have missed any deadlines because of packaging problems, but it is a constant concer around here and things would run a lot smoother with more reliable equipment in 2002, wo will pay about SGD15,470 per year for maintenance costs. The operator is paid SGD03.700 per year for his regular time, but he has been averaging SGD81,900 per year because of the overtime he has been working. The equipment is on the tax and reporting books at SGD218,400 and will be fully deprecated in three years time (we are currently using the straight-line depreciation method for both tax and reporting purposes and will continue to do so. Because of changes in packaging technology, the equipment has no market value other than its worth as scrap metal. But the scrap value is about equal to the cost of having it removed. In short, we believe the equipment has no salvage value at all. The new packager offers many advantages over the current equipment. It is faster, more reliable, more feable with respect to the types of packaging it can perform and will provide enough capacity to cover all our packaging needs in the foreseeable future. With suitable maintenance, we believe the package will operate indefinitely Thus, for the purposes of our analysis, we can assume that this will be the last packaging equipment we will over have to purchase. Because of the anticipated growth at Star River, the current equipment will not be able to handie our packaging needs by the end of 2004. Thus, if we do not buy new packaging equipment by this year's end, we will have to buy it after three years time anyway. Since the speed, capacity and reability of the new equipment will eliminate the need for overtime labor, we feel strongly that we should buy now rather than wait another three years. The new equipment currently costs SGD1.B2 million, which we would depreciate over 10 years at SGD 180.000 per year. It comes with a lifetime factory maintenance contract that covers all routine maintenance and repairs at a price of SGD3,640 for the initial year. The contract stipulates that the price after the first year will be increased by the same percentage as the rate of increase of the price of new equpment. Thus it the manufacturer continues to Increase the prion of new packaging equipment at 5% per annum as it has in the past, our martenance costs will rise by 5% also. We believe that this sort of regular maintenance should insure that the new equipment will keep operating in the foreseeable future without the need for a major overhaul Star River's labor and maintenance costs will continue to rise due to inflation at approximately 1.5% per year over the long term. Because the manufacturer of the packaging equipment has been increasing its prices at about 5% per year, we can expect to save SGD286,878 in the purchase price by buying now rather than waiting three years. The marginal tax rate for this investment would be 24.5% Case 26 Star River Electronics Ltd, Case26 Ster Beni EXHIBIT 4 | Lim's Memo Regarding New Packaging Equipment MEMORANDUM TO PROM DATE SUBJECT: Adeline Koh President and CEO, Star River Electronics Esmond Lim, Plant Manager June 30, 2001 New Packaging Equipment Amrough our CD packson equipment is adequate at current production levels, his tembly inefficient. The new machinery on the market can give us significantlabor savings as well as increased fodbilly with respect to me type d packaging used. I recommend that we go with the new technology. Should we decide to do so me now machine can be acquired immediately. The considerations relevant to the decision are included in this momo Our current packaging equipment was purchased the years ago as used equipment in a liquidation soe ola shall company. Although the equipment was inexpensive, it is slow, requires constant monitoring and is frequently shut down for repairs. Since the packaging equipment is significantly lower than the production equipment, we routinely have to use overtime labor to allow packaging to catch up with production. When the packager is down for repairs, the problem is exacerbated and we may spend several two-shin days catching up with production cannot say that we have missed any deadlines because of packaging problems, but it is a constant concer around here and things would run a lot smoother with more reliable equipment in 2002, wo will pay about SGD15,470 per year for maintenance costs. The operator is paid SGD03.700 per year for his regular time, but he has been averaging SGD81,900 per year because of the overtime he has been working. The equipment is on the tax and reporting books at SGD218,400 and will be fully deprecated in three years time (we are currently using the straight-line depreciation method for both tax and reporting purposes and will continue to do so. Because of changes in packaging technology, the equipment has no market value other than its worth as scrap metal. But the scrap value is about equal to the cost of having it removed. In short, we believe the equipment has no salvage value at all. The new packager offers many advantages over the current equipment. It is faster, more reliable, more feable with respect to the types of packaging it can perform and will provide enough capacity to cover all our packaging needs in the foreseeable future. With suitable maintenance, we believe the package will operate indefinitely Thus, for the purposes of our analysis, we can assume that this will be the last packaging equipment we will over have to purchase. Because of the anticipated growth at Star River, the current equipment will not be able to handie our packaging needs by the end of 2004. Thus, if we do not buy new packaging equipment by this year's end, we will have to buy it after three years time anyway. Since the speed, capacity and reability of the new equipment will eliminate the need for overtime labor, we feel strongly that we should buy now rather than wait another three years. The new equipment currently costs SGD1.B2 million, which we would depreciate over 10 years at SGD 180.000 per year. It comes with a lifetime factory maintenance contract that covers all routine maintenance and repairs at a price of SGD3,640 for the initial year. The contract stipulates that the price after the first year will be increased by the same percentage as the rate of increase of the price of new equpment. Thus it the manufacturer continues to Increase the prion of new packaging equipment at 5% per annum as it has in the past, our martenance costs will rise by 5% also. We believe that this sort of regular maintenance should insure that the new equipment will keep operating in the foreseeable future without the need for a major overhaul Star River's labor and maintenance costs will continue to rise due to inflation at approximately 1.5% per year over the long term. Because the manufacturer of the packaging equipment has been increasing its prices at about 5% per year, we can expect to save SGD286,878 in the purchase price by buying now rather than waiting three years. The marginal tax rate for this investment would be 24.5% Case 26 Star River Electronics Ltd