The requirement is finish the excel

IS Support Next Journalize the purchase of the truck, the first year's depreciation expense, and the disposal of the truck. (including explanations) Here's the data: Purchased on January 1, 2012 for $13,000. Has an estimated residual value of $1,000. Useful life of 5 years or 100,000 miles. Sold on December 31st, 2013 Be sure to rename your file: Lname, Fname Barb's.xls Verify your print format is Portrait, half inch margins and one page. 42714 Type here to search DELL FO F10 S > 2 5 6 7 8 9 a W E R T Y P . A S D F G H Z C V B Z M Alt Alt Ctrl modas Pictures Enable Editing H B 1 10d Depr Scheds Barb's Florists Solution with thru Disposal and Taccounts XX 2 Watch all Video's provided. They are a demonstration of Joe's Delivery which is similar to this assignment. Verify your print format is Portrait, half inch margins and one page. Be sure to rename your file: Lname, Fname Barb's.xls 4 Total points Straightline Table DOB Table Name: Units Table Depreciation Schedules Barb's Florists 5 6 7 Cost $13.000 8 Expected salvage value $ 1.000 9 Estimated useful life in years 10 Estimated useful life in miles 100,000 Purchased new truck Jan 1, 2012 Sold Dec 31, 2013 for $7,500 JE'S T Accounts Late/Misc Complete A, B, C, D 7.5 minutes 11 12 Intro thru SL Depr 8 min >> 13 A. Prepare the straight line depreciation table. 14 Straight line Year Depr Deprec Exp 16 Purchase 17 C: Journalire Purchase and DDE General Journal Date Account JE Purchase for cash: Deprec 15 Book Value Notes/calculations Truck Date of Purchase Life years Down Cost Salvage Value The C 18 19 Depr Schl's, JEST's Sheets O Type here to search DELL VO $ O ! 5 6 7 2 3 Y T R a W E D E G H 11 Complete A, B, C, D 7.5 minutes 12 Intro thru SL Depr 8 min >> 13 A. Prepare the straight line depreciation table. 14 Straight-line 15 Year Depr% Deprec Exp 16 Purchase C: Journalize Purchase and DDE General Journal Date Account JE Purchase for cash: Deprec Book Value 17 Notes/calculations Truck Dale of Purchase Life Depreciation Rate Cost Salvage Value Depreciable Col 1st year #Months Date of Disposal Sales Price (cashi 18 19 20 JE Depreciate Asset (Obl Declin 21 22 Truck Date of Purchase JE Dispose Asset (DOB Depr) De 23 24 B. Double-Declining 5 Min >> S Prepare the double-declining balance depreciation table. 26 Accum 07 Year Depr Deprec Exp Deprec Purchase Depr Sch', JEST's Sheets Book Valve Cost O Type here to search DELL 1 % S 4 6 7 3 2 1 P 1 Y R E W a Tab F G H S D A Caps Lock N M ad G H K . 5 Min >> .. Double-Declining Prepare the double-declining balance depreciation table. Truck Dale of Purchase Life years JE Dispose Asset (DDB Depr) De Year Purchase D. Post 'T' Accounts: based on Cash Beginning 75000 Accum Depr% Deprec Exp Deprec Book Value Depreciation Rate Cost 0 Salvage Value 31 Depreciate Cou 1st year #Months 32 Date of Disposal 33 Sales Price (cash) 34 35 36 37 38 C. Units of Activity 4 Min >> 19 Actual usage of the machine was as follows: Yr 1: 12000, Yr 2: 18000 Yr 3: 21000 Yr 4: 14000 Yr 5. 60000 Truck 10 Prepare the Units of Activity depreciation Schedule Accum Date of Purchase Book Value Deprec 11 Year Actual Miles Deprec Exp > Dichnen Depr Schi's. EST's Sheet Truck Type here to search DELL FE F2 A 6 B $ 7 5 3 2 1 Y R. E W a JK * LUO Tab H G D F Truck Accum Deprecat B D 37 G H 38 C. Units of Activity 4 Min >> 39 Actual usage of the machine was as follows: Yr 1: 12000, Yr 2: 18000 Yr 3: 21000 Yr 4: 14000 Yr 5: 60000 40 Prepare the Units of Activity depreciation Schedule Truck Accum 41 Year Actual Miles Deprec Exp Deprec Book Value Date of Purchase 42 Purchase 43 Deprecate Rates Cost 45 Salvage Value 46 The Cost Estimated units 47 Suit de ate AB 449 1st year Months Date of Disposal 50 Sales Price (coshi 51 52 33 44 Deprecap Depesch, JETS Sheet O Type here to search DELL 1 B $ 4 5 5 P 3 O 2 1 T Y R W E Tab G H D F A S Caps Lock N M