Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Gabel School Balance Sheet AS of September 30, 2019 30 - SEP - 19 ASSETS Current Assets Checking / Savings* 1 . Bank Accounts 1016

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
Gabel School Balance Sheet AS of September 30, 2019 30 - SEP - 19 ASSETS Current Assets Checking / Savings* 1 . Bank Accounts 1016 . Money Market 195, 411 .93\\ 1020 . Operating* 949 , 258 . 2 1025 . Fire Account* 231 , 253. 85 1081 . Petty Cash Office 1 , 527. 00 1082 . Petty Cash 1 , 700.00 Total 1 . Bank Accounts 1, 3.80, 251. 00 Total Checking / Savings* 1 , 3.80, 251. 00 Accounts Receivable* 2. Receivables 1100 . Accounts Receivable 83, 510.60 Total 2 . Receivables* 83 , 510.50 Total Accounts Receivable* 83, 610.50 Other Current Assets 3 . MorganStanley Smith Barney Accts* 1091 . General Investment 1 , 588, 754. 10 1503 . Fundraise - Restrict Donate* 471 . 35 Total 3 . Morganstanley Smith Barney Accts 1, 589, 225. 58 4. Prepaid Insurance* 1340 . Insurance - Prepaid 32, 988, 20 Total 4 . Prepaid Insurance* 32, 988 . 20 Total Other Current Assets 1 , 522 , 213. 78 Total Current Assets 3, 085 , 075 . 38 Fixed Assets* 5 . Depreciation 1612 . Accum Dept - Computer System -152 , 887 . 54 1614 . Accum Dept - Soccer Field -41 , 085 . 70 1517 . Accum Dept - New Acad BIde 280, 377 . 25 1619 . Accum Depr - 73. Maple St - 84 , 176. 75 1620 . Accum Dept - Education Elder* - 141 , 591. 51 1623 . Accum DEPT - Climbing Wall - 15 , 171 .00 1630 . Accum Dept - Leased Land Imp 3.35 , 120. 05 163.3 . Accum Dept - Sports Complex* -22, 280. 64 1640 . Accum DepT - Creative Arts* - 188 , 577 . 04 1650 . Accum Dept - Gym\\ -225 , 319.98 1650 . Accum DepT - Motor Vehicles - 3.48 , 168. 17 1670 . Accum DEPT - Furniture & Fix 258, 422.05 1672 . Accum Dept - Skate Park* - 4 , 159. 31 1680 . Accum DEPT - Leased BidE Imp* 820, 716. 53 1700 . Accum DEPT - Phone System - 4, 481 . 90 1711 . Depreciation - Dorm -40, 598. 23 Total 6 . Depreciation - 2, 974 , 3:34. 71 7. Assets1610 . Land 53, 3:44. 00 1611 . Computer System 170 , 360. 47\\ 1613 . Soccer Field 47, 485. 80 1615 . Educational EldE 215 , 450. 88 1515 . New Education BIde* 671 , 352.60 1618 . 73. Maple Street $76, 598. 40 1622 . Climbing Wall 15 , 171 .00 1625 . Leased Land Improvements 535 , 559. 44 1632 . Sports Complex 250 , 435.52 1635 . Creative Arts 31 1 , 3.3.4. 30 1645 . Gymnasium 3.02 , 838 . 10 1655 . Motor Vehicles 3.85, 097 . 03 1565 . Furniture & Fixtures $13 , 819. 35 1671 . Skate Park 13 , 441 . 81 1675 . Leased EldE Improvements 1 , 248 , 715. 85 1595 . Capitalized Phone* 5 , 981 . 98 1710 . Dorm New 730, 852. 27 Total 7 . Assets 5 , 558 , 960. 85 Total Fixed Assets 2, 584, 625.15 Other Assets* 8. Assets - Other 1800 . Endowment Fund 5.41 , 019.57 Total 8 . Assets - Other 6:41 , 019.57 Total Other Assets 5.41 , 019.57 TOTAL ASSETS 6 , 3.11 , 721 . 10 LIABILITIES & EQUITY* Liabilities Current Liabilities Accounts Payable* 2140 . Accounts Payable* 42, 286. 01 Total Accounts Payable* 42, 286. 01 credit Cards* 9 . Credit Cards 1900 . Bank of America 3 , 278. 95 1901 . American Express 15 , 052 . 24 Total 9 . Credit Cards* 18, 3:31 . 19 Total Credit Cards* 18, 3.31 . 19 Other Current Liabilities 10 . Accruals 2363 . Accrued Compensated Balance 47 , 102.50 Total 10 . Accruals 47 , 102. 60 11 . Clearing 2400 . Student clearing account 8, 908. 04 2449 . ERLaundry\\ 4, 712. 23 2506 . School Store Clearing* 2, 083 . 10 2728 . Or . Bermingham* 3.3, 500.00 2729 . Due to Or . Bermingham 16 , 8:00 . 00 2801 . Miscellaneous Clearing Account 16 , 531 . 40 Total 11 . Clearing* 45 , 305 . 7713 . Payroll Deductions* 2100 . Health Insurance 2, 8.83. 20 21002 . Acc1 25 67 .44 2102 . 403 8. 3 , 3:48. 48 $105 . Dental Insurance - 2. 17 21050 . Cancer 48.42 21051 . Critill! 15. 12 2108 . STD 46.09 2109 . Life Insurance 48. 84 2110 . 401 K - 82.40 13 . Payroll Deductions - Other 3.45. 17 Total 13 . Payroll Deductions* 259. 85 2450 . Tuition Paid in Advance* 5.48 , 178 . 28 2500 . 401 K Employer Contribution - 4, 517 . 11 Total Other Current Liabilities 5.35 , 229. 39 Total Current Liabilities 595, 846.59 Long Term Liabilities 14 . Loans ( LTL ) 2005 Ford Van Loan 598. 88 2013 . 2013 Volvo Loan 14 , 811.50 2150 . Mortgage 187 , 841 . 32 2727 . Nissan Loan 150. 74 Total 14 . Loans ( LTL ) 203, 502. 44 Total Long Term Liabilities 203 , 502.44 Total Liabilities 9.00 , 3.49. 03 Equity 15 . Equity Accounts 3.000 . Fund Balance ( Central) 1 , 920, 351.00 3.010 . Unrestricted - Not Designated 2, 347 , 282. 17 3:035 . Designated Stabilization* 3.74 , 224 . 00 3150 . Endowment Fund Balance 451, 515. 00 Total 15 . Equity Accounts 5 , 093 , 3.8:3. 17 3:020 . Unrestricted Net Assets 1, 076 , 601 . 75 Net Income* - 758 , 512. 86 Total Equity* 5 , 411 , 372.07 TOTAL LIABILITIES & EQUITY 5 , 3:11 , 721 . 10Gabel School Profit & Loss July through September 2019 Ordinary Income / Expense Income* 16 . Income* 4000 . Contributions 7, 500. 00 4090 . Tuition 398, 497. 61 1405 . Rental 300. 00 5001 . Uncategorized Income 2 , 981 , 648.35 Total 16 . Income* 3 , 387 , 945 . 96 9100 . Investments Incr / Decr - General - 48 , 964.92 9101 . Invest Incr / Decr - Fund Raising 451 , 821. 98 9102 . Invest Incr / Decr - Endowment -24 , 823.82 9400 . Interest - Fund Raising* 1 , 512.95 9401 . Dividends - Endowment 670. 86 9402 . Gain / Loss Fundraising* 27 , 901 . 33 9500 . Interest - Endowment* 2 , 827 .76 9501 . Dividends - Endowment 559. 99 9600 . Interest - Unrestricted 9 , 743.86 9601 . Dividends - Unrestricted* 2 , 517 . 63 9602 . Gain / Loss - General / unrestricted 6 , 053.64 Total Income* 2 , 914 , 123 . 26 Expense* 17 . Administrative Expenses Fire 2 , 958 , 564. 94 5120 . Office Supplies 3 , 138.54 5130 . Accounting Fees 1 , 237 .50 513.3 . Credit Card Fees 3 , 169.81 5141 . Advertising* 3, 064. 22 51421 . Interest Expense 1 , 834. 65 5146 . Conferences 2 , 651. 39 5148 . Postage Expense 1 , 482.76 5149 . 401 K Administration costs 0. 00 5151 . Depreciation Expense* 42 , 252.45 51561 . Interest - 2006 Ford Van Loan 109 . 17 51562 . Interest 2013 Volvo Loan 164. 96 5160 . Graduation* 36.46 5162 . Miscellaneous 368.41 5163 . Reconciliation Discrepancies 0 . 10 5165 . Uncategorized Expense* 1 , 383. 06 5166 . Unemployment* 481 . 20 5170 . Mileage Reimbursement 97. 00 5171 . Bank Service Charges 97. 00 5359 . Rent* 22, 50,0.00 8000 . Overseas Travel 300. 00 8010 . Parents Weekend 96.53 8013 . Reimbursements 155. 00 8:014 . Additional Help - Temp Service 7, 970.63Total 17. Administrative Expenses 3,051,155.78 18. Empoyee Health Insurance 5113 . AdministrationHealth Insurance 6,070.09 5114 . Housekeeping Health Insurance 1,422.14 51141 . Kitchen Health Insurance 1,419.26 5117 . Nurse Health Insurance 785.46 5118 . Program Health Insurance 7,616.74 5119 . Teachers Health Insurance 4,088.90 Total 18. Employee Health Insurance 21,402.59 19. Employee Payroll 5110 . Administration Salaries 98,512.85 51101 . Housekeeping Salaries 21,406.70 51102 . Kitchen Salaries 24,634.97 51103 . Maintenance Salaries 14,827.50 51104 . Nurse Salary 14,807.66 51105 . Program Salaries 168,567.81 51106 . Teacher Salaries 105,846.85 51107 . Tutoring 2,120.00 51108 . Vision Payroll Fee 836.95 Total 19. Employee Payroll 451,561.29 20. Fica [Federal Insurance Contributions Act, e.g. social secruity) Expense 5112 . Administration Fica Expense 7,259.78 51121 . Housekeeping Fica Expense 1,566.66 51122 . Kitchen Fica Expense 1,825.06 51123 . Maintenance Fica Expense 1,134.31 51124 . Nurse Fica Expense 1,087.81 51125 . Program Fica Expense 12,695.65 51126 . Teachers Fica Expense 7,939.54 51127 . MA Health Expense 180.33 Total 20. Fica Expense 33,689.14 21. Housekeeping 5400 . Equipment 272.56 5401 . Supplies 2,970.50 5402 . Additional Staff 1,232.00 Total 21. Housekeeping 4,475.06 22. Insurance 5115 . Workmans Comp Insurance 9,398.73 53453 . Homeowners Insurance 2,525.00 53456 . Umbrella Insurance 300.00 Total 22. Insurance 12,223.73 23. Kitchen 52001 . Food 6,968.33 520011 . Snack 2,413.12 52002 . Miscellaneous 66.55 52005 . Supplies 5,339.01 52006 . Tool Maintenance 114.13 52007 . Additional Help 286.86 Total 23. Kitchen 15,188.00 24. Medical Expenses 5523 . Consulting Psyciatrist Total 24. Medical Expenses 25. Nursing Expenses 5520 . Medical Supplies 5521 . Miscellaneous Total 25 . Nursing Expenses 26. Program 5224 . Meals off campus 5424 . Laundry 5726. Sports Expenses 5822. Equipment Maintenance 5826 . Student Work Account 5828 . Experiential 58281 . Recreation 5842 . Airport Travel 6180 . Merit Ratings 6181 . Newspapers 6182 . Petty cash overfunder 6183 . Staff AdmissionsfSoda 6184. Staff Training 6185 . Supplies 6791 . Miscellaneous 6792 . Travel to appointments Total 26. Program 2?. Repairs and Maintenance 5320. Building Maintenance Supplies 5363 . Grounds Maintenance 53631 . Heating System Maintenance 5366 . Trash 5367 . Exterminator 5368 . Contractor Fees Total 27. Repairs and Maintenance 28. Taxes 5250 . Real Estate Taxes Total 28. Taxes 29. Teaching Expenses Curriculum 5718 . Testing 5720 . Supplies 5724 . Books 57251 . Summer Program Total 29. Teaching Expenses 30. Utilities 5140 . Telephone 5360 . Heating Oil 5361 . Electricity 5362 . Water 5364 . Sewer 5365 . Gas 5369 . Water Heater Rental 780.00 780.00 322.06 105.98 428.04 607.87 61.98 1,238.68 1,587.24 2,294.04 14,921.12 2,770.73 227.81 188.00 180.89 6.24 144.40 461.90 283.75 100.00 25.00 25,087.17 2,935.65 3,423.07 556.50 2,253.40 344.85 9,753.99 19,267.46 7,651.28 7,651.28 0.00 1,580.00 2,134.56 2,316.41 695.97 6,726.94 4,556.50 1,716.98 6,857.56 2,819.69 736.59 636.87 24.40 30. Utilities Other Total 30. Utilities 31. Vehicle Expense 5154 . Gas Vans 5159 . Fastlane 5855 . Maintenance Vans 58551. Maintenance Total 31. Vehicle Expense Total Expense Net Ordinary Income Other Income.Expense Other Income 9200 . Interest Income Total Other Income Net Other Income Net Income 411.67 17,760.26 5,029.06 78.87 616.21 70.00 5,794.14 3,673,190.88 759,067.62 454.76 454.76 454.76 758,612.86 Gabel School Statement of Cash Flows July* through September 2019 Jul - SEP 19 OPERATING ACTIVITIES Net Income* -758, 512.85 Adjustments to reconcile Net Income to net cash provided by operations :" 2 . receivables : 1 100 . Accounts receivable* 4 4, 404. 57 3 . MorganStanley smith Barney Accts : 1091 . General Investment* 10 , 381 . 40 3 . MorganStanley smith Barney Accts : 1503 . Fundraise - Restrict Donate* 421 , 735. 84 2140 . Accounts Payable* 2 , 789. 43 9 . Credit Cards : 1900 . Bank ofAmerica -22 , 385.92 9 . Credit Cards : 1901 . American Express -3, 503. 51 11 . Clearing : 2400 . Student clearing account - 4 , 807 . 58 11 . Clearing : 2449 . ERLaundry -22 , 778.56 11 . Clearing : 2506 . School Store Clearing* - 575. 31 11 . Clearing : 2728 . Dr. Roger - 1, 400.00 11 . Clearing : 2801 . Miscellaneous Clearing Account -12, 574.47 13 . Payrol Deductions : 2100 . Health Insurance* - 1 , 41 1 . 12 13 . Payrol Deductions : 21002 . Acc1 25 67 .44 13 . Payrol Deductions : 2102 . 403 B 257 . 16 13 . Payrol Deductions : 2105 . Dental Insurance 0 . 22 13 . Payrol Deductions : 21050 . Cancer 48.42 13 . Payrol Deductions : 21051 . Critill 15 . 12 13 . Payrol Deductions : 2108 . STD 41 . 40 13 . Payrol Deductions : 2109 . Life Insurance 48. 84 13 . Payrol Deductions : 2110 . 401 K - 82.40 2450 . Tuition Paid in Advance* 103, 3:00. 45 2500 . 401 K Employer Contribution - 4, 517 . 11 Net cash provided by Operating Activities - 359, 3:29.89 INVESTING ACTIVITIES* 5. Depreciation : 1612 . Accum Dept - Computer System 1 , 7:03.55 6 . Depreciation : 1614 . Accum Dept - Soccer Field 581 .82 5 . Depreciation : 1617 . Accum Dept - New Acad BIde 4 , 844 . 15 6 . Depreciation : 1619 . Accum Dept - Staff BildE* 2, 095. 15 5 . Depreciation : 1620 . Accum Dept - Education BIde 1, 559. 20 6 . Depreciation : 1630 . Accum Dept - Leased Land Imp* 3 , 543.56 5 . Depreciation : 163.3 . Accum Dept - Sports Complex* 805. 32 5 . Depreciation : 1640 . Accum Dept - Creative Arts* 2, 343. 95 5 . Depreciation : 1650 . Accum Dept - Gym 1 , 355.54 6 . Depreciation : 1650 . Accum Dept - Motor Vehicles 7 , 255. 19 6 . Depreciation : 1670 . Accum Dept - Furniture & Fix 3, 440.52 6 . Depreciation : 1672 . Accum Dept - Skate Park* 299.97 6 . Depreciation : 1680 . Accum Dept - Leased Blog Imp* 7 , 428.15 6 . Depreciation : 1700 . Accum Dept - Phone System 80. 34 6 . Depreciation : 1711 . Depreciation - Dorm 4 , 584.95 8 . Assets - Other : 18:00 . Endowment Fund 21 , 436 . 07 Net cash provided by Investing Activities 5:3 , 5:88.52 FINANCING ACTIVITIES 14 . Loans ( LTL ) : 20:05 Ford Van Loan - 777.15 14 . Loans ( LTL ) : 2013 Volvo Loan 1 , 693. 52 14 . Loans ( LTL ) : 2150 . Mortgage* -2 , 298. 45 Net cash provided by Financing Activities - 4 , 759. 12 Net cash increase for period 3.0 0, 410.45 Cash at beginning of period 1 , 5.80 , 5,51.49 Cash at end of period 1 , 3.80 , 251 . 00

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

Step: 3

blur-text-image

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

Managerial Accounting Decision Making and Performance Management

Authors: Ray Proctor

4th edition

273764489, 978-0273764489

More Books

Students also viewed these Accounting questions

Question

4. What means will you use to achieve these values?

Answered: 1 week ago