Loading...
HomeMy WebLinkAbout1969 Financial StatementsApt., AUDITED FINANCIAL STATEMENTS AND OTHER FINANCIAL INFORMATION VILLAGE OF EDINA, MINNESOTA DECEMBER 31, 1969 rf t°�t n �� � Z7 IN " W� ERNST& ERNST -ee1.. AUDITED FINANCIAL.STATEMENTS AND .OTHER FINANCIAL INFORMATION .VILLAGE,OF EDINA, MINNESOTA December 31, 1969 •• INDEX ACCOUNTANTS' REPORT ON AUDITED'FINANCIAL STATEMENTS .......... PAGE 4 COMMENTS AND ACCOUNTANTS' REPORT ON OTHER FINANCIAL INFORMATION ................ ............................... 5 FUND'BALANCE SHEETS ......... ............................... 10 GENERAL FUND: BALANCE SHEET ............. ............................... 12 STATEMENTOF'SURPLUS ...... ............................... 13 ANALYSIS;OF'CHANGE IN CASH BALANCE ....................... 14 REVENUE ................>.. ............................... 15 EXPENDITURES .............. ............................... 16 CENTRAL SERVICES .......... ............................... 20 FIXED ASSETS .............. ............................... 21 BONDS PAYABLE ............. ............................... 22 POOR FUND: BALANCE SHEET ............. ............................... 23 , STATEMENT OF SURPLUS —. UNAPPROPRIATED .................... 24 STATEMENT OF REVENUES AND EXPENDITURES ................... 24 ANALYSIS OF CHANGE IN CASH BALANCE ....................... 25 PARK FUND: BALANCE SHEET........... ............................... 26 STATEMENT OF UNAPPROPRIATED SURPLUS ...................... 27 ANALYSIS,OF SURPLUS INVESTED IN FIXED ASSETS ............. 27 ANALYSIS.OF CHANGE IN CASH BALANCE.... .................... 28 REVENUE. AND: - EXPENDITURES .. ............................... 29 FIXED.: ASSETS .............. ............................... 30 SWIMMING POOL FUND: BALANCE SHEET ............. ............................... 31 STATEMENT OF SURPLUS:...... . .............................. 32 ANALYSIS OF CHANGE IN CASH BALANCE ....................... 33. STATEMENT :OF INCOME AND EXPENSE .......................... 34 STATEMENT OF 'INCOME AND EXPENSE (CONCESSIONS ONLY) ....... 35 FIXEDASSETS .............. ............................... 36 GOLF COURSE FUND: BALANCE: SHEET ............................................. 37 STATEMENT OF SURPLUS ...... ............................... 38 ANALYSIS'OF CHANGE IN CASH BALANCE ....................... 39 STATEMENT OF INCOME AND— EXPENSE .......................... 40 STATEMENT OF INCOME AND EXPENSE — OPERATING DEPARTMENTS.. 42 FIXED ASSETS .............. ............................... 43 BONDS PAYABLE ............. .......e....................... 44 RECREATION CENTER FUND: BALANCE SHEET ............. ............................... 45 STATEMENT OF 'SURPLUS ...... ............................... 46 ANALYSIS OF CHANGE IN CASH BALANCE ....................... 47 STATE ENT :OF'INCOME AND EXPENSE .......................... 48 FIXED ASSETS .. ......... ............................... 49 BONDS PAYABLE ............. ............................... 50. INDEX (Coat' d) PARK SINKING FUND: BALANCE SHEET . ............................... PAGE 51 STATEMENTOF .SURPLUS... .. ....................�.......... 52 .ANALYSIS OF CHANGE IN CASH BALANCE......... ............... 53 BOND AND'INTEREST MATURITIES AND DEFERRED TAX LEVIES ................... ............................... 54 PARK CONSTRUCTION FUND: BALANCE SHEET ............. ............................... 55 ANALYSIS:OF RESERVE FOR CONSTRUCTION ..................... 56 ANALYSIS OF CHANGE .IN CASH BALANCE ......................... 57 FIXED.ASSETS.......... . ................... ............ 58 ANALYSIS OF'CHANGES IN CONSTRUCTION IN PROGR$SS.......... 59 IMPROVEMENT FUNDS: COMBINED'BALANCE SHEET .... ............................... 60• STATEMENT OF SURPLUS . -. UNAPPROPRIATED .................... 61 ANALYSIS OF CHANGE IN .CASH BALANCE ......................... 62 BONDS PAYABLE ............. ............................... 64 WATERWORKS FUND: BALANCESHEET ............. ............................... 65 NOTES TO BALANCE SHEET ..... ............................... 66 STATEMENT OF SURPLUS......... ...... 67 STATEMENT OF INCOME AND EXPENSE .......................... 68 ANALYSIS:OF.CHANGE IN CASH BALANCE...... ... o ... oo ......... 70 FIXED ASSETS .............. ............................... 71 ±mil ; �I i BALANCE .SHEET .............................................. .72' STATEMENT :OF'SURPLUS�( DEFICIT ) ........................... 73 STATEMENT:OF'INCOME AND EXPENSE .......................... 74 ANALYSIS OF CHANGE IN CASH BALANCE ....................... 75 FIXED ASSETS :............. ............................... 76 LIQUOR DISPENSARY FUND: BALANCESHEET ....................... ............4...... 77 STATEMENT'OF SURPLUS ...... ............................... 78 STATEMENT OF INCOME AND'EXPENSE ................. 79 OPERATING EXPENSES ....................................... 80. ANALYSIS.OF CHANGE IN CASH BALANCE ....................... 81 FIXED ASSETS .............. ............................... 82 GENERAL: CASH - ALL FUNDS ......................................... 83 SECURITY FOR DEPOSITS ..... ............................... 84 INVESTMENTS............... ............................... 85 NOTE TO INVESTMENTS ............................ ........ 86 -TAXABLE VALUATIONS, TAX LEVIES AND RATES.................. 87 OFFICrIAL BONDS ............ ............................... 88 INSURANCE COVERAGE, ........ ............................... 89 ORGANIZATION ............................................. 91 ERNST & ERNST FIRST NATIONAL BANK BLDG. MINNEAPOLIS, MINN. 55402 ACCOUNTANTS' REPORT ON AUDITED FINANCIAL STATEMENTS To the Village Council Village of.:Edina, Minnesota We have examined the balance sheets of the various funds of the Village of Edina, Minnesota as.of December 31,,1969 and the related statements of revenues and expenditures or income and expense and surplus for the year then ended. Our examination was made in accordance with-generally accepted auditing standards, and accordingly included such,.tests of the accounting records and such.other auditing procedures as we considered necessary in the circumstances.. In our opinion,.the accompanying balance sheets and statements of revenues and expenditures, income and expense and surplus present .fairly the financial posi- tion of the .Village of Edina at December 31,:1969 and its various special funds and the results of their operations for the year then ended, in conformity with generally-accepted accounting.,principles applied on a.basis consistent with that of the preceding year. Minneapolis., Minnesota May,22,:1970 -4- ERNST & ERNST FIRST NATIONAL BANK BLDG. MINNEAPOLIS, MINN. 55402 COMMENTS AND ACCOUNTANTS' REPORT.ON OTHER YINANCIAL INFORMATION Village of.Edina Edina, Minnesota The audited financial statements of the various funds of the Village consisting of balance sheets and statements of revenues and expenditures or income and expense., and surplus and our report thereon are presented in appropriate sections of this report. Financial information not specifically referred to -above and financial information contained in the following comments, except the schedules of security for deposits, taxable valuations, tax-levies and rates, official bonds, insurance coverage and organization, was derived from the accounting :records tested by us as part of the auditing :procedures followed in our examination,of.the aforementioned financial statements and,.in our opinion,.it is fairly presented in all material respects -in relation to the financial statements taken as a whole; however,;it_is not necessary for a:fair presentation of the financial position and results of operations of the Village. The information shown:in the schedules of security for deposits, taxable valuations, tax levies and rates, official bonds, insurance coverage, and organization was prepared from information furnished to us by the Village., but we did not make independent tests of the schedules as-they do not involve information which enters into the financial statements. The following comments set forth certain auditing procedures and other matters pertinent-to our examination: Cash on deposit at December 31,.1969 was reconciled to balances reported directly to us by the various depositories. Cash working funds and cash on hand for de- posit at.December31,.1969 were counted by us. Cash receipts and cash disbursements procedures were reviewed and tested by us for selected .periods during the year to determine that proper procedures were being followed to control recording.of receipts and that proper authorization was provided for disbursements. Securities held for investment by the several funds of the Village were inspected by us or, in the case where securities were held in safekeeping, confirmed to us. Related interest income computations were tested. Amounts receivable from water and sewer rental charges at December 31, 1969 were tested by direct correspondence and by review of the records for subsequent col- lections. Differences reported were not material and were explained to our satis- faction. -5- Current and delinquent taxes and special assessments and tax 'settlements received during the year were confirmed by.direct correspondence with the County.Auditor. We reviewed delinquent taxes reported to us and adjusted the balances to conform to the County.Auditor's-balances. ..Transactions pertaining -to special assessments receivable were reviewed. Interfund transfers and charges and.interfund balances were reviewed by us. We were present at the municipal liquor stores at the-time physical inventories were taken. We- observed.inventory procedures used by Village employees and tested quantities by independent count of items selected by us. Inventory valuations were tested by- reference to -vendors'invoices and by tests of clerical accuracy. Additions to and disposals from fixed asset accounts were reviewed by us and veri- fied by inspection of contracts, invoices or other data. Allowances for deprecia- tion charged to operating funds of.the Village were reviewed by us. We tested accounts payable by .direct correspondence and -by reference to disburse - ments subsequent-to December 31,,1969. All canceled .bonds redeemed and.paid during 1969 were.inspected by us. We inspected interest coupons redeemed and paid during ;1969 on -a :test- basis. Official minutes of the Village Council for 1969 were read by us. Copies of - licenses and permits .issued during the year were tested to recorded col - lections. Recreational facilities, except for equipment, of the Swimming Pool Fund, Golf Course Fund and Recreation Center Fund are not depreciated. COMMENTS ON FINANCIAL STATEMENTS 'GENERAL 'FUND Detail schedules reflecting activity and status of this fund are shown on pages.12 to 22, inclusive, of this report. POOR FUND Reference -is made to detail schedules elsewhere in this report as to operations of this fund. Such details appear on pages 23 to 25, inclusive. PARK FUND Reference is,made to detail schedules elsewhere in this report.as to operations of this fund. Such details appear on pages 26 to 30, inclusive. SWIMMING POOL FUND Detail schedules:outlining , financial.operations of this fund .are shown on pages 31 :to 36, inclusive, of this report. The net income of $3,252.07 is after the provision of $6,000.00'for interest on bonded debt issued for the swimming pool facilities, and the provision of .$190.08 for depreciation,.computed by the straight1 ine method, on swimming pool equipment. -6- GOLF COURSE FUND Net revenues of the Liquor Dispensary .Fund are pledged to secure the payment of obligation of :the Golf Course Fund. Detail gchedules outlining financiallopera- tions of this:fund are shown on pages 37 to 44,.inclusive, of..this report. The net income-of $40,440.68.is after the provision of $24,511.00 .for interest on bonded debt, issued for the golf course facilities, and-the.-provision of $7,218.00 for depreciation,.computed . by the straight line method, on golf course-equipment. $25,000.00 of the bonded debt matured and was redeemed in 1969. RECREATION CENTER'FUND Net revenues:of the Liquor Dispensary Fund are pledged to secure payment.of obligations of.the Recreation Center Fund. Detail schedules covering operations of this fund appear on pages.45 to 50., inclusive. The . net: -income of $22;264.72 is after the provision of $13,551.00 for interest on' bonded debt issued for the recreational center facilities and the provision of $2,649.58 for depreciation, computed by the straight line method, on recreational center equipment. $15,000.00 of bonded debt matured and was redeemed in 1969. Funds in the amount of :$100,000.00 were derived from the sale of Recreation Center.Bonds;in 1969. The bonds bear interest at 5% and $10;000.00 of the issue mature on August 1 of each of the 10 years beginning in.'1970. Proceeds were used to finance current construction. PARK SINKING FUND Reference is made to detail schedules on pages 51 :to 54, inclusive; of this report .as to the operations of this fund. $40;000.00 of the bonded debt matured and was redeemed in 1969. PARK CONSTRUCTION FUND Reference is made to detail schedules in this report as to operations.of this fund. Such.details appear.on pages 55 to 59, inclusive. Fixed .assets for park purposes amounting to $287,761.44 were purchased during the year and projects completed at a cost.of $583,690.94 were transferred to the Park -Fund. Funds were made-available from $130,000.00,in transfers from the Liquor Dispensary Fund and.a $200,000.00 advance from the Recreation Center Fund. IMPROVEMENT FUNDS 1. Reference.is made to detail schedules elsewhere in this report as to operations.of these funds and the related.Construction Fund. Such details appear on pages 60 to 64,.inclusive,'of this report. Construction costs,incurred by.the-Village,:other than for park purposes, are ac- counted for in the Construction Fund which receives the proceeds from sale of permanent and temporary bonds sold .for construction or improvement.purposes by.the various improvement funds. Redemption of these bonds .is provided for by Levies of special assessments on properties benefited from the construction or improvements. To facilitate tabulation of these special assessments,.interest from date of final assessment hearing to December 31st is-included as part of .project costs. Assess - able costs also include a percentage charge in an amount sufficient to reimburse the Village for actual costs of engineering and clerical services.properly assign- able to the various special assessment projects. The reserve for assessment-adjustments-represents the excess:of assessments over actual costs incurred,.less charges where actual costs exceeded the assessments. Also charged to the reserve for assessment adjustments are determinable costs for financed projects,on which work had not.been done and on which final disposition is pending. These balances may be used for refunding canceled assessments. -7- Funds_in the amount of $2,500,000.00 were made available from the sale of General Obligation Improvement Bonds in 1969. The proceeds were used to finance current construction. The.bonds bear :interest at rates from 5.30% to 5.70% and $250,000.00 of the issue mature on December 1 in each of the 10 years beginning.in 1970. The bonds will be redeemed with funds made available from special assessments. WATERWORKS FUND Reference is made to detail schedules elsewhere in this report this fund. Such.details appear on pages 65 to:7l,.inclusive. $117,632.45 is after the provision of $19,408.00 for interest. for the waterworks facilities and the provision of.:$186,947.00 the facilities. $48,000.00 of..the bonded.debt matured and was as to operations of .The net income of :)n bonded debt .issued for depreciation on redeemed in 1969. SEWER RENTAL FUND Reference is.made to detail schedules elsewhere in this report as to operations of this fund. Such details appear on pages. 72 to 76, inclusive. Included in accounts payable.is a disputed liability to the City of Minneapolis for sewer charges in the amount of:.$154,593.52. LIQUOR DISPENSARY FUND Reference is made to detail schedules elsewhere in this report as to operations of this fund. Such details appear on pages,77 to 82, inclusive. Net.income of $384,583.21 for the year is after the provision of $9,169.00 of depreciation, computed by .the straight line method,.on. liquor store equipment. Of this amount, $2.75,000.00 was transferred to other :funds of the Village by action of the .Village Council. In connection with -.the sale of Golf Course Bonds of1963 and Recreation Center Bonds of-1965 the net revenues of the liquor Dispensary Fund are pledged to secure the payment of.said bonds and .interest thereon. SECURITY FOR DEPOSITS Reference is made to schedule on page 84 of this report showing details of deposits of.the Village and securities pledged as collateral thereto at December 31,1969. Security for deposits at the First Edina National Bank were inadequate with re- spect to compliance with the provisions of M. S. A. Section118.01 which prohibit the Treasurer from maintaining.a deposit in excess of ninety per cent of.the market value of the collateral pledged exclusive of .amounts covered.by federal deposit insurance. First Edina .National Bank Balance on deposit :$508,594.67 Security for deposit: Collateral at 90% of market $312,077.00 'Federal deposit insurance 20,000.00 .$332;077.00 N BONDING REQUIREMENTS All Village employees who are required to be bonded by Minnesota statutes were so bonded. PUBLICATION OF FINANCIAL STATEMENTS A detailed .financial statement was not prepared and published or posted as re- quired .by M. S. A. Section 412.281. Minneapolis, Minnesota May 22, 1970 H ASSETS Cash: Current funds Appropriated Investments: United States Treasury notes and United States Government Agency securities - at face value or cost Village of Edina bonds - at face value or cost Land investment - at cost Amount segregated and shown below Receivables: Taxes and special assessments: Current Delinquent Deferred Customers Due from other funds Miscellaneous receivables Less allowance for delinquent taxes Inventories Prepaid expenses Segregated investments for reserve for debt retirement Construction in progress Fixed assets Unallocated construction costs * Indicates red figure. Total $ 244,009.75 20,568.75 $ 264$78.50 $ 3,978,286.14 201,236.14 67,851.16 $ 4,247,373.44 63,495.00 $ 4,183,878.44 $ 1,849,107.13 326,065.07 8,9961762.66 127,160.43 1,151,497.90 34,211.90 $12,484,805.09 866,996.59 $11,617,808.50 423, 24,7.23 4,523.70 63,495.00 3,398,540.30 12,466,412.48 100,121..57 $32,522,605.72 FUND BALANCE SHEETS VILLAGE OF EDINA December 31, 1969 Swimming Golf Recreation General Poor Park Pool Course Center $ 21,703.88 $ 478.53 $ 18,158.94 $ 11,552.44* $ 3,153.06* $ 296.06 $ 21,703.88 $ 478.53 $. 18,158.94 $ 11,552.44* $ 3,153.06* $ 296.06 $ 5851147.14 $25,358.30 $ 12,500.00 i $ 75,472.19 $172,705.28 Sewer 6,000.00 Sinking Construction Improvement Waterworks 67,851.16 Rental Dispensary $ 1,263.49 $ 312:54'; $ $ 652,998.30 $31,358.30 $ 12,500.00 $ - $ 75,472.19 $172,705.28 $ 652,998.30 $31,358.30 $ 123,500.00 $ - $ 75.,472.19 $172,705.28 $ 3,952.09 $ 312.54 $ 205,671.70 $ 15,795.54 $ 48,839.19 $ 22,352.92 $ 3,763.81 86,640.42 $ 2,256,625.61 ' $ 13,287.39 $ 70,185.60 $.50,924.58 15,000.00 153,000.00 $ 82.60 $ 4,241.50 224,216.65 $ 2,409,625.61 831725.00 539,107.86 $ 18,694.70 208,000.00 33,612.39 400.00 63,495.00 $ 323,907.71 $ - $: 12,888.81 $ - $ 18,777.30 $212,241.50 48,839.19 $ 70,185.60 .3,763,81 I $ 64$00.00 $ $ 275,,068.52 $ -. $ 9,125.00 $ - $ 18,777.30 $212,241.50 10,000.00 272,419.34 600.00 1,795.36 616,000.00 8,367,475.27 . 148.54 903.34 2,598,635.99 1,1663P088.43 211,375.42 972,925.18 562,120.15 $3,558,406.69 $311p836.83 $1,206,472.37 26$78.77 $199,822.98 $1,064,170.15 $950,061.69 I I I i I I I I Park Park i Sewer ,Liquor Sinking Construction Improvement Waterworks Rental Dispensary $ 1,263.49 $ 312:54'; $ 205,671.70 ! $ 4,773.21* $ 6,749.60* $ 22,352.92 20,568.75 $ 1,263.49 $ 312.54 $ 205,671.70 $ 15,795.54 $ 6,749.60* $ 22,352.92 $103,619.16 $ 86,640.42 $ 2,256,625.61 ' $ 539$107.86 $ 70,185.60 $.50,924.58 15,000.00 153,000.00 27,236.14 I $103,619.16 $ 101,640.42 $ 2,409,625.61 $ 539,107.86 $ 70,185.60 $ 78,160.72 63,495.00 $103,619.16 $ 101,640.42 $ 2,409,625.61 $ 475,612.86 $ 70,185.60 $ 78,160.72 I $ 64$00.00 $ 1,780,655.04 1,042.73 272,419.34 616,000.00 8,367,475.27 . $ 96,257.56 $ 26$78.77 5.31500.00 233$83.30 17,010.44 1,728.01 $434,039.80 I 199.51 i $6873P042.73 $ - $10,654,332.46 $ 113,268.00 $ 28$06.78 $434,039.80 34,567.73 779,825..861. $652,475.00 $ - $ 9,874,506.60; $ 113,268.00 $ 28$06.78 ,$434,039.80 31,469.95 379$81.92. i 831.50 35.00 2,605.32 63,495.00 I 379,043.47 3,019,496.83 963$74.,24 5,926,116.05 13$77.09 51,999.93 100,121.57 $757,357.65 $1,444,570.67 j $15,609.,422.31 $6,626,588.90 $105$54.87 $968,540.61 -10- Total LIABILITIES, RESERVES AND SURPLUS Due to other funds $ 1,151,497.90 Accounts payable 389,706.79 Salaries and wages 24,648.35 Due to Hennepin.County 10,180.80 Interest payable 29,562.48 Deferred income 9,681.00 Construction and other deposits 49,317.27 Edina Firemen's Relief Association 29,397.00 Construction contracts 408,130.57 Unexpended contributions 289034.64 Reserve for future bond interest 179,373.34 Bonds payable 14,708,000.00 Reserve for assessment adjustments 119,523.61 Reserve for construction 75,081.99 Surplus: Invested in fixed assets 10,531,391.55 Appropriated: For imprest cash 550.00 For debt service 172,863.75 For commitments 368,983.00 Unappropriated (deficit) 4,236,081.68 $32,522,605.72 General Poor $ 119,333.84 79,988.00 $ 223.41 11,070.34 313.33 14,667.37 29,397.00 38,000.00 FUND BALANCE SHEETS (Cont'd) 28,034.64 725,000.00 520,000:00 2,598,635.99 1,166,088.43 211,375.42 42,120.15 550.00 52,300.00 36,500.00 368,983.00 297,467.82 31,613.42 ( 10,906.64) ( 17,233.53) 25,383.37 31,301.76 $3,558;406.69 $31,836.83 $1,206,472.37 $199,822.98 $1,064,170.15 $950,061.69 Park Swimming Golf. Recreation Park Pool Course Center $ 13,147.35 $ 55500.00 $ 259,039.80 $289,656.70 4,675:08 181.09 22446.98 13,784.35 5,433.51 $ 157.50 1,904.41, 2,027.69 20,351.68 $199,877.31 5,113.32 9,681.00 28,034.64 725,000.00 520,000:00 2,598,635.99 1,166,088.43 211,375.42 42,120.15 550.00 52,300.00 36,500.00 368,983.00 297,467.82 31,613.42 ( 10,906.64) ( 17,233.53) 25,383.37 31,301.76 $3,558;406.69 $31,836.83 $1,206,472.37 $199,822.98 $1,064,170.15 $950,061.69 Park Park Sewer Liquor Sinking Construction Improvement Waterworks Rental Dispensary $ 222,388.53 $ 228,810.55 $ 13,463.63 $ 157.50 32,234.69 2,027.69 20,351.68 $199,877.31 33,916.51 13,183.32 735.02 4,321.75 ,10,180.80 $ 20,755.00 I 3,380.83 34,649.90 46,139.22 362,591.35. 114,740.00 64,633.34 5703000.00 12,28010000.00 575,000.00 119,523.61 47,329.74 27,752.25 I 1,096,478.49 i 5,3513116.05 13,577.09 51,999.93 84,063:75 51,862.65 2,479,252.82 578,029.64 ( 108,834.55). 878,144.92 $757,357.65 $1,444,570.67 $15,609,422.31• $6,626,588.90 $105,354.87 $968,540.61 -11- GENERAL FUND BALANCE SHEET VILLAGE 'OF EDINA December 3,1, 1969 Cash: Demand - deposits (deficit) Time deposits Working :funds Investments - at cost: Federal Land Bank bonds Federal Home Loan'Bank'notes United States Treasury bonds Federal National Mortgage Association Certificates Land investments Receivables: .Accounts receivable Special assessments — current Special assessments — deferred Due from other funds Supply inventory - estimated `'Taxes receivable delinquent Less allowance for delinquent taxes Fixed .assets ASSETS ($ 13;846.12) 35,000.00 $ $ 3,952.09 13,287.39 LIABILITIES AND SURPLUS .Due to other funds Accounts payable: Trade accounts Accrued payroll Edina Firemen's Relief Association Contributions 'to Edina Library .'Fund Sundry deposits Bonds payable Accrued interest payable Surplus: Invested.in'fixed assets Direct Annexed from,Morningside — invested in fixed assets Contributed - invested in fixed assets Appropriated: Reserve for commitments For imprest cash Unappropriated $2,504,022.88 2.7,650.00 66,963.11 21,153.:88 -550.00 $ 21,703.88 $ 50,000.00 306,561.67 77,000.00 151,585.47 67,851.16 652,998.30 $ 33,612.39 17,239.48 224;216.65 275,068.52 ,,1.0,000.00 $ 48,839.19 48,839.19 - 2;598,635.99 $3;558,406.69 $ 119,333.84 $ 79,988.00 11,070.34 29,397.00 9,661.44 5,005.93 135,122.71 $ :38,000.00 3.13.33 38,313.33 $295981635.99 368,983.00 550.00 2;968,168.99 297,467.82 $3;558,406.69 -12- GENERAL FUND STATEMENT OF SURPLUS VILLAGE OF:EDINA Year Ended December 31,.1969 APPROPRIATED Balance at January 1, 1969 Additions: Transfers from unappropriated surplus: Invested in Total Fixed Assets Contributed i $2,724;155.30 $2,350,492.19 $66,963.11 For fixed assets - net 153,530.69 For commitments 139,483,.00 $3,017,168.99 .Deductions: Transfer to revenue 49,000.00 Balance at:December 31, 1969 ,.$2,968,168.99 UNAPPROPRIATED Balance at January:1,.1969 Additions: Revenue - see separate schedule Installment on voting machines Less: -Expenditures - see separate schedule _:Deductions : General Fund.share of: construction costs. 153,530:69 $2,504,022.88 $66,963.11 $2.,504.,022.88 $66,96311 Contributed For Imprest For by Annexation Cash Commitments $ 2,7,650.00 . $ :550.00 $2,78,.500.00 I :139,4.83.00 $ 27,650.00 $ 550.00 $417,983.00 49,000.00 i $ 2],650.00 $ 550.00. $368,983.00 $220,976.21 i I $2,403,584.66 1,624.00 $2,405,208.66 i 2,316,890.16 88,318.50. $309,294..71 11,826.89 Balance at. December .31, 1969 . $297;467.82 -13- GENERAL FUND ANALYSIS OF CHANGE;IN CASH BALANCE VILLAGE -.OF EDINA Year Ended December:31, 1969 Balance at January,l, 1969 Additions: Receipts - per separate schedule ,Sale of investments Collection of amount due others: Waterworks Fund 'Edina.Firemen's.:Relief Association Collection made on accruals at December 31,:1968 Payments received .from Independent School District No. 273 for gasoline purchases Receipts -- Morningside Improvement Fund Less payments from fund Deductions: Payments for other funds Disbursements - per separate schedule Gasoline purchased for Independent School District No. 273 Payments on accruals at December 31,.1968: Accounts payable Accrued.payroll Edina Firemen's Relief Association Due to other funds Payment.of bonds Purchase of investments Land investment Decrease in, sundry deposits $17,010.44 29,712.00 30,227.18 ;16,553:83 $50,415.50 10,330.14 2.1,274.44 26,556.89 $2,133,620.33 200,000.00 46,, 722.44 258,401.46 :17,987.49 13.673.35 $ 17,521.00 2;101,003.16 18,219._81 108,576.97 16;000.00 485,147.14 67,851.16 .1,909.77 Balance at December 31,.1969 $ :166,977.82 2,670,405.07 $2,8375382.89 2,816,229.01 $ 21,153.88 -14- GENERAL FUND REVENUE VILLAGE OF EDINA Year Ended December 31, 1969 I Actual Revenue Over- Under* Estimated Estimated Receipts j Accruals Revenues Revenue Revenue Real and .personal property taxes: Received from direct.local.levies $1,102,758.00 I $1,102,158.00 $1,126,322.00 $24,164.00* Received from .Sales Tax.Replacement Fund: Personal property .$ 30,486.00 $ 30,486.00 $ 30,486.00 $ - -five per cent forgiveness 257,246.00 257,246.00 257,246.00 - .Thirty TOTAL SALES TAX REPLACEMENT FUND 287,732.00 - 287,732.00 287,732.00 $ TOTAL REAL AND'PERSONAL PROPERTY TAXES $1,389,890.00 I $ - $1,389,890.00 .$1,414,054.00 $24,164.00* Other taxes 35,736.00 j 35,736.00 33,500.00 2,236.00 Bicycle licenses 2,113.00 2,113.00 2,200.00 87.00* Beer and liquor licenses .1,480.00 1,480.00 1,500.00 20.00* Cigarette licenses 1,855.00 1,855.00 1,600.00 255.00 Dog.and,impounding.fees 6,849.00 I 6,849.00 7,000.00 151.00* Food and soft drinks 6,295.00 6,295.00 4,500.00 1,795.00 Gas pump licenses 1,372.00 1,372.00 ! 1,000.00 '372.00 Bowling, taxi,.pinball, etc. 4,653:00 4,653.00 5,100.00 447.00* Heating and ventilating.:licenses 1,413.00 j 1,413.00 i 1,413.00 Water softener installation licenses 70.00 i '70.00 70.00 Scavenger and garbage collectors 968.00 968.00 550.00 418.00 Building permits 75,107.00 '75,107.00 62,000.00 .13,107.00 Cesspool and sewer permits 1,896.00 1,896.00 2,750.00 '854.00* Plumbing permits 23,613.00 23,613.00 18,000.00 5,613.00 Sign permits 4.,636.00 4,636.00 3,500.00 1,136.00 Other permits and fees 150.00 150.00 - 700.00 550.00* Heating permits 7,577.00 '7,577.00 5,500.00 2,077.00 Street opening fees 5,166.00 5,166.00 1,200.00 3,966.00 Planning fees 3,547:00 3,547.00 2,000.00 1,547.00 Engineering, clerical and searches 13,336:00 $203,476.00 216,812.00 185,000.00 31,812.00 Police service 6,398.00 �" 6,398.00 9,062.00 2,664.00* Equipment rental ( 5,400.00) 5,977.00 577.00 600.00 23.00* Municipal court fines 63,068.00 7`,284.00 70,352.00 56,500.00 13,852.00 Income - on.investments .14,348.00 14,348.00 10,000.00 4,348.00 Sale and rental of property 37,378.00 37,378.00 36,518.00 860.00 State apportionment —sales and use 197,972.00 197,972.00 194,617.00 3,355.00 State 'apportionment - highway 46,909.00 46,909.00 54,500.00 7,591.00* State apportionment — liquor and cigarette 132,727.00 132,727.00 126,080.00 6,647.00 Contribution from active funds 25,502.00 25,502.00 25,502.00 - Charges to other funds 16,200.00 '16;200.00 16,200.00 - Special assessment - tree trimming 6,000.00 6,000.00* Discount earned 1,983.00 i 172.00 2,155.00 2,155.00 Other revenue 8,813.33 .4,055.33 .12,868.66 13,350.00 481.34* Transfer - reserve for commitments 49,000.00 49,000.00 492000.00 I - $2,133,620.33 $269,964.33 $2,403,584.66 $2,349,583.00 $54,001.66 ( ) Indicates negative amount. -15- GENERAL FUND 'EXPENDITURES VILLAGE OF EDINA Year Ended December 31, -1969 GENERAL GOVERNMENT 'Mayor and Council Planning Administration: Personal services Contractual services Commodities Fixed charges Finance: Personal services Contractual services Commodities Fixed charges Elections Assessing: Personal services Contractual services Commoditie§.; Fixed :charges. Legal services Library: Personal services .Contractual services Commodities Fixed charges TOTAL GENERAL GOVERNMENT ADMINISTRATIVE, ENGINEERING AND'PUBLIC WORKS Administration: Personal services Contractual services Fixed charges Engineering: Overhead Project engineering General engineering ,16- Unexpended Disbursements i Encumbrances Expenditures Appropriation Balance $ :10,450.00 $ '747.00 $ -11,197.00 $ :10,650.00 $ 547.00* 23,548.00 i 391.00 23,939.00 26,122.00 2,183.00 $ 52,912.00 $ 27.00 $ 52,939.00 $ 53,225.00 $ :286.00 7,548.50 ' 91.00 7,639.50 8,048.00 408..50 73.50 73.50 125.00 51.50 - 14,460.00 14,4.60.00 14,460.00 - $ 74,994.00 $ 118.00 $ - 75,112.00 $ 75,858.00 $ 346.00 _$ 47,368..00 $ - 47,368.00 $ 47,485,.00 $ :117.00 3,124.00 $ 24.00 3,148.00 3,240.00 92.00 68.00 68.00 75.00 7.00 11,220.00 :11,220.00 11,220.00 - $ 61,780.00 $ 24.00 $ 61,804.00 $ 62;020.00 $ X216.00 :10,584.00 69.00 10,653.00 8,99.5.00 1.,658.00* $ 50,758.00 $ 10.00 $ 50,768.00 $, 52,360.00 $-1,592.00 .1,712.00 91.00 1,803.00 2,531.00 728.00 479.00 479.00 535.00 56.00 12,660.00 . 12,660.00 12,660.00 - $ 65,609.00 101.00 $ 65,710.00 $ 68,086.00 $ 2,376.00 -38,186.00 5,090.00 43,276.00 i 41,560.00 1,716.00* $ 10,286.00 $ 194.00 $ 10;480.00 $ 10,500.00 $ 20.00 - 10,849.16 1,189.00 L2,038.16 11,715.00 323.16* 3,387.00 508.00 3,895.00 13,925.00 30.00 1,380.00 1,380.00 1,380.00 $ :2.5,902.16 $ ;1,891.06 $ :27,793.16 -$ 27;520.00 $ 273.16* $ 311,053.16 $ 8,431.00 $- 3,19,484.16; :$ I .320,811.00 $ 1,326.84 $ :17,652.00 ;! $ 17,652.00 $ 17,705.00 $ 53.00 198.00 i 19 8. 00 200.00 2.00 ,4 620.00 4,620.00 j. 4,620.00 - 22,470.00 $ - $ 22,470.00 $ 22,525.00 $ 55.00 $ 26,134.00 $ 847.00 $ 26,981.00 $ 27,699.00 $ -718.00 .1351962.00 705.00 136,667.00 141,872.00 5,205.00 .18,178.00 '323.00 18,501.00 20,274.00 1,773.00 $ 1801274.00 $ 1,875.00 $ 182,149.00 $ -189,845.00 $ 7,696.00 ,16- GENERAL FUND _EXPENDITURES (Cont'd) ADMINISTRATION, ENGINEERING AND`PU BLIC WORKS (Cont'd) Public works: Supervision and overhead: Supervision and clerical Training Paid leave Allocated to operating :departments General maintenance: General Oil and gravel streets Asphalt streets Concrete streets Street.cleaning Renovation Curb and gutter repair Snow and -ice removal Alley.construction Replacements Street lighting Street name signs Traffic control: Sign maintenance Traffic control maintenance Pavement marking Guard rail maintenance Bridges - general maintenance Storm sewer maintenance Temporary drainage and culverts Village - properties: Turf care and plantings Tree maintenance Noxious weed control Lake and pond maintenance Sidewalks: Disbursements $ 64,064.00 530.00 28$64.00 $ 93,158.00 ( 92,736.00) $ 422.00 $ 18,281.00 28,151.00 72,985.00 7.061.00 $ 126,478.00 54,016.00 60,349.00 1,674.00 88,600.00 55,719:00 20,929.00 $ 10,534.00 8,163..00 6.580.00 $ 25;277.00 2,843.00 2,419.00 30,220.00 :3,951.00 $ 9,482.00 16,623.00 $ 26,105.00 126.00 .11,806.00 Maintenance and repair $ 876.00 Snow and ice removal 936.00 $ 1,812.00 TOTAL PUBLIC WORKS $ 512,746.00 TOTAL ADMINISTRATION, ENGINEERING AND PUBLIC WORKS $ - 715,490.00 Encumbrances $ 429.00 ,2,566.00 $ 2,995.00 $ 2,995.00 $ -8,646.00* 726.00 261.00 2,506.00 $ 5,153.00* 11,802.00 7,444.00 23 ;767.00 10,429.00 1;273.00 $ .422.00 500.00 503.00 $ 1,425.00 3.67.00 $ 1,494.00 $ 1,494.00 $ ;55, 843.00 $ 57,718.00,. Expenditures $ 64,4.93..00 530.00 31,130.00 $ :96,153.00 ( 92,736.00) $ .3,417.00 $ 9,635.00 28,877.00 73,246.00 9.567.00 $ 121,325.00 54,016:00 60,349.00 1,674.00 100,402.00 7,444.00 23,767.00 66,148.00 22,202..00 $ 10,956.00 8,663.00 '7.,083_:00 $ - 26,702:00 2,843.00 2,419.00 30,587.00 3,951.00 $ :10,976.00 16, 623.00 $ 27,599.00 126.00 11,806.00 $ 876.00 936.00 $ 1,812.00 $ 568,,589..00 $ .773,208.00 Appropriation $ 64,636.00 550.00 31,180.00 $ 96,366.00 ( 92,736:00) $ 3,630.00 $ 9,800.00 29,400.00 '73,660.00 9.860.00 $ :122,72.0.00. 54;880.00 61,460.00 1,700.00 101,400.00 7,500.00 23,76.7.00 66. 376.00 22,700.00 $ 11,020.00 8,756.00 7.532.00 $ 27,308.00 2,940.00 2,600.00. 30,770.00 4,020.00 i j $ :11,480.00 :16,800.00 $ 28, 280.00 150.00 12,080.00 I $ 946.00 1,136 00 $ 2,082.00 $ 576,363.00 $ 788,733.00 Unexpended 72.1 ­a $ :143.00 20.00 50.00 $ 2.13.00 $ 213.00 $ 165.00 523.00 414.00 293.00 $.1,.395.00 864.00 11,111.00 26.00 998.00 56.00 228.00 498.00 $ 64.00 93.00 -449.00 $ 606.00 97.00 181.00 183.00 69.00 $ 504..00 177.00 $ 6;81.00 24.00 274.00 $ 70.00 200.00 $ 270.00 $ 7,774.00 $15,525.00 -.17- GENERAL FUND EXPENDITURES (Cont'd) PROTECTION OF PERSONS AND PROPERTY Police protection: Personal services Contractual services Commodities Fixed charges Fire protection: Personal services Contractual services Commodities Fixed:charges Civilian Defense Public health: Personal services Contractual services Commodities Fixed charges Animal control Inspections: Personal services Contractual services Commodities Fixed charges TOTAL PROTECTION OF PERSONS AND PROPERTY NON- DEPARTMENTAL Disbursements $ 401,000.00 11,182.00 3,622.00 115,416.00 $ 531,220.00 $ :164,487:00 4,442.00 -3,466.00 4.7,820.00 $ 220,215.00 3,339.00 $ :14,659.00 31.00* 1,032.00 '5,400..00 $ 21;060.00 13;931.00 $ 34,624.00 3,161..00 660.00 7,920.00 $ 46,365.00 $ 836,130.00 Contingencies $ 6,110.00 Settlement of suits 3;848.00 Special assessments.on Village park.property 41,741.90 TOTAL NON- DEPARTMENTAL $ 51,699.90 CENTRAL SERVICES See separate schedule attached CAPITAL OUTLAY Administration- general government Finance Assessing Administration- .engineering and public works Engineering Public works Police 52 269.00 TOTAL OPERATING EXPENSES $1,966,642.0 425.00 241.00 3,002.00 34.,828.00 16,982.00 Encumbrances Expenditures Appropriation i $ 320.00* 3,42.00 195.00 $ 217.00 $ :322.00* .235.00 191.00 $ 104.00 51.00 $ 2,720.00* 344.00 450.00 *`' $ 2,826.00* 1,•202.00 $ 498.00 233.00 $ 731.00 $ :521.00* $ :1,038.00 $ -1,038.00 15, 458.00* $ 5.1,208.00 8,725.00 234.00 $ 400,680.00 11,524.00 3,817.00 115,4.16.00 $ 531,437.00,; $ 164,165.00 4,677.00 3,657.00 47,820.00 $ '220,319.00' '3,390.00 $ 11,939.00 3,13.00 5.82.00 5;400.00 $ 18,234.00 '15,133.00 $ 34,624.00 3,659.00 893.00 7,920.00 $ 47,096.00 $ 835,609.00 $ 7,148.00 3,848.00 41,741.90 $ 52,737.90 36,811.00 $2,017,850.06 $ 65.00 425.00 241.00 3,002.00 43;553:00 17,216.00 $ 409,780.00 13,585.00 5,161.00 115,416.00 $ 543,942.00 $ -166,112.00 5,351.00 4,847.00 47,820.00 $ 224 ;130.00 3,392.00 $ 13,605.00 640.00 910.00 5.400.00 $ 20,555.00 15;600.00 $ 34,720.00 3,113.00 925.00 7,920.00 $ 46,678.00 $ 854,297.00 $ 7,050.00 3,850.00 41,750.00 $ 52,650.00 31.700.00 $2,048,191.00 1 $ '75.00 � 150.00 500.00 250.00 3;050.00 44,200.00 17,492.00 Unexpended $ 9,100.00 2,061.00 1,344.00 $12,505.00 $ -1,947.00 674.00 1,190.00 $ 3,811.00 2.00 $:1 ;666.00 327.00 328.00 $ 2,321.00 467.00 $ 96.00 546.00* 32.00 418.00* $18,688.00 $ 98.00* 2.00 8.10 $ 87.90* 5,111.00* $30 ;340.94 $ :10.00 •150.00 75.00 9.00 48.00 647.00 276.00 -.18- GENERAL FUND EXPENDITURES (Cont'd) .CAPITAL OUTLAY (Cont'd) Fire Public health Inspections Contingencies Special assessments on Village property 'Unallocated capital outlay RESERVE FOR COMMITMENTS Police protection Public works Unallocated capital outlay Capital.improvements * Indicates- red figure. Unexpended Disbursements Encumbrances Expenditures Appropriation Balance j $ 55,953.00 $ :90.00 $ 561043.00 $ 56;500.00 $ 457.00 292:00 i 292.00 1300.00 8.00 150.00 :150.00 12,592.00 12,592.00 12;600.00 8.00 6,3,11.10 ' 6.,311.10 6,350.00 38.90 .3,670.00 16,147:00 19,817000 20;292.00 475.00 $ 134,361.10 j $ 25,196.00 $ :159,557.10 $ 161,909.00 $ 2,351.90 $ 5,700.00 $ 5,700.00 $ 5,700..00 $ - 70,733.00 '70,733.00 70,733.00 - 13,050.00 13,050.00 :13,050.00 - 50,000.00 50,000.00 50,000.00 - $ - $139,483.00 $ 139,483.00 $ :139,483.00 $ - TOTAL $2,101;003:16 i i I � $215,887.00,. - $2,316,890.16 $2,349,583.00 I f $32;692.84 I _19- GENERAL FUND CENTRAL SERVICES VILLAGE OF -EDINA Year Ended December 31, 1969 General: Contractual services Commodities Village Hall: Personal services Contractual services Commodities Central services Garage Equipment- operation: Personal services Contractual services Commodities Fixed charges Gasoline and fuel oil Tires and tubes Lubricants Parts and accessories Less allocations to other departments or funds * Indicates red figure. TOTAL GENERAL TOTAL VILLAGE HALL TOTAL EQUIPMENT OPERATION TOTAL Disbursements $349,865.00 7,565.00 .$357,430.00 $ 11,784.00 8j698.00 3,344.00 1,620.00 $25,446.00 22,577.00 $ 53,313.00 24,191.00 12,284.00 25,080.00 27,948.00 8,162.00 3,022.00 30,392.00 $184.,392.00 $589,845.00 537,576.00 $ 52,269.00 Encumbrances $33,636.00* 420.00 $33,216.00* $ " :298.00 X1;508.00 1,122.00 $ 2,928.00 2,662.00 $1,093.00 1,704.00 648.00 3,431:00 591.00 393.00 4,308.00 $12,168.00 $15,458.00* $15,458.00 ,1� Expenditures $316;229.00 '7,9.85.00 $324;214.00 $ 12,082.00 10,206.00 4,466.00 1,620.00 $28,374.00 25,239.00 $:54,406.00 25,895.00 12,932.00 25,080.00 31,379.00 8,753.00 3,415.00 34,700.00 $196,560.00 $574,387.00 '537,576.00 $ 36,811.00 Appropriation $315,036.00 8,100.00 $323,136.00 $12,200.00, 10,220.00 3,850.00 ;1,620.00 .$ 27,890.00 25,730.00 $'54,425.00 26,000.00 12,950.00 25,080.00 27,015.00 8,800.00 3,450.00 34,800.00 $192,520.00 $569,276.00 537,576.00 $ 31,700.00 Unexpended $1,193.00* 115.00 $1,078.00* $ :118.00 '14.00 616.00* $ :484.00* 491.00 $ 19.00 ;105..00 18.00 4,364.00* 47.00 35.00 100.00 $4,040.00* $5,111.00* $5,111.00* -20- Land Land improvements Buildings Furniture and .fixtures Equipment: Highway Police Fire Election Engineering Traffic signals Executive Miscellaneous _GENERAL FUND 'FIXED ASSETS VILLAGE OF EDINA Year Ended December 31,1969 TOTAL Balance January -1, 1969 $ :276,316.24 143,,478.38 1,160,660.67 62,061.61 414,540.21 43,927.82 98,02.5.05 96,257.93 31,22.9.23 84.,707.18 1,834.15 :32,066.83 $2,445,105.30 $ 6,311.10 24,.953.00 7,3,87.00 45,387.00 .28,616.00 56,026.00 Balance December 31, Deductions .1969 $ 276,316.24 149,789.48 1,185,613.67 $-1,534..33 67,914.28 10,784.13 3,256.95 3,668.00 3,242.00 $172,348.10 $18,817.41 459,927.21 61,759.69 150,794.10 96,257.93 31,655.23 84.,707.18 1,834:15 32.066.83 $2,598,635.99 -21- GENERAL FUND BONDS PAYABLE VILLAGE OF EDINA December 31, 1969 Year Total Annual maturities and interest dates Interest rates 1970 $10,000:00 :1971 8,000.00 .1972 5,000.00 1973 5,000.00 1974 5,000.00 1975 5.000.00 $38,000.00 -22- Saintary Sewer Improvement Sanitary Sewer No..11 and and Watermain Curb and Gutter Street Improvement Improvement 'Improvement No. 9 No, 12 No..14 February -1 and February.l and May l and August .l August 1. November 1 4% 3.4% 3.9% $2,000.00 $39000.00 $:5,000.00 3;000.00 :5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 $2,000.00 $6,000.00 $30,000.00 -22- POOR FUND BALANCE.SHEET VILLAGE OF EDINA December 31,:1969 ASSETS Cash,on deposit :Investments: Village of Edina -2.5% Waterworks.Revenue Bonds of.1955 - at face value .Federal National Mortgage Association Participation Certificates - at cost LIABILITIES.AND SURPLUS Accounts payable Unappropriated surplus $ 478.53 $ 6,000.00 25,358.30 31,358.30 1$31,836.83 $ 223.41 31,613.42 $31,836.83 -23- POOR FUND STATEMENT :OF'SURPLUS_- .UNAPPROPRIATED VILLAGE OF EDINA Year Ended, December, 31, 1969 Balance at January,1,.1969 i$29,274.55 Additions: Net income for year 2,338.87 Balance at,December 31, 1969 $31,613.42 STATEMENT.'OF.REVENUES AND EXPENDITURES Revenue receipts and accruals: Tax settlements Income on investments Disbursements and accruals: Suburban:Hennepin County-Relief,Board: Relief.orders ,Administration Rural'.Hennepin County.Nursing Committee Professional.services NET 'INCOME Year Ended December. 31 I- $15,403.60 $15,339.11 1;282.98 432.19 $16,686.58 $15,771.30 .$:2,261.98 962.24 10,998.49 125.00 $14,347.71 $. 2;338.87 $ 565..25 :1,058.62 :10,998.49 ;100.00 $12,722.36 $:3,048.94 Increase Decrease* $ 64.49 850.79 '$ 915.28 $ 1,696.73 96.38* 25.00 $ ;1,625.35 $ '710.07* -24- POOR 'FUND ANALYSIS:OF CHANGE IN CASH BALANCE VILLAGE OF EDINA Year:Ended December 31,,1969 Balance at January J,.1969 Additions: Sale of investments Tax settlements received: March 1969 June 1969 ,November 1969 Income on.investments Deductions: Payment . to - Suburban Hennepin County Relief :Board: Relief.orders Administration Less accounts payable at December 31, 1969 `Rural.Hennepin County.Nursing Committee Professional.service Purchase of investments $ 957.76 7,463.91 o 6,981.93 ,$15,403.60 - 1,282.98 $ 2,274.55 21,000.00 16,686.58 $39,961.13 $2,261.98 962.24 .$3,224.22 223.41 $ 3,000.81 10,998.49 125.00 .25,358.30 39,482.60 Balance at December 31,,1969 $ 478.53 -25- PARK FUND BALANCE : SHEET :VILLAGE OF'EDINA :December 31, 1969 ASSETS Cash: Demand deposits Investments: United,States Treasury bonds - at cost Receivables: Accounts receivable Taxes receivable — delinquent Less allowance for delinquent taxes Due from other funds Inventory.of.supplies — estimated Fixed assets - on the basis of cost LIABILITIES AND.SURPLUS 'Liabilities: Trade accounts payable .Accrued salaries and..wages '.Due to other -funds - :Unexpended_contributions:for specific purposes: Dwight Williams:Memorial,Park Wooddale Park- improvements and recreation program Cornelia..Lake Park - .improvement Braemar Sports Complex :Teen -Age Recreation Program Park'District:.No. -2 Park District.No..3 ,Park_District.No. 4 Park District -.No. 5 'Figure skating and.skiing.,instructors' salaries Hockey,equipment Edina Swim Club Other surplus: Invested.in fixed .assets: Direct .Contributed: Property and special assessment-paid 'by.>Generai Fund $350,567.55 Property donated by others 10,558.66 -Unappropriated (deficit)_, $ .39763.81 :3,763.81 $ :100.00 1,416.31 71.00 . 1,738.34 1,456.26 6,185.00 2,150 -00 3,400.00 -500.00 9,842.82 391.83 ,146.47 4114 r_, $804,962.22 $ 18,158.94 .12,500.00 400.00 8,725.00 600.00 ,,1;166,088.43 ,$1;206,472.37 $ 4,675.08 5,433.51 13,147.35 28,034..64 361,126.21 131166,088.43 ( 10,906.64) $1,206,472.37 -26- PARK FUND STATEMENT OF UNAPPROPRIATED.SURFLUS VILLAGE OF:EDINA Year Ended..December :31, 19'69 Balance (deficit).at..January,l, 1969 Additions: Revenue for year :(see separate.schedule for details) ($.18,281.99) 257,454.35 $239,172.36 Deductions: Expenditures for year,,including $14;205.00 for capital outlay. 'for :fixed assets (see detail schedule) 250,079.00 .Balance (deficit) at December 31,:1969 ($ 10,906.64) ANALYSISOF SURPLUS :'.INVESTED ,IN FIXED• ASSETS Contr: , By .-General Fund by Payment of Special Combined Assessments Balance at January,!, 1969 $ 531,074.05 ;$308,825.65 Additions for the year: Lbuted Direct ,Investment in Fixed By Others Assets $10,558.66 $211,689.74 From unappropriated surplus 14,205.00 14,205.00 Special assessments paid by General Fund 41,741.90 41,741.90 .Transfer of .:fixed .assets Park Construction Fund 5831,690.94 583,690.94 $1,170,711.89 $350,567.55 $10,558.66 $809,585.68 Deduct: Fixed assets,traded.,in 4,623..46 4,623.46 Balance at December 31, 1969 $1,166,088.43 $350,567.55 $10,558.66 :$804,962.22 -27- PARK FUND ANALYSIS OF CHANGE IN CASH BALANCE VILLAGE.OF -EDINA Year Ended,December 31, 1969 Balance at January 1, 1969 Additions: Receipts for year (see separate schedule for details) .Registration .fees.- figure skating and skiing Dedicated funds: .Teen -Age Recreation Miscellaneous Deductions: Disbursements for year (see separate schedule for details) .Expenses - figure skating:and. skiing Purchase of investments Payment on accruals at�December 31, 1968: Trade accounts Accrued payroll Due to other funds Payment from dedicated funds $ 27,272.19 $263,911.04 26,873.20 $ 4,496.12 :34.00 4,530.12 2957314.36 $322,586.55 ;$253,181.00 16,883.59 :12,500.00 $ 1,986.11 4,388.02 14,371.90 20,746.03 1,116.99 304.,427.61 Balance at December 31, 1969 $:18,158.94 -28- PARK FUND REVENUE AND EXPENDITURES -VILLAGE OF EDINA Year Ended December 31, 1969 REVENUE Real and .personal property taxes Registration fees Transfer from active funds Other revenue TOTAL REVENUE EXPENDITURES Administration: Personal services Contractual services Commodities Central services Training Paid leave TOTAL.ADMIN.ISTRATION Capital outlay Recreation: Baseball and softball Skating and hockey 'Tennis.instruction Playgrounds Swimming instruction `Teen program Special activities TOTAL RECREATION Maintenance: :Mowing Special turf care Planting and trees iLitter removal Parking areas Building.and equipment Skating rinks TOTAL MAINTENANCE TOTAL EXPENDITURES ( )'Indicates:red figure. -29- Actual Revenue Over- Under* 'Estimated Estimated Receipts Accruals Revenue Revenue Revenue $113;568.00 $113.,568.00 $114,147.00 $ '579.00* :30,504.00 ($6,457.00) 24,047.00 27;000.00 2,953.00* 119,498.00 119,498.00 119,498.00 - :341.04 .31 341.35 1,000.00 658.65* $263,911.04 ($6,456.69) $257,454.35 $261,645.00 $4,190.65* Unexpended .Disbursements Encumbrances Expenditures Appropriation Balance $,39,339.00 $ 39,339.00 $.39,800.00 $ 461.00 2 ;021.00 $ -56.00 2,077.00 2,200.00 %123.00 82.00 82.00 '125.00 '43.00 30,840.00 30,840.00 30,840.00 - .155.00 1155.00 370.00 215.00 .92051.00 1,154.00 10,205.00 10,400.00 195.00 $ 81,488.00 $1 3210.00 $ 82,698..00 $ 83,735.00 '$ 1,037.00 22;352.00 ( 8;147..00) .14;205.00 14,200.00 :( 5.00) $ `.4,306.00 $ 4,306.00 $ 4,350.00 $ 44.00 10,211.00 .,$ 166..00 10,377.00 10,400.00 23.00 ,12 ;249.00 2,249.00 2,275.00 26.00 11,839.00 11,839.00 11,850.00 11.00 16,255.00 162255.00 16;275.00 20.00 15,853.00 ( 43403.00) . 1,450.00 1,490.00 40.00 6 331.00 37.00 6,368.00 6,150.00 ( 218.00) 54..00) 57,044.00 ($4;200.00) $ 52,844.00 $ 52,790.00 ($ $;11,746.00 $ 11,746.00 $13,650.00 $ 1,904.00 14,498.00 $1,229.00 - 15,727.00 16 ;980.00 1,253.00 :5,901.00 465.00 6.,366.00 02650.00 284.00 4,280.00 4,280.00 52800.00 1,520.00 43031.00 42031.00 52400.00 15369.00 24;014.00 964.00 24,978.00 26,840.00 1,862.00 .27,827.00 5,377.00 .333204.00 352600.00 2,396.00 $ 92;297.,00 $8,035.00 $100,332.00 $110;920.00 $10,,588.00 $253,181.00 ($32102.00) $2502079.00 $261.,645.00 $11,566.00 -29- PARK FUND FIXED.ASSETS VILLAGE OF EDINA Year Ended December 31, 1969 Construction in progress: 52nd Balance 131.26 131.26* Balance 50th January 1, 2,324.85 2;324.85* December 31, East 1969 , Additions Deductions Transfers 1969 57th-and Land $'90,806.64 261.36* - $ 90,806.64 Skating rinks :5,812.03 $639;637.84 $4.,623.46 $ - $1,166,088.43 5,812.03 Land,improvements :325,946.10 $ 41,741.90 367,688.00 Building 4,042.32 .4.,042..32 _ Park equipment 51,606.43 35-420.00 55,02.6.43 Furniture, fixtures and equipment - 2,612.78 54.00 2,666.78 Trucks, automobile and tractors 37,023.24 10,507.00 $4,623.46 42,906:78, Miscellaneous 6,721.32 224.00 6.,945.32 .Parks: .Utley Park - 22,457.91 $2;324.85 24.,782.76 Chowen Park - 6,414..59 2.61.36 6,6.75.95 Arden Park - 17,629.22 131.26 -17,760.48 ,Normandale Park - 47,123.53 47,123.53 Alden Park - 30,576.10 - 30,576.10 Highlands Park - 61,536.94 3,785.72 65,322.66 York Park - 9,368.19 9,368.19 McGuire Park - 3,959.00 3,959.00 Cornelia School Park - 41,631.64 41,631.64 Nine Mile Creek Parkway - 3,2.20.92 3;220.92 Lake Edina:Park - 34,826.54 34,826.54 Countryside Park - 23,227.65 23,227.65 Beard Park - 15,160.46 15,160.46 Division Park - 36,068.46 36,068.46 Valley View School Park - 8,696.96 8;696.96 Garden Park - 45,518.85 45,518.85 Heights'Park - 26,200.40 26,200.40 Walnut Ridge Park - 13,504.15 13,504.15 Creek Valley School Park - 54,232.73 54,232.73 Cornelia Park - 48,239.51 48,239.51 Weber Park - 21,325.65 21$25.65 Sherwood Pump Park - .700.51 700.51 Birchcrest Park - 2,816.49 2,816.49 Tingdale Park - 44020.11 4,020.11 St. John's.`Park - 733.33 733.33 Bristol Park - 43501.10 4,501.10 Construction in progress: 52nd and Arden 131.26 131.26* - 50th and Wooddale 2,324.85 2;324.85* - East Mirror-Lake 3,785.72 3,785.72* 57th-and Chowen 261.36 261.36* - TOTAL $53,1;074.05 $639;637.84 $4.,623.46 $ - $1,166,088.43 -30- SWDAMING POOL FUND 'BALANCE 'SHEET VILLAGE :OF EDINA December 31, 1969 ASSETS Cash (deficit) Fixed assets - at cost: Land Swimming.pool and bathhouse Filter system Concession 'furniture and fixtures 'Less-allowance for depreciation ($ 11,552.44) $ '10,000.00 184.,026.67 17,000.00 :$400:00 51.25 348.75 211,375.42 $199,822.98 LIABILITIES AND, SURPLUS Payables: Trade accounts Due to Park Sinking Fund Surplus: Invested.in fixed assets: Acquired by.'bonds Acquired by surplus :Donated Unappropriated (deficit) $209,431.89 :1,893.53 50.00 $ :181.09 5,500.00 $ :5,681.09 211,375.42 ( 17,233.53) ,,$199,822.98 -31- SWIMMING POOL FUND STATEMENT OF SURPLUS 'VILLAGE.OF.EDINA Year Ended December 31, 1969 Invested in Fixed Assets Unappro- From From Total priated Donated Surplus Bond Fund Balance at January 1, 1969 $190,389.82 $21,175.68* $ 50.00 $2,083.61 $209,431.89 Additions and transfers: Net - income for the year Interest provided-for at December 31, 1968 included ;in operations Provision for depreciation Deduct: Allocation to Sinking Fund for interest * Indicates -red figure. 3,252.07 3,2521.07 6,000.00 6,000.00 - 190.08 190.08* $199,641.89 $11,733.53* $ 50.00 $1,893.53 $209,431.89 5,500.00 5,500.00 $194,141..89, $17,233.53* $'50.00 $1,893.53 .$209,431.89 -32- SWI101ING POOL FUND ANALYSIS W CHANGE IN CASH BALANCE VILLAGE OF 'EDINA Year Ended_December 31, 1969 Balance (deficit) at January.l, 1969 Additions: Pool fees Concession income (see separate schedule) $1,727.00 Add .provision for depreciation not requiring ,cash 190.08 Other revenue Deductions: $45,195.00 1,917.08 1,550.07 Operating:expense.(see separate schedule) $39,220.00 Less accounts payable at December 31,_1969 181.09 $39,038.91 Payment made on accruals at December 31,,1968 6,179.40 Balance (deficit) .at December. 3,1, ,1969 ($14;996.28) .48,662.15 $33,665.87 45, 2.18.3.1 ($:11,552.44) -33- . SWIMMING POOL FUND STATEMENT OF-INCOME AND EXPENSE VILLAGE OF EDINA Year Ended - December 31, 1969 Revenues: Pool fees: Season tickets General admissions ,Rental -.Instruction-program Other Operating expenses :` Salaries and wages: Supervision and clerical 'Lifeguards Cashier Basket room attendants Watchmen Maintenance Light and power Water and sewer Gas Telephone Rubbish hauling 'Insurance 'Repairs -and maintenance Cleaning supplies Water treatment General supplies Annual audit Printinvand office expense Central services Other Interest on bonds Income from concessions.- see separate schedule $ '3,866.00 11,254.00 1,153.00 3,926.00 849.00 4,160.00 $38,.680.00 6,515.00 ,..$45,195.00 1,500.00 50.07 $46;745.07 $ 25,208.00 2;213.00 30.00 3;094.00 150.00 150.00 325.00 2;455.00 .138.00 1,249.00 1,023.00 125.00 447.00 .2,580.00 33.00 39,220.00 $ 7,525.07 6,000.00 $:1,525.07 1;727.00 NET `INCOME'FROM OPERATION $:33252.07 -34- SWIMMING POOL FUND STATEMENT OF INCOME AND-EXPENSE .(CONCESSIONS ONLY) VILLAGE OF EDINA Year Ended December 31, 1969 Gross 'Profit Operating :expenses: Salaries and wages: Manager .Clerk Supplies Repairs and maintenance Provision for depreciation $93415.00 $4,878.00 $4,537.00 $ :443.00 2,017.00 2,460.00 :80.00 80.00 190.00 NET :INCOME 2,810.00 $1,727.00 Per Cent to Sales 45.83% 52.08 75.47 37.46 27.24 61.68 48.19% -35- Cost of Sales Sales Amount Soft drinks $.1,379.00 $ 747.00 $ 632.00 Soft ice cream 3,030.00 1,452.00 1,578.00 Popcorn 1,753.00 430.00 %1,323.00 Pies 590.00 369.00 221.00 Cakes 2,496.00 1,816.00 680.00 Other 167.00 64.00 103.00 Operating :expenses: Salaries and wages: Manager .Clerk Supplies Repairs and maintenance Provision for depreciation $93415.00 $4,878.00 $4,537.00 $ :443.00 2,017.00 2,460.00 :80.00 80.00 190.00 NET :INCOME 2,810.00 $1,727.00 Per Cent to Sales 45.83% 52.08 75.47 37.46 27.24 61.68 48.19% -35- SWIMMING POOL-FUND FIXED ASSETS VILLAGE OF EDINA Year Ended December 31, 1969 ASSETS, Land Swimming pool and bathhouse Filter system Concession furniture and equipment ALLOWANCE FOR DEPRECIATION Concession furniture and- equipment 'Balance Balance January.l, December 31, .1969 Additions Deductions 1969 $40,000.00 $ 10;000.00 184,026.67 184;026.67 17,000.00 175000.00 3,802.37 $3,402.37 400.00 $214,829.04 $ - $3,402.3.7 $211,426.67 $ 3,263.54 $190.08 $3,402.37 $ 51.25 NET 'BALANCE ...$211,565.50 $211,375.42 -36- GOLF COURSE FUND BALANCE SHEET VILLAGE OF EDINA December 31, 1969 ASSETS Cash: On deposit:(deficit) Working :funds Investments: Federal:National Mortgage Association - at cost Accrued interest Accounts receivable Due from other funds Prepaid expenses Fixed assets - at cost: Golf course Buildings Well Parking lot and roadways Equipment Less allowance for depreciation Accounts payable Due to other funds Loan from Liquor Dispensary Fund Bonds payable Surplus: Appropriated - for debt service Unappropriated $71,550.98 32,592.11 LIABILITIES AND SURPLUS ($ 3)203.06) 50.00 ($ 31153.06) $ 75,358.30 113.89 75,472.19 82.60 18,694.70 .148.54 $726,414.02 182,906.82 15,018.15 9,627.32 38,958.87 .972,925.18 $1,064,170.15 $ 2,446.98 9,039.80 250,000.00 725,000.00 52,300.00 25,383.37 $1,064,170.15 -37- � --, GOLF COURSE FUND STATEMENT OF SURPLUS VILLAGE OF EDINA Year Ended December 31, 1969 Appropriated for Debt Service Balance (deficit) at January 1, 1969 $52,300.00 Add net income for the year Balance at December 31, 1969 $52,300.00 Unappropriated ($15,057.31) .40,440.68 $25,383.37 -38- GOLF 'COURSE 'FUND ANALYSIS OF-:CHANGE-IN CASH BALANCE VILLAGE.OF EDINA Year Ended _December 31, 1969 Balance at January 1,.1969 Additions: Revenue - see separate schedule ,Net income - operating department - see separate schedule Add depreciation included therein not requiring cash Sale of investments Income on.-investments Decrease in accounts receivable Decrease in prepaid expenses Increase in. liabilities: Balance at December 31, 1969: Accounts payable Due to other funds Balance at January-1, 1969: Accounts payable Due to other funds Deductions: Operating expenses - see separate schedule Investments purchased Fixed assets :purchased,.less carrying value of disposals Payment to fiscal agent: Principal Interest Service charge .Interest paid .Liquor Dispensary Fund Increase in amount due from other funds $ 3,334.08 $174,072.68 $21,148.00 1,914.00 23,062.00 10,307.34 3,450.00 1,638.30 19.87 $ 2,446.98 9,039.80 11,486.78 $ 958.22 :8,750.00 9,708.22 1,778.56 214,328.75 $217,662.83 $119,665.00 25,472.19 :3,0,96.00 $25,000.00 .24,450.00 61.00 $49,511.00 8,750.00 58,261.00 14,371.70 220,865.89 Balance (deficit) at December 31,,1969 ($ 3,203.06) -39- GOLF.COURSE'FUND STATEMENT OF INCOME AND EXPENSE VILLAGE.OF EDINA Year Ended December 31, 1969 Revenue: Membership fees Green fees: Regular course Short course Rental - 1969 Golf:Classic Locker rental Other Operating expenses: Administration: Salaries and wages: Manager - pro Supervision Rangers and starters Cashiers, clerical and other Audit Printing Supplies Insurance and alarm system Retirement,.insura.nce,.office supplies, etc. Travel and mileage Other Building. - club-house and pro shop: Salaries and wages Utilities: Telephone Water and sewer 'Fuel .!Light and power Laundry Rubbish hauling Less amount charged to grill Insurance Repairs - building.and.equipment Supplies Other $1,235.00 123.00 .1,243.00 1,576.00 1,196.00 480.00 $5,853.00 1.,756.00 $ 1,926.00 4,097.00 172.00 3,608.00 1,461.00 .197 nn $122,182.00 18,965.00 $ 3,900.00 7,300.00 2,398.00 8,189.00 $ 2.1,787.00 550.00 1,483.00 137..00 741.00 8,460.00 148.00 251.00 $:33,557.00 11,391.00 $ 23,124.00 141,147.00 8,250.00 1,320.00 23.1.68 $174,072.68 -40- GOLF COURSE FUND STATEMENT OF 1NCOME AND EXPENSE (Cont'd) Operating expenses (cont'd): Maintenance -of course and grounds: Salaries and wages: Superintendent $ 9,180.00 Maintenance , 31,463.00 $40;643.00 'Equipment rental 547.00 'Telephone 219.00 Light and power 3,751.00 Fuel 358.00 Fertilizer and .chemical 7,202.00 Sod, black dirt and seed 22399.00 Blacktop, sand and gravel 1,091.00 Repairs 835.00 Lumber 645.00 Equipment.operation ,11,400.00 U.S.G.A. visiting service 200.00 Supplies 5,400.00 Other 27.00 $ 7.4,717.00 $119,665.00 $:54;407.68 Net income - operating departments - see separate schedule $ 21;148.00 'Income-on-investments 32450.00 '24,598.00 INCOME BEFORE INTEREST AND'DEPRECIATION $.79,005.68 Interest expense: On 'bonds On loan from.Liquor Dispensary Fund Provision for depreciation $:24,511.00 8,750.00 INCOME BEFORE DEPRECIATION NET INCOME 33,261.00 $ 45,744.68 5,304.00 $ 40,440.68 -41- :GOLF_COURSE FUND STATEMENT OF INCOME AND'EXPENSE - OPERATING DEPARTMENTS VILLAGE OF'EDINA Year Ended December 31,:1969 Driving range: Revenue Less operating expenses: Salaries and wages Replacement - balls Supplies Provision for depreciation Grill: Sales: Food Beer Other Less cost of.goods sold: Food Beer Less operating expenses: Salaries and wages: Manager Cooks, waiters and waitresses Insurance — liability Dishes, napkins, tools, etc. Repair work Expenses - .prorated Provision for depreciation Other $ 4,701.00 2, 898.00 720.00 888.00 $17,640.00 4.,182.00 $:3,705.00 9,900.00 .$13,605.00 154.00 195.00 506.00 1,756.00 1,026.00 233.00 $24,046.00 9,207.00 $33,654.00 :11,444..00 508.00 $45,606.00 21,822.00 $23;784..00 $14,839.00 17,475.00 62309.00 NET INCOME .$21,148.00 -42- GOLF COURSE .FUND FIXED ASSETS - VILLAGE OF EDINA Year Ended December 31, 1969 -43- Balance Balance January.l, December 31, 1969 Additions Deductions 1969 ASSETS Golf course $ 726,414.02 $ 726,414.02 Buildings: Club house $ 174,202.26 $ 174,202.26 Maintenance building 6,,491.92 0,491.92 Range building 2,212.64 2;212.64 $ 182,906.82 $ - $ - $ 182,906.82 Well 15,018.15 15,018.15 Parking lot and roadways 9;627.32 9;627.32 Equipment; Golf'course equipment $ 41,766.57 $2,130.00 $ 550.00 $ 43,346.57 Clubhouse equipment 8,100.91 8,100.91 Pro -shop equipment 2,446.19 1,500.00 3,946.19 Range equipment -6,160.93 6,160.93 Concession equipment 10,516.38 520.00 9,996.38 $ 68,990.98 $3,630.00 $1,070.00 $ 71,550.98 $1,002,957.29 $3,630.00 '$1,070.00 $1,005,517.29 ALLOWANCE FOR DEPRECIATION Golf course equipment $ 14,360.71 $4,255.66 $ 275.00 $ 18,34.1.37 Club house equipment 2,712.90 728.48 3,441.38 Pro -shop equipment 1,019.21 319.63 1,338.84 Range equipment 3,510.07 887.59 4,397.66 Concession equipment .4,307.22 1,025.64 260.00 5,072-.86 $ 25,910.11 $7,217.00 $ :535.00 $ :32,592.11 NET BALANCE .$ :977,047.18 $ :972,925.18 -43- GOLF.COURSE.FUND BONDS PAYABLE VILLAGE OF EDINA December 31, 1969 Annual maturity and interest date December 1 and June l Interest rate 2.87. to 3.5% Year 1970' $- 25;000.00 1971 35,000.00 1972 35,000.00 1973 35,000.00 1974 35,000.00 1975 35,000.00 1976 '35;000.00 1977 40,000.00 1978 40,000.00 1979 40,000.00 1980 40,000.00 1981 40,000.00 1982 40,000.00 1983 50,000.00 1984 50;000.00 1985 50,000.00 1986 50,000.00 •1987 50, 000.00 TOTAL $725,000.00 -44- RECREATION CENTER FUND BALANCE SHEET VILLAGE OF EDINA December '31, 1969 ASSETS Cash: On deposit (deficit) ($ 703.94.) Working fund 1,000.00 $ 296.06 Investments: Federal National Mortgage Association - at cost $:167,071.88 Accrued interest 614.84 $167,686.72 United _States,Treasury bonds - at cost $ 5,000.00 Accrued.interest 18.56 5,018.56 172,705.28 Accounts receivable 4,241.50 Due from other funds 8,000.00 Merchandise inventory - at cost 1,795.36 Advance to Park Construction Fund 200,000.00 Prepaid insurance 903.34 Fixed assets - on the basis of cost: Land improvements $:32,185.72 Building 511,693.34 Furniture and equipment $ 27,773.77 Less allowance for depreciation 9,532.68 18,241.09 562,120.15 LIABILITIES AND SURPLUS Accounts.payab.le Accrued payroll Accrued interest Due to other funds: Golf Course Fund Permanent Improvement Revolving Fund Liquor Fund Deferred income Bonds payable Surplus: Invested in fixed assets: Direct Contributed Appropriated.- for debt service Unappropriated $14,656.70 100,000.00 .175,000.00 $36.,070.15 6,050.00 $950,061.69 $ 13,784.35 1,904.41 5,113:32 289,656.70 $310,458.78 9,681.00 520,000.00 42,120.15 36,500.00 .31,301.76 $950,061.69 -45- .'RECREATION CENTER FUND STATEMENT OF SURPLUS -VILLAGE 'OF.EDINA .Year Ended December'31,,1969 Appropriated Contributed Invested in Invested in For Debt Unappropriated Fixed. Assets Fixed Assets Service Total Balance rat ~January.'1, -.1969 $25,627.46' $18,379.73 $7,150.00 $362500.00 $62,029.73 Additions: Net..income for year 22,264.72 Fixed assets purchased 41240.00* 43,240.00 4.,240.00 Transfers: Payment -of bonds. 1531000.00* 15,000.00 I `15,000.00 Provision for depreciation 2,649.58 1,549.58* l = 1100.00* 25649658* Balance at December 31,.196.9 $31;301.76 $36,070.15 $6,050.00 $36,500.00 $78,620.15 Indicates-red-figure. i I I I i I i I I i I -46- RECREATION CENTER FUND ANALYSIS OF CHANGE IN CASH BALANCE VILLAGE OF EDINA Year Ended .December 31,:1969 Balance at January 1, 1969 Additions: Excess:of revenue over expenses - see separate schedule $22,264.72 Add depreciation included therein not requiring :cash 2,649.58 Sale of :investments Loan from Liquor Fund Sale of bonds Decrease in inventory ::Decrease.in due from other funds Increase in deferred income Increase.in liabilities: Balance at 12/31/69: Accounts payable $13,784.35 Accrued.payroll 1,904.41 Accrued interest 5,113.32 Due to other funds 14,656.70 $35,458.78 Balance at January 1, 1969: Accounts payable Accrued payroll Accrued interest Due to other funds Deductions: Purchase of investments Advance to Park Construction Fund Payment of bonds Additions to fixed assets 'Increase.in working:fund 'Increase in prepaid insurance Increase.in accounts receivable $ 24,914.30 15,461.01 175,000.00 100,000.00 341.62 933.65 618:00 $:7,984.94 1,381.65 4,696.67 :550.00 14,613:2,6 20,845.52 $142,705.28 200,000.00 15,000.00 4,240.00 200.00 52.60 356.00 Balance (deficit) at December 3,1, 1969 $ 23,735.84 338;114.10 $361,849.94 362,553.88 ($ 703.94) -47- RECREATION - CENTER FUND STATEMENT 'OF 'INCOME AND EXPENSE VILLAGE .OF 'EDINA Year Ended December 31, 1969 Revenues: Season tickets Daily fees Spectator fees Ice rental Skate sharpening and repair Other Concession income Less operating.expense: Cost of food sold Salaries and wages Operating expenses: Salaries and wages: Manager Supervision and clerical Ice guard Cashier and ticket takers Custodian Maintenance Organist Other expenses: Light and ..power Fuel and heat Central services Equipment maintenance Lumber and paint Mileage and conference expense Telephone Printing Supplies Insurance Audit Tartan surfacing Rubbish hauling Other Income on investments Interest on bonds Provision for depreciation $18,642.00 $ 5,621.00 2,371.00 7,992.00 $9,719.00 3;321.00 .1,449.00 3,741.00 9,035.00 23,616.00 .1,015.00 51,896.00 $10,085.00 11,566.00 10,560.00 7,785.00 1,702.00 282.00 1,130.00 1,.358.00 9,108.00 1;239.00 450.00 2,345.00 450.00 178.00 58,238.00 INCOME BEFORE DEPRECIATION NET 'INCOME $-19,930.00 :10,867.00 21,563.00 75,486.00 6.,209.00 552.30 .10,650.00 $145;257.30 110,134.00 :3,342.00 $:38,465.30 13,551.00 $ 24,914.30 2.649.58 $ 22;264.72 -48- RECREATION CENTER FUND FIXED ASSETS VILLAGE OF:EDINA Year Ended December 31, 1969 Balance Balance January 1, December 31, 1969 Additions Deductions 1969 ASSETS Land $32;185.72 $'32,185.72 Building 511;693..34 511,693.34 Furniture and.equipment 23,533077 $4,240.00 27,773.77 $567,412.83 $4,240.00 $ - $571,652.83 ALLOWANCE FOR'DEPRECIATION Furniture and equipment $ 6,883.10 $2,649.58 .$ $ :9,532.68 NET BALANCE $560,529.73 $562,120.15 -49- RECREATION-CENTER FUND BONDS PAYABLE VILLAGE OF EDINA December 31,.1969 Annual maturity and .interest date March l and March l and February l and September .1 September l August l Interest rate 3% to 3% 5% 3.3% .Year Series A Series -B Series C .Total 1970 $ 10,000.00 $ :5,000.00 $ 10,000.00 $ 25,000.00 1971 10,000.00 .5,000.00 10,000.00 25,000.00 1972 10,000.00 5,000.00 :10;000.00 25,000.00 1973 20,000.00 10;000.00 110,000.00 40,000.00 1974 20,000.00 10,000.00 10,000.00 40;000.00 1975 20,000.00 X10,000.00 10,000.00 '40,000.00 1976 - 20;000.00 10,000.00 10,000.00 40,000.00 :1977 20,000.00 10,000.00 .10,000.00 40,000.00 '1978 30,000.00 15,000.00 :10,000.00 '55,000.00 1979 30,,000.00 15,000.00 10,000.00 55,000.00 1980 30,000.00 15,000.00 - 45,000.00 1981 30,000.00 15,000.00 45,000.00 1982 30,000.00 115,000.00 '45,000.00 TOTAL $280,000.00 $140,000.00 $100,000.00 $520,000.00 -50- PARK SINKING FUND BALANCE 'SHEET VILLAGE OF EDINA December 31, 1969 ASSETS Cash: Demand deposits Investments: United - States Treasury .notes - at face value Federal Home Loan Bank notes - at cost United States Treasury bonds - at cost Receivables: Due from Swimming•Pool Fund Taxes receivable — current and delinquent Taxes receivable — deferred Less allowance for delinquent and uncollectible taxes $ 25,000.00 51,119.16 27,500.00 $ 5,500.00 $ 1,263.49 103,619.16 $ 65,542.73 616,000.00 $681,542.73 34,567.73 646,975.00 652,475.00 .$757,357.65 LIABILITIES, RESERVE AND SURPLUS Amount payable during J970: Interest $ 20,755.00 Bonds 40,000.00 $ 60,755.00 Bonds payable $570,000.00 'Less current portion —shown above 40,000.00 530,000.00 Reserve for-future interest' $135,495.00 ,Less current portion - shown above 20,755.00 :114,740.00 Unappropriated surplus 51,862.65 $7572357.65 -51- PARK SINKING FUND STATEMENT OF 'SURPLUS VILLAGE'.OF EDINA Year Ended December 31, 1969 Balance at January 1, 1969 Additions: Income on investments Transfers: Reserve -for future interest $22,135.00 Reserve for uncollectible taxes 9;245.00 Deductions: Allowance for delinquent-taxes Payment to fiscal agents: Interest .$2.1,410.00 Service charge 124.42 Balance at December 31, 1969 :$ 3,665.08 '31,380.00 $ 4,962.51 $43,314,.50 35,045.08 $78;359.58 21,534.42 26.,496.93 $51,862.65 -52- PARK SINKING FUND ANALYSIS OF CHANGE IN CASH BALANCE VILLAGE OF EDINA Year Ended December 31, 1969 Balance at January.l, 1969 Additions: Tax settlements received from county: March 196.9 June 1969 November 1969 Sale of investments 'Income on investments Payment received on amount due from other funds at December 31, 1968 Deductions • Purchase .of investments Payment to fiscal agents: Principal 'Interest Service charge Payment of amount due other funds Balance at December 31, 1969 $ :4,160.49 30:,833.72 -28,363.28 $30,000.00 21,410.00 124.42 $:17;917.50 $63,357.49 41,477.00 3,665.08 6,000.00 114,499..57 $132,417.07 $78,619.16 51,534.42 1,000.00 131,153:58 $ 1,263.49 -53- PARK .SINKING FUND BOND AND'INTEREST MATURITIES AND DEFERRED TAX LEVIES VILLAGE '.OF EDINA December 31,:1969 Annual maturity and interest date March.l, June 1, September 1 and December 1 Interest rates 2.7% to-3.90% Excess of Deferred -Levies over Bond and`Interest Deferred ,Year Bonds. Interest Maturities Levies 1971 $ 40,000.00 $ 19,3,75.00 $10;625.00 $70,000.00 1972 50,000.00 17,810.00 3,190.00 71,000.00 1973 50,000.00 16,040.00 5,960.00 .723000.00 .1974 50.,000.00 14,230.00 7,770.00 '72,000.00 1975 50,000.00 12,380.00 10,620.00. 73;000.00 1976 40,000.00 10,530.00 123470.00 63;000.00 1977 50,000.00 8,775.00 5,225.00 642000.00 1978 50,000.00 6_,825.00 8,175.00 65,000..00 1979 50,000.00 4,875.00 11,125.00 66,000.00 1980 50,000.00 2,925.00 52,925.00* 1981 50,000.00 .975.00 50,975.00* TOTAL $530,000..00 $1.14,740.00 $28,740.00* $616,000.00 * Indicates red figure. -54- PARK CONSTRUCTION-FUND BALANCE SHEET VILLAGE OF EDINA December 31, 1969 ASSETS Cash: On deposit Investments: Edina Park System bonds - at face value United States Treasury bonds - at face value Federal Home'Loan Banknotes - at cost Fixed assets - at cost: Land Construction in progress _LIABILITIES,- RESERVE AND SURPLUS Trade accounts payable Due to other funds Contracts-payable-for purchases of ;land Advance from Recreation Center.Fund Reserve for construction Surplus.invested in fixed assets $:15,000.00 10,000.00 76,640.42 312:54 :101,640.42 $963,574.24 379,043.47 1,342,617.71 $:1,.444,570.67 $ :323234.69 22,388.53 46,139.22 200,000.00 47,329.74 :1,096,478.49 $1,444,570.67 -55- PARK CONSTRUCTION FUND ANALYSIS OF RESERVE FOR CONSTRUCTION VILLAGE OF'EDINA Year Ended December 3,1, 1969 Balance at January 1, 1969 Additions: Transfer from Liquor Dispensary Fund Other Deductions: Purchase of.fixed.assets Contract payments for purchase of .land Transfers from Recreation Center Fund $130,000.00 786.97 $287,761.44 31,400.00 $319,161.44 $;35,704.21 130,786.97 $166,491.18 200,000.00 119,161.44 Balance at December 31,.,1969 $ 47,329.74 -56- PARK CONSTRUCTION FUND ANALYSIS OF CHANGE-IN CASH BALANCE VILLAGE OF EDINA Year Ended December 31, 1969 Balance at -January 1, ,1969 Additions: Transfer from Liquor Dispensary Fund Payment from other funds Advance from Recreation Center Fund Sale of investments 'Miscellaneous Deductions: Purchase of fixed assets: Recreation Center Other Purchase of: investments 'Decrease.in:liabilities: . Balance at January.l, 1969: .Accounts payable Due to other funds Contracts payable Balance at December 31, 1969: Accounts payable Due to other funds Contracts payable $32,234.69 :22,388.53 46,139.22 $101;247.04 186,1514..40 $ 1,699.2.9 :46,144.85 61,839.22 .$109;683.36 $130,000.00 :1,550.00 200,000.00 40;000.00 - 786.97 287,761.44 86.,640.42 $:11,298.35 372;336.97 $383,635.32 100,762.44 8,920.92 383;322.78 Balance at December 31, 1969 $ 312.54 -57- PARK CONSTRUCTION FUND FIXED. ASSETS VILLAGE OF EDINA December.31,.1969 Land: Garden Park Braemar Park Cornelia School Park Pamela Park Alden Park Beard Park Arden Park Countryside Park Lake Edina -Park York Park Birchcrest Park Division Park Normandale Park Walnut Ridge Park Heights Park: Valley View School site Creek Valley School Park Mud Lake Cornelia Park :Morton Arneson Park Construction in progress: Pamela Park Braemar Park Mud Lake Historical site Recreation Center SUMMARY OF CHANGES;IN FIXED ASSETS Balance at January -1, 1969 Purchase of :fixed.assets Deduct: Transfer to Park Fund (see separate schedule) $,15,007.09 230;5,70.37 12,639.48 2,440.00 23,506..60 26,715.00 1,250.00 18,300.00 30;330.00 7;369.21 .1.1,620.22 16,908.88 16,594.04 3,466.84 23,537.13 1,217.55 38,809.53 395,614.60 85,126.65 2,551.05 $2222015.43 33;590.28 10,497.74 11,692.98 101,247.04 TOTAL Balance at December 31, 1969 _$ :963;574.24 - 379,043.47 $,1,342,617.71 $1,638,547.2,1 287,761.44 $1,.926,308.65 583,690.94 $1,342,617.71 -58- PARK CONSTRUCTION FUND ANALYSIS OF CHANGES IN CONSTRUCT.ION.IN PROGRESS VILLAGE OF EDINA December 31„ 1969 $784,698.47 $178,035.94 $583,690.94 $379,043.47 _ -59- Balance Transfers Balance January 1, to December 31, :1969 Additions Park Fund 1969 Utley Park $ 22,3,78.91 $ 79.00 $ 22,457.91 $ - Chowen Park 6;414.59 6,414.59 - Cornelia Park 47,895.13 344.38 48,239.51 - Pamela Park 196,975.39 25,040.04 222,015.43 Arden Park 17,629.22 17,62,9.22 - Normandale Park 47,123.53 47,123.53 - A1den.Park 30,576.10 30.,576.10 - Highlands:Park 61,036.94 500.00 61;536.94 - .York Park 9,368.19 9,368.19 - McGuire Park 3,959.00 3 ;959.00 - Beard..Park 14,677.46 483.00 15,160.46 Cornelia School Park 41,439.64 192.00 41,631.64 - .Lake-Edina Park 34,682.54 .144.00 34,826.54 Countryside-Park 23,227.65 23,227.65 - Braemar:Park 31,926.91 1,663.37 33,590.28 Division Park 34;928.79 1.,139.67 36 ;068.46 - Valley View School site 8,696.96 8,696.96 - Garden Park 45,518.85 45,518.85 - Walnut.Ridge Park 9,660.15 3,844.00 13,504.15 - Heights Park 25,891.11 309.29 26,200.40. - Creek Valley,School Park 35,616.14 .18,616.59 54,232.73 - St. John's Park 733.33 .733.33 - Tingdale Park 3,941.11 79.00 4,020:11 - Birchcrest Park 2,816.49 2;816.49 - Bristol Park 4,501.10 4,501.10 - Nine Mile Creek Parkway 3,220:92 3,220.92 - Sherwood Pump,Park 700.51 700.51 - Mad Lake 1,250.00 9,247.74 10,497.74 Weber :Park 17,911.81 3,413.84 21,325.65 - Historical site - 11,692.98 :1.1,692.98 Recreation Center - 101.247.04 .101.247.04 $784,698.47 $178,035.94 $583,690.94 $379,043.47 _ -59- IMPROVEMENT FUNDS COMBINED BALANCE SHEET VILLAGE OF EDINA December 31, 1969 ASSETS Cash: Demand deposits Time deposits Investments Receivables: Special assessments: Current. - certified in:1969 - collectible in 1970 Delinquent Deferred Assessments receivable - Village share of projects: Deferred Less allowance for delinquent taxes Due from other funds Due from Construction Fund for advances Construction.in progress: Current Deferred Unallocated construction cost . Sundry receivable LIABILITIES, RESERVE AND SURPLUS Accounts payable Accrued interest Due to Hennepin County Due to other funds Construction contracts payable Advance from .Improvement Funds Bonds payable Construction deposits Reserve for assessment adjustments Reserve for construction Unappropriated surplus Total :$ 105 ;671.70 100,000.00 $ 205,671.70 :2,409;625.61 $:1,780 ;655.04 272,419.34 8,117,147..24 250;328.03 10,420,549.65 779.825.86 $9,640,723.79 233,583.30 2,656,905.48 362;591.35 100,121.57 199.51 $ - 2;759,995.27 i $15,609,422.31 $2 ;759,995.27 $ 2;027.69 64,633.34 10,180.80 228,810.55 362,591.35 ; $2,759,995.27 12,280,000.00 •34,649.90 119,523.61 27,752.25 2,479,252.82 $15,609,422.31 $2,759,995.27 N Joint Permanent Sanitary Improvement Municipal Sewer Improvement Sewer Southdale Bond State -Aid Construction No. 1 Revolving No.153 Improvement Redemption Street Bonds $ 86,967..10 $ 86,967.10 152,302.08 ..133,583.30 $2;564..40 $2,564.40 2,656,905.48 362, 591.,35 16,619.20 199.51 $3,409,168.02 $2,564.40 $ 224,179.25 362,591.35 2,759,995.27 34,649.90 $ 175.09 $ :175.09 149,271.26 $ .:5,389.71 31;300..52 886.64 $ 37,576.87 31.614.34 $ 5,962.53 100,000.00 100.'000.00 $ 471.11 $ 471.11 147,071,88 $ 23;338.43 4,.167.31 58,333.31 38,574.08 $124,413.13 10.179.60 $114,233.53 i I $355,408.88 $261,776.52 I $ 67.40 $ 193.40 4,631.30 200,000.00 $ 1,035.32 $ 14,207.50 $251.18 100,000.00 $1,035.32 $ :114,207.50 $251.18 80,460.42 1,880,519.97 $ 1,751,926.90 236,951.51 8,057,927.29 211,753.95 $ - $10,258,559.65 $ - •738,031.92 $ - $9,520,527.73 $ - 2,659,995.27 83,502.37 $81,495.74 $14,258,752.84 $251.18 $ 2;027.69. :$ 600.00 64.,033.34 10,020.00 60,000.00 12,020,000.00 7,862.91 12,673.60 98,987.10 27,752.25 $2,564.40 342,847.27 61,683.12 82222.14 2,063,684.71 $251.18 $3,409,168.02 $2,564.40 $355,408.88 $261,776..52 $81,495.74 $14,258,752.84 $251.18 IMPROVEMENT FUNDS i STATEMENT OF SURPLUS - .UNAPPROPRIATED i VILLAGE OF .EDINA Year Ended December 31, 1969 Joint Permanent Sanitary Improvement Municipal Sewer Improvement Sewer :Southdale Bond State -Aid Total No. 1. Revolving No. 53 Improvement Redemption Street Bonds Balance at January 1,, 1969 $2,204.;145.58 $2,564.40 $335,424.55 $72,693.21 $6;648.89 $11-786 ;563:35 $251.18 Additions: .Interest spread on assessments for collection I -in 1970 $ 504,327.37 $ .341.10 $ 3,889.74. I $ 500,096.53 ;Income on investments 85,307.25 7,114.92 4,2.76.68 $3,47300 70,442.65 Capitalized interest 135,920.00 .1.35,920.00 Mi_ "scellaneous income 4;186.12 4 ;186.12 $ 729,740.74 $ - $ 7,456.02 $ 8,166.42 $3,4.73L00 '$ 710,645.30 $ - Deductions: Interest.on bonds $ 410,864.54 $ -7,440.00 $11875600 $ .401,549.54 Bank service charges 2,651.28 105.30 24x75 2,521.23 Cost of bond sale 3,081.96. .j 3,081.96 Cancellations and adjustments :13,083.83 12,806.57 277.26 $ .429,681.61 $ _ $ - $20;351.87 $.1,899;:75 $ :407,429.99 $ - $2;504.,204.71 $2,564.40 $342,880.57 $60,507:7.6 $822221114 A2,:089,778.66 $251.18 Transfers - add .- (deduct): I Allowance for delinquent taxes, ( 24,951.89) ( 33.30) 1;175.36 !'i ( 26,093.95) Balance at December 31, 1969 $2,479,252.82 .$2.,564.40 $342,847.27 $61;681.12 $8,222;.14 II I $2,063,6.84.71 $251.18 ,I I -61- .IMPROVEMENT FUNDS ANALYSIS OF CHANGE IN CASH BALANCE VILLAGE OF EDINA Year Ended December 31, 1969 Balance at January 1, 1969 Combined $ 118,522.10 Joint Sewer Construction No. 1 $ 29- ,664.83* .$2,564.40 .Additions: Sanitary Improvement Municipal Collections on special assessments: Sewer, Southdale Bond State -Aid 'By County.Auditor No. 53 Improvement $1,6149142.45 Street Bonds By Village. $:6,320.79 372,960.56, $ 4,013.49 Proceeds from sale of bonds $ 251.18 $ 3,855.82 2;504,186.12 Sale of investments 469.33 1,518,140.24 Advance from .Improvement.Bond.Redemption Fund 2,5002000:00 $2,500,000.00 Payment received on connection charges 27,114.92 27,717.73 $44,950.00 Construction deposits received 11,816.95 i 11,816.95 Payments received from .Municipal State - Aid Street Fund 218,509.45 21,803.20 Collections received on accruals at December. 31,.1968 93,579.33 86,617.55 $8,861,052.83 $2:,620,237.70 Deductions: Construction costs charged to others: General Fund $ 91,870.39 Permanent Improvement Revolving Fund 4,631.30 Park Fund 1,229.45 Waterworks-Fund .13,463.63 Improvement Bond Redemption Fund 1,982,335.50 Park Construction Fund 22,388.53 State of Minnesota Highway Department - State -Aid Division 39,659.30 Other 390,313.37 $2,545,891.47 Less payments received 390,313.37 $2;155,578.10 Increase in construction in progress: Balance at December 31, 1969: Current construction $2,656.,905.48 Deferred construction 362,591.35 Unallocated costs 16,619.20 $3,036,116.03 Balance at January 1,71969: Current construction $2,281,879.39 Deferred construction 615,153.82 Unallocated 2,719.95 2,899,753.16 $ 136,362.87 Decrease in contracts payable: Balance at January 1, 1969 $ 615,153.82 Balance at December 31, 1969 - 362,591.35 252,562.47 388,925.34 $2,544,503.44 Less amount due General Fund for construction costs 224,179.25 2,320,324.19 2,320,324.19 ,(Balance Carried Forward) $63P659,250.74 $ 2709248.68 Permanent Sanitary Improvement Municipal Improvement Sewer, Southdale Bond State -Aid Revolving No. 53 Improvement Redemption Street Bonds $:6,320.79 $ 59,545.69 $ 4,013.49 $ 75,491.38 $ 251.18 $ 3,855.82 $ 24,495.26 $1,585,791.37 469.33 1,957.76 370,533.47 .2,504,186.12 27,114.92 109,276.68 $44,950.00 1,336,798.64 27,717.73 $196,706.25 6,961..78 $ - $31,440.07 $135,729.70 '$44,950.00 $5,831,989.11 ,$196,706.25 $2,564.40. $37,760.86 $195,275.39 i $48,963.49 $5,907,480.49 $196,957.43 -62- IMPROVEMENT FUNDS ANALYSIS OF CHANGE SIN CASH BALANCE (Cont'd) (Balance Brought Forward) Deductions (cont'd): Payment to other funds accrued .at December 31, 1968 Investments purchased Payment to County Auditor for bookkeeping charges Transfer to Construction Fund Bonds redeemed Interest on bonds Bank service charges Cost of :bond sale Return of construction deposits Refunds and .adjustments Balance:at December 31, 1969 * Indicates red figure. Joint Permanent Sanitary Improvement Municipal Sewer Improvement Sewer Southdale Bond State -Aid Combined Construction No. 1 Revolving No. 53 Improvement Redemption Street Bonds $6,659;250.74 $ 2705248:68 $2,564.40 $37,760.86 $195,275.39 $48,963.49 $5,907,480.49 $196,957.43 $ 22,71572.30 $ 25,523.73 $'3,307.46 $ :198,741.11 1,7461%625.61 i 152,302.08 34;271.26 $147,071.88 $30,460.42 1;382,519.97 1;310.40 7.05 '187.10 1,116.25 231500,000.00 2,500,000.00 1,570,000.00 :40,000.00 15,000.00 1,320;000.00 $1955000.00 396,333.75 7,440.00 2,025.00 385,162.50 A,706.25 2,651.28 105.30 24.75 2,521.23 3,081.96 3,081.96 5,455.77 55455.77 547.97 418.00 129.97 $6,453,579.04 $ 183,281.58 $ - $37,585.77 $194,804,.28 $47,92.8.17 $5,793;272.99 $196,706.25 $ .'205,671.70 $ 86,967.10 $2,564.40 $ :175.09 $ 471.11 $ 1,,035.32 .$ 114.,207.50 $ 251.18 IMPROVEMENT FUNDS BONDS PAYABLE VILLAGE OF'EDINA December 31, 1969 -64 -- Sanitary Improvement Sewer Southdale Bond Year Total No. 53 •Improvement Redemption Annual maturities and interest A ates January,l March l and March.l, -May 1, and July 1 September l June 1, September 1, November l and December 1 3 1/4% and 2% to 3,1/10%, 3% 5.70% 1970 $ 1,760,000.00 $15,000.00 $ 1,745,000.00 1971 1,600,000.00 $ 40,000.00 15,000.00 1,545,000.00 1972 1,600,000.00 40,000.00 15,000.00 1,545,000.00 1973 1,600,000.00 40,000.00 15,000...00 1,545,000.00 1974 1,285,000.00 40,000.00 1,245,000.00 1975 1,145,000.00 40,000.00 1,105,000.00 .1976 1,105,000.00 1,105,000.00 1977 755,000.00 '755,000.00 1978 715,000.00 715,000.00 1979 715,000.00 1715,000.00 TOTAL $12,280,000.00 $200,000.00 $60,000.00 $12,020,000.00 -64 -- ASSETS CURRENT ASSETS Cash: Demand deposits (deficit) Appropriated funds Investments - at cost and accrued.interest: Federal Land Bank.bonds United States Treasury notes Federal National Mortgage Association Certificates Federal Home Loan Bank notes United States Treasury -bonds Less amount.segregated and shown'below Accounts receivable: From customers Due from other funds Inventories: Meters - at cost Supplies — estimated Prepaid insurance OTHER ASSETS Segregated investments - reserve for debt retirement FIXED ASSETS - Note A Land Land improvements Distribution system Buildings and equipment Less allowance for depreciation $ 101,057.29 25,172.33 :177,513.22 205,253.66 30,111.36 $ 539,107.86 63,495.00 $ 96,257.56 17,010.44 $ 29,719.95 :.1,750.00 TOTAL CURRENT 'ASSETS $ 15,498.59 5,692,-282.66 ` 1,888,104.89 $7,595,886.14 1,697,326.47 $ . 27,556.38 WATERWORKS 'BALANCE VILLAGE December ($ 4,773,21) 20,568.75 15,795.54 475,612.86 113,268.00 31,.469.95 831.50 $ 636,977.85 63,4.95.00 5,898,559.67 5,9262116.05 ,$6,626,588.90 FUND SHEET OF EDINA 31, 1969 LIABILITIES AND SURPLUS CURRENT LIABILITIES Accounts payable and accrued expenses: Trade accounts Salaries and wages. Refunds payable Interest Due to other funds Current maturities of,bonds payable LONG -TERM DEBT Bonds payable - Note B Less current maturities -shown above SURPLU S :Invested in fixed .assets: Direct Revaluation of fixed assets - Note A Contributed by special assessments .Note A Contributed by General Fund _Appropriated -:for debt service Unappropriated See notes to balance sheet. TOTAL CURRENT LIABILITIES $ '814,380.51 24,603.60 4,500,508.22 1.1,623,72 $ 575,000.00 45,000.00 5,351,116.05 84.,063.75 578,029.64 $ 20;259.98 :1,183. 32 91.70 3,380.83 13,463.63 $ :38;379.46 45,000.00 $ 831379.46 530.,000.00 6,013,209.44 $6,626,588.90 -65- WATERWORKS FUND NOTES TO BALANCE SHEET VILLAGE OF EDINA December 31, 1969 Note A - The original utility purchased.in 1947 is carried at amounts based on appraisal at time of.acquisition. Subsequent purchases are carried at cost. Watermains for which the benefited property owners have been assessed are carried at construction cost with contra - credit to surplus contributed by special assessments. Each of the aforementioned amounts has been reduced by the depreciation thereon charged to ,income,.which income has been transferred to earned surplus. Note B - The annual maturities, due dates and interest rates of the bonds payable are as follows: 1955 Issue 1959'Issue 1963 Issue Total Annual maturities and interest dates March,.l and March l and June l and September 1 September 1 December 1 Interest rates 2.50% 3.40% and 2.80%, 3.00%, 3.50% 3.20% and 3.30% Annual amount of maturities: 1970 $20,000.00 $ 15,000.00 $10,000.00 $ 45,000.00 1971 35,000.00 20,000.00 55,000.00 1972 35,000.00 20.,000.00 55,000.00 1973 35,000.00 20,000.00 55,000.00 1974 35,000.00 20,000.00 55,000.00 1975 40,000.00 20,000.00 60,000.00 1976 50,000.00 50,000.00 1977 50,000.00 50,000.00 1978 50,000.00 50,000.00 ,1979 50,000.00 50,000.00 1980 50:000.00 50.000.00 $20,000.00 $195,000.00 $360,000.00 $575,000.00 Bonds of the 1955 issue are subject to redemption and prepayment at the option of the Village on any interest date. Bonds maturing after March 1, 1970 of the 1959 issue shall be subject to redemption and prepayment at the option of the Village on said.date and any interest date thereafter, at a price of par and accrued interest, plus :a premium of $10.00 for each bond redeemed, and.in inverse order of their serial number. Thirty days prior notice must be given to bondholders. -66- WATERWORKS FUND STATEMENT OF SURPLUS VILLAGE OF.EDINA Year Ended December 31, 1969 Total Balance at January.1,.1969 $5,474,943.94 Additions: Watermains contributed by special assessments 420,633.05 Net income for year 117 632.45 6,0132209.44 Transfers: Provision for depreciation - Bonds retired - Additions to fixed .assets - Decrease in appropriation of funds for reserve for debt retirement - Balance at December 31,.1969 $6,013,209.44 * Indicates red figure. Invested Earned Surplus in Fixed Unappropriated Appropriated Assets I $315,525.69 $94,246.25 $844.,312.46 117 632.45 433,158.14 186,948.07 48,000.00* 4,259.07* _10,182.50 :$578,029.64 $94,246.25 844,312.46 82,191.02* 48,000.00 4;259.07 10,182.50* $84;063.75 $814,380.51 ..Contributed 'Contributed by by . Assessments General. Fund Revaluation $4.,183,622.63 .$11,951.33 $25;285.58 420,633.05 $4,604,255.68 $11,951.33 :$25,285.58 I 103,747.46* 327.61* 681.98* $4.,500;508.22 .$11,623.72 $24.,603.60 -67- WATERWORKS FUND STATEMENT OF :INCOME AND EXPENSE VILLAGE OF EDINA Per Cent to Year Ended December 31 Increase Gross Income 1969 1968 Decrease* 1969. 1968 Number of meters in use: At end.of year 9,163 8,698 465 At beginning of year 8;698 831336 362 Income: Sale of meters $.34,942.00, $36,211.00 $ 1,269.00* Less cost of meters sold .28,435.00 27,605.00 830.00 $ 6;507.00 $ 8,606.00 $ 2,099._00* Water sales 503,140.00 '375,992.00 127,148.00 Penalties 7,657.00 7,000.00 657.00 Water connection permits 2,255.00 2,660.00 405.00* 'Tapping fees 350.00 219.00 131.00 Use of hydrants 17,010.00 13,935.00 3,075.00 Miscellaneous 1,339.45 :1,035.96 •303.49 .$538,258.45 $409,447.96 $128,810.49 100.00% 100..00% - Expenses: Pumping: . Labor $ 8,425.00 $ 7,893.00 $ 532.00 -Power and A ight 51,174.00 '39;050.00 12,124.00 Supplies and repairs 6,019.00 12,547.00 6,528.00* Buildings: Labor 1;525.00 1,505.00 20.00 Fuel 2,520.00 2,124.00 396.00 Supplies 693.00 423.00 270.00 Repairs 79.00 328.00 249.00* Insurance 699.00 567.00 132.00 Water purchased 20,548.00 17,681.00 2,867.00 .Provision for depreciation 733,097.00 29,679.00 3,418.00 .$124,779.00 $111,797.00 $12,982.00 23.18 27.30 'Distribution: Labor $ 13,066.00 $ 8,864.00 $ 4,202.00 Materials and supplies 9,977.00 5,356.00 .4,621.00 Operation of meters: Labor 11,306.00 7,602.00 3,704.00 Supplies and expenses 2,786.00 1,024.00 1,762.00 Provision for depreciation 109,630.00 97;075.00 '12,555.00 Repairs - 8,019.00 7,338.00 681.00 Hydrant replacement' 12,818.00 - 12,818.00 $167,602.00 $127,259.00 $ 40,343.00 31.14 31.08 ..Tanks, towers and reservoir: Labor $ 619.00 $ 1,155.00 $ 536.00* Power.and.lease lines -1,736.00 1,314.00 422.00 Supplies and expenses 4,482.00 825.00 3,657.00 Provision for depreciation 22,674.00 22,674.00 - Insurance 659.00 485.00 174.00 $,30,170.00 $ 26,453.00 $ 3,717.00 5.60 6.46 WATERWORKS FUND STATEMENT 'OF INCOME 'AND EXPENSE (Copt' d) -69- Per Cent to Year Ended December 31 Increase Gross Income 1969 1968 Decrease* 1969 1968 Expenses (cont'd): Water treatment: Labor $ 3,362.00 $ .3,521.00 $ 159.00* Supplies and expense -11,963.00 11,847.00 116.00 Provision for depreciation 19,312:00 18,616.00 696.00 $.34,637.00 $ 33,984.00 $ 653.00 6.44 8.30 Vehicle operations: Allocated from equipment pool $ 6,960.00 $ 6,600.00 $ 360.00 Provision ,for depreciation 1,204.00 1,441.00 .237.00* $ :8,164.00 $ 8,041.00 $ X123.00 -1.52 1.96 Administrative and general: Salaries: Superintendent $11,352.00 $:10,455.00 $ 897.00 Clerical 4,056.00 3,922.00 134.00 Meter-reading 11,057.00 9,021.00 2,036.00 Meter reading supplies 275.00 142:00 133.00 Office supplies,- postage, .telephone, hospitali- zation, etc. 12,360.00 10,020.00 2,340.00 Supervision 3,360.00 3,000.00 360.00 Provision for depreciation 1,030.00 670.00 360.00 Professional services 8,022.00 3,800.00 42222.00 Supplies and expenses 961.00 693.00 268.00 Building rental 720.00 720.00 - $53,193.00 $ 42,443.00 $ 10,750.00 9.88 10.37 TOTAL EXPENSES $418,545.00 $349,977.00 $ 68,568.00 :77.767, 85.47% OPERATING INCOME $119,713:45 $ 59,470.96 $ 602242.49 22:247, 14.53% Income on investments 17,413.00 9,875.00 7,538.00 3.24 2.41 $137,126.45 $ 69,345.96 $ 67,780.49 25.487. 16.94% Other deductions: Interest on bonds $ 19,408.00 $ 20,811.00 $ 1,403..00* Fiscal agent service charge 86.00 109.00 23.00* $:19,494.00 $ 20,920.00 $ 1,426.00* 3.62 5.11 NET :INCOME .$117,632.45 $ 48,425.96 $ 69,206.49 21.86% 11.83% Depreciation, computed by,the straight line method charged to operations included in expenses :$186;947.00 $170,155.00 $ 16,792.00 -69- WATERWORKS FUND ANALYSIS OF CHANGE IN CASH BALANCE VILLAGE OF EDINA Year Ended December 31, 1969 Balance at January 1, 1969 Additions: Collection on accounts receivable Collection on amount due from other funds Sale of water meters Sale of investments Sundry,sales and services Income on- investments Increase.in amounts payable: Balance at December 31,:1969: Trade accounts Accrued payroll Due to other funds Balance at January.l, 1969: Trade accounts Accrued.payroll Due to other funds Deductions: Payment to fiscal agents: Principal Interest Service charge Meters-purchased Additions to fixed assets ..Less amount contributed .Purchase of investments Operating expenses Less provision for depreciation .Payment of sales tax Refunds Summary: Sinking Fund Operating Fund (deficit) $495,276.53 13;935.47 34,942.00 113,380.78 3,069.05 17,413.00 $ 20;259.98 .1,183.32 13,463.63 .$:34,906.93' $14,653.66 770.82 :3,832.32 19,256.80 '15,650.13 $ 48,000.00 - 19,858.00 QA nn $424,892.12 .420,633.05 $418,545..00 186,947.00. 67,944.00 42,592.22 .4,259.07 362,878.24 231,598.00 13,584..00 6,207.00 Balance at December 31, 1969 $:20,568.75 ( 4,773.21) ,$:15,795.54 $51,191.11 693,666.96 $744,858.07 729,062.53 $:15,795.54 -70- WATERWORKSYFUND FIXED ASSETS VILLAGE OF EDINA Year Ended December 31,,1969 Land Land improvements Distribution systems: Purchased Contributed by.special assessments ..Contributed by General Fund Buildings and equipment: Pumphouses Wells Pumps and piping Tanks, towers and reservoir Office equipment Miscellaneous equipment Water treatment equipment Automobiles and trucks Storm sewer Tools TOTAL * Indicates red figure. A s �s e t s Balance Balance J anuary.l, December 31, 1969 Additions Deductions Transfers 1969 $ 27,556.38 $ 27,556.38 14,178.52 $ 1,320.07 15,498.59 $ 277,769.71 4;977,499.24 :16;380.66 $5,271,649.61 $ 247,102..12 446,117.94 114,551..28 566,867.16 3,453.05 $ 277,769.71 $420;633.05 5,398,132.29 16,380.66 $420,633.05 $ $ - $5,692,282.66 .11,918.74 432,540.66 7,072.31 $ 2,939.00 $2;126.06 57,318.69 350.00 $1,887,291.95 $ 2,939.00 $2;126.06 $7,200,676.46 -$4245892.12 $2,126.-06 $72,534.70 131,758.70* 47,624.00 11,600.00 $ 319,636.82 314;359.24 :162,175.28 566,867.16 . 3,453.05 11;918.74 444,140.66 .7,885.25 57,318..69 j350.00 $.1,888,104.89 $7,623,442.52 Allowance -for Depreciation Balance Balance January,l, December 31, 1969 Additions Deductions - -1969 4,922.28 $ 594.10 5,516.38 $ :112,408.48 793,876.61 5,023.33 $ 911,308.42 $ 73,2.64.73 98,440.39 67,044.60 244,429.59 3,039.83 7,869.,62 91,737.79 3,868.03 6,579.18 $ 5963,273.76 $1,512,504.46 $- 5,555.3.8 $ 117,963.86 103,747.46 897,624.07 327.61 5,350.94 $109,630.45 $ - $1,020,938.87 $:14,236.16 $ 87,500.89 9,939.39 .108,379.78 8,327.40 '75,372.00 22,674.06 267 - 103.65 .115.91 3,155.74 914..34 82783.96 18,165.74 109,903.53 1,204.15 $2,126.06 2,946.12 .1,146.37 7,725-.55 $ 76,723.52. $2,126.06 $ 670,871.22 $186,948.07 $2,126.06 $1,697,326.47 -71- SEWER RENTAL FUND 'BALANCE SHEET VILLAGE OF EDINA December 31, 1969 ASSETS Current assets: Cash .(deficit) Investments - at cost: United States Treasury bonds Accrued interest Federal National Mortgage-Association Certificates Receivables• From customers .Assessments receivable Due from other funds Prepaid insurance Fixed assets - on the basis of cost: Land improvements Furniture and fixtures Trucks .Equipment Less allowance for depreciation ;$50,000.00 185.60 $50;185.60 20,000.00 LIABILITIES AND SURPLUS :Current - liabilities: Trade accounts payable Accrued payroll $26,240.67 338.10 TOTAL CURRENT ASSETS $ 4,653.25 2,161.69 8,491.00 26,471.90 $4.1,777.84 '28,200.75 TOTAL CURRENT LIABILITIES Surplus: Invested in fixed assets Unappropriated (deficit) ($ 6,749.60) 70,185.60 26,578.77 ;1,72.8.01 35.00 $:91,777.78 13,577.09 $105,354.87 $199,877.31 -.735.02 $200,612.33 13,577.09 ( 108,834.55) $105;354.,87 -72- SEWER RENTAL FUND STATEMENT OF SURPLUS '(DEFICIT) VILLAGE.OF EDINA Year Ended December.31, -1969 Balance (deficit) at January -,1, ;1969 Deduction: Net loss for year Transfers: Additions to fixed assets Provision for depreciation Balance (.deficit) at December-31, 1969 * Indicates red.figure. Unappropriated .Surplus (Deficit) ($:45,679.66) 62,497.84 ($108;177.50) $ 3;640.00* 2;982.95 $ 657:05* ($108;834.55) Surplus Invested in Fixed Assets $1.2,920.04 $12,920.04 $:35,640.00 2,982.95* $ 657.05 $13,577.09 -.73- SEWER RENTAL FUND STATEMENT OF INCOME AND EXPENSE VILLAGE OF EDINA Year Ended December 3.1 Increase 1969 1968 Decrease* Operating income: Service charges and penalties $1493610..00 $140,010.00 $ 9,600.00 Expenses: Operating: Sewer maintenance and treatment Labor Supplies Repairs Water Power .Provision for depreciation Other Vehicle operation: .Allocated from equipment pool .Provision for depreciation Administrative and general: Clerical and supervision Auditing Supplies, telephone, postage and retirement Building:rental Provision for depreciation Professional services TOTAL EXPENSES OPERATING LOSS 0 the r.income: Income on investments Miscellaneous NET LOSS Depreciation charges to opera - tions .included in expenses Per Cent to .Operating Income 1969 1968 100.0% 100.0% -$122,440.00 $ 77,159.00 $45,281.00 40;3.86.00 36,145.00 4,241.00 _8,049.00 2,857.00 .5;192.00 12,567.00 . 12,656.00 89.00* 200..00 200..00 - 6,832.00 6,156.00 676.00 1,3.80.00 1,405.00 25.00* 516.00 .506.00. 10.00 $192;370.00 $137,084..00 $55,286.00 12.8. -6% 97.9% $ 4,860.00 $ 4.2500..00 $ 360.00 1,486..00 941.00 545.00 $ 6.3346.00 $ 5,441.00 $ 905.00 4.2 /3.9 $ 5,244.00 $ 4,929.00 $ :315.00 550.00 475.00 75.00 8,723.00 7,566..00 1,157.00 660.00 576.00 84.00 117.00 140.00 23.00* 1,863.00 2,486.00 623.00* $17;157.00 $ 16,172.00 $ 985.00 11.5 11.5 $215,873.00 $158;697.00 $57;176.00 144..3% _113:3% $ 66,263.00 -$:18,687.00 $47,576.00 44.3% ..13.3% $ 2,102.00 $ X1,472.00 $ 630.00 1,663.16 1,668.60 5.44* $ 3,765.16 $ 3,140.'60 $ 624.56 2.5 2.2 $ 62,497.84 $ 15,546.40 $46,,951.44 41.8% 11.1% -$ 2,983.00 $ 2;4.86.00 $ 497..00 -74- SEWER RENTAL FUND ANALYSIS 'OF CHANGE IN CASH BALANCE VILLAGE OF'EDINA Year Ended December 3.1,:1969 Balance at January ,1,:1969 Additions: Collections on accounts receivable Sale of investments Tax settlements received Income on investments Increase.in liabilities: Balance at December 31,:1969: :Trade accounts Accrued payroll Balance at January 1, 1969: .Trade accounts Accrued payroll Other Deductions: Expenses for the year Less :provision for depreciation not requiring cash Investments purchased Purchase of fixed.assets 'Increase.in amount due from other funds Other :$199,877.31 735.02 $200,612.33 $149,791.48 753.48 1501544.96 $215,873..00 $ 17,437.82 $149,787.50 41,229.37 184.85 2,102,.00 50,067.37 1,663.16 245,034:25 $262;472.07 2,983.00 $2.12,890.00 50,185.60 3,640.00 1.,728.01 778.06 269,221.67 Balance (deficit) at December 31, 1969 ($ 0,749.60) i -75- ASSETS Land improvements Furniture and .fixtures Trucks Equipment ALLOWANCE'FOR DEPRECIATION Land improvements Furniture and .fixtures Trucks Equipment SEWER RENTAL FUND FIXED ASSETS VILLAGE OF EDINA Year Ended:December:3l, 1969 Balance Balance January 1, December 31, 1969 Additions Deductions 1969 $4,430.25 $ 223.00 $4,653.25 2;161.69 2,161.69 6;374.,00 3,417.00 $12300.00 8,491.00 26:,471.90 26,471.90 $395,437.84 $3,640.00 $1;300.00 $4.1,777.84 $1,399.97 $ 181.66 $:1,581.63 1,747.58 116.84 :1,864.42 1;369.20 1,485.50 $:1;300.00 2,554..70 21,001.05 :1,198.95 22;200.00 $262517.80 $2,982.95 $1,300.00 $28,200.75 NET BALANCE $12,920.04 $13,577.09 -76- LIQUOR DISPENSARY FUND BALANCE SHEET VILLAGE.OF EDINA December 31, 1969 ASSETS 'CURRENT ASSETS Cash: Demand deposit Deposit in transit Working :funds. Investments - at cost: Village of Edina - Waterworks Revenue Bonds of 1959 .Accrued interest United States Treasury notes - at cost Due from Golf Course Fund Merchandise .inventory - at cost (first -in, first -out method): Liquor Wine Beer Mix and miscellaneous Prepaid expenses: Unexpired insurance Supply inventory 'LOAN TO OTHER 'FUNDS Golf .Course Fund Recreation Center Fund (arena) FIXED ASSETS. - at cost Land . Land improvements Building Furniture,:fixtures and.equipment Leasehold improvements $ 8,942.68* 28,295.60 $26,924..47 'li 1 A7 $ 19;352.92 3,000.00 $ :27,23,6.14 50,924.58 $325,266..09 -39,796.16 1.1,547.81 2,771.86 $ 2,205.32 ann nn TOTAL CURRENT ASSETS $ 3,412.66 75,331.92 48,373.74. 28:172.74 $155,291.06 $250,000.00 175,000.00 $ 16,500.00 $:225352.92 78,160.72 .9;039.80 379,381.92 2,605.32 $491,540.68 425;000.00 Less allowance for depreciation and amortization .1.19,791.13 '35;499.93 51,999.93 .$968,540.61 LIABILITIES AND SURPLUS CURRENT LIABILITIES Trade-accounts-payable .$ 33,916.51 Salaries and wages 4,321.75 Due to Golf Course Fund 157.50 TOTAL CURRENT LIABILITIES $ '38,395.76 SURPLUS Invested infixed assets Unappropriated * Indicates red .figure. $- 51,999.93 878,144.92 930,144..85 .._$968,540.61 -77- LIQUOR DISPENSARY FUND STATEMENT OF.SURPLUS VILLAGE OF EDINA Year Ended December 31, 1969 Balance -at January 1, 1969 Additions: Net income for.year Deductions: Transfer to General Fund Transfer to Park Fund Transfer to Park Construction Fund Transfers: Provision for depreciation Balance at December. 31, 1969 *.Ind.icates red figure.. Total Available $ 820,561.64 $ 759,393.04 $ :384,583.21 $ :3.84.,583.21 $1,205,144..85 $1,143,976.25 $ 18,389.00 $ 18,389.00 126;611.00 1261611.00 130,000.00 130,000.00 $ 275,000.00 $ 275,OOQ.00 .$ 930,144.85 $ 868,97625 - 9,168.67 $ 930,144.85 $ 878,144.92 Invested in Fixed $61;168.60 $61,168.60 $61,168.60 9,168.67* $51,999.93 -.78- LIQUOR DISPENSARY FUND STATEMENT OF INCOME 'AND 'EXPENSE VILLAGE OF EDINA Sales: Liquor Wine Beer Mix and miscellaneous Less bottle refunds NET SALES Cost of sales: .Inventory at.January lst Purchases Inventory at December 31st GROSS MARGIN Operating expenses: Selling Occupancy Administrative TOTAL OPERATING EXPENSES OPERATING INCOME Other income: Cash discount' Cash over or.(under) Other Income on investments Depreciation and amortization included in expenses ( ) Indicates red figure. i I Year'Ended December 31 4,387.00 1 9 50th Street Southdale $655,221.00 $4442325.00 116,137.00 89,733.00 :163,179.00 68,900.00 20,893.00 ;102883.00 $9552430.00 $613,841.00 :4,998.00 :1,304.00 $950,432.00 $612,537.00 $105,810.89 $ 85,770.50 7491213.00 486,398.00 $855,023.89 $572,168.50 142,939.77 117,614.35 $7122084.12 $454,554.15 $238$47.88 $1572982.85 .$ 38,896.00 $ 28,388.00 12,544.00 20,835.00 19,130.00 .18,206.00 $ 70,570.00 $ 67,429.00 $167,777.88 $ 90$53.85 4,387.00 3;117.00 36.00 ( 130.00) . 359.19 329.00 $172,560.07 $ 93,869.85 -6 9 1 1968 Grandview Total Total $452,137.00 $1,551,683.00 $1,372,601.00 79;467.00 285,337.00 248,800.00 99,058.00 331,137.00 291,080..00 20,405.00 522181.00 45,975.00 $651,067.00 $2,220;338.00 $1,958,456.00 1,914..00 8;216:00 8,628.00 $649,153.00 $2,2122122.00 $1,949,828.00 $ 92,634.51 V $ 284,215.90 $ 291,638.91 510,800.00.1 1,746,411.00 1,445,685.99 ,$603,434.51 $2,030,626.90 $1,737,324.90 118,827.80 '379,381.92 .284,215.90 $484,606.71 $1,651,244.98 $1,453,109.00 $164,546.29 $ 560,877.02 $ 496,719.00 $ 27$24.00 $ 94,808.00 $ 83,381.00 19,070.00 52,449.00 50,973.00 17,800.00 '55,136.00 49,557.00 $ 64,394.00 $ 202,1393.00 $ 183,911.00 $100,152.29 $ 358,484.02 $ 312,808.00 2,943.00 10,447.00 7,714.00 210.00 %116.00 84.00 '329.00 1,017.19 908.34 $103,634.29 $ 370,064.21 $ 321,514.34 14,519.00 X13,613.00 NET INCOME $ 384,583:'21 $ 335;127.34 $ 5,323.00 $ 603.00 $ 3,243.00 $ ,. Per Cent to Net Sales Increase 1 9 6 9 19 '8 Decrease* 50th Street Southdale Grandview Total Total $179,082.00 36,537.00 40,057.00 6:206.00 $2613882.00 412.00* $262,294.00 $ 7,423.01* 300,725.01 $293;302.00 .'95,166.02 $198,135.98 $ 64,158.02. $ 11,427.00 1,476.00 5,579.00 $.18,482.00 $ 45,676.02 2,733.00 32.00 .108.85 $ 48,549.87 906.00 $ 49,455.87 9,169.00 $ 7,763.00 $ 1,406.00 .100.00% 100.00% .100.00% 100.00% 100.00% 74.92 74.21 74.65 74.65 74.53 ;25.08% 25.79% 25.35 %• 25.35% 25.47% 4.09% 4.64% 4.24% 4.28% 4.28% 1.32 3.40 2.94 2.37 2.61 2.02 2.97 2.74 2.49 2.54 7.43% 11.01% 9.92% 9.14% 9.43% 17.65% .14.78 0/.• 15.43% 16.21% 716.04% .47 .51 .45 .47 .40 ( .02:) .03 .04 .05 .05 .05 .05 18.16% 15.32% 15.96% 16.73% 16.49% -79- LIQUOR DISPENSARY FUND OPERATING EXPENSES VILLAGE OF EDINA Selling: Salaries and wages Supplies 'Licenses and dues Pro rata promotion Service contracts Direct promotion Occupancy: Salaries and wages Rent Telephone' Supplies Light and power Maintenance - refrigeration equipment Heat Laundry,and rug :service Burglar alarm Insurance Share of maintenance parking lot and traffic directing Repairs and maintenance Provision .for.depxeciation Rubbish hauling Janitorial services .Miscellaneous Plumbing (includes sewer hookup) Water and sewer services Administrative: Salaries and wages Supplies ,Professional services Allocated expenses - retirement, insurance, office supplies, etc. Miscellaneous Mileage TOTAL ( ) Indicates red figure. Year Ended 176.00 '176.00 171.00 '523.00 $38,896.00 $28,388.00 $27,524..00 $:94,808.00 December 31 1 9 6 8 50th Street Southdale Grandview Total $32,648.00 $23,102.00 $23,678.00 $ 79,428.00 1,397.00 1,102.00 1 9 6 9 35.00 110.00 50th Street Southdale Grandview Total $36,976.00 $26,701.00 $26,559.00 $ 90,236.00 1,704.00 %1,171.00 764.00 3,639.00 -40.00 29.00 30.00 99.00 225.00 311.00 4.00* 311.00 176.00 '176.00 171.00 '523.00 $38,896.00 $28,388.00 $27,524..00 $:94,808.00 December 31 1 9 6 8 50th Street Southdale Grandview Total $32,648.00 $23,102.00 $23,678.00 $ 79,428.00 1,397.00 1,102.00 .838.00 3,337.00 40.00 35.00 35.00 110.00 191.00 191.00 97.00 112.00 106.00 315.00 $34,182.00 $24,542.00 $24,657.00 $ 83,381.00 Increase - Decrease* 50th Street Southdale Grandview Total $4,328.00 $3,599.00 $2,881.00 $10,808.00 307.00 69.00 74.00* 302.00 6.00* 5.00* 11.00* 120.00 120.00 97.00* 112.00* 106.00* 315.00* 176.00 176.00 171.00 523.00 $4,714.00 $3,846.00 $2,867.00 $11,427.00 $ 96.00 $ 32.00 $ 35.00 $ 163.00 $ 132.00 $ 67.00 3,243.00. $ 199.00 $ 36.00* $ 35.00* $ 35.00 $ 36.00* 690.00 16,686.00 10,596..00 27,282.00 57.00 15,681.00 10,600.00 26,281.00 225.00 1,005.00 4.00* 1,001.00 336.00 271.00 253.00 860.00 336.00 278.00 252.00 866.00 198.00 7.00* .1.00 6.00* 284.00 20.00 81.00 385.00 189.00 59.00 118.00 366.00 95.00 39.00* 37.00* 19.00 1,668.00 1,129.00 1,428.00 4,225.00 1,607.00 1,002.00 1,382.00 3,991.00 61.00 .127.00 46.00 234.00 545.00 113.00 172.00 830.00 634.00 48.00 101.00 783.00 89.00* 65.00 71.00 47.00 376.00 421:00, 797.00 353.00 370.00 723.00 23.00 51.00 74.00 365.00 294.00 355:00 1,014.00 394.00 32.5.00 392.00 1,111.00 29.00* 31.00* 37.00* 97.00* 164.00 96.00 260.00 187.00 .131.00 318.00 23.00* 35.00* 58.00* 1,897.00 1,257.00 ;1,918.00 5,072.00 1,668.00 1,100.00 1,626.00 4,394.00 229.00 157.00 292.00 678.00 155.00 149.00 76.00 304.00 5,323.00 603.00 3,243.00. 9,169.00 420.00 240.00 300.00 960.00 690.00 25.00 135.00 850.00 57.00 19.00 25.00 25.00 225.00 16.00 12.00 253..00 $12;544.00 $20,835.00 $19,070.00 $ 52,449.00 $12,253.00 $12,417.00 $123046.00 $36,716.00 198.00 127.00 248.00 573.00 933.00 833.00 833.00 2;599.00 5,520.00 4,560.00 4,500.00 14,580.00 126.00 •169.00 73.00 '368.00 100.00 100.00 100.00 300.00 .$19,_130.00 $18,206.00 $17,800.00 $ 55,136.00 $70,570.00 $67,429.00 $64,394.00 $202,393.00 323.00 323.00 262.00 134.00 76.00 472.00 5,323.00 ( 803.00) 3,243.00 7,763.00 420.00 240.00 300.00 960.00, 655.00 19.00* 105.00 760.W' 57.00 19.00 %12.00 88.00 1,575.00 16.00 12.00 1,575.00 $13,792600 $18,150.00 $19,031.00 $ 50,973.00 $11,186.00 $_11,318.00 $10,890.00 $ 33,394.00 124.00 '124.00 124.00 372.00 882.00 782.00 632.00 2,296.00 4,620.00 41260.00 4,200.00 13,080.00, 73.00 342.00 415.00 $162885.00 16,826.00 $15,846.00 $ 49,557.00 $64,.859.00 .$59,518.00 $59,534.00 $1832911.00 323.00* 323.00* 107.00* 15.00 76.00* 168.00* 1,406.00 1,406.00 35.00 25.00 30.00 90.00 57.00* 19.00* 13.00 63.00* 1,575.00* 1,575. "00* 225.00 16.00 12.00 253.00 $1,248.00* $2,685.00 $ 39.00 $11,476.00 $1,067.00 $1,099.00 $1,156.00 $ 3,322.00 74.00 3.00 124.00 201.00 51.00 51.00 201.00 303.00 900.00 300.00 300.00 :1,500.00 53.00 173.00* 73.00 47.00* 100.00 100.00 100.00 300.00 $2,245.00 $1,380.00 $1,954.00 $ 5,579.00 $5,711.00 $7,911.00 $4,860.00 $18,482.00 M LIQUOR DISPENSARY FUND ANALYSIS OF CHANGE .IN CASH BALANCE VILLAGE OF EDINA Year Ended December 31, 1969 Balance at January.l, 1969 Additions: Gross sales Cash discounts Investments sold Interest received on investments Payment received.on accruals at December 31, 1968 Decrease.in prepaid insurance .Other revenue Deductions: Merchandise purchased Bottle - refunds Operating:expenses Less depreciation included therein not - requiring cash Transfers: General Fund Park Fund Park Construction Fund Payment for another fund Loan to Recreation Center Fund Decrease .in liabilities.: Balance at January.,l, 1969: Trade accounts Accrued payroll Balance at December 31,,1969: Trade accounts $33,916.51 Accrued payroll 4,321.75 Due to other funds 157.50 $202,393.00 9,169.00 $18,389.00 126,611.00 130,000.00 $ 35,958.22 3,579.76 $:39,537.98 $2,220,338.00 10,447.00 .123,688.12 5,748.00 8,750.00 1,100.72 1,132.88 $1;746,4.11.00 8;216.00 193,224.00 275;000.00 289.80 175,000.00 38,395.76 1,142.22 Balance at December 31, 1969 $ .47,431.22 2,371,204.72 $2,418,635.94 2,399,283.02 $ 19,352.92 -81- LIQUOR DISPENSARY FUND FIXED ASSETS VILLAGE OF ED.INA Year Ended December 31, 1969 -82- Balance Balance January 1, December 31, 1969 Additions 1969 ASSETS Land $ 16,500.00 $16,500.00 .Land improvements 3,412.66 3,412.66 Building ]59331.92 753331:92 Furniture, fixtures and equipment 48,373.74 48,373.74 Leasehold improvements 28,172.74 28,172.74 $171,791.06 $ - $171,791.06 .ALLOWANCES FOR DEPRECIATION AND AMORTIZATION Land improvements -$ 1,702.69 $ 139.93 $ 1,842.62 Building 52,369.42 33900.73 563270.15 Furniture, fixtures and equipment 33,099.33 3,509.09 36,608.42 Leasehold improvements 233451.02 1,618.92 251069.94 $110,622,46 $9,168.67 $119,791.13 NET BALANCE $ 61,168.60 $ 51,999.93 -82- Fund: General: Current Poor: Current Park: Current Swimming Pool: .Current Golf Course: Current Recreation Center: Current Park °Sinking: For bonds:and.interest Park Construction: For construction Improvement Current For bond interest For construction Waterworks: Current Appropriated Sewer Rental: Current Liquor Dispensary: Current Depository: Demand deposits: First-Edina National.Bank First Sou.thdale National Bank Midland•National Bank Time deposits: First Edina National Bank Working :funds * Indicates xed figure.. CASH - ALL FUNDS VILLAGE-OF EDINA December 31,.1969 Demand and Time Working Deposits Funds Total $ 21,153.88 $ .550.00 .. $ 21,703.88 .4.7 8.53 .478.53 - 18,158.94 18,1518.94 11;552.44* 11,552.44* 3;203.06* 50.00 -3;153:06* 703.94* 1,000.00 296.06 1,263.49 1,2.63:49 .12.54 312.54 $ 54,071.26 64,633.34 ._86,967. 10 ,$205;6.71.70 205,671.70 $ 4,77 3, 21* 20,568..75 $:15,795.54 15,795.54 6,749.60* 61,749.60* 19,352.92 3,000.00 22,352.92 TOTAL $259,978.50 $4,600.00 $264,578.50 $92,945.73 27,211.97 4,82.0.80 $124,978.50 $:135,000.00 $135,000.00 4.600.00 $264,578.50 -83- SECURITY FOR DEPOSITS :I i VILLAGE OF EDINA December 31,;1969 Security for! Deposits Deposits I Principal Book Bank i Amount Description, Due Date First Edina-National Bank — demand deposit $92,945.73 $373 , 594.67 $370,000.00(A) United .States Treasury .bonds November 15, 1973 do certificate of .deposit 135;000.00 135;000.00 32;000.00(A) United States Treasury bonds .. ;:j May 15, 1974 20,000.00 Federal Deposit Insurance .TOTAL $227,945:73 $508,594..67- $422,000.00 Midland National Bank - demand deposit $ .4;820.80 $ :4,820.80 $.25,000.00 I.S.D. #275 Golden Valley July .1, 1979 50,000.00 I.S.D. #423 Hutchinson March :1, 1980 50,000.00 I.S.D. #742 St. Cloud February 1, 1980 20,000.00 Federal Deposit_Insurance TOTAL $ :4,820.80 $ 4.,820.80, $145,000.00 First Southdale National Bank - demand deposit $ 27,211.97 $46,266.95 $.20;000.00 Village of Edina Recreation Center Bonds September 1,, 1977 20,000.00 Village of Edina.Recreation Center Bonds September 1,:1980 20,000.00 Columbia Heights, Minnesota .I.S.D. #13 February 1, 1980 20,000.00 State of California School Bonds September 1, 1978 20,000.00 Winona Special S /D' #5, Minnesota July 1, 1978 20,000.00 State of Hawaii i' October 15,.1977 :. 20,000.00 St. Louis 'Park;:Minnesota Refunding December 1, .1975 20,000.00 Willmar, Minnesota. Refunding August .1, 1975 20,000.00 Eugene, Oregon Bancroft.Improvement June 1, 1975 20;000.00 White Bear Lake., Minnesota I.S.D. #624 April 1, 1975 j 10,000.00 Blue Island, Illinois Comm. H.S.D. #218 December 1, 1973 5,000.00 Bra „inerd,.Minnesota -Imp. February 1, 1972 5,000.00 Burnsville, Minnesota, I.S.D. #191 November 1, 1972 5,000.00 Dawson,.Minnesota I.S.D. #373 School Building August 1,.1972 5,000.00 Edina, Minnesota Park System of 1957 March 1, 1972 5,000.00 Slayton, Minnesota IS D. #504 ( February 1, 1971 15,000.00 Jt. Ind. Cons. Sch. Dist. #39 Ramsey County 4103 Washington County, Minn. School Building Bonds February 1, 1983 20,000.00 Washington Motor Vehicle.Fuel..Tax Revenue September 1, 1976 10,000.00 New York, New York Various Purpose October :1, 1971 20,000.00 Bloomington, Minnesota..I.S.D. #271 School Building February 1,:1979 20,000.00 Federal Deposit Insurance TOTAL $27,211.97 $46;266.95 $320,000.00 Note A — Aggregate market value o'f United, States Treasury bonds at December 31, 1969 is $346,75:1.88. i -84- Description United.S"ta.tes Treasury notes United .States Treasury ?fonds Federal Intermediate Credit -Bank debentures INVESTMENTS:!., VILLAGE OF EDINA December 31, 1969 Maturity February 15, 1975 February, 15, 1972 June 1, 1970 Interes -t Rate 5.75.'% 4.75 (A) 8.125 Federal Home Loan Bank Notes February 25, 1970 7.00 % do March 25, 1970 6.00 do August 25, 1970 6.70 do August 25, 1970 8.20 Federal National Mortgage Association Participation Certificates February 11, 1970 6.35.% do February .10,.1971 8.75 Federal Land Bank bonds :February 20, 1970 do July 20, 1970 do July 20,.1976 Village of:Edina, Minnesota: 1955 Improvement Bonds 1957'Improvement.Bonds 1960.Improvement Bonds 1962 _Improvement Bonds 1966-Improvement-Bonds 1968 Improvement Bonds 1957 Park Bonds ,1962 Park Bonds '1955 Waterworks Revenue Bonds 1958 Waterworks Revenue Bonds 1953 Sanitary Sewer Bonds FUND OWNERSHIP Improvement Funds General - Poor Golf.Course Park Park Sinking Park Construction Waterworks Sewer Rental Liquor Dispensary Recreation:_Center General Fund - land.investment March March September December November December :March December March September January 1, .1, 1977 1, 1974 — 1979 1, -1970 1,.1970 1, 1970 —1972 1, 1978 1, 1970 1, 1970 1, 1970 1, 1971 —1974 1973 Face Amount $ :300,000.00 720,750.00(A) 250,.000.00 $ 250,000.00 .75,000.00 50,000.00 750.000.00 $1,125,000.00 $ 200,000.00 .750,000.00 $ 950,000.00 6.30 % $ 300,000.00 6.00 '100,000.00 5.375 200,000.00 $ 600,000.00 2.90 % 3.90 3.30 82.70 3.90 4.00 3.70 2.70 2.50 3.40 to 3.50 3.10 TOTAL .SECURITIES Face Amount December 31, 1969 $2,401,750.00 577,000.00 31,000.00 75,000.00 .12,500.00 102,500.00 100,000.00 530,000.00 70,000.00 77,000.00 .170,000.00 $4,146,750.00 TOTAL INVESTMENTS $ 25,000.00 31,000.00 32,000.00 20,000.00 20,000.00 15,000.00 5,000.00 '10,000.00 6,000.00 27,000.00 10,000.00 $ 201,000.00 $4,146,750.00 Carrying Amount December 31, 1969 $2,409,625.61 585;147.14 31,358.30 75,472.19 12,500.00 103,619.16 101,640.42 539,107.86 70,185.60 78,160.72 172,705.28 $4,179,522.28 67,851.16 $4;247,373.44 -85 Note A - The face amount of these the cost of the bonds st the bank will repurchase Village interest for the Date to be Repurchased September 15,:1970 March :15, :1971 NOTE .TO 'INVESTMENT S VILLAGE OF EDINA December 31,1969 bonds is:$775,000. ace the Village has the bonds at cost period held at the .Amount $420,750 300,000 ,However, the amount :shown above .is an agreement with the bank whereby :)n the dates shown below and pay the following rates: Interest Rate 8.50% 8.45 TAXABLE VALUATIONS,.TAX LEVIES AND RATES Taxable valuation: Real estate Personal property Tax levies extended: Extended.in year Collectible in year General Parks ,Bonds and interest Poor and public nursing, Firemen's relief Fire protection Tax -rate by mills: General Parks Bonds and interest Poor and.public nursing Firemen's relief Fire protection 'VILLAGE OF EDINA TOTAL TOTAL TOTAL December 31 1969 1968 $56,680;'044.00 .2,825,324.:00 $59,505,368.00 1969 1970 $ ,1,.471, 567.75 118,415.68 63, 075.69 .13, 686-23 5,950.54 16,661.51 .$:1,689,357:.40 24.73 1.99 .-1.06 .23 .10 .28 28.39 $53,585,438.00 2,467,585.00 $56;053;023.00 1968 1969 $ 13387;3,12.32 112,106.05 62;218.86 .15,134.32 5,605.30 16;815.91 $1,599,192.76 -24.75 2.00 1.11 .27 .10 . 3,0 28.53 -87- OFFICIAL BONDS VILLAGE OF EDINA December 31, 1969 Position On file with Clerk - Treasurer: Blanket position Blanket position ,Treasurer Village Clerk Deputy.Assessor Deputy Assessor Deputy Assessor On file with County,Auditor: Assessor Name Police department employees All Village employees not otherwise required bylaw to be specifically bonded J. N. Dalen Florence B. Hallberg Ronald A. Blagen Ralph E. Johnson Kent Swanson Donald Kearns i Bond Expires Amount Surety March 1, 1970 $ 5,000.00 Allied Mutual Insurance Company March 1, 1970 $50,000.00 Allied Mutual Insurance Company March 1, 1970 $50,000.00 Allied Mutual Insurance Company March 1, 1970 $ 500.00 _ Allied Mutual Insurance Company March 1, 1970 $ 500.00 Allied Mutual Insurance Company March 1, 1970 $ 500.00 March 1, 1970 $ 500.00 Allied Mutual Insurance Company March 1, 1970 $ 500.00 i Allied Mutual Insurance Company I i i i '1 -88- INSURANCE COVERAGE 'VILLAGE OF EDINA December 31, .1969 Inventories: Liquor store - Southdale $ :130,000(D) Liquor store - 50th Street A 60,000(D) Liquor -store - Grandview 120,000(D) Automotive: Bodily.injury $250 / 500,000 Property damage 100,000 Comprehensive Actual cash value -89- Fire and Extended Coverage Building Contents Other Building :and contents .(A): Village Hall $510,000 $.75,000 Library 440,000 :14;000 Mornings,ide municipal buildings 30,800 .4,000 Village garage 410,000 27,500 Municipal liquor store - 50th,Street 72,000 20,000 Municipal liquor store - Southdale 20,000 'Municipal liquor store - Grandview 27,000 Municipal golf course clubhouse - 150,000 :14,000 Municipal recreation center 420,000 112;500 :Municipal recreation center - East addition 1532-000 .7231000 .Municipal swimming pool 182,000 Water reservoir 363;000 Pumping stations :(location): Wooddale 57,500 55,000 Halifax -15,000 12,100 Southview :Lane 10,9Q0 -13,200 Southdale 14,500 13;200 Concord 48,400 77,000 Brookview Heights :15,000 '13,200 Hansen Road ;14,500 :17,600 76th Street 65,000 :105,000 '2nd .Street 66.,000 ;103;000 6500 Dewey Hill Road 41,800 13,000 Sherwood 12,100 13;200 Mirror Lakes 44.,000 14,000 Creek Valley .45,000 33,000 'Water tower - Concord Street - 133,100 Water :tower - 69th Street -2.18,000 Sanitary sewer lift station 49,000 30,000 Bathhouse 62,000 '11,000 .Maintenance building -golf course 7,250 2,000 Range building - golf course 2,500 5,000 Storage building 4,000 Dwelling - Olinger Road 7,000, Dwelling, - West 70th Street 45,000 7,500 Garage building 4,000 Cahill School building 4.9000 Inventories: Liquor store - Southdale $ :130,000(D) Liquor store - 50th Street A 60,000(D) Liquor -store - Grandview 120,000(D) Automotive: Bodily.injury $250 / 500,000 Property damage 100,000 Comprehensive Actual cash value -89- 'INSURANCE.COVERAGE (Cont'd) Village-liquor stores :. Liquor liability Boiler - 50th Street Business interruption 50th Street Business interruption - Southdale Business interruption — Grandview Burglary, robbery.and theft - within premises Burglary, robbery and .theft - outside premises Burglary,.robbery. and theft - .merchandise Village- golf.course: Liquor liability 'Burglary, robbery.and.theft - within premises Burglary, robbery and theft - outside premises Boiler Recreation center: Business interruption Burglary, robbery: °and theft - within premises Burglary, robbery,and theft - outside premises Burglary, .robbery and theft - merchandise Boiler Other insurance: General liability: Automotive non - ownership,, independent contractor, and Village premises - operations Bodily injury Property damage Umbrella policy Workmen's compensation ;Edina Volunteer Fire Department group accident policy, maximum each fireman Property floater all risk- .voting machines 'Property floater - equipment other than automotive Boiler Earthquake coverage - swimming pool and water reservoir - 90% coinsurance Other locations Note A - 90% coinsurance. Note B - 50th Street, Southdale and Grandview. Note •C .- 40% coinsurance. Note D — Reporting form. Fire and Extended Coverage Building Contents Other $ 300,000(B) 50,000 115,000 90,000 50:,000 5,000(B) 5,000(B) 7, 500 (B) (C) 300,000 5,000 5,000 50;000 80,000 2,500 2,500 2,500(C) 50,000 $250 / 5002000 100,000 2,000,000 Statutory 3,000 102,000 Actual cash value 50.,000(E) 4902500(F) Note E - Administration building, municipal building, street department and library. Note F - Fire and extended coverage, $10,000 other locations and $10,000 in transit. ORGANIZATION VILLAGE OF'EDINA December 31, 1969 Village Council: Mayor: Arthur C..Bredesen, Jr. Trustees: James Van Valkenburg Richard C..Johnson C. Wayne Courtney Willis F. Shaw Village Manager: .Warren C. Hyde Village Attorney: William A. Whitlock Clerk: Florence Hallberg Treasurer and Finance Director: J. N. Dalen Assessor: Donald.Kearns Prosecuting Attorney: Walter. Gustafson Director of Public Works and Engineering: Robert C. Dunn Term Expires December 31 1969 1969 1971 1969 1970 Elected, Re- elected or Re- appointed to December 31 1971 1972 1972 Appointed by Council 1969 1970 -91-