Question: PLS HELP QUICK 9. Create a PivotTable and complete the following fixed asset schedule. Future Electronics will include the schedule in the notes to its


9. Create a PivotTable and complete the following fixed asset schedule. Future Electronics will include the schedule in the notes to its financial statements for fiscal 2020 . (Express every number as a postive number.) \begin{tabular}{|c|c|c|c|c|c|c|} \hline Values & \begin{tabular}{l} Column Labels - \\ Buildings \end{tabular} & Equipment & Furniture & Land & Land Improvements & Grand Total \\ \hline Sum of BegAccumDepr & 465,268 & 798,879 & 3,421,627 & - & 1,049,947 & 5,735,721 \\ \hline Sum of CurrentYearDepr & 438,111 & 1,060,956 & 2,960,626 & - & 492,778 & 4,952,471 \\ \hline Sum of EndAccumDepr & 903,379 & 1,859,835 & 6,382,253 & . & 1,542,725 & 10,688,192 \\ \hline \end{tabular} 10. Create a PrivotTable and determine total cost, accumulated depreciation and carrying amount of fixed assets at December 31,2020 by each province. (Express every number as a postive number.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
