The URL can be used to link to this page

3.0.A SWCSR 11-18-20219/30/21 9/30/20 % Change Current Assets Checking/Savings - Wells Fargo Bank 421,493.27 518,670.17 Total Current Assets 421,493.27 518,670.17 Current Liabilities Payroll Liability (312.00) (312.00) Total Current Liabilities (312.00) (312.00) Opening Balance Equity 227,531.07 227,531.07 Retained Earnings 267,012.62 354,313.17 Net Income (72,738.42) (62,862.07) Total Equity 421,805.27 518,982.17 421,493.27 518,670.17 -18.70%Total Liabilities & Equity SWC4 Balance Sheet 9/30/2021 Assets Liabilities & Equity Equity SWC4 5-Year Comparison Profit & Loss Statement 2017 2018 2019 2020 2021 Actual Actual Actual Actual Through 09/30 Beginning Cash Balance 364,246 804,114 687,249 581,532 494,232 Income Franchise Fees (Charter)778,546 776,953 766,154 814,931 599,167 Franchise Fees (Other) Arvig 18,841 22,078 15,857 19,932 8,272 City of Big Lake 445 - - - City of Maple Lake 199 - - - City of Monticello 52,249 41,989 43,478 46,486 21,969 PEG Fees (Other) Reimbursed Expenses - 581 (74) 119,491 Total Income 850,279 841,601 825,414 1,000,839 *629,408 Expenses Administrative - - - 1,800 3,500 Automobile - - - - 9,363 Cable Service 10,200 11,508 7,837 7,435 7,991 Check Printing - - 249 - Contract Labor - All Cities 30,834 56,848 96,532 84,112 91,459 Big Lake 5,977 5,251 10,550 6,225 9,577 Buffalo 11,280 9,186 48,694 26,868 27,435 Channel 19 676 - - - Cokato 4,087 3,806 4,371 12,972 5,240 Dassel 2,477 2,085 2,139 - 6,815 Delano 7,509 5,226 9,787 5,635 6,447 Elk River 13,396 23,825 9,543 40,313 110,341 Maple Lake 3,538 3,406 7,168 3,082 3,261 Monticello 13,028 12,829 22,957 26,797 109,682 Rockford 7,260 8,860 9,501 14,175 43,654 Trailer 1,517 3,104 1,026 - 755 Watertown 1,813 3,319 4,706 10,704 33,372 Other - 1,780 - 65,899 - Total Contract Labor 103,392 139,526 226,973 296,782 448,040 * 2021 Franchise Fees include payments through 2nd Qtr. 3rd Qtr expected to be received end of November. 2017 2018 2019 2020 2021 Delivery Fees/Charges 1,780 580 970 870 565 Dues & Subscriptions 28,399 1,878 31,210 43,771 41,365 Equipment Purchases - All Cities 35,926 68,763 101,973 212,636 24,570 Big Lake 1,547 14,563 533 5,287 8,465 Buffalo 6,602 25,000 28,044 23,693 19,218 Cokato 2,243 20,074 - 2,420 1,421 Dassel 1,631 2,559 - - 20,069 Delano 2,621 12,896 10,254 3,543 5,823 Elk River 23,719 40,996 5,095 30,542 30,913 Maple Lake 1,603 3,092 - - 2,017 Monticello 3,784 30,245 10,193 19,732 8,831 Rockford 391 17,525 799 1,807 8,974 Watertown 1,183 1,173 4,033 35 Equipment Purchase - Other - 3,239 - Playback - - 12,540 - Producer Equipment/Software 4,135 - 608 4,016 - Trailer Equipment 270 4,221 - Total Equpment Purchases 85,655 244,347 170,040 307,710 130,338 Franchise Fees to Cities 198,215 601,306 565,946 343,620 - Insurance - Liability 3,664 3,385 3,471 3,295 3,520 Other 200 242 230 256 278 Licenses & Permits - 272 47 47 Payroll - - - 34,681 53,556 Postage & Delivery 24 - 182 167 - Producer Expense - Wages & Benefits 88,429 57,995 8,432 17,937 - Other 1,136 350 7,889 12,958 225 Professional Fees - Accounting - - 7,500 - Consulting - - - 7,432 Legal Fees 4,197 7,535 6,218 1,880 760 Rent 4,407 5,599 19,446 20,151 18,170 Equpment Repairs 1,961 524 634 926 5,897 Repairs - Other - 6,266 419 - Security - - - - 1,127 Software & Hosted Server 12,571 13,536 3,707 18,349 343 Telephone - - 35 356 712 Trailer Tabs 40 - - - Training - - - - 747 Utilities - - - - - Total Expenditures 544,268 1,094,850 1,061,434 1,120,422 726,498 Net Ordinary Income 306,011 (253,249) (236,020) (119,583) (97,090) 2017 2018 2019 2020 2021 Other Income/Expense Interest Income 46 130 239 89 33 Deposit 05/06/19 ?- - 1,275 - PEG Fees 13,261 Charter 127,499 123,491 118,624 29,066 - Arvig 4,501 4,914 3,213 2,764 - City of Big Lake 9 - - - - City of Monticello 1,803 1,704 1,687 - - Workers Comp Dividend - 320 352 364 Sale of Equipment - Truck - - 4,913 - Refund of Overpayment AVI Systems - 795 - - Charter Communications - 5,029 - - Total Other Income 133,857 136,383 130,303 32,282 13,294 Net Income 439,868 (116,866) (105,717) (87,301) (83,797) - 200,000 400,000 600,000 800,000 1,000,000 2,017 2018 2019 2020 2021 Franchise & PEG Fees Received (5 Year Comparison) Franchise Fees PEG Fees - 100,000 200,000 300,000 400,000 500,000 600,000 700,000 2,017 2018 2019 2020 2021 Franchise Fees Paid to Cities