Question

In: Economics

Some factory equipment was bought at a cost of $100,000. The O&M costs for the first...

Some factory equipment was bought at a cost of $100,000. The O&M costs for the first year were $10,000 and they are expected to increase by $2,500 per year thereafter. The market value of the equipment declines by 15% per year over its 5-year life. What is the minimum cost life for this equipment? Assume MARR = 4%.

Group of answer choices

5 years

3 years

2 years

4 years

Solutions

Expert Solution

Using Excel for Economic Analysis period

Year Discount factor O&M cost PV (O&M) Cumulative (O&M) Cumulative (O&M) + Initial Cost Salvage value PV (Salvage value) NPV (A/P,4%,n) EUAC
A B C D=C*B E F=E+100000 G H=G*B I=F-H J K = I*J
1 0.9615 10000.00 9615.38 9615.38 109615.38 85000.00 81730.77 27884.62 1.0400 29000
2 0.9246 12500.00 11556.95 21172.34 121172.34 72250.00 66799.19 54373.15 0.5302 28828
3 0.8890 15000.00 13334.95 34507.28 134507.28 61412.50 54595.49 79911.79 0.3603 28796
4 0.8548 17500.00 14959.07 49466.36 149466.36 52200.63 44621.31 104845.04 0.2755 28884
5 0.8219 20000.00 16438.54 65904.90 165904.90 44370.53 36469.34 129435.56 0.2246 29075
Discount factor 1/(1+0.04)^n
(A/P,i,n) i((1 + i)^n)/((1 + i)^n-1)

Minimum EUAC is 28796 at year 3

Economic service life = 3 yrs

Second option is correct answer

Showing formula in Excel

Year Discount factor O&M cost PV (O&M) Cumulative (O&M) Cumulative (O&M) + Initial Cost Salvage value PV (Salvage value) NPV (A/P,4%,n) EUAC
A B C D=C*B E F=E+100000 G H=G*B I=F-H J K = I*J
1 =1/(1.04)^A14 10000 =C14*B14 =D14 =100000+E14 =100000*0.85 =G14*B14 =F14-H14 =0.04*((1 + 0.04)^A14)/((1 + 0.04)^A14-1) =I14*J14
2 =1/(1.04)^A15 =C14+2500 =C15*B15 =E14+D15 =100000+E15 =G14*0.85 =G15*B15 =F15-H15 =0.04*((1 + 0.04)^A15)/((1 + 0.04)^A15-1) =I15*J15
3 =1/(1.04)^A16 =C15+2500 =C16*B16 =E15+D16 =100000+E16 =G15*0.85 =G16*B16 =F16-H16 =0.04*((1 + 0.04)^A16)/((1 + 0.04)^A16-1) =I16*J16
4 =1/(1.04)^A17 =C16+2500 =C17*B17 =E16+D17 =100000+E17 =G16*0.85 =G17*B17 =F17-H17 =0.04*((1 + 0.04)^A17)/((1 + 0.04)^A17-1) =I17*J17
5 =1/(1.04)^A18 =C17+2500 =C18*B18 =E17+D18 =100000+E18 =G17*0.85 =G18*B18 =F18-H18 =0.04*((1 + 0.04)^A18)/((1 + 0.04)^A18-1) =I18*J18
Discount factor 1/(1+0.04)^n
(A/P,i,n) i((1 + i)^n)/((1 + i)^n-1)

Related Solutions

Alternative R has a first cost of $88,000, annual M&O costs of $62,000, and a $20,000...
Alternative R has a first cost of $88,000, annual M&O costs of $62,000, and a $20,000 salvage value after 5 years. Alternative S has a first cost of $175,000 and a $58,000 salvage value after 5 years, but its annual M&O costs are not known. Determine the M&O costs for alternative S that would yield a required incremental rate of return of 23%. The M&O cost for alternative S is $
A person has bought an equipment which costs $100,000 to buy and $16,000 to install. The...
A person has bought an equipment which costs $100,000 to buy and $16,000 to install. The annual operating cost would be $5,000 for the first year and it is expected to increase by $500 thereafter. This equipment will save $40,000 for each year and the life of the equipment is 5 years. 1. Determine depreciation for each year by using MACRS (20%, 32%, 19.2%, 11.52%, 11.52%, and 5.76%) 2. If the person decides to sell this equipment at the end...
A new asset is available for $239,000. O&M costs are $24,000 each year for the first...
A new asset is available for $239,000. O&M costs are $24,000 each year for the first five years, $37,680 in year six, $57,700 in year seven, and $88,300 in year eight. Salvage values are estimated to be $198,000 after one year and will decrease at the rate of 17% per year thereafter. At a MARR of 12%, determine the economic service life of the asset. Enter your answer as an integer from 1 to 8.
A new asset is available for $227,000. O&M costs are $34,000 each year for the first...
A new asset is available for $227,000. O&M costs are $34,000 each year for the first five years, $51,000 in year six, $79,100 in year seven, and $121,800 in year eight. Salvage values are estimated to be $204,000 after one year and will decrease at the rate of 50% per year thereafter. At a MARR of 18%, determine the economic service life of the asset. Enter your answer as an integer from 1 to 8
"A new asset is available for $236,000. O&M costs are $10,000 each year for the first...
"A new asset is available for $236,000. O&M costs are $10,000 each year for the first five years, $13,300 in year six, $19,300 in year seven, and $28,800 in year eight. Salvage values are estimated to be $144,000 after one year and will decrease at the rate of 49% per year thereafter. At a MARR of 10%, determine the economic service life of the asset. Enter your answer as an integer from 1 to 8." Answer is 8
A machine cost $30,000 initially and has no salvage value. The O&M costs in year 1...
A machine cost $30,000 initially and has no salvage value. The O&M costs in year 1 were $10,000 and have been increasing by $2,000 from year 2. The minimum cost life of this machine for a MARR of 10 %. (show your solution) A. 4 years B. 2 years C. 6 years D. None of above
Pausini Corporation is considering a new equipment for their factory in Milan. The equipment costs   ...
Pausini Corporation is considering a new equipment for their factory in Milan. The equipment costs    $500,000 today and it will be depreciated on a straight-line basis over five years. In          addition, the      company’s inventory will increase by $81,000 and accounts payable will rise by $29,000. All other           operating working capital components will stay the same. The change in net working capital will be recovered at the end of third year at which time the company sells...
The government is considering purchasing some excavating equipment. It has a first cost of $68,000, will...
The government is considering purchasing some excavating equipment. It has a first cost of $68,000, will result in annual savings to the public of $20,000 per year, and will be sold for $15,000 at the end of its useful life. The useful life is 4 years, and the MARR is 4%. a. Determine the benefits to cost (B/C) ratio for this situation. Should the government invest in the excavating equipment? b. An intern working with the company came across some...
A company is considering purchasing factory equipment that costs $320,000 and is estimated to have no...
A company is considering purchasing factory equipment that costs $320,000 and is estimated to have no salvage value at the end of its 8-year useful life. If the equipment is purchased, annual revenues are expected to be $90,000 and annual operating expenses exclusive of depreciation expense are expected to be $40,000. The straight-line method of depreciation would be used. The cash payback period on the equipment is Select one: A. 3.6 years. B. 8.0 years. C. 3.2 years. D. 6.4...
On 1 January 2017, Entity A bought a $100,000 5% bond for $95,000, incurring issue costs...
On 1 January 2017, Entity A bought a $100,000 5% bond for $95,000, incurring issue costs of $2,000. Interest is received in arrears. The bond will be redeemed at a premium of $5,960 over the face value on 31 December 2019. The effective interest rate is 8%. The fair value of the bond was as follows: 31 December 17 : $110,000 31 December 18 : $104,000 REQUIRED: (1) Measure the amounts recognized in the Statement of Financial Position for the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT