Company A:
First Cost - $ 15000
Add: Maintenance & Repairs - 1600*4 = 6400
Less: Annual Benefit - 8000*4 = 32000
Less: Salvage Value = 3000
Net Effective Cost = - 13600 i,e. savings of $ 13600 over the period of 4 years.
Incremental ROR = 13600/4 = 3400 p.a.
i.e. 3400/15000 = 22.66% p.a,
Future Worth = $ 13600.
Payback Period,
Assuming revenues are earned equally over the period of time
15000/ (8000-1600) = 2.34 years
Benefit to cost ratio:
Annual Benefit = 8000
Annual Cost = 1600
Annual Amortisation of fixed cost = 3750
Annual amortization of salvage value = 750
Benefit to cost = (8000+750) : (1600+3750)
=8750:5350
Company B:
First Cost - $ 25000
Add: Maintenance & Repairs - 400*4 = 1600
Less: Annual Benefit - 13000*4 = 52000
Less: Salvage Value = 6000
Net Effective Cost = - 31400 i,e. savings of $ 31400 over the period of 4 years.
Incremental ROR = 31400/4 = 7850 p.a.
i.e. 7850/25000= 31.40% p.a,
Future Worth = $ 31400.
Payback Period,
Assuming revenues are earned equally over the period of time
25000/ (13000-400) = 1.98 years
Benefit to cost ratio:
Annual Benefit = 13000
Annual Cost = 400
Annual Amortisation of fixed cost = 6250
Annual amortization of salvage value =1500
Benefit to cost = (13000+1500) : (6250+400)
=14500:6650
Company C:
First Cost - $ 20000
Add: Maintenance & Repairs - 900*4 = 3600
Less: Annual Benefit - 9000*4 = 36000
Less: Salvage Value = 4500
Net Effective Cost = - 16900 i,e. savings of $ 16900 over the period of 4 years.
Incremental ROR = 16900/4 = 4225 p.a.
i.e. 4225/20000= 21.125% p.a,
Future Worth = $ 16900.
Payback Period,
Assuming revenues are earned equally over the period of time
20000/ (9000-900) = 2.47 years
Benefit to cost ratio:
Annual Benefit = 9000
Annual Cost = 900
Annual Amortisation of fixed cost = 5000
Annual amortization of salvage value = 1125
Benefit to cost = (9000+1125) : (5000+900)
=10125:5900
Company B:
First Cost - $ 35000
Add: Maintenance & Repairs - 400*4 = 1600
Less: Annual Benefit - 13000*4 = 52000
Less: Salvage Value = 6000
Net Effective Cost = - 21400 i,e. savings of $ 31400 over the period of 4 years.
Incremental ROR = 21400/4 = 5350 p.a.
i.e. 5350/35000= 15.28% p.a,
Future Worth = $ 21400.
Payback Period,
Assuming revenues are earned equally over the period of time
35000/ (13000-400) = 2.77 years
Benefit to cost ratio:
Annual Benefit = 13000
Annual Cost = 400
Annual Amortisation of fixed cost = 8750
Annual amortization of salvage value =1500
Benefit to cost = (13000+1500) : (8750+400)
=14500:9150
8-18 QZY, Inc. is evaluating new widget machines offered by three companies. The chosen machine А...
dget machines The chosen machine A А 8-18 OZY, Inc. is evaluating new widget mac offered by three companies. The chosen will be used for 3 years. Company Company Company B First cost $15,000 $25,000 $20,000 Maintenance 1,600 400 900 and operating Annual benefit 8,000 13,000 9,000 Salvage value 3,000 6,000 4,500 NOTE: MARR used is 15%. Use 4 years instead of 3 years. (“The chosen machine will be used for 4 years.") Solve for the following for 1.ROR for...
8-18 А QZY, Inc. is evaluating new widget machine offered by three companies. The chosen machi will be used for 3 years. Company Company Company $25,000 400 $20,000 900 First cost $15,000 Maintenance 1,600 and operating Annual benefit 8,000 Salvage value 3,000 13,000 6,000 9.000 4,500 NOTE: MARR used is 15%. Use 4 years instead of 3 years. ("The chosen machine will be used for 4 years.") Solve for the following for each company machines: 1. Incremental ROR 2. Future...
Please show work on excel
8-18 0ZY, Inc. is evaluating new widget machine offered by three companies. The chosen machi A will be used for 3 years. Company Company Company A $25,000 400 $15,000 1,600 $20,000 900 First cost Maintenance and operating Annual benefit Salvage value 8,000 3,000 13,000 9,000 6.000 4,500 NOTE: MARR used is 15%. Use 4 years instead of 3 years. ("The chosen machine will be used for 4 years.") Solve for the following for each company...
Problem 8-18 (10 points) - Ignore parts a & b of the problem shown in the text. Instead, answer parts a thru e below. Also, change the analysis period from 3 years to 4 years. Basically you will solve this problem four different times using the following four analysis methods using the numbering below you will see on the template. Then you will duplicate the analysis following instructions in parte after changing a value for one of the alternatives a....
CALCULATE FOR B
PROBLEM The following costs are associated with three tomato-peeling machines being considered for use in a food canning plan Machine A S52,000 15,000 Machine B $67,000 12,000 Machine C $63,000 9,000 First cost Annual Maintenance & Operating costs Annual increase starting in year2 Annual benefit Salvage value Useful life, in years 38,000 13,000 4 37,000 22,000 12 250 31,000 19,000 If the canning company uses a MARR of 12%, which is the best alternative? Show your analysis...
Heartland Paper Company is considering the purchase of a new high-speed cutting machine. Two cutting machine manufacturers have approached Heartland with proposals: (1) Toledo Tools and (2) Akron Industries. Regardless of which vendor Heartland chooses, the following incremental cash flows are expected to be realized. Year Incremental Cash Inflows Incremental Cash Outflows 1 $ 27,000 $ 22,000 2 28,000 23,000 3 33,000 28,000 4 36,000 31,000 5 35,000 30,000 6 34,000 29,000 a. If the machine manufactured by Toledo Tools...
x Company must replace one of its current machines with either Machine A or Machine B. The useful life of Last year, X Company sold 64,200 units of its only product for $18.00 each. Total costs were as follows: both machines is seven years. Machine A costs $50,000, and Machine B costs $63,000. Estimated annual cash flows with the two machines are as Cost of goods sold Variable $483,426 follows: 131,610 Fixed Machine Machine Selling and Year A. administrative 1...
Three alternatives Machines have the following cost data associated with them. Machine Z Data Machine X Machine Y Useful Life, Years 10 10 10 $1,325,000 $1,980,000 $1,650,000 First Cost $265,000 $589,000 $435,000 Annual Benefit $95,000 $97,000 $91,000 Annual M&O Costs Annual additional M&O $2,300 $1,980 $2,100 cost in Gradient Salvage Value $205,000 $178,000 $145,000 Loan Payment $187,971 $150,946 $225,565 The loan payments are calculated using an interest rate of 10%, a life equal to the life of the machine, and...
a.ca mouleunotlemptph Trading Importation Jose Espana 20 55 50 40 Question 7 The General Hospital is evaluating new office equipment offered by four companies. The useful ife of the equipment is 5 years Not yet answered Marked out of 1.00 C 2 C 1 C3 C4 P Fag duestion $20.000 First cost $15,000 $18,000 $25,000 1049 Maintenance and 1.600 1230 400 operating cost (annual) Annual benefit 9.000 13,000 11.000 8.000 Salvage value 5002 4,500 3.500 6.000 When doing an incremental...
Three alternatives Machines have the following cost data associated with them. Machine Y Machine Z 10 Data Useful Life, Years First Cost Annual Benefit Annual M&O Costs Annual additional M&O cost in Gradient Salvage Value Loan Payment Machine X 10 $1,325,000 $265,000 $95,000 $2,300 $1,980,000 $589,000 $97,000 $2,100 $1,650,000 $435,000 $91,000 $1,980 $145,000 $150,946 $205,000 $225,565 $178,000 $187,971 The loan payments are calculated using an interest rate of 10%, a life equal to the life of the machine, and a...