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

PLS HELP QUICK
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 financial statements for fiscal 2020 . (Express every number as a

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!