Create your own spreadsheet file to show the calculations for all of the following. It would be best if you used a different sheet/tab for each question, but only one document. ***USE FORMULAS whenever possible. 1. Amortization Methods. The Flakeboard Company purchased three machines. Various amortization methods were selected. Information is as follows: WN Machine Acquired Cost Residual Value Useful Years Method 1 Jan 1/99 $96,000 $6,000 10 Straight-line 2 Jan 1/00 $60,000 $10.000 8 Declining Balance 3 Nov 1/01 $66,000 $6,000 6 Units-of-activity For the declining balance method, the company uses double the declining balance rate. For the units-of-activity method, total machine hours are expected to be 24,000. Actual hours in the first two years were 1000 in 2001 and 4500 in 2002. Calculate the amount of amortization for each method and then calculate the accumulated amortization for each method as of December 31, 2002. ** SHOW the amortization for each year, and the accumulated amortization at the end of each year. 2. Show the journal entry for December 31, 2002 for each of the above machines