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.)

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
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.)
Buildings
Equipment
Furniture
Land
Land
Improvements
Total
Cost
At January 1, 2020
15,316,200
4,457,785
18,967,224
9,872,050
7,820,640
Additions
5,888,910
1,601,510
14,369,270
2,361,350
2,041,930
56,433,899
26,262,970
Disposal
0
0
0
0
0
0
At December 31, 2020
21,205,110
6,059,295
33,336,494
12,233,400
9,862,570
82,696,869
Accumulated Depreciation
At January 1, 2020
465,268
Depreciation expense
798,879
1,326,217
3,421,627
0
1,049,947
5,735,721
0
492,778
1,818,995
Disposal
0
0
0
0
0
0
At December 31, 2020
465,268
2,125,096
3,421,627
0
1,542,725
7,554,716
Carrying Amount
At January 1, 2020
14,850.932
3,658,906
15,545,597
9,872,050
6,770,693
50,698,178
At December 31, 2020
12.233,400
8,319,845
20,553,245
Transcribed Image Text: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.) Buildings Equipment Furniture Land Land Improvements Total Cost At January 1, 2020 15,316,200 4,457,785 18,967,224 9,872,050 7,820,640 Additions 5,888,910 1,601,510 14,369,270 2,361,350 2,041,930 56,433,899 26,262,970 Disposal 0 0 0 0 0 0 At December 31, 2020 21,205,110 6,059,295 33,336,494 12,233,400 9,862,570 82,696,869 Accumulated Depreciation At January 1, 2020 465,268 Depreciation expense 798,879 1,326,217 3,421,627 0 1,049,947 5,735,721 0 492,778 1,818,995 Disposal 0 0 0 0 0 0 At December 31, 2020 465,268 2,125,096 3,421,627 0 1,542,725 7,554,716 Carrying Amount At January 1, 2020 14,850.932 3,658,906 15,545,597 9,872,050 6,770,693 50,698,178 At December 31, 2020 12.233,400 8,319,845 20,553,245
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Accounting for Impairment of Assets
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education