I need help for Question 5. I was doing well with my homework. Until, I got stuck on finding the answers for year 5 to year 8 on Double Declining Balance. However, I did found the answers online on a different website. But I want to learn how did they got the answers. My question is how did they find the answers for year 5 to year 8 on DDB? I took several screenshots of my homework that I did and hopefully this help you. Thank you!

landscape orientation and fit-to-1 page scaling. Check ligure: DDB depreciation for Yea (cell E31). $43,750 3. In the space below, prepare the journal entry to record the depreciation taken in Year under the units of production method WHAT-IF ANALYSIS 4. To test your formulas, assume the machine purchased had an estimated useful life of three years (20,000, 30,000, and 50,000 hours, respectively). Enter the new information in the Data Section of the worksheet. Does your depreciation total $320,000 under all three methods? There are three common errors made by students completing this worksheet. Let's clear up two of them. One, an asset that has a three-year life should have no depreciation claimed in Year 4. This can be corrected using an =IF statement in Year 4. For example, the correct formula in cell C32 is =IF(B32>09.0,(07-D8)/D9) or D9,0,SLN(D7.08.09)). You may wish to edit what you have already entered rather than retype it. Two, as mentioned in requirement 2, the double-declining-balance calculation needs to be modified in the last year of the asset's life. Assuming you have already modified the formula for Year 4 (per instructions in step 2), alter the formula for Year 3 also If you corrected any formulas, test their correctness by trying different estimated useful lives (between 3 and 8) in cell E9. Then reset the Data Section to the original values, save the revised file as DEPREC2, and reprint the worksheet to show the correct formulas. The third common error doesn't need to be corrected in this problem. The general form of the double-declining-balance formula needs to be modified to check the net book value of the asset each year to make sure it does not go below salvage value. =DDB does this automatically, but if you are writing your own formulas, this gets very complicated and is beyond the scope of the problem. 5. A truck was recently purchased for $75,000 with a salvage value of $5,000 and an estimated useful life of eight years or 150,000 miles (24,000 miles per year for the first five years and 10.000 miles per year after that). Enter the new information in the Data Section of the worksheet . Again, make sure the totais for all three methods are in agreement Print the worksheet. Save this new data as DEPREC5. 63 B DEPREC2020 - Saved Insert Draw Page Layout Formulas Data Review Vie Arial MT 12 - A A == BIU- A- Wrap Text Merge & Center Font Alignment f =D7*1/09*2 B D F Year 1 2 E Double Declining Balance $18,710 14,063 10,547 7,910 Straight Line $8,750 8,750 8,750 8,750 8,750 8,750 8,750 8,750 $70,000 4 Units of Production $11, ! ) 11,200 11,200 11,200 11,200 4,667 4,667 4,66 $70,000 5 6 7 8 Total 4,449 3,337 5,011 $64,067 DEPRECE WHATEA DEPRECS Sheet2 Type here to search DEPREC2020 - S. Home Insert Draw Page Layout Formulas Data RE Arial MT - 12 - A A e BIU a Wrap a. A- Merge Board Font Alignment f =D7-E29) *1/09-2 A B C D Year 3 E Double Declining Balance $18,750 14,078 10,547 7,910 Straight Line $8,750 8,750 8,750 8,750 8,750 8,750 8,750 8,750 $70,000 4 Units of Production $11,200 11, !) 11,200 11,200 11.200 4,667 4,667 4,667 $70,000 5 6 7 8 Total 4,449 3,337 5,011 $64,067 DEPRECE WHAT-TA DEPRECS Sheetz Type here to search Formulas Arial MT Data - 12 - A H BI UH 29 Wra G-A- bard Font Merg Alignment fo ={D7-E29-E30)*1/09*2 A B C D Year 2 3) Straight Line $8,750 8,750 8.750 8,750 8,750 8,750 8,750 8,750 $70,000 4 Double Declining Balance $18,750 14,063 10,547 Units of Production $11,200 11,200 11,) 11,200 11,200 4,667 4,667 4,667 $70,000 5 7,910 6 7 8 Total 4,449 3,337 5,011 $64,067 DEPREC WHATIFA DEPREC5 Sheets Type here to search O omne Insert DEPREC2020 - Saved - Draw Page Layout Formulas Arial MT Data 12 A ' ' Review BIU a A Merge & Center 25 Wrap Text Font Alignment =(D7-E29-E30-E31) *1/09*2 B D F Year 1 2 3 E Double Declining Balance $18,750 14,063 10,547 7,970 Straight Line $8,750 8,750 8,750 8,750 8.750 8,750 8,750 8,750 $70,000 4 Units of Production $11,200 11,200 11,200 11. :) 11,200 4,667 4,667 4,667 $70,000 5 6 7 8 Total 4,449 3,337 5,011 $64,067 DEPREC WHATEA DEPRECS Sheet2 Type here to search o