Need help with the blank spots in this excel file. Just years 10 and 11 numbers. The population for year 10 is 702,149 and year 11 population is 696,746. The first photo is slots i need filled out and the other photos are the numbers used to find them.

more! C140 D 364141560 5715 S6 Total Bonded Debt in Revenues per capita 5 1.0417 S 1.485 52.33 33 expenditures per capite $ 1.44 41 12 LT debt per capita 310794 $11.9156 $11.707 14) 44 Employees per capita 29 25 Intergovernmental revenues 27 na Primary Revenues over expenditures 5 o 105 150 Change in Net Position/Revenues LO 15 153 unrestricted fund balance / Revenues 5 153 14 Liquidity O 155 156 long term debt/sessed valuation 157 158 current liabilities/revenues 159 160 debt service ( Prevenues) 361 167 Tunded Ratio: Pensions sets/pension abilities 163 164 Pension obligation / salaries 165 166 Capital outlay/primary government expenses 162 168 159 170 2a reviewing trends, what we revence line items are the largest come for Conce 13 3. What is the trend in Nel Position, both restricted and restricted? Why woulder 122 123 14 175 176 171 4 Are the area operating results stable? Do you believe there is a to reviewing the trends in ratio witne the keys (comisia duty Sheet TV Good to go Speling The Wor 1 Lookup Comment Accesibility Hoofing C140 D A Year Year 11 Year 10 5 390.2 5 156,4 S $123 341 3120 2755 4.5 115.4 173.6 305 65 5.1 0.7 0.7 24.0 01 1 94 22 2 25 3 . 2 ASSETS Cash and Gas Equivalent 9 investments 10 Accounts and Contracts Beweet 11 Det from Components 12 Due trom the Governance Inventory 14 Prepaid Expos 15 Lone Advance to Component Utbrary 11 Other A 18 Restricted Assets 19 Net Devon Asset 29 Delated res 21 Fall Value of Delvatives 22 Bonds. Notes and POC Cost 23 Capital Assets 34 Non recible Deprecat 26 23 Deped Outflows of 2 Total Assets 1369 150 1.121 1513 421 1,34 15 4 1,0428 1.1312 52213 1,02 5.99 2530 100 16 $10,3113 $10,0301 $10,37 20 abilities 11 Accounts and Contacts Acar 30 Kerud Sand we 13 Arrand interest Payable 25 Do Oh Government 30 Due to componente 17 Deposit donde 38 Deler 1 Ben and Notes 10 De Swap 41 Con) Long-Term Origions Da 4 Due than one Totes $ 263.42788 21 9 249 3 1005 1376 14 1193 12,2 16 7.4 1 25 205 23 35.8 32. 00 439 612 70 52.NL 3119 3060 2.1110 10.6533 121 8,324 10.106 10.0592 Sheet TAG C140 X fx D E B $ 1,851.2 S 1,147.9 1,49 36.4 0.8 0.9 30.1 0.7 0.9 104.1 277.6 5.9 491.8 6 252 (2,759.0) (372.0) (1,590.4) (29.1) 2 (1,611 26: $10,311.3 $10,030.1 $10,371 46 47 Net Position (Deficit) 48 Net Investment in Capital Assets 49 Restricted for: 50 Highway and Street Improvement 51 Endowments and Trust (Expendable) 52 Endowments and Trust (Non-Expendable) 53 Capital Projects and Acquisitions 54 Debt Service 55 Other 56 Unrestricted (Deficit) 57 Total Net Position (Deficit) 58 59 Total Liabilities and Net Position (Deficit) 60 61 62 63 64 65 GENERAL REVENUES: 66 Taxes 67 Property Taxes 68 Municipal Income Tax 69 Utility Users' Tax 70 Wagering Tax 71 State Hotel and Liquor Tax 72 Other Taxes and Assessments 73 State Shared Taxes 74 State Returnable Liquor License Fees 75 Interest and Penalties on Taxes 76 Investment Earnings (Losses) 77 Miscellaneous Revenues 78 Loss on Disposal of Capital Assets 79 Special item (net Year 11 Year 10 Year 9 + $ 218 216.9 $ 233.0 39.8 181.6 235.9 S 228.3 44.6 177.0 216 44 183 3 15 239 16.5 173.3 17.4 239.3 4.3 (144.5) 4.9 9 (33 7 7.6 18.4 9.9 (92.0) (9.8) 876.6 50. 952 80 725.8 0 V : X V fx B pecial item D (9.8) 876.6 E 50 952 725.8 $ XPENSES Primary Government Public Protection Health Recreation and Culture Economic Development Educational Development Housing Supply and Conditions Physical Environment Transportation Facilitation Development and Management Interest on Long-Term Debt Total Expenses - Primary Government 698.4 $ 9.1 8.8 10.3 (0.5) (1.1) 34.5 (45.6) 88.1 129.1 931.1 703.8 $ 685 16.7 10. 13.2 (0 19.7 23. (0.3) 0. (5.4) 4. 44.3 20. (69.3) (3. 93.2 159. 132.8 129. 948.7 1,029. $ EXPENSES Business-type Activities Sewage Disposal Transportation Water Automobile Parking Airport Total Expenses - Business-type 18.5 $ 82.7 34.4 1.0 1.1 137.7 101.4S 86.8 29.0 3.2 1.6 222.0 59.4 64.5 61.1 3.2 1.5 189.7 Change in Net Position $ (343.0) $ (294.1) $ (266.8 Prohing Lang C140 A Year 11 Year 10 Year 9 100 1044 109 106 107 08 109 Population 110 111 Assessed Valuation in millions) 112 11 Actuarial Pension Assets 6.746 702.169 211.19 $ 8.7560 59,2632 5 9,604 $5,420SBR.1 57,091 $ 7,4669 57.528.8 S 7,47 5 463.85 523.5 S 563 5 97,6 S 102.4 5 115 Actuarial Pension Liability Te Payroll covered by Pension 33 119 Govt Funds Capital Outlayin million 120 121 Gov't Funds Operating Expenditures 122 123 Actuarial Unfunded (unded) Pension and other 124 postemployment obligations $ 145 1,608 S 1,6151 56.712.1 5310 55.3775 10.535 11.0213.02 125 employees 122 120 Detit Subject to Limitation 130 to Legal Limitation $957.1 5 1,03129197 $1,330 1.2182 S12183 5 5457.6060950 12 Debt Not Subject to Limitation 133 114 Percentage of debt limit outstanding 135 1% Total Bonded Debt 92.69N 4.82 7546 56.41475435 57157 Revenues per capita 51,015 1,2485 51.96 110 expenditures per capita 5 140 511,511.0156 511,707 LT de perete 14 Emoloyees per capita 23 Sheet1 TO A Good to DI