Record the following in the general journal. Link/reference your amounts back to the cells on the depreciation schedule. This will create a functioning effective analysis tool for the business. A. Record the entry for the orlginal purchase on Jan 1, Year 1. B. Record the depreciation journal entry for Dec 31 , year 1 for all three methods. C. Record the journal entry for Straightline and DDB if Assembly Machine sold on Jan 1, Year 4. Prepare a double declining balance depreciation schedule using Excel/Sheet formulas for years 1-5. The schedule should start with the purchase date, and include the cost, and for each year: the depreciation expense, the accumulated depreciation, the cost, and the book value. Round to 2 decimal places. Record the following in the general journal. Link/reference your amounts back to the cells on the depreciation schedule. This will create a functioning effective analysis tool for the business. A. Record the entry for the original purchase on Jan 1, Year 1. UIRED FOR POINTS: Complete a depreciation schedule for the new assembly machine using all 3 depreciation methods. Link/reference all cells on your depreciation schedules back to the Master Fixed Asset record. Use the math functionality as needed. Referencing 'answer' cells (schedules) back to 'input' cells (fixed asset record) creates a functioning aeffective worksheet. Making these connections allows the worksheet to be used for analyzing potential changes in the results. Prepare a straight-line depreciation schedule using Excel/Sheet formulas for years 1-5. The schedule should star with the purchase date, and include the cost, and for each year: the depreciation expense, the accumulated depreciation, the cost, and the book value. Round to 2 decimal places. Prepare a units of production depreciation schedule using Excel/Sheet formulas for years 1-5. The schedule should start with the purchase date, and include the cost, and for each vear: the depreciation expense, the You must make a copy before using this sheet. This is the master. File (right under the title) then make a copy to save to your own Google Drive or Download as Microsoft Excel. Bardmen Corp has purchased a new Assembly Machine on Jan 1, 2023 paying 10\% of the purchase price in cash and signing a 5 year note for the balance. The following information is known: Prepare a units of productiondepreciation schedule using Excel/Sheet formulas for years 1-5. The schedule should start with the purchase date, and include the cost, and for each year: the depreciation expense, the accumulated depreciation, the cost, and the book value. Round to 2 decimal places. Record the following in the general journal. Link/reference your amounts back to the cells on the depreciation schedule. This will create a functioning effective analysis tool for the business. A. Record the entry for the orlginal purchase on Jan 1, Year 1. B. Record the depreciation journal entry for Dec 31 , year 1 for all three methods. C. Record the journal entry for Straightline and DDB if Assembly Machine sold on Jan 1, Year 4. Prepare a double declining balance depreciation schedule using Excel/Sheet formulas for years 1-5. The schedule should start with the purchase date, and include the cost, and for each year: the depreciation expense, the accumulated depreciation, the cost, and the book value. Round to 2 decimal places. Record the following in the general journal. Link/reference your amounts back to the cells on the depreciation schedule. This will create a functioning effective analysis tool for the business. A. Record the entry for the original purchase on Jan 1, Year 1. UIRED FOR POINTS: Complete a depreciation schedule for the new assembly machine using all 3 depreciation methods. Link/reference all cells on your depreciation schedules back to the Master Fixed Asset record. Use the math functionality as needed. Referencing 'answer' cells (schedules) back to 'input' cells (fixed asset record) creates a functioning aeffective worksheet. Making these connections allows the worksheet to be used for analyzing potential changes in the results. Prepare a straight-line depreciation schedule using Excel/Sheet formulas for years 1-5. The schedule should star with the purchase date, and include the cost, and for each year: the depreciation expense, the accumulated depreciation, the cost, and the book value. Round to 2 decimal places. Prepare a units of production depreciation schedule using Excel/Sheet formulas for years 1-5. The schedule should start with the purchase date, and include the cost, and for each vear: the depreciation expense, the You must make a copy before using this sheet. This is the master. File (right under the title) then make a copy to save to your own Google Drive or Download as Microsoft Excel. Bardmen Corp has purchased a new Assembly Machine on Jan 1, 2023 paying 10\% of the purchase price in cash and signing a 5 year note for the balance. The following information is known: Prepare a units of productiondepreciation schedule using Excel/Sheet formulas for years 1-5. The schedule should start with the purchase date, and include the cost, and for each year: the depreciation expense, the accumulated depreciation, the cost, and the book value. Round to 2 decimal places