AutoSave . Off MACRS Excel Exercise - Excel Jonah Rushing JR X File Home Insert Page Layout Formulas Data Review View Developer Help Search Share Comments Get Add-ins b ? de PivotTable Recommended Table Illustrations My Add-ins Recommended Maps PivotChart 3D Line Column Win/ Slicer Timeline Link Comment Text Symbols PivotTables Charts Map Loss Tables Add-ins Charts Tours Sparklines Filters Links Comments C18 X B C D F G H M N O Q 4 $179 GDS Date Recovery GDS Expense Remaining Remaining Recovery Recovery Luxury Auto Total Allowable Please insert any comments here you feel 5 Description Acquired Cost Period Convention Method Amount Basis Bonus Rate Bonus Deprn. Basis % Deduction MACRS Cap Deductions are needed to explain your approach. 6 Executive Vehicle (Audi A8) 5/6/2019 $ 92,004 92,004 92,004 Meat Slicers & Related Food Service (Used 7 Eqpt.) 2/24/2019 323,064 323,064 323,064 8 Walk-in Cooler & Related 6/20/2019 368,651 368,651 368,651 Furniture & Fixtures 7/26/2019 122,200 HY DDB 122,200 na na na 122,200 10 Computers & Peripherals 1/16/2019 48,238 5 HY DDB 48,238 na n/a na 48,238 11 Canned software - business applications 9/25/2019 34,500 34,500 34,500 Delivery/Cargo Trucks (3 - each GVW 12 9,500 lbs) 11/11/2019 173,700 173,700 173,700 13 Building Improvements - Expansion Costs 10/12/2019 526,296 526,296 526,296 14 15 Totals $ 1,688,653 $ 170,438 $1,518,215 $ $ 1,518,215 $ $ 170,438 16 Total Personal Property (after any $179) 17 Total Personal Property 4th Quarter (after any $179) 18 Fourth Quarter Ratio 19 21 22 23 24 25 Template + Ready - + 70% Type here to search O M X W 1:53 PM 3/31/2020