A. complete a depreciation schedule for the new tractor using all 3 depreciation methods. Link/reference all cells on your depreciation schedules back to the given data sectoon.
B. Include answers to the following:
1. Record rhe adjusting journal entry for year 1 for each of the methods. Reference/link amount from your schedule.
2. Record the journal entry for each method if the tractor is sold Jan 1, year 3 for $75,000.
3. Recalculate ONLY the year 1 depreciation for each method if the tractor had been purchased on April 1 rather than Jan 1. Record the year 1 adjusting journal entry for this change. If no change is needed, please record "no change" in the journal entry.
Reference or give data action Exchakulation should rence back to the | alternate | Cost: $ 165,000 15,000 Numerous examples have been provided Estimated Residuals Estimated Life in years Estimated Life in hours Actual hours per Outcomes: (demonstrated in this project) Calculate depreciation for long term tangible assets using straight line, units of A production and double declining balance B Use technology to record and summarise information used in business decisions REQUIRED FOR POINTS: A. Complete a depreciation schedule for the new tractor using all 3 depreciation methods. Link/reference all cells on your depreciation schedules back to the Given data section, Be sure you download or make a copy of this file to start Use the add/sum/subtract functionality as needed. B. Include answers to the following: 1. Record the adjusting journal entry for year 1 for each of the methods. Reference/ link the amount from your schedule. 2. Record the journal entry for each method if the tractor is sold Jan 1, year 3 for $75.000 3. Recalculate ONLY the year I depreciation for each method if the tractor had been purchased on April 1 rather than Jan 1. Record the year 1 adjusting journal entry for this change. If no change is needed, please record "no change in the journal entry 1.200 MORE Purchased for 03 gestion Amount of each forea 360 300 320 220 2 There are some built form 4 retion Prepare a straight-line depreciation schedule using Excel/Sheet formulas for years 14. The schedule should contain for each year, the year number, the depreciation expense, the accurated depreciation and the book value DAL DESCRIPTEN ALLEN CE Sulhan Ranch Companie Depreciation Schedule Straight line method Prepare a units of production depreciation schedule using Excel Sheet formulas for years 144 The schedule should contain for each year the year number the depreciation expense, the accumulated depreciation and the book value DITION MOUNT Co Savannah Coral Depreciation Schedule Unite al production tedes DATE Ver Prepare a double dedining deprecation schedule using Excel/Sheet formulas for years 14. The schedule should contain for each year, the year number, the depreciation expense, the accurated depreciation and the book wahae DESCRIPTION ACEINT Crola Sali Benth Corporation De hoeveering method DATE Your Outcomes: (der Calculate depre A production and B Use technology REQUIRED FOR A.Complete ad methods. Link/reference section. Be sure Reference or given data section Each calculation should reference back to this information Cost: $ 165,000 $ $ 15,000 Estimated Residual: Estimated Life in years Estimated Life in 4 Numerous examples have been provided or completed in chapter 9. Use the add/su hours Actual hours per year 1,200 Month Purchased for B 3 question Amount of cash for B2 360 question 300 320 220 75,000 1 2 B. Include answ 1. Record the a link the amount 2. Record the jo $75,000. 3. Recalculated been purchased entry for this ch journal entry 4 There are some built in formulas in Excel Sheets related to depreciation. Use them or design your own Prepare a straight-line depreciation schedule using Excel/Sheet formulas for years 1-4. The schedule should contain for each year: the year number, the depreciation expense, the accumulated depreciation and the book value. DATE Sullivan Ranch Corporation Depreciation Schedule Straight-line method End of year amounts Prepare a units of production depreciation schedule using Excel/Sheet formulas for years 1-4. The schedule should contain for each year: the year number, the depreciation expense, the accumulated depreciation and the book value. Sullivan Ranch Corporation Depreciation Schedule Units of production method End of year amounts DATE Year Outcomes: (demonstrated in this project) Calculate depreciation for long term tangible assets using straight line, units of A production and double declining balance B Use technology to record and summarize information used in business decisions REQUIRED FOR POINTS: A.Complete a depreciation schedule for the new tractor using all 3 depreciation methods. Link/reference all cells on your depreciation schedules back to the Given data section. Be sure you download or make a copy of this file to start. Use the add/sum/subtract functionality as needed. B. Include answers to the following: 1. Record the adjusting journal entry for year 1 for each of the methods. Reference/ link the amount from your schedule. 2. Record the journal entry for each method if the tractor is sold Jan 1, year 3 for $75,000. 3. Recalculate ONLY the year 1 depreciation for each method if the tractor had been purchased on April 1 rather than Jan 1. Record the year 1 adjusting journal entry for this change. If no change is needed, please record "no change" in the journal entry. DESCRIPTION ACCOUNT Dahil Credit DATE Year DATE DESCRIPTION ACCOUNT Det Credit Year Prepare a units of production depreciation schedule using Excel/Sheet formulas for years 1-4. The schedule should contain for each year: the year number, the depreciation expense, the accumulated depreciation and the book value. Sullivan Ranch Corporation Depreciation Schedule Units of production method End of year amounts DATE Year Prepare a double declining depreciation schedule using Excel/Sheet formulas for years 1-4. The schedule should contain for each year: the year number, the depreciation expense, the accumulated depreciation and the book value. Sullivan Ranch Corporation Depreciation Schedule Double declining method End of year amounts DATE Year DESCRIPTION ACCOUNT Debit Credit DATE Year ne DESCRIPTION ACCOUNT Debit Credit DATE Year Reference on tach calculation should reference to this Cost: $ 165,000 15,000 Estimated Residuals Estimated Life in years Estimated Life in hours Actual hours per year Neerpestavenido completed in chapter Outcomes: (demonstrated in this project) Calculate depreciation for long term tangible assets using straight line, units of A production and double declining balance. B Use technology to record and summarize information used in business decisions REQUIRED FOR POINTS: A. Complete a depreciation schedule for the new tractor using al 3 depreciation methods. Link/reference all cells on your depreciation schedules back to the Given data section. Be sure you download or make a copy of this file to start Use the add/sum/subtract functionality as needed. B. Include answers to the following: 1. Record the adjusting journal entry for year 1 for each of the methods. Reference/ link the amount from your schedule. 2. Record the journal entry for each method if the tractor is sold Jan 1, year 3 for 575,000 3. Recalculate ONLY the year 1 depreciation for each method the tractor had been purchased on April 1 rather than Jan 1. Record the year 1 adjusting journal entry for this change. If no change is needed, please record no change in the Journal entry 1,200 More Bestien Amount of cachor 360 300 320 220 75,000 2 3 4 The built Be Sheets Prepare a straight line depreciation schedule using Excel/Sheet formulas for years 1-4. The schedule should contain for each year the year number, the depreciation expense, the accumulated depreciation and the book value DATE Sul Ranch Corporation Depreciation Schedule Straight Guated DESCRIPTION ACCOUNT Prepare a units of production depreciation schedule using Excel/Sheet formulas for years 1-4. The schedule should contain for each year, the year number, the depreciation expense, the accumulated depreciation and the book value DATE DESCRITTI MTENT Sales are aparation Indy Prepare a double declining depreciation schedule using Excel Sheet formulas for years 14. The schedule should contain for each year, the year number, the depreciation expense, the accumulated depreciation and the book value DATE Suite Ranch Cup Depreciation Schedule Double designed DESCRIPTION AGENT Reference or given data section. Each calculation should reference back to this information Cost: $ 165,000 15,000 Estimated Residual: $ Estimated Life in years Estimated Life in hours 4 Numerous examples have been provided or completed in chapter 9. Actual hours per year 1,200 Month Purchased for B 3 question Amount of cash for B 2 360 question 300 320 220 75,000 1 2 3 4 There are some beitin formulas Excel Sheets related to Depreciation Use them or design FOOT B Use technology to record and summarize information used in business decision REQUIRED FOR POINTS: A.Complete a depreciation schedule for the new tractor using all 3 depreciation methods. Link/reference all cells on your depreciation schedules back to the Given data section. Be sure you download or make a copy of this file to start. Use the add/sum/subtract functionality as needed. B. Include answers to the following: 1. Record the adjusting journal entry for year 1 for each of the methods. Reference/link the amount from your schedule. 2. Record the journal entry for each method if the tractor is sold Jan 1. year 3 for $75,000 3. Recalculate ONLY the year 1 depreciation for each method if the tractor had been purchased on April 1 rather than Jan 1. Record the year 1 adjusting journal entry for this change. If no change is needed, please record "no change in the journal entry Reference or give data action Exchakulation should rence back to the | alternate | Cost: $ 165,000 15,000 Numerous examples have been provided Estimated Residuals Estimated Life in years Estimated Life in hours Actual hours per Outcomes: (demonstrated in this project) Calculate depreciation for long term tangible assets using straight line, units of A production and double declining balance B Use technology to record and summarise information used in business decisions REQUIRED FOR POINTS: A. Complete a depreciation schedule for the new tractor using all 3 depreciation methods. Link/reference all cells on your depreciation schedules back to the Given data section, Be sure you download or make a copy of this file to start Use the add/sum/subtract functionality as needed. B. Include answers to the following: 1. Record the adjusting journal entry for year 1 for each of the methods. Reference/ link the amount from your schedule. 2. Record the journal entry for each method if the tractor is sold Jan 1, year 3 for $75.000 3. Recalculate ONLY the year I depreciation for each method if the tractor had been purchased on April 1 rather than Jan 1. Record the year 1 adjusting journal entry for this change. If no change is needed, please record "no change in the journal entry 1.200 MORE Purchased for 03 gestion Amount of each forea 360 300 320 220 2 There are some built form 4 retion Prepare a straight-line depreciation schedule using Excel/Sheet formulas for years 14. The schedule should contain for each year, the year number, the depreciation expense, the accurated depreciation and the book value DAL DESCRIPTEN ALLEN CE Sulhan Ranch Companie Depreciation Schedule Straight line method Prepare a units of production depreciation schedule using Excel Sheet formulas for years 144 The schedule should contain for each year the year number the depreciation expense, the accumulated depreciation and the book value DITION MOUNT Co Savannah Coral Depreciation Schedule Unite al production tedes DATE Ver Prepare a double dedining deprecation schedule using Excel/Sheet formulas for years 14. The schedule should contain for each year, the year number, the depreciation expense, the accurated depreciation and the book wahae DESCRIPTION ACEINT Crola Sali Benth Corporation De hoeveering method DATE Your Outcomes: (der Calculate depre A production and B Use technology REQUIRED FOR A.Complete ad methods. Link/reference section. Be sure Reference or given data section Each calculation should reference back to this information Cost: $ 165,000 $ $ 15,000 Estimated Residual: Estimated Life in years Estimated Life in 4 Numerous examples have been provided or completed in chapter 9. Use the add/su hours Actual hours per year 1,200 Month Purchased for B 3 question Amount of cash for B2 360 question 300 320 220 75,000 1 2 B. Include answ 1. Record the a link the amount 2. Record the jo $75,000. 3. Recalculated been purchased entry for this ch journal entry 4 There are some built in formulas in Excel Sheets related to depreciation. Use them or design your own Prepare a straight-line depreciation schedule using Excel/Sheet formulas for years 1-4. The schedule should contain for each year: the year number, the depreciation expense, the accumulated depreciation and the book value. DATE Sullivan Ranch Corporation Depreciation Schedule Straight-line method End of year amounts Prepare a units of production depreciation schedule using Excel/Sheet formulas for years 1-4. The schedule should contain for each year: the year number, the depreciation expense, the accumulated depreciation and the book value. Sullivan Ranch Corporation Depreciation Schedule Units of production method End of year amounts DATE Year Outcomes: (demonstrated in this project) Calculate depreciation for long term tangible assets using straight line, units of A production and double declining balance B Use technology to record and summarize information used in business decisions REQUIRED FOR POINTS: A.Complete a depreciation schedule for the new tractor using all 3 depreciation methods. Link/reference all cells on your depreciation schedules back to the Given data section. Be sure you download or make a copy of this file to start. Use the add/sum/subtract functionality as needed. B. Include answers to the following: 1. Record the adjusting journal entry for year 1 for each of the methods. Reference/ link the amount from your schedule. 2. Record the journal entry for each method if the tractor is sold Jan 1, year 3 for $75,000. 3. Recalculate ONLY the year 1 depreciation for each method if the tractor had been purchased on April 1 rather than Jan 1. Record the year 1 adjusting journal entry for this change. If no change is needed, please record "no change" in the journal entry. DESCRIPTION ACCOUNT Dahil Credit DATE Year DATE DESCRIPTION ACCOUNT Det Credit Year Prepare a units of production depreciation schedule using Excel/Sheet formulas for years 1-4. The schedule should contain for each year: the year number, the depreciation expense, the accumulated depreciation and the book value. Sullivan Ranch Corporation Depreciation Schedule Units of production method End of year amounts DATE Year Prepare a double declining depreciation schedule using Excel/Sheet formulas for years 1-4. The schedule should contain for each year: the year number, the depreciation expense, the accumulated depreciation and the book value. Sullivan Ranch Corporation Depreciation Schedule Double declining method End of year amounts DATE Year DESCRIPTION ACCOUNT Debit Credit DATE Year ne DESCRIPTION ACCOUNT Debit Credit DATE Year Reference on tach calculation should reference to this Cost: $ 165,000 15,000 Estimated Residuals Estimated Life in years Estimated Life in hours Actual hours per year Neerpestavenido completed in chapter Outcomes: (demonstrated in this project) Calculate depreciation for long term tangible assets using straight line, units of A production and double declining balance. B Use technology to record and summarize information used in business decisions REQUIRED FOR POINTS: A. Complete a depreciation schedule for the new tractor using al 3 depreciation methods. Link/reference all cells on your depreciation schedules back to the Given data section. Be sure you download or make a copy of this file to start Use the add/sum/subtract functionality as needed. B. Include answers to the following: 1. Record the adjusting journal entry for year 1 for each of the methods. Reference/ link the amount from your schedule. 2. Record the journal entry for each method if the tractor is sold Jan 1, year 3 for 575,000 3. Recalculate ONLY the year 1 depreciation for each method the tractor had been purchased on April 1 rather than Jan 1. Record the year 1 adjusting journal entry for this change. If no change is needed, please record no change in the Journal entry 1,200 More Bestien Amount of cachor 360 300 320 220 75,000 2 3 4 The built Be Sheets Prepare a straight line depreciation schedule using Excel/Sheet formulas for years 1-4. The schedule should contain for each year the year number, the depreciation expense, the accumulated depreciation and the book value DATE Sul Ranch Corporation Depreciation Schedule Straight Guated DESCRIPTION ACCOUNT Prepare a units of production depreciation schedule using Excel/Sheet formulas for years 1-4. The schedule should contain for each year, the year number, the depreciation expense, the accumulated depreciation and the book value DATE DESCRITTI MTENT Sales are aparation Indy Prepare a double declining depreciation schedule using Excel Sheet formulas for years 14. The schedule should contain for each year, the year number, the depreciation expense, the accumulated depreciation and the book value DATE Suite Ranch Cup Depreciation Schedule Double designed DESCRIPTION AGENT Reference or given data section. Each calculation should reference back to this information Cost: $ 165,000 15,000 Estimated Residual: $ Estimated Life in years Estimated Life in hours 4 Numerous examples have been provided or completed in chapter 9. Actual hours per year 1,200 Month Purchased for B 3 question Amount of cash for B 2 360 question 300 320 220 75,000 1 2 3 4 There are some beitin formulas Excel Sheets related to Depreciation Use them or design FOOT B Use technology to record and summarize information used in business decision REQUIRED FOR POINTS: A.Complete a depreciation schedule for the new tractor using all 3 depreciation methods. Link/reference all cells on your depreciation schedules back to the Given data section. Be sure you download or make a copy of this file to start. Use the add/sum/subtract functionality as needed. B. Include answers to the following: 1. Record the adjusting journal entry for year 1 for each of the methods. Reference/link the amount from your schedule. 2. Record the journal entry for each method if the tractor is sold Jan 1. year 3 for $75,000 3. Recalculate ONLY the year 1 depreciation for each method if the tractor had been purchased on April 1 rather than Jan 1. Record the year 1 adjusting journal entry for this change. If no change is needed, please record "no change in the journal entry
