Calculate budgetary cushion

Assume the following information was derived from the fund financial statements prepared by the city of Tallahassee, Florida for the fiscal year ended September 30, 2019:

City of Tallahassee
General Fund
Balance Sheet
(in thousands)
Assets:
Cash and cash equivalents	$2,480
Due from other governments	0
All other assets	11,848
Total assets	$14,328
Liabilities:
Total current liabilities	$11,287
Fund balance:
Nonspendable	1,500
Committed	0
Assigned	0
Unassigned	1,541
Total fund balance	3,041
Total liabilities and fund balance	$14,328

City of Tallahassee
General Fund
Statement of Revenues, Expenditures,
and Changes in Fund Balance
(in thousands)
Total revenues	$109,901
Total expenditures	164,473
Excess of revenues over (under) expenditures	-54,572
Other financing sources (uses):
Transfers in	49,597
Transfers out	-21,522
Proceeds from sale of capital assets	430
Total other financing sources (uses)	28,505
Net change in fund balance	-26,067
Fund balance, October 1, 2019	29,108
Fund balance, September 30, 2019	$3,041

A note to Tallahassees financial statements reads as follows: Fund Balance: The City Commission has established an emergency reserve policy and fund, referred to as the Deficiencies Fund, in order to meet unforeseen expenditures. The target amount per the policy is a maximum level of two (2) months of general government operating expenditures of the ensuing years operating budget. Use of the Deficiencies Fund requires approval by the City Commission. The Deficiencies Fund is contained as a separate sub-fund within the General Fund and the balance is classified as committed fund balance within the General Fund. The notes, however, also disclose that the entire cushion was used in October 2018 when Hurricane Michael struck the city. The city also disclosed that it expended more than $28 million in response and that it expects to receive $24 million in reimbursements.

In its required reconciliation of the governmental funds balance sheet to the government-wide statement of net position, the city reports $30.4 million of long-term receivables that do not yet meet the criteria for recognition in the governmental fund financial statements prescribed by the Governmental Accounting Standards Board. a) Calculate the current budgetary cushion using the data as reported. Answer

% Use revenues plus transfers as the denominator. Round percentage to two decimals. b) Using the GFOA Best Practices guideline, would the budgetary cushion be considered reasonable, too high, or too low? AnswerReasonableToo highToo low

c) Analysts would likely consider the $30.4 million long-term receivable as 'available' in their calculations. Calculate the budgetary cushion including the $30.4 million receivable. Answer

% Use revenues plus transfers as the denominator. Round percentage to two decimals d) Using the GFOA Best Practices guideline, would the adjusted budgetary cushion be considered reasonable, too high, or too low? AnswerReasonableToo highToo low