ScramCo has purchased an instrument to measure tolerances in its production of jet engines. The instrument cost $30,000 and the installation costs were $3,000. The operating and maintenance costs for the first year are $2000 and they increase by $2000 every year. Use Excel to find the economic life of the instrument. Depreciation is 20% annually and the MARR is 8%.

ScramCo has purchased an instrument to measure tolerances in its production of jet engines. The instrument cost $30,000 and the installation costs were $3,000. The operating and maintenance costs for the first year are $2000 and they increase by $2000 every year. Use Excel to find the economic life of the instrument. Depreciation is 20% annually and the MARR is 8%.

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter9: Capital Budgeting And Cash Flow Analysis

Section: Chapter Questions

Problem 2P

See similar textbooks

Similar questions

Utica Machinery Company purchases an asset for 1,200,000. After the machine has been used for 25,000 hours, the company expects to sell the asset for 150,000. What is the depreciation rate per hour based on activity?
The Scampini Supplies Company recently purchased a new delivery truck. The new truck cost $22,500, and it is expected to generate net after-tax operating cash flows, including depreciation, of $6,250 per year. The truck has a 5-year expected life. The expected salvage values after tax adjustments for the truck are given here. The company’s cost of capital is 10%. Should the firm operate the truck until the end of its 5-year physical life? If not, then what is its optimal economic life? Would the introduction of salvage values, in addition to operating cash flows, ever reduce the expected NPV and/or IRR of a project?
Dunedin Drilling Company recently acquired a new machine at a cost of 350,000. The machine has an estimated useful life of four years or 100,000 hours, and a salvage value of 30,000. This machine will be used 30,000 hours during Year 1, 20,000 hours in Year 2, 40,000 hours in Year 3, and 10,000 hours in Year 4. With DEPREC5 still on the screen, click the Chart sheet tab. This chart shows the accumulated depreciation under all three depreciation methods. Identify below the depreciation method that each represents. Series 1 _____________________ Series 2 _____________________ Series 3 _____________________ When the assignment is complete, close the file without saving it again. Worksheet. The problem thus far has assumed that assets are depreciated a full year in the year acquired. Normally, depreciation begins in the month acquired. For example, an asset acquired at the beginning of April is depreciated for only nine months in the year of acquisition. Modify the DEPREC2 worksheet to include the month of acquisition as an additional item of input. To demonstrate proper handling of this factor on the depreciation schedule, modify the formulas for the first two years. Some of the formulas may not actually need to be revised. Do not modify the formulas for Years 3 through 8 and ignore the numbers shown in those years. Some will be incorrect as will be some of the totals. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as DEPRECT. Hint: Insert the month in row 6 of the Data Section specifying the month by a number (e.g., April is the fourth month of the year). Redo the formulas for Years 1 and 2. For the units of production method, assume no change in the estimated hours for both years. Chart. Using the DEPREC5 file, prepare a line chart or XY chart that plots annual depreciation expense under all three depreciation methods. No Chart Data Table is needed; use the range B29 to E36 on the worksheet as a basis for preparing the chart if you prepare an XY chart. Use C29 to E36 if you prepare a line chart. Enter your name somewhere on the chart. Save the file again as DEPREC5. Print the chart.
Urquhart Global purchases a building to house its administrative offices for $500,000. The best estimate of the salvage value at the time of purchase was $45,000, and it is expected to be used for forty years. Urquhart uses the straight-line depreciation method for all buildings. After ten years of recording depreciation, Urquhart determines that the building will be useful for a total of fifty years instead of forty. Calculate annual depreciation expense for the first ten years. Determine the depreciation expense for the final forty years of the assets life, and create the journal entry for year eleven.
Filkins Fabric Company is considering the replacement of its old, fully depreciated knitting machine. Two new models are available: Machine 190-3, which has a cost of $190,000, a 3-year expected life, and after-tax cash flows (labor savings and depreciation) of $87,000 per year; and Machine 360-6, which has a cost of $360,000, a 6-year life, and after-tax cash flows of $98,300 per year. Knitting machine prices are not expected to rise because inflation will be offset by cheaper components (microprocessors) used in the machines. Assume that Filkins’ cost of capital is 14%. Should the firm replace its old knitting machine? If so, which new machine should it use? By how much would the value of the company increase if it accepted the better machine? What is the equivalent annual annuity for each machine?
Montello Inc. purchases a delivery truck for $25,000. The truck has a salvage value of $6,000 and is expected to be driven for 125,000 miles. Montello uses the units-of-production depreciation method, and in year one the company expects the truck to be driven for 26,000 miles; in year two, 30,000 miles; and in year three, 40,000 miles. Consider how the purchase of the truck will impact Montellos depreciation expense each year and what the trucks book value will be each year after depreciation expense is recorded.
Alfredo Company purchased a new 3-D printer for $900,000. Although this printer is expected to last for ten years, Alfredo knows the technology will become old quickly, and so they plan to replace this printer in three years. At that point, Alfredo believes it will be able to sell the printer for $15,000. Calculate yearly depreciation using the double-declining-balance method.
Gimli Miners recently purchased the rights to a diamond mine. It is estimated that there are one million tons of ore within the mine. Gimli paid $23,100,000 for the rights and expects to harvest the ore over the next ten years. The following is the expected extraction for the next five years. Year 1: 50,000 tons Year 2: 90,000 tons Year 3: 100,000 tons Year 4: 110,000 tons Year 5: 130,000 tons Calculate the depletion expense for the next five years, and create the journal entry for year one.
Montezuma Inc. purchases a delivery truck for $15,000. The truck has a salvage value of $3,000 and is expected to be driven for eight years. Montezuma uses the straight-line depreciation method. Calculate the annual depreciation expense. After three years of recording depreciation, Montezuma determines that the delivery truck will only be useful for another three years and that the salvage value will increase to $4,000. Determine the depreciation expense for the final three years of the assets life, and create the journal entry for year four.
Colquhoun International purchases a warehouse for $300,000. The best estimate of the salvage value at the time of purchase was $15,000, and it is expected to be used for twenty-five years. Colquhoun uses the straight-line depreciation method for all warehouse buildings. After four years of recording depreciation, Colquhoun determines that the warehouse will be useful for only another fifteen years. Calculate annual depreciation expense for the first four years. Determine the depreciation expense for the final fifteen years of the assets life, and create the journal entry for year five.
During the current year, Arkells Inc. made the following expenditures relating to plant machinery. Renovated five machines for $100,000 to improve efficiency in production of their remaining useful life of five years Low-cost repairs throughout the year totaled $70,000 Replaced a broken gear on a machine for $10,000 A. What amount should be expensed during the period? B. What amount should be capitalized during the period?
During the current year, Arkells Inc. made the following expenditures relating to plant machinery. Renovated seven machines for $250,000 to improve efficiency in production of their remaining useful life of eight years Low-cost repairs throughout the year totaled $79,000 Replaced a broken gear on a machine for $6,000 A. What amount should be expensed during the period? B. What amount should be capitalized during the period?