Do the following question I can pay for additional question after you did that one Could you Arrange the trial balances given in Raw Data and displaying them side by side on the same page When doing this, please pull the data from the raw trial balances with excel formulas 2014 Trial Balance Account Code Debit Credit Debit Balance Credit Balance 100 117,112 98 101,986 19 15,126 79 0 00 101 7,331,264 95 6,010,308 20 1,320,956 75 0 00 102 191,398,862 79 187,949,954 40 3,448,908 39 0 00 108 711,593 21 592,045 68 119,547 53 0 00 120 58,362,795 81 45,011,885 88 13,499,857 37 148,947 43 121 698,589 41 698,589 41 0 00 0 00 136 312,179 47 294,997 74 17,181 73 0 00 153 30,444,571 27 30,008,832 30 440,738 97 0 00 180 200,450 03 144,322 94 56,127 10 0 00 181 10,492 21 5,017 85 5,474 36 0 00 191 5,126,042 51 5,126,042 51 0 00 0 00 192 13,013 97 12,345 72 668 25 0 00 193 362,827 33 82,839 90 279,987 43 0 00 195 1,500 00 0 00 1,500 00 0 00 196 26,725 00 7,500 00 19,225 00 0 00 226 1,660 19 0 00 1,660 19 0 00 254 45,033 22 0 00 45,033 22 0 00 255 974,229 29 0 00 974,229 29 0 00 257 0 00 665,241 20 0 00 665,241 20 264 11,942 02 0 00 11,942 02 0 00 268 0 00 10,210 12 0 00 10,210 12 280 72,279 57 0 00 72,279 57 0 00 296 84,000 00 0 00 84,000 00 0 00 300 5,882,248 85 6,058,208 85 0 00 175,960 00 309 19,394 72 20,623 39 0 00 1,228 68 320 30,390,584 78 41,000,344 59 20,453 57 10,630,213 39 321 0 00 756,628 00 0 00 756,628 00 331 881,973 79 881,973 79 0 00 0 00 335 811,951 34 876,436 80 0 00 64,485 47 360 4,987,108 14 7,081,183 93 0 00 2,094,075 79 361 404,989 43 436,076 62 0 00 31,087 19 368 6,570 91 45,996 13 0 00 39,425 22 370 258,047 97 258,047 97 0 00 0 00 371 258,047 97 258,047 97 0 00 0 00 373 1,272,812 72 2,153,838 80 0 00 881,026 08 380 44,980 00 44,980 00 0 00 0 00 391 9,794,630 80 9,794,630 80 0 00 0 00 392 12,345 72 13,013 97 0 00 668 25 438 0 00 72,279 57 0 00 72,279 57 500 0 00 1,272,501 50 0 00 1,272,501 50 540 0 00 233,243 21 0 00 233,243 21 549 0 00 595,991 25 0 00 595,991 25 570 949,671 89 2,325,367 14 0 00 1,375,695 26 590 1,027,289 08 1,027,289 08 0 00 0 00 600 0 00 32,596,060 98 0 00 32,596,060 98 600 01 0 00 31,948,206 31 0 00 31,948,206 31 600 02 0 00 647,854 67 0 00 647,854 67 601 0 00 108,475 24 0 00 108,475 24 601 01 0 00 104,548 04 0 00 104,548 04 601 02 0 00 3,927 20 0 00 3,927 20 602 0 00 125,203 67 0 00 125,203 67 610 86,605 79 9,114 47 77,491 32 0 00 621 29,098,113 98 188,167 32 28,909,946 67 0 00 642 0 00 37,231 30 0 00 37,231 30 646 311 79 1,169,186 76 0 00 1,168,874 97 653 43,615 00 65 65 43,549 35 0 00 656 1,359,128 76 0 11 1,359,128 65 0 00 679 0 00 68,629 21 0 00 68,629 21 689 13,947 20 0 01 13,947 19 0 00 760 570,962 09 0 00 570,962 09 0 00 760 01 488,530 62 0 00 488,530 62 0 00 760 02 82,431 48 0 00 82,431 48 0 00 770 1,760,622 20 50,322 38 1,710,299 82 0 00 770 01 874,800 28 0 00 874,800 28 0 00 770 03 11,264 26 0 00 11,264 26 0 00 770 04 247,297 89 8,676 18 238,621 71 0 00 770 05 135,124 59 279 76 134,844 84 0 00 770 06 122,237 11 0 00 122,237 11 0 00 770 07 155,982 10 0 00 155,982 10 0 00 770 08 20,374 03 0 00 20,374 03 0 00 770 09 7,401 32 2,296 76 5,104 57 0 00 770 10 186,140 64 39,069 69 147,070 95 0 00 780 33,316 70 156 37 33,160 34 0 00 780 01 33,316 70 156 37 33,160 34 0 00 2015 Trial Balance Account Code Debit Credit Debit Balance Credit Balance 100 83,999 30 55,699 05 28,300 25 0 00 101 10,201,917 26 8,850,069 06 1,351,848 20 0 00 102 378,698,599 71 376,294,482 86 2,404,116 85 0 00 108 980,347 15 834,907 14 145,440 01 0 00 120 69,346,240 36 47,688,955 06 22,526,254 32 868,969 02 121 479,203 62 479,203 62 0 00 0 00 136 555,550 52 538,211 51 17,339 01 0 00 153 43,853,518 43 41,587,413 41 2,266,105 03 0 00 180 293,742 44 219,358 04 74,384 40 0 00 181 11,019 73 5,474 36 5,545 37 0 00 191 6,789,705 10 6,789,705 10 0 00 0 00 192 20,344 37 15,746 79 4,597 58 0 00 193 712,706 09 268,236 89 444,469 21 0 00 195 1,500 00 0 00 1,500 00 0 00 196 19,225 00 19,225 00 0 00 0 00 226 1,660 19 0 00 1,660 19 0 00 254 45,033 22 13,512 55 31,520 67 0 00 255 1,014,536 62 0 00 1,014,536 62 0 00 257 13,512 55 771,250 36 0 00 757,737 81 264 11,942 02 0 00 11,942 02 0 00 268 518 43 12,013 18 0 00 11,494 75 280 72,279 57 72,279 57 0 00 0 00 296 84,000 00 0 00 84,000 00 0 00 300 7,537,070 78 7,587,070 78 0 00 50,000 00 309 48,280 67 49,072 04 0 00 791 37 320 37,915,269 68 56,860,924 50 933,454 75 19,879,109 56 321 791,939 52 858,428 44 0 00 66,488 92 331 797,945 49 797,945 49 0 00 0 00 335 837,966 53 890,746 24 1,279 49 54,059 21 360 6,007,270 81 9,075,395 05 0 00 3,068,124 24 361 389,940 51 424,855 06 0 00 34,914 55 368 39,425 53 111,705 10 0 00 72,279 57 370 279,987 43 279,987 43 0 00 0 00 371 279,987 43 279,987 43 0 00 0 00 373 3,260,576 46 3,778,418 19 0 00 517,841 73 391 12,994,342 45 12,994,342 45 0 00 0 00 392 15,746 79 20,344 37 0 00 4,597 58 438 72,279 57 72,279 57 0 00 0 00 500 0 00 1,272,501 50 0 00 1,272,501 50 540 0 00 370,573 54 0 00 370,573 54 549 0 00 595,991 25 0 00 595,991 25 570 939,227 26 2,481,697 77 0 00 1,542,470 51 590 1,106,002 51 1,106,002 51 0 00 0 00 600 0 00 43,676,029 15 0 00 43,676,029 15 600 01 0 00 42,534,329 14 0 00 42,534,329 14 600 02 0 00 1,141,700 01 0 00 1,141,700 01 601 0 00 151,816 13 0 00 151,816 13 601 01 0 00 140,027 29 0 00 140,027 29 601 02 0 00 11,788 84 0 00 11,788 84 602 0 00 109,785 55 0 00 109,785 55 610 800,680 08 0 00 800,680 08 0 00 621 39,674,683 57 1,288,791 37 38,385,892 21 0 00 642 0 00 164,844 36 0 00 164,844 36 646 0 00 1,156,815 70 0 00 1,156,815 70 653 136,417 34 497 57 135,919 78 0 00 656 1,443,845 19 32,444 81 1,411,400 39 0 00 679 32 80 84,232 33 0 00 84,199 53 689 41,997 20 0 00 41,997 20 0 00 760 555,247 26 4,715 60 550,531 66 0 00 760 01 435,280 84 0 00 435,280 84 0 00 760 02 119,966 42 4,715 60 115,250 82 0 00 770 1,833,693 15 3,999 89 1,829,693 26 0 00 770 01 905,158 52 0 00 905,158 52 0 00 770 03 26,788 92 325 84 26,463 08 0 00 770 04 280,092 48 317 48 279,775 00 0 00 770 05 151,400 56 206 15 151,194 41 0 00 770 06 128,589 53 0 00 128,589 53 0 00 770 07 128,158 95 0 00 128,158 95 0 00 770 08 18,880 33 0 00 18,880 33 0 00 770 09 14,196 88 3,150 42 11,046 46 0 00 770 10 180,426 99 0 00 180,426 99 0 00 780 8,159 32 1,132 30 7,027 02 0 00

The Answer is in the image, click to view ...

Question: Do the following question. I can pay for additional question after you did that one. Could you Arrange the trial balances given in Raw Data

Do the following question. I can pay for additional question after you did that one.

Could you Arrange the trial balances given in Raw Data and displaying them side by side on the same page. When doing this, please pull the data from the raw trial balances with excel formulas.

2014 Trial Balance
Account Code	Debit	Credit	Debit Balance	Credit Balance
100	117,112.98	101,986.19	15,126.79	0.00
101	7,331,264.95	6,010,308.20	1,320,956.75	0.00
102	191,398,862.79	187,949,954.40	3,448,908.39	0.00
108	711,593.21	592,045.68	119,547.53	0.00
120	58,362,795.81	45,011,885.88	13,499,857.37	148,947.43
121	698,589.41	698,589.41	0.00	0.00
136	312,179.47	294,997.74	17,181.73	0.00
153	30,444,571.27	30,008,832.30	440,738.97	0.00
180	200,450.03	144,322.94	56,127.10	0.00
181	10,492.21	5,017.85	5,474.36	0.00
191	5,126,042.51	5,126,042.51	0.00	0.00
192	13,013.97	12,345.72	668.25	0.00
193	362,827.33	82,839.90	279,987.43	0.00
195	1,500.00	0.00	1,500.00	0.00
196	26,725.00	7,500.00	19,225.00	0.00
226	1,660.19	0.00	1,660.19	0.00
254	45,033.22	0.00	45,033.22	0.00
255	974,229.29	0.00	974,229.29	0.00
257	0.00	665,241.20	0.00	665,241.20
264	11,942.02	0.00	11,942.02	0.00
268	0.00	10,210.12	0.00	10,210.12
280	72,279.57	0.00	72,279.57	0.00
296	84,000.00	0.00	84,000.00	0.00
300	5,882,248.85	6,058,208.85	0.00	175,960.00
309	19,394.72	20,623.39	0.00	1,228.68
320	30,390,584.78	41,000,344.59	20,453.57	10,630,213.39
321	0.00	756,628.00	0.00	756,628.00
331	881,973.79	881,973.79	0.00	0.00
335	811,951.34	876,436.80	0.00	64,485.47
360	4,987,108.14	7,081,183.93	0.00	2,094,075.79
361	404,989.43	436,076.62	0.00	31,087.19
368	6,570.91	45,996.13	0.00	39,425.22
370	258,047.97	258,047.97	0.00	0.00
371	258,047.97	258,047.97	0.00	0.00
373	1,272,812.72	2,153,838.80	0.00	881,026.08
380	44,980.00	44,980.00	0.00	0.00
391	9,794,630.80	9,794,630.80	0.00	0.00
392	12,345.72	13,013.97	0.00	668.25
438	0.00	72,279.57	0.00	72,279.57
500	0.00	1,272,501.50	0.00	1,272,501.50
540	0.00	233,243.21	0.00	233,243.21
549	0.00	595,991.25	0.00	595,991.25
570	949,671.89	2,325,367.14	0.00	1,375,695.26
590	1,027,289.08	1,027,289.08	0.00	0.00
600	0.00	32,596,060.98	0.00	32,596,060.98
600.01	0.00	31,948,206.31	0.00	31,948,206.31
600.02	0.00	647,854.67	0.00	647,854.67
601	0.00	108,475.24	0.00	108,475.24
601.01	0.00	104,548.04	0.00	104,548.04
601.02	0.00	3,927.20	0.00	3,927.20
602	0.00	125,203.67	0.00	125,203.67
610	86,605.79	9,114.47	77,491.32	0.00
621	29,098,113.98	188,167.32	28,909,946.67	0.00
642	0.00	37,231.30	0.00	37,231.30
646	311.79	1,169,186.76	0.00	1,168,874.97
653	43,615.00	65.65	43,549.35	0.00
656	1,359,128.76	0.11	1,359,128.65	0.00
679	0.00	68,629.21	0.00	68,629.21
689	13,947.20	0.01	13,947.19	0.00
760	570,962.09	0.00	570,962.09	0.00
760.01	488,530.62	0.00	488,530.62	0.00
760.02	82,431.48	0.00	82,431.48	0.00
770	1,760,622.20	50,322.38	1,710,299.82	0.00
770.01	874,800.28	0.00	874,800.28	0.00
770.03	11,264.26	0.00	11,264.26	0.00
770.04	247,297.89	8,676.18	238,621.71	0.00
770.05	135,124.59	279.76	134,844.84	0.00
770.06	122,237.11	0.00	122,237.11	0.00
770.07	155,982.10	0.00	155,982.10	0.00
770.08	20,374.03	0.00	20,374.03	0.00
770.09	7,401.32	2,296.76	5,104.57	0.00
770.10	186,140.64	39,069.69	147,070.95	0.00
780	33,316.70	156.37	33,160.34	0.00
780.01	33,316.70	156.37	33,160.34	0.00

2015 Trial Balance
Account Code	Debit	Credit	Debit Balance	Credit Balance
100	83,999.30	55,699.05	28,300.25	0.00
101	10,201,917.26	8,850,069.06	1,351,848.20	0.00
102	378,698,599.71	376,294,482.86	2,404,116.85	0.00
108	980,347.15	834,907.14	145,440.01	0.00
120	69,346,240.36	47,688,955.06	22,526,254.32	868,969.02
121	479,203.62	479,203.62	0.00	0.00
136	555,550.52	538,211.51	17,339.01	0.00
153	43,853,518.43	41,587,413.41	2,266,105.03	0.00
180	293,742.44	219,358.04	74,384.40	0.00
181	11,019.73	5,474.36	5,545.37	0.00
191	6,789,705.10	6,789,705.10	0.00	0.00
192	20,344.37	15,746.79	4,597.58	0.00
193	712,706.09	268,236.89	444,469.21	0.00
195	1,500.00	0.00	1,500.00	0.00
196	19,225.00	19,225.00	0.00	0.00
226	1,660.19	0.00	1,660.19	0.00
254	45,033.22	13,512.55	31,520.67	0.00
255	1,014,536.62	0.00	1,014,536.62	0.00
257	13,512.55	771,250.36	0.00	757,737.81
264	11,942.02	0.00	11,942.02	0.00
268	518.43	12,013.18	0.00	11,494.75
280	72,279.57	72,279.57	0.00	0.00
296	84,000.00	0.00	84,000.00	0.00
300	7,537,070.78	7,587,070.78	0.00	50,000.00
309	48,280.67	49,072.04	0.00	791.37
320	37,915,269.68	56,860,924.50	933,454.75	19,879,109.56
321	791,939.52	858,428.44	0.00	66,488.92
331	797,945.49	797,945.49	0.00	0.00
335	837,966.53	890,746.24	1,279.49	54,059.21
360	6,007,270.81	9,075,395.05	0.00	3,068,124.24
361	389,940.51	424,855.06	0.00	34,914.55
368	39,425.53	111,705.10	0.00	72,279.57
370	279,987.43	279,987.43	0.00	0.00
371	279,987.43	279,987.43	0.00	0.00
373	3,260,576.46	3,778,418.19	0.00	517,841.73
391	12,994,342.45	12,994,342.45	0.00	0.00
392	15,746.79	20,344.37	0.00	4,597.58
438	72,279.57	72,279.57	0.00	0.00
500	0.00	1,272,501.50	0.00	1,272,501.50
540	0.00	370,573.54	0.00	370,573.54
549	0.00	595,991.25	0.00	595,991.25
570	939,227.26	2,481,697.77	0.00	1,542,470.51
590	1,106,002.51	1,106,002.51	0.00	0.00
600	0.00	43,676,029.15	0.00	43,676,029.15
600.01	0.00	42,534,329.14	0.00	42,534,329.14
600.02	0.00	1,141,700.01	0.00	1,141,700.01
601	0.00	151,816.13	0.00	151,816.13
601.01	0.00	140,027.29	0.00	140,027.29
601.02	0.00	11,788.84	0.00	11,788.84
602	0.00	109,785.55	0.00	109,785.55
610	800,680.08	0.00	800,680.08	0.00
621	39,674,683.57	1,288,791.37	38,385,892.21	0.00
642	0.00	164,844.36	0.00	164,844.36
646	0.00	1,156,815.70	0.00	1,156,815.70
653	136,417.34	497.57	135,919.78	0.00
656	1,443,845.19	32,444.81	1,411,400.39	0.00
679	32.80	84,232.33	0.00	84,199.53
689	41,997.20	0.00	41,997.20	0.00
760	555,247.26	4,715.60	550,531.66	0.00
760.01	435,280.84	0.00	435,280.84	0.00
760.02	119,966.42	4,715.60	115,250.82	0.00
770	1,833,693.15	3,999.89	1,829,693.26	0.00
770.01	905,158.52	0.00	905,158.52	0.00
770.03	26,788.92	325.84	26,463.08	0.00
770.04	280,092.48	317.48	279,775.00	0.00
770.05	151,400.56	206.15	151,194.41	0.00
770.06	128,589.53	0.00	128,589.53	0.00
770.07	128,158.95	0.00	128,158.95	0.00
770.08	18,880.33	0.00	18,880.33	0.00
770.09	14,196.88	3,150.42	11,046.46	0.00
770.10	180,426.99	0.00	180,426.99	0.00
780	8,159.32	1,132.30	7,027.02	0.00

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!

Center for Learning and Technology COURSE SYLLABUS PRINCIPLES OF STATISTICS STA-201-GS Course Syllabus PRINCIPLES OF STATISTICS STA-201-GS Thomas Edison State College May 2015 Course Essentials...

Please solve the following question using excel commands like solver, Analytic Solver, or sensitivity analysis. 5. Reconsider the model given in Problem 5.2. While doing what-if analysis, you learn...

499 Everyone Knows the Game: Legal Consciousness in the Hawaiian Cockfight Kathryne M. Young Past legal consciousness research has revealed a great deal about what individuals think and do with...

I have attached both the chapters from which you will be answering the following question. Ch 8 (p 387 of text or p 35 of the pdf) ?Exercise D. Prepare the bank reconciliation and any required...

Using the following attached reading titled "An Institutional Explanation of the Democratic Peace by Bruce Bueno de Mesquita, James D. Morrow, Randolph M. Siverson and Alastair Smith compose a paper...

I would like someone to look over my project. I am unsure about the unearned revenue portion. Also, I think the net income should be the retained earning but I can't balance...Either A. I am off...

Hi, please Ihave this project to do as soon as possible. Could you help me? Thank you! Instructions to ACCT4112 Project: Accounting Data Analyses 1. From the \"Project\" section of the Content...

I have a attached a copy of the data used to answer the question Prepare a 2007 classified balance sheet and multistep income statement. Use the account balances from the unadjusted trial balance and...

ATTENTION TUTORS PLEASE HELP ME IN ANSWERING THIS ATTACHMENT WORKSHEET I NEED IT FOR CLASS IN ACCOUNTING THANK YOU HAVE THE ANSWERS IN YELLOW PLEASE SEE ATTACHMENT Question 1 of 15 1. A small...

Attijari Wafa Bank distributed on May 2022 a dividend per share of 5 MAD / share. The company is planning to have next 3 years a growth rate of 5% then after 7%. If the required rate of return is 12%...

3. The formula for flow through a randomly packed bed of spheres is given by Ergun's equation 150(1 - )?,, 1.75 (1- )? H zP Where : Ap is the pressure drop across the bed, H is the length of the bed...

smith agrees with her computation but says the credit entry should be directly to the equipment account. smith argues that while accumulated depreciation is technically correct, it is less hassle not...

You are required to identify and select a project that you have worked on , whether as a project manager or project team member. If you have not worked on a project before or you are unable to select...

Appreciate the rationale for having a human resources department.

Describe or formulate the mission of a human resources department or area in a healthcare organization.

What are some global employee and labor relations problems?