Fill This Form To Receive Instant Help
Fill This Form To Receive Instant Help
Homework answers / question archive / The following information was obtained from the comprehensive annual financial report of the city of Tampa, Florida for the fiscal year ended September 30, 2016
The following information was obtained from the comprehensive annual financial report of the city of Tampa, Florida for the fiscal year ended September 30, 2016. Condensed General Fund balance sheet Total assets including cash and investments of 120,616,000)-5141,353,000 Total Habilities--$24,062,000: Fund balance -5117,291,000 Classification of General Fund fund balance Total fund balance of 5117,291,000 consists of Nonspendable-5302,000. Committed--3717,000, Assigned call for intended uses, but no formal action taken to commit--527,423,000: Unassigned-588,849,000 Total revenues: 5356,942,000 (major elements are property taxes----144.295.000 ly charges-540.214,000: State ad $46,873,000, and charges for services - $51,678,000) Transfers.in.vimally all from recurring Rayments.in.tol taxes and franchisees): 533,443,000 Property taley: 5149,922.000 Property taxes collected in the year of the levy: 5143,516,000 Debt service expenditures in everamental de Principal-513,037.000; Interest--510, 464,000 Governmental activities debt service principal requirements to maturity Grand total $414,745.000 (includes notes payable of 53.845.000), maturas follows:in 2017 $13,905,000: 2018- $23. 180,000: 2019-524,950,0002020-32.190.000:2021-562.800.000, from 2022-2026-5121.990.000 from 2027 2031.590.615.000 from 2032-2011 - 519,300.000; from 2042-2051-$13,315.000 Pension plandato General employees' pension plan: Total pension ability - 1740,043,000, Plan Iiduciary net position 5637493.000 and Firefighters and police officers' pension plant Total pension Mobility--51.923,536,000. Plan liduciary net poskion -51.727.520.000
Required: Calculate the following indicators of financial position for the city of Tampar: (a) budgetary cushion; (b) debt service burden (cover both the debt service burden and the rate of payback of debt service principal (c) quick ratio (assume the investments are short-term (di property tax collection rate efficiency, and (e) pension benefit burden Instructions • Round answers to one decimal place et R7453711 Note:Quick ratio is the only ratio not presented as percentage Round answer one decimal place
Answer 96 96 96 Ratio (a) Budgetary cushion (b) Debt service burden Principal payback (5 years) Principal payback (10 years) (c) Quick ratio (d) Property tax collection (e) Pension benefit burden (general employees) Pension benefit burden (firefighters and police) 96 96 96 96
(A) Budgetory cushion =
Formula = Total unreserved fund balance / Total revenues
Total unreserved fund balance = $27,423,000 + $88,879,000 =$ 116,302,000
Total revenues = $356,942,000 + $33,443,000 = 390,385,000
Budgetory cushion = $116,302,000 / $390,385,000 = 29.80%
Budgetory cushion = 29.80%.
(B) Debt service burden :-
Formula = Debt service expenditures / Revenue and transfers in
Debt service burden = $13,837,000 + $10,364,000 / ($356,942,000 + $33,443,000)
Debt service burden = $24,201,000 / $390,385,000
Debt service burden :- = 6.20%
a. Principal payback (5 years ) :- Sum of repayment of principal (2017 to 2022) / Total repayment liabilty
Sum of repayment of principal (2017 to 2022) = $13,905,000 + $23,180,000 + $24,950,000 + $62,800,000
Sum of repayment of principal (2017 to 2022) = $157,025,000
Total repayment liabilty = $414,750,000
Principal payback (5 years ) = $157,025,000 / $414,750,000 =
Principal payback (5 years ) = 37.9%
b. Principal payback (10 years ) :- Sum of repayment of principal (2017 to 2027) / Total repayment liabilty
Sum of repayment of principal (2017 to 2027) = $157,025,000 + $133,990,000 = $291,015,000
Total repayment liabilty = $414,750,000
Principal payback (10 years ) = $291,015,000 / $414,750,000
Principal payback (10 years ) = 70.2%
(C) Quick ratio
Formula = Cash + Cash Equivalents + short term investments / current liabilities
Quick ratio = $120,616,000 / $24,062,000
Quick ratio = 5.0
(D) Property tax collection :- Property tax collected ( current year ) / Real property tax levy ( current year )
Property tax collection = $143,836,000 / $149,922,000
Property tax collection = 95.9%
(E) Pension benefit burden (General employees )
Formula = Plan fiduciary net position / Total pension liability
Pension benefit burden (General employees ) = $657,493,000 / $740,043,000
Pension benefit burden (General employees ) = 88.8%
(F) Pension benefit burden (Fire fighters and police employee)
Formula = Plan fiduciary net position (Fire fighters and police employee) / Total pension liability (Fire fighters and police employee)
Pension benefit burden (Fire fighters and police employee) = $1,727,529,000 / $1,923,536,000
Pension benefit burden (Fire fighters and police employee) = 89.8%
