A B D E F G H Asset Category Number Land J K L Acquisition Date...

Transcribed Image Text:

A B D E F G H Asset Category Number Land J K L Acquisition Date Useful Life (Yrs) Cost Accumulated Depreciation to 12/31/Y5 Depreciation Expense Y6 Accumulated Depreciation to 12/31/Y6 Adjustments to 12/31/Y6 NBV 525,000.00 Description 1 acre 11th Line 05/31/Y4 401 Main Street 09/01/Y3 .5 acre 402 Main Street 09/01/Y3 355,000.00 225,183.20 1,105,183.20 Building 2015-01 401 Main Street 09/01/Y3 40 1,849,816.80 786,172.14 46,245.42 832,417.56 2015-09 410 Main Street 02/1/Y4 40 150,000.00 63,375.00 2016-09 406 Main Street 08/1/Y4 40 945,000.00 363,825.00 2,944,816.80 1,213,372.14 3,750.00 23,625.00 73,620.42 67,125.00 387,450.00 1,286,992.56 1,017,399.24 82,875.00 557,550.00 1,657,824.24 Equipment Y4-02 2013 Ford F150 Truck 02/01/Y4 Y4-03 2014 Dodge Ram Truck Y4-04 Toro lawn mower 03/31/Y4 06/30/Y4 66 12,500.00 10,069.44 15,600.00 10,833.33 4 2,300.00 1,437.50 2,083.33 2,600.00 575.00 12,152.78 13,433.33 347.22 2,166.67 2,012.50 287.50 Y4-05 2007 John Deere Excavator 09/01/Y4 12 Y4-06 2009 Cat Backhoe 09/01/Y4 12 Y4-07 2004 Case Tractor 10/01/Y4 12 Y4-08 3 wagons 10/01/Y4 Y5-10 2018 Chev Truck 03/01/Y5 Y5-11 2010 Toyota Tundra 05/31/Y5 Y5-12 2017 Kenworth 07/31/5 Y5-13 2015 Loader 08/01/Y5 12 Y5-14 1996 Grader 12/01/Y5 12 Y5-15 Flat-bed Trailer 12/01/Y5 12 222 4666222 25,000.00 4,861.11 2,083.33 6,944.44 18,055.56 12,300.00 2,391.67 1,025.00 3,416.67 8,883.33 9,800.00 1,837.50 816.67 2,654.17 7,145.83 3,000.00 1,687.50 750.00 2,437.50 562.50 35,600.00 10,877.78 5,933.33 16,811.11 18,788.89 18,750.00 4,947.92 3,125.00 8,072.92 10,677.08 225,500.00 53,243.06 37,583.33 90,826.39 134,673.61 18,165.00 2,144.48 1,513.75 3,658.23 14,506.77 7,200.00 12,300.00 398,015.00 650.00 1,110.42 106,091.70 600.00 1,025.00 59,713.75 1,250.00 5,950.00 2,135.42 10,164.58 165,805.45 232,209.55 Right of Use Asset Leased Machine TOTAL PV $ 4,448,015.00 $ 1,319,463.84 $ 133,334.17 $ 1,452,798.01 $ $ 1,890,033.79 A B D E F G H Asset Category Number Land J K L Acquisition Date Useful Life (Yrs) Cost Accumulated Depreciation to 12/31/Y5 Depreciation Expense Y6 Accumulated Depreciation to 12/31/Y6 Adjustments to 12/31/Y6 NBV 525,000.00 Description 1 acre 11th Line 05/31/Y4 401 Main Street 09/01/Y3 .5 acre 402 Main Street 09/01/Y3 355,000.00 225,183.20 1,105,183.20 Building 2015-01 401 Main Street 09/01/Y3 40 1,849,816.80 786,172.14 46,245.42 832,417.56 2015-09 410 Main Street 02/1/Y4 40 150,000.00 63,375.00 2016-09 406 Main Street 08/1/Y4 40 945,000.00 363,825.00 2,944,816.80 1,213,372.14 3,750.00 23,625.00 73,620.42 67,125.00 387,450.00 1,286,992.56 1,017,399.24 82,875.00 557,550.00 1,657,824.24 Equipment Y4-02 2013 Ford F150 Truck 02/01/Y4 Y4-03 2014 Dodge Ram Truck Y4-04 Toro lawn mower 03/31/Y4 06/30/Y4 66 12,500.00 10,069.44 15,600.00 10,833.33 4 2,300.00 1,437.50 2,083.33 2,600.00 575.00 12,152.78 13,433.33 347.22 2,166.67 2,012.50 287.50 Y4-05 2007 John Deere Excavator 09/01/Y4 12 Y4-06 2009 Cat Backhoe 09/01/Y4 12 Y4-07 2004 Case Tractor 10/01/Y4 12 Y4-08 3 wagons 10/01/Y4 Y5-10 2018 Chev Truck 03/01/Y5 Y5-11 2010 Toyota Tundra 05/31/Y5 Y5-12 2017 Kenworth 07/31/5 Y5-13 2015 Loader 08/01/Y5 12 Y5-14 1996 Grader 12/01/Y5 12 Y5-15 Flat-bed Trailer 12/01/Y5 12 222 4666222 25,000.00 4,861.11 2,083.33 6,944.44 18,055.56 12,300.00 2,391.67 1,025.00 3,416.67 8,883.33 9,800.00 1,837.50 816.67 2,654.17 7,145.83 3,000.00 1,687.50 750.00 2,437.50 562.50 35,600.00 10,877.78 5,933.33 16,811.11 18,788.89 18,750.00 4,947.92 3,125.00 8,072.92 10,677.08 225,500.00 53,243.06 37,583.33 90,826.39 134,673.61 18,165.00 2,144.48 1,513.75 3,658.23 14,506.77 7,200.00 12,300.00 398,015.00 650.00 1,110.42 106,091.70 600.00 1,025.00 59,713.75 1,250.00 5,950.00 2,135.42 10,164.58 165,805.45 232,209.55 Right of Use Asset Leased Machine TOTAL PV $ 4,448,015.00 $ 1,319,463.84 $ 133,334.17 $ 1,452,798.01 $ $ 1,890,033.79