$1$ Start Excel. Open the file named e$06\_$grader$\_$a$2\_$Assets.xlsx$.$ Save the file with the name e$06\_$grader$\_$a$2\_$Assets$\_$LastFirst, replacing LastFirst with your last and first name.

$2$ On the Depreciation worksheet, in cell B$7,$ use the straight$-$line depreciation function to calculate the depreciation value of the equipment for year one. Use absolute cell references. Copy the function down through B$13.$

$3$ In cells C$7$:C$13,$ calculate the accumulated depreciation value for each year. In cell C$7,$ reference the current year's Depreciation Expense. In cell C$8,$ add the prior year's Accumulated Depreciation and the current year's Depreciation Expense. Copy the formula down through C$13.$

$4$ In cells D$7$:D$13,$ calculate the book value at the end of each year. Use absolute cell references where appropriate to allow the formula to be copied.

$5$ In cell G$7,$ use the declining balance depreciation function to calculate the depreciation value of the equipment for year one. Use absolute references where appropriate. Copy the function down through G$13.$

$6$ In cells H$7$:H$13,$ calculate the accumulated depreciation value for each year. In H$7,$ reference the current year's Depreciation Expense. In cell H$8,$ add the prior year's Accumulated Depreciation and the current year's Depreciation Expense. Copy the formula down through H$13.$

$7$ In cells I$7$:I$13,$ calculate the book value at the end of each year. Use absolute cell references where appropriate to allow the formula to be copied.

$8$ In cell G$18,$ use the double declining balance depreciation function to calculate the depreciation value of the equipment for year one. Use absolute cell references where appropriate. Copy the function down through G$24.$

$9$ In cells H$18$:H$24,$ calculate the accumulated depreciation value for each year. In H$18,$ reference the current year's Depreciation Expense. In cell H$19,$ add the prior year's Accumulated Depreciation and the current year's Depreciation Expense. Copy the formula down through H$24.$

$10$ In cells I$18$:I$24,$ calculate the book value at the end of each year. Use absolute cell references where appropriate to allow the formula to be copied.

$11$ On the Contest worksheet, in cell E$2,$ use the Hypergeometric probability function to calculate the probability of someone drawing $0$ of the $15$ top prize envelopes containing $$5000$ from a pile of $200$ envelopes with seven chances to draw an envelope. Copy the function down through E$9.$

$12$ In cell F$2,$ create a formula that calculates the value of the winnings if the winner selects zero $$5000$ top prize envelopes and all of the draws were $$100$ envelopes. Format the cell as Currency and copy the formula to F$9.$

$13$ In cell G$2,$ create a formula to calculate the expected value of the winnings. Format the cell as Currency and copy the formula to G$9.$

$14$ In cell G$11,$ create a formula to calculate the total expected value of the contest.

$15$ Save the workbook, exit Excel, and then submit your file as directed by your instructor.

PLEASE HELP WITH ALL!!!