Question

In: Finance

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.

Solutions

Expert Solution

Formula Sheet

A1 B C D E F G H I J
2 Economic service life is the life of the machine at which equivalent uniform annual cost is minimum.
3 Total EUAC consist of two components: Capital recovery cost and Equivalent uniform annual cost of O&M.
4 Capital recovery cost in year n is calculated as follows:
5 CRn = P*(A/P,i,n)-S*(A/F,i,n)
6 CRn = (P-S)*(A/P,i,n)+S*(i)
7 Where P is the present value (Cost) of the machine and S are maket value on nth year and i is interest rate.
8 Equivalent uniform annual cost of O&M, EUAC (O&M) is calculated as follows:
9 To Calculate EUAC (O&M) for a period, NPV of costs for till the period needs to be calculated first.
10 Then EUAC (O&M) can be calculated as follows:
11 EUAC (O&M) =NPV of Costs till year n*(A/P,i,n)
12 Then total EUAC for each of the year is calculated.
13 Total EUAC at year n =CRn+EUAC (O&M)
14
15 Calculation of EUAC for Existing Machine
16 MARR (i) 0.12
17 Year Market Value (MV) Operating cost ($ per year)
18 0 239000
19 1 =D18*(1-17%) 24000
20 2 =D19*(1-17%) 24000
21 3 =D20*(1-17%) 24000
22 4 =D21*(1-17%) 24000
23 5 =D22*(1-17%) 24000
24 6 =D23*(1-17%) 37680
25 7 =D24*(1-17%) 57700
26 8 =D25*(1-17%) 88300
27
28 For Year 1:
29 Capital Recovery Cost(CR1) = (P-S)*(A/P,i,n)+S*(i)
30 =(D18-D19)*(1/PV(D16,C19,-1,0))+D19*D16 =(D18-D19)*(1/PV(D16,C19,-1,0))+D19*D16
31 NPV of costs till year1 =E18+NPV(D16,E19) =E18+NPV(D16,E19)
32 EUAC (O&M) till year1 =NPV of Costs till year n*(A/P,i,n)
33 =D31*(1/PV(D16,C19,-1,0)) =D31*(1/PV(D16,C19,-1,0))
34
35 Total EUAC at year 1 =CR1+EUAC (O&M) for year 1
36 =D30+D33 =D30+D33
37
38 Similarly for other years it can be calculated as follows:
39 Interest rate (i) =D16
40 Year Market Value (MV) Operating cost ($ per year) Capital Recovery Cost NPV of Cost EUAC (O&M) Total EUAC
41 0 =D18 =E18
42 1 =D19 =E19 =($D$41-D42)*(1/PV($D$39,C42,-1,0))+D42*$D$39 =E41+NPV(D39,E42) =G42*(1/PV($D$39,C42,-1,0)) =F42+H42
43 2 =D20 =E20 =($D$41-D43)*(1/PV($D$39,C43,-1,0))+D43*$D$39 =$E$41+NPV($D$39,$E$42:E43) =G43*(1/PV($D$39,C43,-1,0)) =F43+H43
44 3 =D21 =E21 =($D$41-D44)*(1/PV($D$39,C44,-1,0))+D44*$D$39 =$E$41+NPV($D$39,$E$42:E44) =G44*(1/PV($D$39,C44,-1,0)) =F44+H44
45 4 =D22 =E22 =($D$41-D45)*(1/PV($D$39,C45,-1,0))+D45*$D$39 =$E$41+NPV($D$39,$E$42:E45) =G45*(1/PV($D$39,C45,-1,0)) =F45+H45
46 5 =D23 =E23 =($D$41-D46)*(1/PV($D$39,C46,-1,0))+D46*$D$39 =$E$41+NPV($D$39,$E$42:E46) =G46*(1/PV($D$39,C46,-1,0)) =F46+H46
47 6 =D24 =E24 =($D$41-D47)*(1/PV($D$39,C47,-1,0))+D47*$D$39 =$E$41+NPV($D$39,$E$42:E47) =G47*(1/PV($D$39,C47,-1,0)) =F47+H47
48 7 =D25 =E25 =($D$41-D48)*(1/PV($D$39,C48,-1,0))+D48*$D$39 =$E$41+NPV($D$39,$E$42:E48) =G48*(1/PV($D$39,C48,-1,0)) =F48+H48
49 8 =D26 =E26 =($D$41-D49)*(1/PV($D$39,C49,-1,0))+D49*$D$39 =$E$41+NPV($D$39,$E$42:E49) =G49*(1/PV($D$39,C49,-1,0)) =F49+H49
50
51
52 Since total EUAC of machine is minimum in year 6 therefore economic life of the machine is 6 year.
53

Related Solutions

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 new delivery truck is available for $200,000. O&M costs are $21,000 each year for the...
"A new delivery truck is available for $200,000. O&M costs are $21,000 each year for the first five years, $33,600 in year six, $52,100 in year seven, and $81,300 in year eight. Salvage values are estimated to be $150,000 after one year and will decrease at the rate of 17% per year thereafter. At a MARR of 17%, determine the economic service life of the truck. Enter your answer as an integer from 1 to 8."
A new asset has been proposed to your company: Year Investment O & M Costs Salvage...
A new asset has been proposed to your company: Year Investment O & M Costs Salvage Value 0 $14,000 1 $3,400 $8,000 2 $4,600 $6,000 3 $5,800 $4,000 4 $7,200 $2,000 5 $8,300 0 How long should the asset be kept? Use a MARR of 12%.
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
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 $
During the first month of its current fiscal year, Green Co. incurred repair costs of $24,000...
During the first month of its current fiscal year, Green Co. incurred repair costs of $24,000 on a machine that had 4 years of remaining depreciable life. The repair cost was inappropriately capitalized. Green Co. reported operating income of $164,000 for the current year. a. Assuming that Green Co. took a full year's straight-line depreciation expense in the current year, calculate the operating income that should have been reported for the current year. b. Assume that Green Co.'s total assets...
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
States Probability Asset M Return Asset N Return Asset O Return Boom 34% 12% 21% 4%...
States Probability Asset M Return Asset N Return Asset O Return Boom 34% 12% 21% 4% Normal 51% 10% 14% 10% Recession 15% 4% 1% 12% Benefits of diversification. Sally Rogers has decided to invest her wealth equally across the following three​ assets: a.  What are her expected returns and the risk from her investment in the three​ assets? How do they compare with investing in asset M​ alone?   Hint​: Find the standard deviations of asset M and of the...
  States Probability Asset M Return Asset N Return Asset O Return   Boom 32​% 13​% 23​% 5​%   ...
  States Probability Asset M Return Asset N Return Asset O Return   Boom 32​% 13​% 23​% 5​%   Normal 45​% 11​% 15​% 11​%   Recession 23​% 5​% 3​% 13​% a. What is the expected return of investing equally in all three assets M, N, and O? - what is the expected return of investing in asset M alone? - what is the standard deviation of the portfolio that invests equally in all three assets M, N, and O? - what is the standard...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT