The following information has been provided by the city of edward for its most recent december 31 fiscal year-end. the information provided relates to financial information needed to reconcile the net change in governmental fund balances to the change in net position of governmental activities. net change in total governmental fund balances $ 322,791 change in net position of governmental activities 228,084 capital outlay reported as expenditures 237,762 long-term debt issuance (notes and leases) 314,083 depreciation expense 36,955 accrued expenses that do not require use of current financial resources 4,550 revenues that do not provide current financial resources 23,119
prepare reconciliation of the net change in governmental fund balances to the change in net position of governmental activities for the.

Variable rate cd’s = $90 treasury bills = $150 discount loans = $20 treasury notes = $100 fixed rate cds = $160 money market deposit accts. = $140 savings deposits = $90 fed funds borrowing = $40 variable rate mortgage loans $140 demand deposits = $40 primary reserves = $50 fixed rate loans = $210 fed funds lending = $50 equity capital = $120 a. develop a balance sheet from the above data. be sure to divide your balance sheet into rate-sensitive assets and liabilities as we did in class and in the examples. b. perform a standard gap analysis and a duration analysis using the above data if you have a 1.15% decrease in interest rates and an average duration of assets of 5.4 years and an average duration of liabilities of 3.8 years. c. indicate if this bank will remain solvent after the valuation changes. if so, indicate the new level of equity capital after the valuation changes. if not, indicate the amount of the shortage in equity capital.