Question

***** please show excel calculations ******* A specialty concrete mixer used in construction was purchased for...

***** please show excel calculations *******

A specialty concrete mixer used in construction was purchased for $300,000 7 years ago. It is MACRS-GDS 5-year property. Its annual O&M costs are $105,000. At the end of an 8-year planning horizon, the mixer will have a salvage value of $5,000. If the mixer is replaced, a new mixer will require an initial investment of $375,000, and at the end of the 8-year planning horizon, the new mixer will have a salvage value of $45,000. Its annual O&M cost will be only $40,000 due to newer technology. Use an EUAC measure, a tax rate of 40 percent, and an after-tax MARR of 9 percent to perform an after-tax analysis to see if the concrete mixer should be replaced if the old mixer is sold for its market value of $65,000.

a. Use the cash flow approach (insider’s viewpoint approach). (11.2.2)

Homework Answers

Answer #1

(a)
MARKET VALUE = $65,000

ANNUAL,O&M COST = $105,000

SALVAGE VALUE IN 8 YEARS = $5,000

REMAINING LIFE = 8

MARR = 15%

EUAC=105000-5000(A|F 15%,8)%3D

EUAC=105000-5000(0.07285)= $104,635.75

REPLACE WITH NEW SPECIALTY CONCRETE MIXER FIRST COST = $375,000

ANNUAL O&M COST = $40,000

SALVAGE VALUE IN 8 YEARS = $45,000

REMAINING LIFE = 8

MARR = 15%

EUAC=(375000-65000)(A|P 15%,8)+40000-45000(A|F 15%,8)

=310000(0.22285)+40000-45000 (0.07285)3

= $105,805.25

$104,635.75 < $105,805.25

Decision: Keep existing Concrete mixer

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A specialty concrete mixer used in construction was purchased for $300,000 7 years ago. Its annual...
A specialty concrete mixer used in construction was purchased for $300,000 7 years ago. Its annual O&M costs are $105,000. At the end of the 8-year planning horizon, the mixer will have a salvage value of $5,000. If the mixer is replaced, a new mixer will require an initial investment of $375,000 and at the end of the 8-year planning horizon, the new mixer will have a salvage value of $45,000. Its annual O&M cost will be only $40,000 due...
A chemical mixer was purchased 8 years ago for $100,000. If retained, it will require an...
A chemical mixer was purchased 8 years ago for $100,000. If retained, it will require an investment of $50,000 to upgrade it; if upgraded, it will cost $35,000/year to operate and maintain (O&M) and will have a negligible salvage value after 5 years. A new mixer can be purchased for $120,000; it will have an annual O&M cost of $15,000 and a salvage value of $40,000 after 5 years. Alternatively, a mixer can be leased with 5 beginning-of-year lease payments...
DBM:  A construction company decided to purchase a concrete mixer truck for $75,000 with a trade-in of...
DBM:  A construction company decided to purchase a concrete mixer truck for $75,000 with a trade-in of their old mixer. The old mixer has a trade-in value of $20,000. The new mixer will be kept for 10 years before being sold. Its estimated salvage value at that time is expected to be $5,000. Assume interest to be 10%. Determine the 6th year BVB by Declining Balance Method (round-off k to 4 decimal places).
DBM:  A construction company decided to purchase a concrete mixer truck for $75,000 with a trade-in of...
DBM:  A construction company decided to purchase a concrete mixer truck for $75,000 with a trade-in of their old mixer. The old mixer has a trade-in value of $20,000. The new mixer will be kept for 10 years before being sold. Its estimated salvage value at that time is expected to be $5,000. Assume interest to be 10%. Determine the 6th year BVB by Declining Balance Method (round-off k to 4 decimal places).
DBM: A construction company decided to purchase a concrete mixer truck for $75,000 with a trade-in...
DBM: A construction company decided to purchase a concrete mixer truck for $75,000 with a trade-in of their old mixer. The old mixer has a trade-in value of $7,000. The new mixer will be kept for 15 years before being sold. Its estimated salvage value at that time is expected to be $5,000. Assume interest to be 12%. Determine the 6th year BVB by Declining Balance Method (round-off k to 4 decimal places).
We need to purchase construction equipment. We have the choice of purchasing: • Item A, which...
We need to purchase construction equipment. We have the choice of purchasing: • Item A, which has an initial cost of $75,000, an annual fuel cost of $ 6,000/year, annual maintenance cost of $2,000 at the end of the first year that increase thereafter by $200 per year and a salvage value of $10,000 at the end of its 8-year life, and • Item B, which has an initial cost of $100,000, an annual fuel cost of $ 5,500/year, annual...
Michelin is considering going ‘‘lights-out’’ in the mixing area of the business that operates 24/7. Currently,...
Michelin is considering going ‘‘lights-out’’ in the mixing area of the business that operates 24/7. Currently, personnel with a loaded cost of $560,000 per year are used to manually weigh real rubber, synthetic rubber, carbon black, oils, and other components prior to manual insertion in a Banbary mixer that provides a homogeneous blend of rubber for making tires (rubber products). New technology is available that has the reliability and consistency desired to equal or exceed the quality of blend now...
Show excel formulas if used. If possible can you make calculations in blue and solution in...
Show excel formulas if used. If possible can you make calculations in blue and solution in red 1. Harry Harrison has purchased a certificate of deposit (CD) from his bank that pays an annual interest rate of 2.50% compounded daily. What is the effective annual rate (EAR) on this CD? 2. Arbor Corporation is considering a new three-year expansion project that requires an initial fixed asset investment of $280,000. The fixed asset will be depreciated straight-line to zero over its...
Please show the formula from excel if you can. Thanks Question 1 : A company has...
Please show the formula from excel if you can. Thanks Question 1 : A company has the opportunity to expand its business operations by acquiring new plant and equipment. The plant and equipment will cost $80,000 and have a useful life of 6 years. At the end of the period the plant and equipment will have a salvage value of $10,000. The Tax Office allows the company to depreciate this equipment at 25% per annum using the prime cost method...
Please show excel steps. Although the Chen Company's milling machine is old, it is still in...
Please show excel steps. Although the Chen Company's milling machine is old, it is still in relatively good working order and would last for another 10 years. It is inefficient compared to modern standards, though, and so the company is considering replacing it. The new milling machine, at a cost of $42,000 delivered and installed, would also last for 10 years and would produce after-tax cash flows (labor savings and depreciation tax savings) of $8,400 per year. It would have...