Chapter 10 Lab- Students (1) Data Review View AutoSave ABE SU Home Insert Draw Page Layout Formulas X Cut Calibri (Body) 14 A Paste Format BIVE A A1 x fx CHAPTER 10 - LAB QUESTION 1 LL A = = = I General Copy 29 Wrap Text Merge & Center $ % V % 8 99 Conditional Format Formatting as Table el Styles CHAPTER 10 - LAB QUESTION 1 On January 1, 2018, Major Company pays a lump sum amount of $2,000,000 for Land, Building 1, Building 2 and Land improvements 1. Building 1 has no value and will be demolished. Building 2 will be an office and is appraised at $1,440,000 with a useful life of 20 years and a salvage value of $200,000. Land improvements 1 is appraised at $240,000 with a useful life of 5 years and a salvage value of $40,000. The Land is appraised for $720,000. Major Company also incurs the following additional costs Cost to Demolish Building 1 Cost of Additional Land Grading Cost to Construct Building 3 Cost to Construct Land Improvements 2 $ 200,000 $ 60,000 $ 2,150,000 (useful life of 25 years and $150,000 salvage) $ 90,000 (useful life of 6 years and no salvage) 1. Prepare a table with the following column headings: Land, Building 1, Building 2, Building 3, Land improvements 1 and Laand improvements 2. Allocate the costs incurred by Major to the appropriate columns and total each column (Lab 1 Solution Tab). 12. Prepare a single journal entry to record all of the incurred costs assuming they are paid on January 1, 2018 (Lab 1 Solution Tab). 13. Using the straight-line method, prepare the December 31, 2018 adjusting entries to record the depreciation expense for the first year the assets were in use (Lab 1 Solution Tab). M27 : X fx Merge & Center $ % 9 Condition formato APPRAISED N OF TOTAL APPORTIONED COST ALLOCATION OF PURCHASE PRICE (*) Land Building 1 Building 2 Land improvements 1 LAND BUILDING 1 BUILDING BUILDING 2 BUILDING LAND LAND IMPROVEMENTS 1 IMPROVEMENTS 2 10 Purchase Price (") 11 Demolition 12 Land Grading Construction - Building 3 Construction. Land Imp 2 - DATE - - - AutoSaver BEJ Chapter 10 Lab-Students (1) Home Insert Draw Page Layout Formulas Data Review View out Calibr (Body 11 A A = = P 29 Wrap Text Coy General $ % 9 Merge & Center 2 Tables 0119 X fx CHAPTER 10 - LAB QUESTION 2 A machine costing $600,000 with a four year life and an estimated salvage value of $40,000 is installed in Porter Company's factory on January 1. The factory manager estimates the machine will produce 500,000 units of product during its life. It actually produces the following units: Year 1.240,000 units Year 2.125,000 units Year 3-120,000 units and Year 4 - 25,000 units. The total number of units produced by the end of Year 4 exceeds the original estimate the difference was not predicted the machine cannot be deprecated below its salvage value. Populate the depreciation tables (Lab 2 Solution Tab) based on (A) Straight Line Method; (B) Units of Production Method; (C) Double Declining Balance Method View AutoSave BESH = Home Insert Draw Page Layout X Cut Calibri (Body) Paste Format B TU x x L Formulas Data Review 14 AA EE C A E os copy ~ 29 Wrap Merge F29 BEGINNING BOOK VALUE STRAIGHT LINE ACCUMULATED DEPRECIATION DEPRECIATION YEAR ENDING BOOK VALUE UNITS OF PRODUCTION ACCUMULATED DEPRECIATION DEPRECIATION BEGINNING BOOK VALUE YEAR ENDING BOOK VALUE BEGINNING YEARBOOK VALUE DOUBLE DECLINING BALANCE ACCUMULATED DEPRECIATION DEPRECIATION ENDING BOOK VALUE