Question

In: Accounting

Over the River Bridge Company needs to replace its CNC Machining line. They have 3 different...

Over the River Bridge Company needs to replace its CNC Machining line. They have 3 different options for the replacement.

Option 1:

Replace the worn-out equipment with the same equipment. The quoted price of this equipment is $16,500,000 due in full upon delivery. This equipment uses $185,000 of electricity a year. It has a service life of 5 years. It has a scrap value of $375,000.

Option 2:

Replace the worn-out equipment with Eco-CNC equipment. The quoted price of this equipment is $17,800,000 payable in 5 equal installments of 3,560,000 starting at delivery. This equipment uses $96,000 of electricity a year. It has a service life of 5 years.It has a scrap value of $475,000.

Option 3:

Replace the worn-out equipment with Bargain Shack equipment. The quoted price of this equipment is $9,000,000 where half is payable upon delivery and the remainder is payable in 1 year after delivery. This equipment uses $135,000 of electricity a year. It has a service life of 5 years. It has a scrap value of $165,000.  

Assume that the discount rate is 6% and that electricity is paid at the end of each year. Calculate the net present value for each option and recommend the option that Over the River Bridge Company should take based on the net present value.

Solutions

Expert Solution

Let us first calculate NPV of each option

(Note - I am showing OUTFLOW as positive item. Lowest NPV would be better in this case)

Option 1

Year Cash Flow PV Factor Present Value
0 $       16,500,000       1.000 $ 16,500,000
1 $            185,000       0.943 $       174,528
2 $            185,000       0.890 $       164,649
3 $            185,000       0.840 $       155,330
4 $            185,000       0.792 $       146,537
5 $            185,000       0.747 $       138,243
5 $           (375,000)       0.747 $      (280,222)
$ 16,999,065

Option 2

Year Cash Flow PV Factor Present Value
0 $         3,560,000       1.000 $    3,560,000
1 $              96,000       0.943 $          90,566
1 $         3,560,000       0.943 $    3,358,491
2 $              96,000       0.890 $          85,440
2 $         3,560,000       0.890 $    3,168,387
3 $              96,000       0.840 $          80,603
3 $         3,560,000       0.840 $    2,989,045
4 $              96,000       0.792 $          76,041
4 $         3,560,000       0.792 $    2,819,853
5 $              96,000       0.747 $          71,737
5 $           (475,000)       0.747 $      (354,948)
$ 15,945,215

Option 3

Year Cash Flow PV Factor Present Value
0 $   4,500,000       1.000 $    4,500,000
1 $      135,000       0.943 $       127,358
1 $   4,500,000       0.943 $    4,245,283
2 $      135,000       0.890 $       120,150
3 $      135,000       0.840 $       113,349
4 $      135,000       0.792 $       106,933
5 $      135,000       0.747 $       100,880
5 $     (165,000)       0.747 $      (123,298)
$   9,190,655

Option 3 is the most cost effective


Related Solutions

A city has built a bridge over a river and it decides to charge a toll...
A city has built a bridge over a river and it decides to charge a toll to everyone who crosses. For one year, the city charges a variety of different tolls and records information on how many drivers cross the bridge. The city thus gathers information about elasticity of demand. If the city wishes to raise as much revenue as possible from the tolls, where will the city decide to charge a toll: in the inelastic portion of the demand...
A person is bungee jumping. The bungee cord is attached to a bridge over a river....
A person is bungee jumping. The bungee cord is attached to a bridge over a river. At time t0, before the person jumps (and while she is at rest), the bungee cord is unstretched. At time t1, the cord is stretched and the person is moving downward at her maximum speed. At time t2, the person has fallen her maximum distance and the cord is stretched by its maximum amount. At t3, the person is moving back up toward the...
A new bridge is to be constructed over the East River in New York City. Two...
A new bridge is to be constructed over the East River in New York City. Two structural possibilities exist: the support could be in the shape of a parabola or the support could be in the shape of a semi-ellipse. The space between the supports needs to be 1050 feet. The height at the center of the arch needs to be 350 feet. Determine the equation of a parabola with these characteristics. (Hint: Place the vertex of the parabola at...
Elon Corporation manufactures parts for an aircraft company. It uses a computerized numerical controlled (CNC) machining...
Elon Corporation manufactures parts for an aircraft company. It uses a computerized numerical controlled (CNC) machining center to produce a specific part that has a design target of 2.317 inches with tolerances of + 0.032 inch. The CNC process that manufactures these parts has a mean of 1.527 inches and a standard deviation of 0.095 inch. Compute the process capability ratio and process capability index, AND comment on the overall capability of the process to meet the design specifications.
DogChew Products needs to replace its rawhide tanning and molding equipment. They have undergone a capital...
DogChew Products needs to replace its rawhide tanning and molding equipment. They have undergone a capital budgeting NPV analysis and have determined they should accept the project. You have been provided with the following information The equipment has a purchase price of $930,000 and has a seven-year useful life. The estimated salvage value is $95,000 in seven years. If they lease the equipment from RayNot Financing, the lease payments will be $205,000 per year for 7 years with the payments...
A lumber company transports its logs by floating them over a river. It wants to find...
A lumber company transports its logs by floating them over a river. It wants to find the mean time for a log to travel down to the factory. Measuring the time for 25 logs, it finds the mean time to be 65 minutes, with a standard deviation of 8 minutes. Construct a 95% confidence interval for the mean travel time.
A firm needs to replace most of its machinery in 7 years at a cost of...
A firm needs to replace most of its machinery in 7 years at a cost of $450,000. The company wishes to create a sinking fund to have this money available in 7 years. How much should the monthly deposits be if the fund earns 5% compounded monthly?
The company is considering a new assembly line to replace the existing assembly line. The existing...
The company is considering a new assembly line to replace the existing assembly line. The existing assembly line was installed 3 years ago at a cost of $90,000; it was being depreciated under the straight-line method. The existing assembly line is expected to have a usable life of 6 more years. The new assembly line costs $120,000; requires $9,000 in installation costs and $5,000 in training fees; it has a 6-year usable life and would be depreciated under the straight-line...
Macon Company is considering a new assembly line to replace the existing assembly line.
  Macon Company is considering a new assembly line to replace the existing assembly line. The existing assembly line was installed 3 years ago at a cost of $90,000; it was being depreciated under the straight-line method. The existing assembly line is expected to have a usable life of 6 more years. The new assembly line costs $120,000; requires $9,000 in installation costs and $5,000 in training fees; it has a 6-year usable life and would be depreciated under the...
write a program that replace each line of a file with its reverse. for example, if...
write a program that replace each line of a file with its reverse. for example, if you run: java Reverse HelloPrinter.java then the contents of HelloPrinter.java are changed to retnirPolleH ssalc clibup { )sgra ][gnirtS(niam diov citats clibup { wodniw elosnoc eht ni gniteerg a yalpsiD // ;) "!dlroW ,olleH " (nltnirp.tuo.mestyS } }
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT