Question

In: Finance

Enter in excel formula You are considering the purchase of one of two machines used in...

Enter in excel formula

You are considering the purchase of one of two machines used in your manufacturing plant. Machine A has a life of two years, costs $95 initially, and then $140 per year in maintenance costs. Machine B costs $165 initially, has a life of three years, and requires $115 in annual maintenance costs. Either machine must be replaced at the end of its life with an equivalent machine. The discount rate is 12 percent and the tax rate is zero. Calculate the EAC. Negative amounts should be indicated by a minus sign. Round your answers to 2 decimal places. EAC Machine A $ Machine B $ Which one should you choose? Machine A or Machine B

(In table below, row one is row 7 in assignment excel sheet . Tax rate is row 14)

Column C Column D

Machine A life (years ) 2
Machine A initial cost $95
Machine A maintenance cost $140
Machine B life (years) 3
Machine B initial cost $165
Machine B maintenance cost 115
discount rate 12%
tax rate 0%

Complete the following analysis. Do not hard code values in your calculation. Do not round intermediate calculations.

Column D Column E

Years Machine A CFs Machine B CFs
0
1
2
3
4
5
6
7
8
9
10

EACa

EACb

choice

Solutions

Expert Solution


Related Solutions

You are considering the purchase of one of two machines used in your manufacturing plant. Machine...
You are considering the purchase of one of two machines used in your manufacturing plant. Machine A has a life of two years, costs $150 initially, and then $105 per year in maintenance costs. Machine B costs $220 initially, has a life of three years, and requires $170 in annual maintenance costs. Either machine must be replaced at the end of its life with an equivalent machine. The discount rate is 13 percent and the tax rate is zero. Calculate...
Capital Budgeting Exercise 1 You are considering the purchase of one of two machines used in...
Capital Budgeting Exercise 1 You are considering the purchase of one of two machines used in your manufacturing plant. Machine A has a life of two years, costs $1500 initially, and then $400 per year in maintenance costs. Machine B costs $2000 initially, has a life of three years, and requires $300 in annual maintenance costs. Either machine must be replaced at the end of its life with an equivalent machine. Which is the better machine for the firm? The...
A  firm is considering the purchase of one of two machines to replace an existing one. MachineA...
A  firm is considering the purchase of one of two machines to replace an existing one. MachineA will cost GBP £18,000 and has a four-year life. Annual net cash flows are expected to be GBP£7,200, beginning one year after the machine is purchased. Machine B will cost GBP £26,000and has a six-year life. Annual net cash flows are expected to be GBP £7,500, beginning oneyear after the machine is purchased. Assume the firm's cost of capital is a constant 15%forever, and...
A firm is considering the purchase of one of two new machines. The data on each...
A firm is considering the purchase of one of two new machines. The data on each are given. Machine A Machine B Initial cost 3400 6500 Service life 3 years 6 years Salvage value 100 500 Net operating cost 2000/year 1800/year If the MARR is 12%, which alternative should be selected when using the following methods? a. Annual equivalent cost approach ( method 2) b. Present Worth comparison (method 2) c. Incremental IRR comparison ( method 2)
A firm is considering the purchase of one of two new machines. The data on each...
A firm is considering the purchase of one of two new machines. The data on each are given. Machine A Machine B Initial cost 3400 6500 Service life 3 years 6 years Salvage value 100 500 Net operating cost 2000/year 1800/year If the MARR is 12%, which alternative should be selected when using the following methods? a. Annual equivalent cost approach ( method 2) b. Present Worth comparison (method 2) c. Incremental IRR comparison ( method 2)
1. You are evaluating the purchase of either of two machines used in your brewery. Machine...
1. You are evaluating the purchase of either of two machines used in your brewery. Machine A will last two years, costs $8,000 initially, and then $1,250 per year in maintenance costs. Machine B costs $9,500 initially, has a life of three years, and requires $1,000 in annual maintenance costs. Either machine must be replaced at the end of its life with an equivalent machine. Your interest rate on current debt and the initial purchases is 9 percent and the...
Please explain your answers and use Excel to show the excel formula you used to get...
Please explain your answers and use Excel to show the excel formula you used to get your solution. 6. A manufacturing process produces connecting rods whose diameter is normally distributed with mean 1.495 cm and standard deviation .05 cm. In what range will the “middle 80%” of the diameters lie? What about the “middle 98%”?
You have the choice to purchase one of two machines, which can produce exactly the same...
You have the choice to purchase one of two machines, which can produce exactly the same product. Machine A has a MTBF of 100 hours and MTTR of 10 hours, Machine B has a MTBF of 10 hours and a MTTR of 1 hour. What is the availability of each machine? In terms of process stability and inventory which machine would you prefer to purchase & why?
A company is considering replacing one of the old machines used in the manufacturing process. The...
A company is considering replacing one of the old machines used in the manufacturing process. The machine was purchased 2 years ago for $500,000. This machine is being depreciated on a straight-line basis, and it has 4 yrs of remaining life. When this machine was purchased 2 yrs ago, it was to have zero salvage value at the end of 6 yrs. Currently , this machine has a market value of $250,000. The company intends to keep this old machine...
A company is considering replacing one of the old machines used in the manufacturing process. The...
A company is considering replacing one of the old machines used in the manufacturing process. The machine was purchased 2 years ago for $600,000. This machine is being depreciated on a straight-line basis, and it has 4 years of remaining life. When this machine was purchased 2 years ago, it was assumed to have zero salvage value at the end of its useful life of 6 years. Currently, this machine has a market value of $250,000. The company intends to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT