Question

In: Finance

Clear Water Company has a down-hole well auger that was purchased 3 years ago for $30,000....

Clear Water Company has a down-hole well auger that was purchased 3 years ago for $30,000. O&M costs are $13,000 per year. Alternative A is to keep the existing auger. It has a current market value of $12,000 and it will have a $0 salvage value after 7 more years. Alternative B is to buy a new auger that will cost $54,000 and will have a $14,000 salvage value after 7 years. O&M costs are $6,000 for the new auger. Clear Water can trade in the existing auger on the new one for $15,000. Alternative C is to trade in the existing auger on a “treated auger” that requires vastly less O&M cost at only $3,000 per year. The “treated auger” costs $68,000, and the trade-in allowance for the existing auger is $17,000. The “treated auger” will have a $18,000 salvage value after 7 years. Alternative D is to sell the existing auger on the open market and to contract with a current competitor to use their equipment and services to perform the drilling that would normally be done with the existing auger. The competitor requires a beginning-of-year retainer payment of $10,000. End-of-year O&M cost would be $6,000. MARR is 15% and the planning horizon is 7 years.

Please show cash flow diagram and do not use excel functions.

a. Clearly show the cash flow profile in the table below for each alternative using a cash flow approach (insider’s viewpoint). No EUAC calculations in this letter.

EOY

Alternative A

Alternative B

Alternative C

Alternative D


b. Using an EUAC and a cash flow approach, decide which is the more favorable alternative.

c. Clearly show the cash flow profile in the table below for each alternative using an opportunity cost approach (outsider’s viewpoint). No EUAC calculations in this letter.

EOY

Alternative A

Alternative B

Alternative C

Alternative D


d. Using an EUAC and an opportunity cost approach, decide which is the more favorable alternative.

Solutions

Expert Solution

EOY

Alternative A

Alternative B

Alternative C

Alternative D

0

0

              (39,000)

                (51,000)

            12,000

                           1

           (13,000)

                (6,000)

                  (3,000)

            (6,000)

                           2

           (13,000)

                (6,000)

                  (3,000)

            (6,000)

                           3

           (13,000)

                (6,000)

                  (3,000)

            (6,000)

                           4

           (13,000)

                (6,000)

                  (3,000)

            (6,000)

                           5

           (13,000)

                (6,000)

                  (3,000)

            (6,000)

                           6

           (13,000)

                (6,000)

                  (3,000)

            (6,000)

                           7

           (13,000)

                   8,000

                  15,000

            (6,000)

Net Initial cost

-

54,000-15,000

68,000-17,000

10,000-12,000

Seventh year is net of salvage value

b. EUAC formula, for initial investment = Initial Cost* r* (1+r)n

                                                                                     (1+r)n - 1

                                For salvage value = Salvage value* r

                                                                                (1+r)n - 1            

                                For O &M, - Same as the actual value.

Total EUAC = EUAC for initial investment - Salvage Value + O&M.

Alternative A

Alternative B

Alternative C

Alternative D

Initial

                       -  

                (9,374)

                (12,258)

                  481

salvage

                       -  

                   1,265

                     1,626

                      -  

O&M

           (13,000)

                (6,000)

                  (3,000)

            (6,000)

Total

           (13,000)

              (14,109)

                (13,632)

            (5,519)

It can be seen from the table that Alternative D is the best option.


Related Solutions

Suppose a machine (defender) was purchased 2 years ago with an initial cost of $30,000. The...
Suppose a machine (defender) was purchased 2 years ago with an initial cost of $30,000. The CCA rate for the machine is 30%. The tax rate is 40%, and the company’s MARR is 15%. The operating cost of the machine is $4,000 per year. The current market value of the machine is $8,000, and this value decreases by $2,000 per year until it reaches zero. (a) What is the current net market value of the machine? (b) What will be...
The Olney Company purchased a machine 3 years ago at a cost of $150,000. It had...
The Olney Company purchased a machine 3 years ago at a cost of $150,000. It had an expected life of 10 years at the time of purchase and an expected salvage value of $5,000.    The existing machine costs $54,000 year to run and generates $1,000,000 a year in revenue with a gross profit margin of 20%.   The old machine can be sold today for $55,000 and the expectation is that it can be sold for $7,500 in 7 years. A...
VV purchased a house in New Hampshire 20 years ago for $30,000. When he died, an...
VV purchased a house in New Hampshire 20 years ago for $30,000. When he died, an appraisal report showed that the house had a fair market value of $650,000. The house went to his Nephew Tom. In a like-kind exchange, Tom exchanged the house with Jerry. Jerry’s house at the time of the exchange had a fair market value of $450,000 and an adjusted basis of $325,000 What is the reason why there is a boot in this exchange? Grandpa...
Two years ago, Sun company purchased a machine for $120,000. The company has learned that a...
Two years ago, Sun company purchased a machine for $120,000. The company has learned that a new machine is available for $145,000 today. It will be depreciated on a straight-line basis over 10 years and has no salvage value. Sun Company expects that the new machine will produce earnings of $45,000 per year for the next 10 years. The old machine is expected to produce earnings of $25,000 per year. The old machine is being depreciated on a straight-line basis...
A person purchased a ​$239,127 home 10 years ago by paying 15​% down and signing a​...
A person purchased a ​$239,127 home 10 years ago by paying 15​% down and signing a​ 30-year mortgage at 10.8​% compounded monthly. Interest rates have dropped and the owner wants to refinance the unpaid balance by signing a new 20​-year mortgage at 6 % compounded monthly. How much interest will refinancing​ save?
A person purchased a ​$133,748 home 10 years ago by paying 20​% down and signing a​...
A person purchased a ​$133,748 home 10 years ago by paying 20​% down and signing a​ 30-year mortgage at 10.2​% compounded monthly. Interest rates have dropped and the owner wants to refinance the unpaid balance by signing a new 20​-year mortgage at 6.3 % compounded monthly. How much interest will refinancing​ save? Money​ Saved: ​(Round to the nearest cent as​ needed.)
Fifteen years ago a couple purchased a house for $230,000.00 by paying a 20% down payment...
Fifteen years ago a couple purchased a house for $230,000.00 by paying a 20% down payment and financing the remaining balance with a 30-year mortgage at 4.7% compounded monthly. (a) Find the monthly payment for this loan. (b) Find the balance of the loan after 16 years and after 17 years? (c) Find the total amount of interest paid by the couple during the 17th year.
A person purchased a $1,145,000 home 10 years ago by paying 25% down and signing a...
A person purchased a $1,145,000 home 10 years ago by paying 25% down and signing a 30-year fixed rate mortgage at 7.8% p.a.. Interest rate have dropped and the owner wants to refinance the unpaid balance by signing a new mortgage fixed 4% p.a.. Assume monthly mortgage payment frequency. Determine the amount of monthly payments under the original mortgage contract without refinancing. After how long will the principal outstanding be reduced by a half? How much interest will refinancing save?...
3. A CNC milling machine was purchased three years ago for $290,000 has a market value...
3. A CNC milling machine was purchased three years ago for $290,000 has a market value that can be described by the relation $290,000 -30,000k, where k is the number of years from the time of purchase. This type of asset has shown that its annual operating cost is described by the relation $40,000 + 20,000k. The asset’s salvage value was originally estimated to be $20,000 after a nine year predicted life. Determine the current values for P,S, and AOC...
A person purchased a ​$219 comma 867 home 10 years ago by paying 10​% down and...
A person purchased a ​$219 comma 867 home 10 years ago by paying 10​% down and signing a​ 30-year mortgage at 8.7​% compounded monthly. Interest rates have dropped and the owner wants to refinance the unpaid balance by signing a new 15​-year mortgage at 5.4 % compounded monthly. How much interest will refinancing​ save? Money​ Saved: ​$ nothing ​(Round to the nearest cent as​ needed.) NOTE: PLEASE WRITE NEATLY AND LABEL THE ANSWERS!!!! EXP: How much interest will financing save?...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT