Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / The Bigbee Bottling Company is contemplating the replacement of one of its bottling machines with a newer and more efficient one

The Bigbee Bottling Company is contemplating the replacement of one of its bottling machines with a newer and more efficient one

Finance

The Bigbee Bottling Company is contemplating the replacement of one of its bottling machines with a newer and more efficient one. The old machine has a book value of $575,000 and a remaining useful life of 5 years. The firm does not expect to realize any return from scrapping the old machine in 5 years, but it can sell it now to another firm in the industry for $235,000. The old machine is being depreciated by $115,000 per year, using the straight-line method.

The new machine has a purchase price of $1,200,000, an estimated useful life and MACRS class life of 5 years, and an estimated salvage value of $125,000. The applicable depreciation rates are 20%, 32%, 19%, 12%, 11%, and 6%. It is expected to economize on electric power usage, labor, and repair costs, as well as to reduce the number of defective bottles. In total, an annual savings of $240,000 will be realized if the new machine is installed. The company's marginal tax rate is 35%, and it has a 12% WACC.

  1. What initial cash outlay is required for the new machine? Round your answer to the nearest dollar. Negative amount should be indicated by a minus sign.
    $
  2. Calculate the annual depreciation allowances for both machines and compute the change in the annual depreciation expense if the replacement is made. Round your answers to the nearest dollar.
    Year Depreciation Allowance, New Depreciation Allowance, Old Change in Depreciation
    1 $ $ $
    2      
    3      
    4      
    5      
  3. What are the incremental net cash flows in Years 1 through 5? Round your answers to the nearest dollar.
    Year 1 Year 2 Year 3 Year 4 Year 5
    $ $ $ $ $
  4. Should the firm purchase the new machine?
    -Select-YesNoItem 22

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

Answer :

(a.) Calculation of Initial Net Cash Flow of the project

Initial Cash Flow = Purchase Price of New Machine - Sale Value of Old Machine - Tax on Sale of Old Machine

Tax on Sale of Old Machine = (Book Value - Sale Value) * Tax Rate

= (575,000 - 235000) * 35%

= 119000

Initial Cash Flow = Purchase Price of New Machine - Sale Value of Old Machine - Tax on Sale of Old Machine

= 1,200,000 - 235,000 - 119000

= -846000

(b.) Calculation of Change in Depreciation

Year Depreaciation New (Initial Cost * MACRS Rate) Deprecaition on Old Change in Depreacition
1 240000 115000 125000
2 384000 115000 269000
3 228000 115000 113000
4 144000 115000 29000
5 132000 115000 17000

(c.) Calculation of Incremental Cash Flows :

Below is the Table showing Incremental Cash Flows

Year After Tax Cash Flow [Annual saving * (1 - Tax Rate) Change in Depreacition * Tax Rate Incremental Cash Flow
1 156000 43750 199750
2 156000 94150 250150
3 156000 39550 195550
4 156000 10150 166150
5 156000 5950 161950+106450 = 268400

After Tax Salvage Value = Salvage Value - Tax on Gain on Sale

Tax on Gain Sale of New Machine = ( Sale Value - Book Value ) * Tax Rate

= [ 125000 - (1200000 * 6%) ] * 35%

= 18550

After Tax Salvage Value = 125000 - 18550

= 106450

(d.) Below is the table showing Net Present value :

Year Cash Inflows PVF @ 12% Present Value of Cash Inflow
1 199700 0.892857143 178303.5714
2 250150 0.797193878 199418.0485
3 195550 0.711780248 139188.6275
4 166150 0.635518078 105591.3287
5 268400 0.567426856 152297.3681
       
  Total Present Value of Cash Outflows   774799
       
  Add: Present Value of Cash Inflow   846000
       
  Net present Value   -71201

No not to purchase as Net Present Value is negative.