Question

In: Accounting

Apricot Computers is considering replacing its material handling system and either purchasing or leasing a new...

Apricot Computers is considering replacing its material handling system and either purchasing or leasing a new system. The old system has an annual operating and maintenance cost of $31,000, a remaining life of 8 years, and an estimated salvage value of $5,800 at that time.
A new system can be purchased for $237,000; it will be worth $26,000 in 8 years; and it will have annual operating and maintenance costs of $19,000/year . If the new system is purchased, the old system can be traded in for $21,000.
Leasing a new system will cost $22,000/year , payable at the beginning of the year, plus operating costs of $8,400/year , payable at the end of the year. If the new system is leased, the old system will be sold for $9,400.
MARR is 14%. Compare the annual worths of keeping the old system, buying a new system, and leasing a new system based upon a planning horizon of 8 years.

Click here to access the TVM Factor Table Calculator
For calculation purposes, use 5 decimal places as displayed in the factor table provided. Round answer to 2 decimal places, e.g. 52.75. The absolute cell tolerance is ±1

What is the EUAC of the best option using the cash flow approach?

Solutions

Expert Solution

Old System New System Leasing New System
Sl. No. Particulars Year Cash Flows PVF/PVAF PV of Cashflows Cash Flows PVF/PVAF PV of Cashflows Cash Flows PVF/PVAF PV of Cashflows
A Cost of Material Handling System Year 0 $                 -   1.00000 $                          -   $ 237,000.00 1.00000 $        237,000.00 $                 -   1.00000 $                          -  
B Opportunity Cost/(Benefit) Year 0 $                 -   $                                        -   $                          -   $ (21,000.00) 1.00000 $        (21,000.00) $ (9,400.00) 1.00000 $          (9,400.00)
C Annual Lease Payment for First Year Year 0 $                 -   $                                        -   $                          -   $                   -   $                                        -   $                          -   $ 22,000.00 1.00000 $          22,000.00
D Annual Lease Payment for balance 7 Years Year 1-7 $                 -   $                                        -   $                          -   $                   -   $                                        -   $                          -   $ 22,000.00 4.28830 $          94,342.71
(1-((1+0.14)^(-7)))/0.14
E Annual Operating and Maintenance Cost Year 1-8 $ 31,000.00 4.63886 $        143,804.78 $    19,000.00 4.63886 $          88,138.41 $    8,400.00 4.63886 $          38,966.46
(1-((1+0.14)^(-8)))/0.14 (1-((1+0.14)^(-8)))/0.14 (1-((1+0.14)^(-8)))/0.14
F Salvage Value Year 8 $ (5,800.00) 0.35056 $          (2,033.24) $ (26,000.00) 0.35056 $          (9,114.54) $                 -   0.35056 $                          -  
(1/((1+0.14)^8)) (1/((1+0.14)^8)) (1/((1+0.14)^8))
G $        141,771.54 $        295,023.88 $        145,909.16

Related Solutions

The Callaway Company is considering the construction of a new feed handling system for its feed...
The Callaway Company is considering the construction of a new feed handling system for its feed lot in Abilene, Kansas. The new system will provide annual labor savings and reduce waste totaling $175,000 while the initial investment is only $480,000. Callaways Management has used a simple payback method for evaluating new investments in the past but plans to calculate the discounted payback to analyze the investment. Where are the appropriate discount rate for this type of project is 11% what...
The Callaway Cattle Company is considering the construction of a new feed handling system for its...
The Callaway Cattle Company is considering the construction of a new feed handling system for its feed lot in​ Abilene, Kansas. The new system will provide annual labor savings and reduced waste totaling 195000 while the initial investment is only 510000 Callaway's management has used a simple payback method for evaluating new investments in the past but plans to calculate the discounted payback to analyze the investment. Where the appropriate discount rate for this type of project is 8 percent....
A company is considering replacing its existing computer systemwith a new computer system. The new...
A company is considering replacing its existing computer system with a new computer system. The new system can offer considerable savings in computer processing and inventory management costs. Information about the existing system and the new system follow:Existing ComputerNew ComputerOriginal cost$10,000$15,000Annual operating cost$ 3,500$ 2,000Accumulated depreciation$ 6,000―Current salvage value of the existing system$ 4,000―Remaining life in 5 years5 yearsSalvage value in 5 years$ 0$ 0Annual depreciation$ 2,000$ 3,000Which of the following is an avoidable cost if a company gives up...
Banana Inc. is considering either purchasing or leasing a $600,000 piece of specialized equipment. The equipment...
Banana Inc. is considering either purchasing or leasing a $600,000 piece of specialized equipment. The equipment has a life of 5 years, belongs in a 30% CCA class, and will have no residual value. The cost of debt is is 12% for this purchase. A lease on this equipment for 5 years is priced at $150,000 a year. Banana Inc.'s corporate tax rate is 34%. What is Banana Inc.'s break-even lease payment? a) $182,968 b) 170,802 c) $109,057 d) $133,677...
PLEASE SHOW WORKINGS ON EXCEL FM Corporation is considering either purchasing or leasing an asset that...
PLEASE SHOW WORKINGS ON EXCEL FM Corporation is considering either purchasing or leasing an asset that costs $1,000,000. The asset, if purchased, will be depreciated on a straight-line basis over six years to a zero residual value. Ace Leasing company is willing to lease the asset for $300,000 per year; the first payment on the lease is due at the time the lease is undertaken (i.e., year 0), and the remaining five payments are due at the beginning of years...
The Luddite Corporation is considering replacing its southwest production line with a totally new system that...
The Luddite Corporation is considering replacing its southwest production line with a totally new system that will increase production as well as decreasing costs from labor and material waste. The new line will cost $680,000 to have in place ready to go. Luddite expects that it will increase cash flows by $120,500 each year for ten years. At the end of its expected life, the system's salvage value is expected to equal the costs to remove it. The required return...
Please show workings clearly on excel sheet Your company is considering either purchasing or leasing an...
Please show workings clearly on excel sheet Your company is considering either purchasing or leasing an asset that costs $1,000,000. The asset, if purchased, will be depreciated on a straight-line basis over six years to a zero residual value. Ace Leasing company is willing to lease the asset for $300,000 per year; the first payment on the lease is due at the time the lease is undertaken (i.e., year 0), and the remaining five payments are due at the beginning...
Your company is considering investing in new material handling equipment for your warehouse. The new equipment...
Your company is considering investing in new material handling equipment for your warehouse. The new equipment will allow for savings in fuel and maintenance costs each year over 6 years. The first year savings is expected to be $3000 and that savings will decrease by $400 each subsequent year (i.e. $2600 savings year 2, $2200 savings year 3, and so on). The new equipment would cost $20,000 today, and at the end of 6 years it would have zero value....
The job-costing system at Melody’s Custom Framing has five indirect cost pools (purchasing, material handling, machine...
The job-costing system at Melody’s Custom Framing has five indirect cost pools (purchasing, material handling, machine maintenance, product inspection, and packaging). The company is in the process of bidding on two jobs: Job 220, an order of 17 intricate personalized frames, and Job 330, an order of 5 standard personalized frames. The controller wants you to compare overhead allocated under the current simple job-costing system and a newly designed activity-based job-costing system. Total budgeted costs in each indirect-cost pool and...
Suppose Amazon is considering replacing an old packaging system with a new one. The old system...
Suppose Amazon is considering replacing an old packaging system with a new one. The old system has a book value of $50,000 and a remaining life of 10 years and could be sold for $75,000 right now. The new machine costs $150,000 and has a depreciable life of 10 years, annual operating costs $40,000 lower than the old machine. Assuming straight line depreciation, 40% tax rate, and no salvage value on either machine at the end of 10 years, should...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT