Question

In: Accounting

Your firm bought a new sanding machine for its factory floor two years ago for $40,000....

Your firm bought a new sanding machine for its factory floor two years ago for $40,000. The current market value (Year 0) of the machine is $10,000 and you believe that it will last 5 more years (Years 1 - 5). When you're done with the machine, you can sell it for scrap and receive $1,000. However, your firm is now considering buying a more advanced sander for $80,000. The more advanced machine also last 5 more years. The new machine will have a salvage value of $5,000. The more advanced sander will increase revenues by $50,000 a year and save the company $10,000 in labor costs each year when compared to the old machine. The appropriate discount rate for this project is 12% and the company's tax rate is 35%. Use straight-line depreciation (including the appropriate salvage values).

What is the NPV of replacing the old machine? Be sure you take into account the sale of the old machine (including the tax consequences of the sale) in Year 0. This problem is really all about carefully calculating the cash flows associated with this decision each year. Build a mini-income statement for each year and then take that income and turn it into free cash flow by taking into account depreciation.

NB: Show excel working formula,p please

Solutions

Expert Solution

Old Machine
Year 0 40000 Depreciation
Year 1 32000 8000
Yaer 2 24000 8000
Year 3 24000 In The Beginning of the Year
Here Considered Zero Salvage value for Depreciation Purpose i.e 40000 - 0 / 5= 8000
Loss on Sale of Old Machine 24000 - 10000 = 14000
Current Market Value 10000
Here Loss is 14000, If this loss is not taken it means we have to pay tax on 14000 X 35% = 4900 due to this loss 4900 will be Cash Inflow
At Year 3 Proposal for Buying New Machine
Year 0 ( Year 3) 80000 Cash Outflow
Life will be 5 Years
Depreciation 80000 - 5000 / = 15000
Analyisis of Cash Inflows
Year 0( Sale of Old Machine) - - - 10000 3500 6500 1 6500
Year 0 ( Saving on Loss of Sale of Old Machine) - - - -14000 -4900 4900 1 4900
Incremental Revenue Savings in Labour Cost Depreciation Net Cash Inflows Tax Rate @ 35% Net Inflow After TA x PV @ 12 %
Year 1 50000 10000 15000 45000 15750 44250 0.8929 39509
Year 2 50000 10000 15000 45000 15750 44250 0.7972 35276
Year 3 50000 10000 15000 45000 15750 44250 0.7118 31496
Year 4 50000 10000 15000 45000 15750 44250 0.6355 28122
Year 5 50000 10000 15000 45000 15750 44250 0.5674 25109
Year 5 ( Salvage) - - - 5000 1750 3250 0.5674 1844
PV Value of Cash Inflows 172755
Cash Ouflows -80000
Net Present Value 92755
Here instead of Presenting Income Statemnet , Refere the table to Understand the Cash inflows.
Income Sttament ( Just for Understanding )
Year 0 Recepts on Sale Of Old 10000
Loss on Sale -14000
Year 1-4
Incremental Revneus 50000

Related Solutions

Your firm bought a new sanding machine for its factory floor two years ago for $40,000....
Your firm bought a new sanding machine for its factory floor two years ago for $40,000. The current market value (Year 0) of the machine is $10,000 and you believe that it will last 5 more years (Years 1 - 5). When you're done with the machine, you can sell it for scrap and receive $1,000. However, your firm is now considering buying a more advanced sander for $80,000. The more advanced machine also last 5 more years. The new...
A machine currently in use was originally purchased 2 years ago for $40,000.The machine is being...
A machine currently in use was originally purchased 2 years ago for $40,000.The machine is being depreciated under MACRS using a 5-year recovery period;it has 3 years of usable life remaining. The current machine can be sold today to net $42,000 after removal and cleanup costs.A new machine,using a 3-year MACRS recovery period,can be purchased at a price of $140,000. It requires $10,000 to install and has a 3-year usable life.If the new machine were acquired, the investment in accounts...
In a PCB factory, a plating line was bought 6 years ago for $300,040. Since it...
In a PCB factory, a plating line was bought 6 years ago for $300,040. Since it caught fire last night, its life span is much shortened and remains for only 1 more year from now. There would be no salvage value. (Round off your final answers to 2 decimal places) Since the fire suddenly shortened the life span of the plating line, the engineer wants to migrate the risk by subscribing a special Refitting Service Plan so that the life...
Two years ago, you bought 1,000 units of a new mutual fund at a price of...
Two years ago, you bought 1,000 units of a new mutual fund at a price of $10 each. To start, the fund raised a total of $100 million; it has an MER of 2.5%. In the first year, the fund manager made $12 million in gross investment income for the fund. At the start of year 2, investors bought another 1 million units and the current NAV. During the second year, the portfolio manager made a total of $14 million...
A company is considering replacing a machine that was bought six years ago for $50,000.
A company is considering replacing a machine that was bought six years ago for $50,000. The machine, however, can be repaired and its life extended by five more years. If the current machine is replaced, the new machine will cost $44,000 and will reduce the operating expenses by $6,000 per year. The seller of the new machine has offered a trade-in allowance of $15,000 for the old machine. If MARR is 12% per year before taxes, how much can the...
A company is considering replacing a machine that was bought five years ago for ​$45,000. The​...
A company is considering replacing a machine that was bought five years ago for ​$45,000. The​ machine, however, can be repaired and its life extended four more years. If the current machine is​ replaced, the new machine will cost ​$44,000 and will reduce the operating expenses by ​$5,200 per year. The seller of the new machine has offered a​ trade-in allowance of $14,700 for the old machine. If MARR is 8​% per year before​ taxes, how much can the company...
A man bought a machine for P66,463 six years ago. It has a salvage value of...
A man bought a machine for P66,463 six years ago. It has a salvage value of P11,373 four years from now. He sold it now for P12,930. What is the sunk cost or the value of the machine that the man lost if the depreciation method used is a Straight-Line method?
A new furnace for your small factory will cost $40,000 to install and will require ongoing...
A new furnace for your small factory will cost $40,000 to install and will require ongoing maintenance expenditures of $2,800 a year. But it is far more fuel efficient than your old furnace and will reduce your consumption of heating oil by 3,700 gallons per year. Heating oil this year will cost $3 a gallon; the price per gallon is expected to increase by $.50 a year for the next 3 years and then to stabilize for the foreseeable future....
Milan Clothing Co. bought a machine for $40,000 on January 1, 2020. The machine has a...
Milan Clothing Co. bought a machine for $40,000 on January 1, 2020. The machine has a useful life of 4 years, and a residual value of $3,000. Part A Assume that Milan Clothing Co. uses the double-declining balance method for depreciation. Calculate depreciation expense for Year 1 and Year 2 of the machine’s useful life. Please show your calculations (i.e., each piece and the total). Part B . Assume that this part is unrelated to Part A. That is, forget...
1. You bought your house 5 years ago, and your original home value when you bought...
1. You bought your house 5 years ago, and your original home value when you bought it was $450,000, you paid 20% down and you financed closing costs equal to 4% of the mortgage amount. The mortgage was a 30-year fixed rate mortgage with a 6.5% annual interest rate. Rates on 30-year mortgages are now at 5% if you pay 2 points upfront. Your refinancing costs will be 2% of the new mortgage amount (excluding points). You won't finance the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT