The following data comes from the 2020 financial statements of the Village of Matthews. Although presented in
Fantastic news! We've Found the answer you've been seeking!
Question:
The following data comes from the 2020 financial statements of the Village of Matthews. Although presented in summarized format, the balance sheet debits and credits are equal and the operating statement information is complete.
General Fund - Balance Sheet Elements | |
Cash | $1,200,000 |
Short-term Investments | 405,000 |
Property taxes receivable - delinquent | 282,000 |
Due from other funds | 58,000 |
Accounts payable and other accrued liabilities | 920,000 |
Assigned fund balance | 90,000 |
Unassigned fund balance | 935,000 |
General Fund - Operating Statement Elements | |
Revenues, including property taxes of $6,125,000 | $8,350,000 |
Expenditures (total) | 7,510,000 |
Transfer out to Debt Service Fund | 400,000 |
Excess of revenues and other sources over expenditures and other uses | 440,000 |
Debt Service Fund - Balance Sheet Elements | |
Cash and cash equivalents | 230,000 |
Restricted fund balance | 230,000 |
Debt Service Fund - Operating Statement Elements | |
Debt service expenditures: | |
Principal | 100,000 |
Interest | 200,000 |
Operating transfer from General Fund | 400,000 |
Excess of revenues and other sources over expenditures and other uses | 100,000 |
Calculate the following ratios for the Village of Matthews:
- Number of days’ cash on hand - General Fund
- Quick ratio - General Fund
- Property tax receivable delinquency rate
- Budgetary cushion for the General Fund (Assume all assigned fund balance is available.)
- Debt service burden
- Excess of revenues and other sources over expenditures and other uses, as a percentage of revenues - Combined, General Fund and Debt Service Fund (Hint: The transfers out and in cancel each other. Therefore, use the revenues for the denominator.)
- Assess the liquidity of the Village of Matthews, based on the standard that the General Fund’s number of days’ cash on hand should be no less than 45 (and that 60 is more desirable) and that the quick ratio should be at least 1.
Related Book For
Intermediate Accounting
ISBN: 978-0132162302
1st edition
Authors: Elizabeth A. Gordon, Jana S. Raedy, Alexander J. Sannella
Posted Date: