Tableau DA 8-3: Mini-Case, Analyzing straight-line, units-of-production, and double-declining-balance LO P1 The company founder hires us as consultants and asks that we oversee the accounting for new equipment purchased on January 1 The founder wants to know the implications of different depreciation methods and estimates for the company's financial statements. Those statements will be used to attract financing from new investors and creditors. At the end of the equipment's first year in operation, we are given the following Tableau Dashboard Estimated Useful Life of Purchase Price & Estimated Salvage Assets Value Building Equipment $70,000 20 Truck 16 $60,000 $50,000 12 Years $40,000 $30,000 $20,000 $10,000 so Building Equipment Truck Purchase Salvage Purchase Salvage Purchase Salvage Price Value Price Value Price Value Actual & Estimated Units-of-Production Actual & Estimated Units-of-Production Year 1 Production Actual Year 2 Production Estimated Year 3 Production Estimated Year 4 Production Estimated 25,000 100,000 125,000 50,000 75,000 Total Units to be Produced tableau 1(a). Determine the equipment's first-year depreciation under the straight-line method 1b). Determine the equipment's first-year depreciation under the units-of-production method. Note: Actual units produced for Year! were equal to the units estimated to be produced for Year 1 1(c). Determine the equipment's first-year depreciation under the double-declining-balance method 2. Which method in part 1 results in the highest net income in the first year? 3. If the company anticipates that its use of assets will vary greatly from one yeat to the next bited on usage, which metod would we recommend the company use? 4. The founder is concerned that a depreciation method might result in more total depreciation expense over the ocelulife of an asset than another method which method would result in the highest amount of depreciation over an asset's useful life VOD 1(a). Determine the equipment's first-year depreciation under the straight line method 16). Determine the equipment's first-year depreciation under the units of production method. Note: Actual units produced for Year 1 were equal to the units estimated to be produced for Year 1. 1c). Determine the equipment's first-year depreciation under the double declining balance method. 2. Which method in part 1 results in the highest net income in the first year? 3. If the company anticipates that its use of assets will vary greatly from one year to the next based on usage, which method would we recommend the company use? 4. The founder is concerned that a depreciation method might result in more total depreciation expense over the useful life of an asset than another method. Which method would result in the highest amount of depreciation over an asset's useful life? Complete this question by entering your answers in the tabs below. Required 2A Required 1B Required 1C Required 2 Required 3 Required 4 Determine the equipment's first-year depreciation under the straight-line method. Straight Line Method Choose Numerator Choose Denominator Annual Depreciation Expense Depreciation expense 1 = Reque Required 18> 2. 1(a). Determine the equipment's first-year depreciation under the straight-line method. 1(b). Determine the equipment's first-year depreciation under the units-of-production method. Note: Actual units produced fo were equal to the units estimated to be produced for Year 1 1(c). Determine the equipment's first-year depreciation under the double declining balance method. 2. Which method in part 1 results in the highest net income in the first year? 3, the company anticipates that its use of assets will vary greatly from one year to the next based on usage, which method recommend the company use? A. The founder is concerned that a depreciation method might result in more total depreciation expense over the useful life of than another method. Which method would result in the highest amount of depreciation over an asset's useful life? Complete this question by entering your answers in the tabs below. Required 1A Required 1B Required 10 Required 2 Required 3 Required 4 Determine the equipment's first-year depreciation under the units-of-production method. Note: Actual units produced for Year 1 were equal to the units estimated to be produced for Year 1. Units-of-production Depreciation Choose Numerator: Choose Denominator: - Annual Depreciation Expense = Depreciation expense per unit Year Annual Production (units) Depreciation Expense 1 (a). Determine the equipment's first-year depreciation under the straight-line method (by. Determine the equipment's first-year depreciation under the units-of-production method NoreActual units produc were equal to the units estimated to be produced for Year 1 Determine the equipment's first-year depreciation under the double-declining balance method 2 Widi method in part 1 results in the highest net income in the first year 3. M the company anticipates that its use of assets will vary greatly from one year to the next based on usage which me recommend the company use? 4.The founder is concerned that a depreciation method might result in more total depreciation expense over the useful than another method. Which method would result in the highest amount of depreciation over an asset's useful life? Complete this question by entering your answers in the tabs below. Required 1A Required 1B Rebuired 10 Required 2 Required 3 Required 4 Determine the equipment's first-year depreciation under the double-declining-balance method. End of Period Depreciation for the Period Beginning of Depreciation Depreciation Period Book Value Rate(%) Expense Annual Period Accumulated Depreciation Book Value First Year a). Determine the equipment's first year depreciation under the straight-line method 1(b). Determine the equipment's first-year depreciation under the units-of-production method. Note Actual units produced for Year were equal to the units estimated to be produced for Year 1. 1(c). Determine the equipment's first-year depreciation under the double-declining balance method. 2. Which method in part 1 results in the highest net income in the first year? 3. If the company anticipates that its use of assets will vary greatly from one year to the next based on usage, which method would recommend the company use? 4. The founder is concerned that a depreciation method might result in more total depreciation expense over the useful life of an ass than another method. Which method would result in the highest amount of depreciation over an asset's useful life? Complete this question by entering your answers in the tabs below. Required 4 Required 1A Required 1B Required 1c Required 2 Required 3 Which method in part 1 results in the highest net inkome in the first year? Which method in part 1 results in the highest net income in the first year? babu 1(a). Determine the equipment's first-year depreciation under the straight-line method. (b). Determine the equipment's first-year depreciation under the units-of-production method. Note: Actual units produced were equal to the units estimated to be produced for Year 1. 1(c). Determine the equipment's first-year depreciation under the double-declining balance method 2. Which method in part 1 results in the highest net income in the first year? 3. Af the company anticipates that its use of assets will vary greatly from one year to the next based on usage, which method recommend the company use? 4. The founder is concerned that a depreciation method might result in more total depreciation expense over the useful life than another method. Which method would result in the highest amount of depreciation over an asset's useful life? Complete this question by entering your answers in the tabs below. Required 1A Required 18 Required 10 Required 2 Required 3 Required 4 If the company anticipates that its use of assets will vary greatly from one year to the next based on usage, which method would we recommend the company use? Which method would we recommend the company use?