A business needs to purchase packaging equipment that will provide revenue of $120,000 per year for 10 years; operating costs are $40,000 per year for 10 years. The equipment costs $220,000, has an estimated useful life of 10 years, and has a salvage value of $20,000 at the end of that period. It is depreciated using the sum-of-the-years-digits method. The company pays income tax at a rate of 30%, VAT of 16% and MARR of 10%. To acquire the equipment, a loan of $70,000 is requested at a rate of 12.5% annual interest, which must be repaid in six years through equal fixed payments (Rents) each year-end, the first one a year after the purchase. Determine the NPV, IRR, EAC, COST/BENNEFIT. *Please show procedure in Excel*

A business needs to purchase packaging equipment that will provide revenue of $120,000 per year for 10 years; operating costs are $40,000 per year for 10 years. The equipment costs $220,000, has an estimated useful life of 10 years, and has a salvage value of $20,000 at the end of that period. It is depreciated using the sum-of-the-years-digits method. The company pays income tax at a rate of 30%, VAT of 16% and MARR of 10%. To acquire the equipment, a loan of $70,000 is requested at a rate of 12.5% annual interest, which must be repaid in six years through equal fixed payments (Rents) each year-end, the first one a year after the purchase. Determine the NPV, IRR, EAC, COST/BENNEFIT. Please show procedure in Excel

Managerial Economics: Applications, Strategies and Tactics (MindTap Course List)

14th Edition

ISBN:9781305506381

Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris

Publisher:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris

Chapter17: Long-term Investment Analysis

Section: Chapter Questions

Problem 2E

See similar textbooks

Similar questions

Madison Manufacturing is considering a new machine that costs $350,000 and would reduce pre-tax manufacturing costs by $110,000 annually. Madison would use the 3-year MACRS method to depreciate the machine, and management thinks the machine would have a value of $33,000 at the end of its 5-year operating life. The applicable depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%. Working capital would increase by $35,000 initially, but it would be recovered at the end of the project's 5-year life. Madison's marginal tax rate is 25%, and a 10% cost of capital is appropriate for the project. 1. Calculate the project's NPV, IRR, MIRR, and payback. 2. Assume management is unsure about the $110,000 cost savings this figure could deviate by as much as plus or minus 20%. What would the NPV be under each of these extremes? 3. Suppose the CFO wants you to do a scenario analysis with different values for the cost savings, the machine's salvage value, and the working capital (WC) requirement.…
Wildhorse Company purchased a computer for $9,440 on January 1, 2019. Straight-line depreciation is used, based on a 5-year life and a $1,180 salvage value. On January 1, 2021, the estimates are revised. Wildhorse now feels the computer will be used until December 31, 2022, when it can be sold for $590. Compute the 2021 depreciation. (Round answer to 0 decimal places, eg. 45,892) Depreciation expense, 2021 $
The Dauten Toy Corporation uses an injection molding machine that was purchased prior to the new tax legislation. This machine is being depreciated on a straight-line basis, and it has 6 years of remaining life. Its current book value is $2,100, and it can be sold for $2,600 at this time. Thus, the annual depreciation expense is $2,100/6 = $350 per year. If the old machine is not replaced, it can be sold for $500 at the end of its useful life. Dauten is offered a replacement machine which has a cost of $9,000, an estimated useful life of 6 years, and an estimated salvage value of $800. The replacement machine is eligible for 100% bonus depreciation at the time of purchase. The replacement machine would permit an output expansion, so sales would rise by $800 per year; even so, the new machine's much greater efficiency would cause operating expenses to decline by $1,000 per year. The new machine would require that inventories be increased by $2,500, but accounts payable would…
What is the depreciation deduction, using 200% DB method, after year 4 for an asset that costs #67894 and has an estimated salvage value of $7,000 at the end of its 7-year useful life? Round your answer to 2 decimal places. Add your answer
Equipment costing $20,000 that is a MACRS 5-year property isdisposed of during the second year for $15,000. Calculate anydepreciation recapture, ordinary losses, or capital gains associatedwith disposal of the equipment.
The Dauten Toy Corporation currently uses an injection molding machine that was purchased prior to the new tax legislation. This machine is being depreciated on a straight-line basis, and it has 6 years of remaining life. Its current book value is $2,400, and it can be sold for $2,600 at this time. Thus, the annual depreciation expense is $2,400/6 = $400 per year. If the old machine is not replaced, it can be sold for $500 at the end of its useful life. Dauten is offered a replacement machine which has a cost of $8,000, an estimated useful life of 6 years, and an estimated salvage value of $800. The replacement machine is eligible for 100% bonus depreciation at the time of purchase. The replacement machine would permit an output expansion, so sales would rise by $800 per year; even so, the new machine's much greater efficiency would cause operating expenses to decline by $1,000 per year. The new machine would require that inventories be increased by $2,500, but accounts payable would…
The depreciation schedule for certain equipment has been arrived at by various methods. The estimated salvage value of the equipment at the end of its 7 year useful life is $700. Identify the resulting depreciation schedules. Year I II III IV 1 $1,329 $2,325 $2,857 $3,161 2 $1,329 $1,993 $2,041 $2,162 3 $1,329 $1,661 $1,458 $1,478 4 $1,329 $1,329 $1,041 $1,011 5 $1,329 $ 996 $ 744 $ 692 6 $1,329 $ 664 $ 531 $ 473 7 $1,329 $ 332 S 379 $ 323 Which scheme represents DB depreciation? Select one: II III IV I
Malu Luigi Company makes an internal policy that for every new machine purchased, the annual depreciation cost should not exceed 15% of the first cost and should cost nothing at the end of its life. Determine the service life of brand new P 500,000 machine using SOYD.
Solve correctly in excel Six years ago, a company purchased $30,000 of equipment. The equipment has just been sold for $5000. The equipment was depreciated using 50% bonus depreciation / 50% MACRS (using a 5-year recovery period). The actual savings due to the purchase of the equipment is shown below. The firm's MARR is 12% and it's tax rate is 25%. What is the after-tax present worth of the investment? Year 1 2 3 4 5 6 Savings 5000 6000 7000 7000 4000 3000
You're evaluating a new electron microscope for the QA (quality assurance) unit. The microscope will cost $22,000 to buy and another $2,000 to install, and will be sold for $1,800 after 3 years. It falls into the 3-year MACRS class, with depreciation rates as follows: Year 1 2 3 4 Depreciation rate 33% 45% 15% 7% The microscope will require an inventory of spare parts worth $5,000. The equipment will not increase revenue, but will save the company $13,000 in labor costs each year. Your company's marginal tax rate (federal plus state) is 34% and the appropriate cost of capital for this project is 16%. What is the initial (year-0) incremental cash flow? Choose the right sign. What is the incremental cash flow in year 1? What is the incremental cash flow in year 2? What is the net salvage value at the end of year 3? What is the incremental cash flow in year 3? What is the NPV of this project?
An SMP machine costs $500,000 and has a $50,000 salvage value after 10 years of use. Using straight-line depreciation, what are the depreciation charge and book value for the machine after year 5?
An income producing asset costs $50,706 and will be depreciated using Double Declining Balance with a $3,363 salvage value over 9 years. What is the Book Value in year 2?