You are still Andy Chin. Prepare the second part of the report due at 7 a.m. tomorrow to the new CEO of Star River Elect
Posted: Sun Jul 03, 2022 4:26 pm
You are still Andy Chin. Prepare the second part of the report due at 7 a.m. tomorrow to the newCEO of Star River Electronics, Ltd., Adeline Koh. This second part should recommend underwhat conditions the firm should invest in the new packaging equipment now or three years fromnow, based on the information provided by Esmond Lim in Exhibit 4. Your memo should include:
A detailed cash flow analysis of the initial outlay, operating cash flow, and terminalcash flow for the alternatives under consideration.
A “first pass” recommendation for when to purchase the new equipment using adiscount rate of 10%.
A Net Present Value Profile analysis that allows you to specify the ranges of costsof capital over which one alternative is preferred to the other. In other words,calculate the “crossover” rate at which Star River would be indifferent to buyingthe equipment now or in 3 years.
Results of sensitivity analysis on key parameters indicating why changes in theirvalues may occur and how those changes will affect Star River’s purchasingdecision.
Please show excel spreadsheet with calculations.
Exhibit 4STAR RIVER ELECTRONICS LTD.
Lim's Memo regarding New Packaging Equipment
Adeline Koh, President and CEO, Star River Electronics Esmond Lim, Plant ManagerJune 30,2001
New
Although our CD packaging equipment is adequate at current production levels, it is terribly inefficient. The new machinery on the market can give us significant labor savings as well as increased flexibility with respect to the type of packaging used. I recommend that we go with the new technology. Should we decide to do so, the new machine can be acquired immediately. The considerations relevant to the decision are included in this memo.
Our current packaging equipment was purchased five years ago as used equipment in a liquidation sale of a small 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 slower 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-shift days catching up with production. I cannot say that we have missed any deadlines because of packaging problems, but it is a constant concern around here and things would run a lot smoother with more reliable equipment. In 2002, we will pay about SGD15,470 per year for maintenance costs. The operator is paid SGD63,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 depreciated 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 its
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 flexible 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 packager will operate indefmitely. Thus, for the purposes of our analysis, we can assume that this will be the last packaging equipment we will ever have to purchase. Because of the anticipated growth at Star River, the current equipment will not be able to handle 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 reliability 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.
-8- UV A-F-1361 Exhibit 4 (continued)
The new equipment currently costs SGD1.82 million, which we would depreciate over 10 years at SGD182,OOO 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 equipment. Thus if the manufacturer continues to increase the price of new packaging equipment at 5% per annum as it has in the past, our maintenance 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%.
MEMORANDUM Exhibit 4 STAR RIVER ELECTRONICS LTD. Lim's Memo regarding New Packaging Equipment TO FROM DATE : Adeline Koh, President and CEO, Star River Electronics Esmond Lim, Plant Manager June 30, 2001 SUBJECT: New Packaging Equipment UVA-F-1361 Although our CD packaging equipment is adequate at current production levels, it is terribly inefficient. The new machinery on the market can give us significant labor savings as well as increased flexibility with respect to the type of packaging used. I recommend that we go with the new technology. Should we decide to do so, the new machine can be acquired immediately. The considerations relevant to the decision are included in this memo Our current packaging equipment was purchased five years ago as used equipment in a liquidation sale of a small 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 slower 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-shift days catching up with production. I cannot say that we have missed any deadlines because of packaging problems, but it is a constant concern around here and things would run a lot smoother with more reliable equipment. In 2002, we will pay about SGD15,470 per year for maintenance costs. The operator is paid SGD63,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 depreciated 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 its 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 flexible 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 packager will operate indefinitely. Thus, for the purposes of our analysis, we can assume that this will be the last packaging equipment we will ever have to purchase. Because of the anticipated growth at Star River, the current equipment will not be able to handle our packaging needs by the end of 2004. Thus, if we do not bay new packaging equipment by this year's end, we will have to buy it after three years time anyway. Since the speed, capacity, and reliability 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.
-8- Exhibit 4 (continued) UVA-F-1361 The new equipment currently costs SGD1.82 million, which we would depreciate over 10 years at SGD182,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 by the s of the price of new equipment. Thus if the manufacturer continues to increase the price of new packaging equipment at 5% per annum as it has in the past, our maintenance 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%.
A detailed cash flow analysis of the initial outlay, operating cash flow, and terminalcash flow for the alternatives under consideration.
A “first pass” recommendation for when to purchase the new equipment using adiscount rate of 10%.
A Net Present Value Profile analysis that allows you to specify the ranges of costsof capital over which one alternative is preferred to the other. In other words,calculate the “crossover” rate at which Star River would be indifferent to buyingthe equipment now or in 3 years.
Results of sensitivity analysis on key parameters indicating why changes in theirvalues may occur and how those changes will affect Star River’s purchasingdecision.
Please show excel spreadsheet with calculations.
Exhibit 4STAR RIVER ELECTRONICS LTD.
Lim's Memo regarding New Packaging Equipment
Adeline Koh, President and CEO, Star River Electronics Esmond Lim, Plant ManagerJune 30,2001
New
Although our CD packaging equipment is adequate at current production levels, it is terribly inefficient. The new machinery on the market can give us significant labor savings as well as increased flexibility with respect to the type of packaging used. I recommend that we go with the new technology. Should we decide to do so, the new machine can be acquired immediately. The considerations relevant to the decision are included in this memo.
Our current packaging equipment was purchased five years ago as used equipment in a liquidation sale of a small 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 slower 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-shift days catching up with production. I cannot say that we have missed any deadlines because of packaging problems, but it is a constant concern around here and things would run a lot smoother with more reliable equipment. In 2002, we will pay about SGD15,470 per year for maintenance costs. The operator is paid SGD63,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 depreciated 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 its
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 flexible 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 packager will operate indefmitely. Thus, for the purposes of our analysis, we can assume that this will be the last packaging equipment we will ever have to purchase. Because of the anticipated growth at Star River, the current equipment will not be able to handle 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 reliability 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.
-8- UV A-F-1361 Exhibit 4 (continued)
The new equipment currently costs SGD1.82 million, which we would depreciate over 10 years at SGD182,OOO 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 equipment. Thus if the manufacturer continues to increase the price of new packaging equipment at 5% per annum as it has in the past, our maintenance 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%.
- You Are Still Andy Chin Prepare The Second Part Of The Report Due At 7 A M Tomorrow To The New Ceo Of Star River Elect 1 (118.12 KiB) Viewed 11 times
-8- Exhibit 4 (continued) UVA-F-1361 The new equipment currently costs SGD1.82 million, which we would depreciate over 10 years at SGD182,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 by the s of the price of new equipment. Thus if the manufacturer continues to increase the price of new packaging equipment at 5% per annum as it has in the past, our maintenance 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%.