I need help in creating a balance sheet and statement of cash flows from the...

70.2K

Verified Solution

Question

Accounting

I need help in creating a balance sheet and statement of cash flows from the following data:

Trail Balance Period: Sep 2014
GL Account Account Description Period OB Debit Credit Period CB
0-1020-000 Cash Disbursement Acct-- 165,745.78 4,911,305.44 (4,547,616.86) 529,434.36
0-1030-000 Payroll Checking Acct-- 23,960.65 2,239.84 (1,752.61) 24,447.88
0-1040-000 Petty Cash Fund-- 3,138.74 2,000.00 (3,709.17) 1,429.57
0-1110-000 Accounts Receivable - Trade-- 13,066,491.45 12,746,083.65 (12,240,457.82) 13,572,117.28
0-1120-000 Allowance for Doubtful Accts-- (105,705.34) - - (105,705.34)
0-1140-000 A/R - Employee Loan-- 5,585.00 50.00 (316.67) 5,318.33
0-1200-000 Inventory in Transit-- 254,034.47 425,359.91 (254,034.47) 425,359.91
0-1210-000 Raw Materials - QA-- 7,689,700.92 1,828,238.21 (2,318,036.93) 7,199,902.20
0-1220-000 Raw Materials - Main Production-- 4,898,111.96 362,949.24 (716,862.27) 4,544,198.93
0-1225-000 Raw Material - DMR-- 402,535.93 2,002,488.60 (2,102,304.10) 302,720.43
0-1230-000 Work In Process - Materials-- 1,772,614.24 5,120,995.45 (4,811,875.81) 2,081,733.88
0-1232-000 Work In Process - Labor-- 308,546.06 1,220,049.38 (1,194,584.45) 334,010.99
0-1234-000 Work In Process - Overhead-- 1,660,331.00 5,871,593.83 (5,783,529.62) 1,748,395.21
0-1236-000 Work In Process - SubContract-- 227,009.67 786,699.48 (758,502.34) 255,206.81
0-1240-000 Finished Goods - Assembly 1-- 1,462,498.05 2,461,568.50 (2,485,557.16) 1,438,509.39
0-1250-000 Finished Goods - Assembly 2-- 7,676,687.07 7,584,140.09 (8,295,669.27) 6,965,157.89
0-1310-000 Reserve - Excess & Obsolete Inventory-- (244,905.60) (97,387.19) (342,292.79)
0-1330-000 Reserve - Inventory Shrink-- (32,297.00) (32,297.00)
0-1410-000 Prepaid Liability Insurance-- 160,695.93 - (18,124.76) 142,571.17
0-1420-000 Prepaid Taxes-- 71,294.58 8,749.00 (14,681.80) 65,361.78
0-1430-000 Prepaid Workers Comp-- 48,400.25 - (4,228.75) 44,171.50
0-1450-000 Prepaid Vehicle Insurance-- (306.00) - (306.00) (612.00)
0-1470-000 Prepaid Deposits-- 138,604.09 30,139.98 (19,945.51) 148,798.56
0-1490-000 Prepaid Other-- 83,299.55 48,590.13 (28,921.00) 102,968.68
0-1700-000 Machinery & Equipment (M&E)-- 7,128,295.51 109,567.13 (1,740.50) 7,236,122.14
0-1710-000 Capitalized Tools-- 2,021,377.44 83,866.88 - 2,105,244.32
0-1720-000 Furniture & Fixtures (F&F)-- 989,779.42 - - 989,779.42
0-1730-000 Computers -- 4,543,701.77 100,006.23 - 4,643,708.00
0-1770-000 Leasehold Improvements (LI)-- 1,593,966.00 19,996.01 - 1,613,962.01
0-1790-000 Construction in Progress-- 345,880.08 70,969.44 (313,436.25) 103,413.27
0-1800-000 Accum Depreciation - M&E-- (3,455,263.42) 1,740.50 (61,541.33) (3,515,064.25)
0-1810-000 Accum Depreciation - Capitalized Tools-- (1,737,731.33) - (21,104.92) (1,758,836.25)
0-1820-000 Accum Depreciation - F&F-- (945,448.23) - (1,557.64) (947,005.87)
0-1830-000 Accum Depreciation - Computers-- (3,788,883.04) - (22,757.66) (3,811,640.70)
0-1870-000 Accum Depreciation - LI-- (2,482,338.05) - (697.26) (2,483,035.31)
0-1900-000 Patents -- 4,882,314.64 4,882,314.64
0-1910-000 Accum Amortization - Patents-- (961,406.21) - (21,443.70) (982,849.91)
0-1960-000 Goodwill-- 14,020,638.99 - - 14,020,638.99
0-2110-000 Accounts Payable - Trade-- (1,288,908.79) 2,617,584.00 (2,042,906.31) (714,231.10)
0-2120-000 Accrual - Receipt Not Invoiced--Trade (1,639,367.28) 2,970,171.68 (1,785,840.59) (455,036.19)
0-2130-000 Accrual - Utilities and Services-- (528,644.71) 438,787.43 (729,247.44) (819,104.72)
0-2310-000 Advances from Customers-- (558,552.13) 123,222.88 (275,896.12) (711,225.37)
0-2410-000 Accrued Payroll-- (498,756.46) 307,837.82 (425,213.80) (616,132.44)
0-2420-000 Accrued Vacation Pay-- (735,909.81) 106,057.72 (95,429.47) (725,281.56)
0-2430-000 Accrued Holiday Pay-- (19,936.39) 26,271.84 (26,000.00) (19,664.55)
0-2460-000 Accrued Sales Commission-- (77,950.56) 46,303.66 (52,981.34) (84,628.24)
0-2540-000 Accrued 401K Payables-- (90,198.68) 217,966.15 (211,913.88) (84,146.41)
0-2550-000 Accrued Employee Benefits-- (160,277.50) 453,913.44 (296,695.60) (3,059.66)
0-2560-000 Accrued Warranty Reserve-Short Term (269,412.23) - (18,585.63) (287,997.86)
0-2610-000 Notes Payable - Long Term (125,431.45) 18,956.37 (55,989.63) (162,464.71)
0-3100-000 Common Stock-- (105.44) (102.30) (207.74)
0-3200-000 Additional Paid in Capital (91,152.88) (88,694.10) (179,846.98)
0-3300-000 Beginning Retained Earnings-- (1,654,789.40) - (1,654,789.40)

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students