Excel please! A heavy duty construction equipment costing Php 500,000 has an estimated life of 25 years with a book value of Php 100,000 at the end of the period.Compute its book value after 24 years using straight-line method.O Php 116,000.00O Php 118,000.00Php 119,000.00Php 117,000.00

Depreciation is the wear and tear of asset during its useful life Depreciation under straight-line…

Answered: straight-line method.

Business

Accounting

straight-line method.

College Accounting, Chapters 1-27

23rd Edition

ISBN:9781337794756

Author:HEINTZ, James A.

Publisher:HEINTZ, James A.

Chapter18: Accounting For Long-term Assets

Section: Chapter Questions

Problem 3CE: A machine costing 350,000 has a salvage value of 15,000 and an estimated life of three years....

See similar textbooks

Similar questions

A machine costing 350,000 has a salvage value of 15,000 and an estimated life of three years. Prepare depreciation schedules reporting the depreciation expense, accumulated depreciation, and book value of the machine for each year under the double-declining-balance and sum-of-the-years-digits methods. For the double-declining-balance method, round the depreciation rate to two decimal places.
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.
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?
An equipment has a first cost of 500,000 PHP and the cost of installation is 30,000 PHP. At the end of its economic life of 35,000 operating hours, the salvage value is 10% of the equipment cost. Determine its book value at the end of the third year if its annual usage is 5,400 hours.
A machine has a first cost of Php 13,000.,an estimate life of 15 years, and anestimated salvage value of Php 1,000. Using SLM, find a) the annualdepreciation charged. b) the annual depreciation rate expressed aspercentage of the first cost c) the book value at the end of 9 years.
A lathe machine cost P300,000 with a salvage value of P15,000 is expected to last for 285000 hours in a period of 5 years. In the first year of service it was used for 8000 hours. Compute the book value of the machine at the end of the first year.
A machine costs Php 2,000,000. It has a salvage value of Php 500,000 at the end of itseconomic life. Using the Sum of the Years Digit Method, the book value at the end of two yearsis Php 800,000. What is the machine's economic life in years?
A milling machine has an initial cost is Php 370,000 and a service life of 10 years. Determine the book value for the first 5 years using (a) straight-line method, (b) decline balance method, and (c) SYDM. Tabulate the result for each method
The first cost of a machine is Php 1,800,000 with a salvage value of Php 400,000 at the endof its life of five years. Determine the depreciation after three years using Constant-PercentageMethod.
Mang Juan purchased an equipment for its manufacturing plant that costs PhP 3,750,000 + 10,000(x). It is estimated to have a useful life of 20 years; scrap value of PhP 375,000, production of 12,345,678 + 15,000(x) units and working hours of 100,000 + 1,500(x) hours. The company uses the equipment for 7,884 hours and produced 876,543 units on the first year and 7,883 hours and produced 987,654 units on thesecond year. Solve for the following: x=09 Sum of Years Digit Method -book value at the end of the 2nd year
An equipment costing P3, 015, 000 has an estimated life of 12 years with a salvage value of P200, 000 at the end of the period. Compute the book value at the end of 7 years using sum of the year’s digit method. Select one: a. C7=P 743,346.15 b. C7=P 741,346.15 c. C7=P 742,346.15 d. C7=P 744,346.15
Bulldozer cost P12 Million and the cost of installation labor, taxes and miscellaneous expenses is P500,000.00. If the salvage value is 10% of the cost of equipment at the end of its life of 20 years, compute the book value at the end of third year using MACRS Method.