Note XX. Property, Plant & Equipment Furniture & Fixtures - Net Machineries and Equipment - Net Total Property Plant, and Equipment Note 10- Property, Plant, and Equipment Furniture & Fixtures Machineries and Equipment Total Cost Accumulated Depreciation - Furniture and Fixtures Accumulated Depreciation - Machineries and Equipment Total Accumulated Depreciation Total Property Plant, and Equipment Net Year 1 105,100.00 102,108.00 207,208.00 January 1,158.33 834.33 1,992.67 Year 2 91,200.00 229.127.33 March April May June February July August 119,000.00 117,841.67 116,683.33 115,525.00 114,366.67 113,208.33 112,050.00 110,891.67 112,120.00 111,285.67 110,451.33 109,617.00 107,437.87 106,603.53 105,769.20 104,934.87 104,100.53 231,120.00 229,127.33 227,134.67 225,142.00 221,804.53 219,811.87 217,819.20 215,826.53 213,833.87 92,096.00 $2,084.00 183,296.00 159,384.00 Year 3 77,300.00 1,158.33 F&F M&E 834.33 1,992.67 834.33 2,179.13 227,134.67 224,955.53 1,158.33 AD Year 4 63,400.00 72,072.00 62,060.00 135,472.00 111.560.00 Year 5 49.500.00 1,158.33 Cost 12760 119,000.00 13390 112120 26,149.60 1,158.33 1,158.33 1,158.33 1,158.33 September October November December 109,733.33 108,575.00 107,416.67 106,258.33 103,266.20 102,431.87 101,597.53 211,841.20 209,848.53 207,855.87 1,158.33 1,158.33 834.33 834.33 2,179.13 2,179.13 834.33 2,179.13 834.33 2,179.13 834.33 2,179.13 834.33 2,179.13 222,962.87 219,625.40 217,632.73 215,640.07 213.647.40 211.654.73 209.662.07 207,669.40 1,158.33 834.33 2,179.13 834.33 2,179.13 1,158.33 834.33 2,179.13 205,676.73

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

can u make like this in excel, and correct this two highlighted digit should have the same result

              COST       AD (annual)                         

F&F = 119,000        12760

M&E = 112,120         13390

 

Note XX. Property, Plant &
Equipment
Furniture & Fixtures - Net
Machineries and Equipment - Net
Total Property Plant, and Equipment
Note 10 Property, Plant, and Equipment
Furniture & Fixtures
Machineries and Equipment
Total Cost
Accumulated Depreciation - Furniture
and Fixtures
Accumulated Depreciation - Machineries
and Equipment
Total Accumulated Depreciation
Total Property Plant, and Equipment -
Net
Year 1
105,100.00
102,108.00
207,208.00
January
1,158.33
June
February March
April
May
119,000.00 117,841.67 116,683.33 115,525.00 114,366.67 113,208.33
112,120.00 111.285.67 110,451.33 109,617.00 107,437.87 106,603.53
231,120.00 229,127.33 227,134.67 225,142.00 221,804.53 219,811.87
834.33
1,992.67
229.127.33
Year 2
91,200.00
92,096.00
183,296.00 159,384.00
Year 3
Year 4
77,300.00
63,400.00
82,084.00 72,072.00
135,472.00
1,158.33
F&F
M&E
834.33
1,992.67
1,158.33
AD
834.33
2,179.13
1,158.33
Cost
834.33
2,179.13
Year 5
49,500.00
62,060.00
111,560.00
227,134.67 224,955.53 222,962.87 219.625.40
12760 119,000.00
13390
112120
26,149.60
1,158.33
834.33
2,179.13
1,158.33
834.33
2,179.13
217,632.73
July
August
112,050.00 110,891.67
105,769.20 104,934.87
217,819.20 215,826.53
1,158.33
834.33
2,179.13
1,158.33
834.33
2,179.13
215,640.07 213,647.40
September October
November December
109,733.33 108,575.00 107,416.67 106,258.33
104,100.53 103,266.20 102,431.87 101,597.53
213,833.87 211,841.20 209,848.53 207,855.87
1,158.33
834.33
2,179.13
1,158.33
834.33
2,179.13
1,158.33
834.33
2,179.13
1,158.33
834.33
2,179.13
211,654.73 209,662.07 207,669.40 205.676.73
Transcribed Image Text:Note XX. Property, Plant & Equipment Furniture & Fixtures - Net Machineries and Equipment - Net Total Property Plant, and Equipment Note 10 Property, Plant, and Equipment Furniture & Fixtures Machineries and Equipment Total Cost Accumulated Depreciation - Furniture and Fixtures Accumulated Depreciation - Machineries and Equipment Total Accumulated Depreciation Total Property Plant, and Equipment - Net Year 1 105,100.00 102,108.00 207,208.00 January 1,158.33 June February March April May 119,000.00 117,841.67 116,683.33 115,525.00 114,366.67 113,208.33 112,120.00 111.285.67 110,451.33 109,617.00 107,437.87 106,603.53 231,120.00 229,127.33 227,134.67 225,142.00 221,804.53 219,811.87 834.33 1,992.67 229.127.33 Year 2 91,200.00 92,096.00 183,296.00 159,384.00 Year 3 Year 4 77,300.00 63,400.00 82,084.00 72,072.00 135,472.00 1,158.33 F&F M&E 834.33 1,992.67 1,158.33 AD 834.33 2,179.13 1,158.33 Cost 834.33 2,179.13 Year 5 49,500.00 62,060.00 111,560.00 227,134.67 224,955.53 222,962.87 219.625.40 12760 119,000.00 13390 112120 26,149.60 1,158.33 834.33 2,179.13 1,158.33 834.33 2,179.13 217,632.73 July August 112,050.00 110,891.67 105,769.20 104,934.87 217,819.20 215,826.53 1,158.33 834.33 2,179.13 1,158.33 834.33 2,179.13 215,640.07 213,647.40 September October November December 109,733.33 108,575.00 107,416.67 106,258.33 104,100.53 103,266.20 102,431.87 101,597.53 213,833.87 211,841.20 209,848.53 207,855.87 1,158.33 834.33 2,179.13 1,158.33 834.33 2,179.13 1,158.33 834.33 2,179.13 1,158.33 834.33 2,179.13 211,654.73 209,662.07 207,669.40 205.676.73
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Accounting for Property, Plant and Equipment
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