Question

***** 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 ﬂow approach (insider’s viewpoint approach). (11.2.2)

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

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 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 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 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 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 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, 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 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 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 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...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 11 minutes ago

asked 13 minutes ago

asked 19 minutes ago

asked 25 minutes ago

asked 50 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago