Excel Basics - Example locetion. \begin{tabular}{|c|c|c|c|c|} \hline & & & & \\ \hline \begin{tabular}{l} Astet \\ No. \end{tabular} & Find Autet Name. & Cont & Lifn of Asent & Salvare Valus \\ \hline 1001 & Desklop computer & 51,500 & 5 & 30 \\ \hline 1.002 & Laptop 92 & 31,000 & 5 & 30 \\ \hline 1003 & Laptope =15 & $2,500 & 5 & 30 \\ \hline 1004 & trablet & 3050 & 5 & 10 \\ \hline 1005 & 4etron Worstation & $3,500 & 10 & $500 \\ \hline 1005 & orice chain (aet of 4 ) & $1,000 & 10 & $100 \\ \hline 1097 & fror Alal scmen TV & 51.750 & 5 & 5250 \\ \hline \end{tabular} Bequired \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{3}{|c|}{ STREOHTA INT MFTheo } & \multicolumn{3}{|c|}{ Arnial Deprectisten } & \multicolumn{2}{|c|}{ Emetrear 1} & & \multicolumn{2}{|c|}{ Fed chyour 3} \\ \hline \begin{tabular}{c} Aaset \\ Ne. \end{tabular} & Antet Name & Cost & \begin{tabular}{c} Year 1 \\ Oesersilited \end{tabular} & \begin{tabular}{c} Your ? \\ Depresiafien \end{tabular} & \begin{tabular}{c} Year 3 \\ Depreclafion \end{tabular} & \begin{tabular}{c} Aceumilated \\ Oepresiation \end{tabular} & \begin{tabular}{c} Not Dleok \\ Valice \end{tabular} & & \begin{tabular}{l} Net Book \\ Yolies \end{tabular} & \begin{tabular}{l} Accumulated \\ Depresiation \end{tabular} & \begin{tabular}{l} Nat Book \\ Valich \end{tabular} \\ \hline 1001 & Chathe compulet. & 1,500 & 7 & 7 & & 7 & 7 & 21 & 7 & 7 & 3 \\ \hline 1002 & latse 132 & 1000 & 7 & 2 & 3 & 3 & 2 & 2 & 7 & & 2 \\ \hline & fictse =1s2 & 2,800 & & 3 & 2 & & ?. & & (3) & 7 & 2 \\ \hline & traplet & cos & 7 & 7 & 7 & 7 & 2 & 7 & (7) & 7 & i) \\ \hline 1005 & 4.penpon Worstaben. & 3500 & ? & 7 & 7 & 7 & ?. & 3 & 97 & 7 & 7 \\ \hline 1600 & & 1,000 & i. & & 7 & 7 & 7 & 2 & 7 & 3 & 77 \\ \hline & fochetseinen N & 1,700 & 7 & 7 & 21 & 31 & 7 & 21 & & 7 & 7 \\ \hline & STRNORTHUNE TOTALS & 11,258 & 8 & 8 & 5 & +1 & & + & 7 & & 1. \\ \hline & & & & & & & & & & & \\ \hline & \multicolumn{3}{|c|}{ Amnial Deprecintion } & \multicolumn{2}{|c|}{ Fend of Yeart } & \multicolumn{2}{|c|}{ Fnd ef Year 2} & \multicolumn{2}{|c|}{ Endoryear 3} \\ \hline \begin{tabular}{l} Asut \\ No \end{tabular} & Asot Bame. & Ceat & \begin{tabular}{c} Your 1 \\ Depreciation \end{tabular} & \begin{tabular}{c} Year 2 \\ Depreciation \\ \end{tabular} & \begin{tabular}{c} Year 3 \\ Depreciation \end{tabular} & \begin{tabular}{l} Accumulated \\ Depreciation \end{tabular} & \begin{tabular}{l} Net Book \\ Velue \end{tabular} & \begin{tabular}{l} Accumulatad \\ Depreciation \end{tabular} & \begin{tabular}{c} Net Blook \\ Value \end{tabular} & \begin{tabular}{l} Acsumulated \\ Depreciation \end{tabular} & \begin{tabular}{c} Not book: \\ Yalya \end{tabular} \\ \hline 1001 & Deaking compuler & 1,500 & 7 & 77 & ? & & 2 & 32 & 2 & 2 & 4? \\ \hline 1.002 & Laptop-137 & 1,000 & 3 & 7 & 7. & 27 & 7 & 7 & 3 & 9. & 7 \\ \hline 1003 & Laptop 15 & 2500 & 7 & 7 & ? & 3 & 2 & ?. & 7. & i) & 7 \\ \hline 1004 & Tabiet & 6so & 3 & ? & 7 & 7 & 3 & 2 & 3 & 2 & 7 \\ \hline 1005 & 4-pencon Wosutation & 3500 & 7 & 77 & 7 & 7 & 7 & 2 & 2 & 7 & 3 \\ \hline 1000 & Oriceschain (tel of 4 ) & 1000 & 7 & 2 & 7 & 7 & ? & 7 & ? & 7 & 7 \\ \hline 1007 & roreat Semen TV & 1,750 & 2 & ? & ? & 7 & ? & 7 & 2 & ? & 31 \\ \hline & DOUELE-OECUNDV TOTALS & & 8 & 8 & 4 & 5 & & 1 & 1 & + & = \\ \hline \end{tabular} b. Based on the depenciatien schedules above, anwwer he fongwing questions based on the comparson of the fwo depmeiation methods \begin{tabular}{|c|c|} \hline & Mothon \\ \hline Which mesod nat the higher Total Depreciation Expetise in Year 1 ? & \\ \hline WNich meDod has the higher Total Desmeiasion Expense in Year 3 ? & \\ \hline Which mebod has the higher Total Aecumulated Depeciotion in Year 1? & \\ \hline Which method has the higher Total Accurruand Depseciation in Year 3 ? & \\ \hline Which method has the higher Total Net Boes Value in Year 1 ? & \\ \hline Which mothod has the higher. Total Nat Pees Value in Year 3 ? & \\ \hline \end{tabular} Required information [The following information applies to the questions displayed below.] This Applying Excel worksheet includes an explanation of the SUM function, SLN function, DDB function and other basic Excel functions. Now change the Cost, Life of the Asset, and Salvage Value for all of the assets listed in the table in your worksheet to match the information below: Be sure to also check the Cost in both of your Detreciation Method tables in your worksheet so that it matches the updated information. Required: 2a. Complete the chart below that shows comparisons of the two depreciation methods. (Round your answers to the nearest whole dollar.) Required information The following information applies to the questions disployod bolow] This Applying Excel worksheet includes an explanstion of the SUM function, SLN function, DDB function and other basic Excel functions. Download the Applying Excel form below. Follow the tutorial on the first tab using basic Excel functions. After following the tutorial on the first tab, enter formulas in cells that contain question marks on the second tab to complete the Fived Asset Depreciation Schedule. Once you have finished, verify that the amounts match the values below. Straight-Line Depreciation Method - Total for All Fixed Assets: End of Year 3 Net Book Value =$6,440 Double-Declining Depreciation - Total for All Fixed Assets: End of Year 3 Net Book Value =$3,902 Check your worksheet setup and formulas by changing the Life of the Desktop Computer in cell D8 in the Data area to be 10 years instead of 5 years, keeping all of the other data the same as in the onginal example. If your worksheet is operating properly, the Total End of Year 3 Book Value for StraightLine Depreciation should now be 56,890 and your Total End of Year 3 Book Value for Double-Declining Depreciation should now be $4.346. If you do not get this answer, find the errors in your worksheet and correct them. Save your completed Applying Excel form to your computer and then upload it here by clicking "Browse". Next click "Save", You will use this worksheet to answer questions in Part 2. Excel Basics - Example locetion. \begin{tabular}{|c|c|c|c|c|} \hline & & & & \\ \hline \begin{tabular}{l} Astet \\ No. \end{tabular} & Find Autet Name. & Cont & Lifn of Asent & Salvare Valus \\ \hline 1001 & Desklop computer & 51,500 & 5 & 30 \\ \hline 1.002 & Laptop 92 & 31,000 & 5 & 30 \\ \hline 1003 & Laptope =15 & $2,500 & 5 & 30 \\ \hline 1004 & trablet & 3050 & 5 & 10 \\ \hline 1005 & 4etron Worstation & $3,500 & 10 & $500 \\ \hline 1005 & orice chain (aet of 4 ) & $1,000 & 10 & $100 \\ \hline 1097 & fror Alal scmen TV & 51.750 & 5 & 5250 \\ \hline \end{tabular} Bequired \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{3}{|c|}{ STREOHTA INT MFTheo } & \multicolumn{3}{|c|}{ Arnial Deprectisten } & \multicolumn{2}{|c|}{ Emetrear 1} & & \multicolumn{2}{|c|}{ Fed chyour 3} \\ \hline \begin{tabular}{c} Aaset \\ Ne. \end{tabular} & Antet Name & Cost & \begin{tabular}{c} Year 1 \\ Oesersilited \end{tabular} & \begin{tabular}{c} Your ? \\ Depresiafien \end{tabular} & \begin{tabular}{c} Year 3 \\ Depreclafion \end{tabular} & \begin{tabular}{c} Aceumilated \\ Oepresiation \end{tabular} & \begin{tabular}{c} Not Dleok \\ Valice \end{tabular} & & \begin{tabular}{l} Net Book \\ Yolies \end{tabular} & \begin{tabular}{l} Accumulated \\ Depresiation \end{tabular} & \begin{tabular}{l} Nat Book \\ Valich \end{tabular} \\ \hline 1001 & Chathe compulet. & 1,500 & 7 & 7 & & 7 & 7 & 21 & 7 & 7 & 3 \\ \hline 1002 & latse 132 & 1000 & 7 & 2 & 3 & 3 & 2 & 2 & 7 & & 2 \\ \hline & fictse =1s2 & 2,800 & & 3 & 2 & & ?. & & (3) & 7 & 2 \\ \hline & traplet & cos & 7 & 7 & 7 & 7 & 2 & 7 & (7) & 7 & i) \\ \hline 1005 & 4.penpon Worstaben. & 3500 & ? & 7 & 7 & 7 & ?. & 3 & 97 & 7 & 7 \\ \hline 1600 & & 1,000 & i. & & 7 & 7 & 7 & 2 & 7 & 3 & 77 \\ \hline & fochetseinen N & 1,700 & 7 & 7 & 21 & 31 & 7 & 21 & & 7 & 7 \\ \hline & STRNORTHUNE TOTALS & 11,258 & 8 & 8 & 5 & +1 & & + & 7 & & 1. \\ \hline & & & & & & & & & & & \\ \hline & \multicolumn{3}{|c|}{ Amnial Deprecintion } & \multicolumn{2}{|c|}{ Fend of Yeart } & \multicolumn{2}{|c|}{ Fnd ef Year 2} & \multicolumn{2}{|c|}{ Endoryear 3} \\ \hline \begin{tabular}{l} Asut \\ No \end{tabular} & Asot Bame. & Ceat & \begin{tabular}{c} Your 1 \\ Depreciation \end{tabular} & \begin{tabular}{c} Year 2 \\ Depreciation \\ \end{tabular} & \begin{tabular}{c} Year 3 \\ Depreciation \end{tabular} & \begin{tabular}{l} Accumulated \\ Depreciation \end{tabular} & \begin{tabular}{l} Net Book \\ Velue \end{tabular} & \begin{tabular}{l} Accumulatad \\ Depreciation \end{tabular} & \begin{tabular}{c} Net Blook \\ Value \end{tabular} & \begin{tabular}{l} Acsumulated \\ Depreciation \end{tabular} & \begin{tabular}{c} Not book: \\ Yalya \end{tabular} \\ \hline 1001 & Deaking compuler & 1,500 & 7 & 77 & ? & & 2 & 32 & 2 & 2 & 4? \\ \hline 1.002 & Laptop-137 & 1,000 & 3 & 7 & 7. & 27 & 7 & 7 & 3 & 9. & 7 \\ \hline 1003 & Laptop 15 & 2500 & 7 & 7 & ? & 3 & 2 & ?. & 7. & i) & 7 \\ \hline 1004 & Tabiet & 6so & 3 & ? & 7 & 7 & 3 & 2 & 3 & 2 & 7 \\ \hline 1005 & 4-pencon Wosutation & 3500 & 7 & 77 & 7 & 7 & 7 & 2 & 2 & 7 & 3 \\ \hline 1000 & Oriceschain (tel of 4 ) & 1000 & 7 & 2 & 7 & 7 & ? & 7 & ? & 7 & 7 \\ \hline 1007 & roreat Semen TV & 1,750 & 2 & ? & ? & 7 & ? & 7 & 2 & ? & 31 \\ \hline & DOUELE-OECUNDV TOTALS & & 8 & 8 & 4 & 5 & & 1 & 1 & + & = \\ \hline \end{tabular} b. Based on the depenciatien schedules above, anwwer he fongwing questions based on the comparson of the fwo depmeiation methods \begin{tabular}{|c|c|} \hline & Mothon \\ \hline Which mesod nat the higher Total Depreciation Expetise in Year 1 ? & \\ \hline WNich meDod has the higher Total Desmeiasion Expense in Year 3 ? & \\ \hline Which mebod has the higher Total Aecumulated Depeciotion in Year 1? & \\ \hline Which method has the higher Total Accurruand Depseciation in Year 3 ? & \\ \hline Which method has the higher Total Net Boes Value in Year 1 ? & \\ \hline Which mothod has the higher. Total Nat Pees Value in Year 3 ? & \\ \hline \end{tabular} Required information [The following information applies to the questions displayed below.] This Applying Excel worksheet includes an explanation of the SUM function, SLN function, DDB function and other basic Excel functions. Now change the Cost, Life of the Asset, and Salvage Value for all of the assets listed in the table in your worksheet to match the information below: Be sure to also check the Cost in both of your Detreciation Method tables in your worksheet so that it matches the updated information. Required: 2a. Complete the chart below that shows comparisons of the two depreciation methods. (Round your answers to the nearest whole dollar.) Required information The following information applies to the questions disployod bolow] This Applying Excel worksheet includes an explanstion of the SUM function, SLN function, DDB function and other basic Excel functions. Download the Applying Excel form below. Follow the tutorial on the first tab using basic Excel functions. After following the tutorial on the first tab, enter formulas in cells that contain question marks on the second tab to complete the Fived Asset Depreciation Schedule. Once you have finished, verify that the amounts match the values below. Straight-Line Depreciation Method - Total for All Fixed Assets: End of Year 3 Net Book Value =$6,440 Double-Declining Depreciation - Total for All Fixed Assets: End of Year 3 Net Book Value =$3,902 Check your worksheet setup and formulas by changing the Life of the Desktop Computer in cell D8 in the Data area to be 10 years instead of 5 years, keeping all of the other data the same as in the onginal example. If your worksheet is operating properly, the Total End of Year 3 Book Value for StraightLine Depreciation should now be 56,890 and your Total End of Year 3 Book Value for Double-Declining Depreciation should now be $4.346. If you do not get this answer, find the errors in your worksheet and correct them. Save your completed Applying Excel form to your computer and then upload it here by clicking "Browse". Next click "Save", You will use this worksheet to answer questions in Part 2