Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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
image text in transcribed
image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting What the Numbers Mean

Authors: David H. Marshall, Wayne W. McManus, Daniel F. Viele,

9th Edition

978-0-07-76261, 0-07-762611-7, 9780078025297, 978-0073527062

More Books

Students also viewed these Accounting questions

Question

If X has distribution function F(t) = 0, t Answered: 1 week ago

Answered: 1 week ago