Using a spreadsheet, compute the book values of a $12,000 asset over a seven-year life, with declining balance depreciation (d = 0.25). Also, compute the book valuof the $12,000 asset using straight-line depreciation, with a scrap value of $5,000 after seven years.Determine the book values.(Round to the nearest dollar as needed.)YearBook ValueBook ValueDeclining BalanceStraight Line2$1$$43$4$4$52$$4$47$Do

Name: Using a spreadsheet, compute the book values of a $12,000 asset over
Uploaded: 2024-03-05T11:50:36.000Z
Channel: Bartleby
Description: Using a spreadsheet, compute the book values of a $12,000 asset over a seven-year life, with declining balance depreciation (d = 0.25). Also, compute the book valuof the $12,000 asset using straight-line depreciation, with a scrap value of $5,000 af

Calculation of Depreciation as decline balance method Year Opening Balance ($) Rate Depreciation…

Business

Accounting

of the $12,000 asset using straight-line depreciation, with a Determine the book values. (Round to the nearest dollar as needed.) Year Book Value Book Value Declining Balance Straight Line %$4 1 $4 $4 3 %24 4. 6 %$4 %$4 7. $ %24 %24 %24 %24 %24 %24 %24 %24 %24 %24 %24 %24 %24 %24 2)

of the $12,000 asset using straight-line depreciation, with a Determine the book values. (Round to the nearest dollar as needed.) Year Book Value Book Value Declining Balance Straight Line %$4 1 $4 $4 3 %24 4. 6 %$4 %$4 7. $ %24 %24 %24 %24 %24 %24 %24 %24 %24 %24 %24 %24 %24 %24 2)

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Given, Mo = Rp. 1,500,000,- i Depreciation = 5% i Interest = 8% Calculate the amount of depreciation expense and interest at the end of year 3 based on Purchase Amount
SUM OF THE YEAR’S DIGIT METHOD A structure costs P12,000 new. It is estimated to have a new life of 5 years with a salvage value at the end of life of P1,000. Determine the book value at the end of each year of life. Year Initial Book Value Depreciation Book Value 1 12, 000 2
Book value Find the book value for the asset shown in the accompanying table, assuming that MACRS depreciation is being used E Recovery period (years) Elapsed time since purchase (years) Asset Installed cost A $987,000 2 The remaining book value is $ . (Round to the nearest dollar.) Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Rounded Depreciation Percentages by Recovery Year Using MACRS for First Four Property Classes Percentage by recovery year* 5 years Recovery year 3 years 7 years 10 years 1 33% 20% 14% 10% 45% 32% 25% 18% 15% 19% 18% 14% 7% 12% 12% 12% 12% 9% 9% 5% 9% 8% 9% 7% 4% 6% 6% 10 6% 11 4% Totals 100% 100% 100% 100% *These percentages have been rounded to the nearest whole percent to simplify calculations while retaining realism. To calculate the actual depreciation for tax purposes, be sure to apply the actual unrounded percentages or directly apply double-declining balance (200%)…
Requirement 1. For each depreciation method, prepare a depreciation schedule showing asset cost, depreciation expense, accumulated depreciation, and asset book value for each year of the asset's life. For the units of production method, round depreciation per unit to three decimal places. Before completing the straight-line depreciation schedule, calculate the straight-line depreciation rate. One year Useful life (SL) Depreciation rate - X 1 More Info - X Requirements Complete the Straight-Line Depreciation Schedule. Begin by filling out the schedule through 2019, and then complete the schedule by entering the amounts through 2022. On January 4, 2018, Bailey Enterprises, Inc., paid $205,600 for equipment used in manufacturing automotive supplies. In addition to the basic purchase price, the company paid $1,000 for transportation charges, $100 for insurance for the equipment while in transit, $10,500 sales tax, and $2,800 for a special which to place the equipment in the plant.…
A depreciable property costing P2,600,000 with original scrap value of P200,000 after 15 years, had been appraised at P4,000,000 with scrap of P40,000. The age of the asset is 4 years and the condition percent is 80. What is the annual depreciation subsequent to revaluation? 198,000 O 120,000 O211,200 128,000
A certain factory has a first cost of P163,000,000 with a salvage value of P163,000 at the end of its 25-year life. Solve for its book value on the 15th year using a. Straight Line Method b. Sinking Fund Method @ i = 10% c. Declining Balance Method d. Double Declining Balance Method e. Sum of the Years Digit Method
a.Determine the capitalized cost of the new machine b. Compute annual depreciation, accumulated depreciation, and the machine’s book value for the first three years assuming i. Straight-line depreciation ii. Double-declining-balance method c. Assume the machine is sold for $9,000 at the end of the third year after depreciation has been calculated. Determine the gain or loss assuming -Straight-line depreciation -Double-declining-balance method d. Given your answer in part c, if Mulligan was able to perfectly predict the future that the machine would be sold for $9,000 at the end of the third year, which depreciation method should Reddic choose? Ignore taxes.
D
Following information provided related to an Equipment: • Book value (beginning of the year) OMR 100,000 • Depreciation rate 45% Which of the following is the equipment's book value (end of the year) using written down value method? a. OMR 55,000 b. OMR 45,000 c. OMR 40,000 d. OMR 100,000
Quantities at which revenues and costs are equal. breakeven point inflection point knee point saturation point Amount of money available for capital investment projects capital budget cash flow capital recovery cost of capital Tax on the use of cars and buses on the road. toll tarif VAT green tax capital recovery cost of capital Interest rate paid for the use of capital funds. depreciation rate first cost cost of capital inflation rate It is an extreme form of inferior good. It arises ecause the income effect is opposite to and outweighs the substitution effect. giffen good merit good disguised good kability Number of years at which the annual worth of costs is at minimum. payback period life-cycle economic service life net present value
A $48,000 asset was purchased and classified as a Class 10 asset for CCA purposes. If the CCA rate is 30%, calculate UCC for the end of year 3. Select one: a. $15,800 b. $18,300 c. $19,992 d. $17,400 e. $16,660 ???
Assignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false ☆ O 1 * Updat A machine costing $58,228 with a 4-year life and $52,607 depreciable cost was purchased January 1. Compute the yearly depreciation expense using straight- line depreciation. Round your answer to the nearest whole dollar. per year Previous Next %24