Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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:

  1. Number of days cash on hand - General Fund
  2. Quick ratio - General Fund
  3. Property tax receivable delinquency rate
  4. Budgetary cushion for the General Fund (Assume all assigned fund balance is available.)
  5. Debt service burden
  6. 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.)
  7. Assess the liquidity of the Village of Matthews, based on the standard that the General Funds 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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The ASQ Certified Quality Auditor Handbook

Authors: Lance B Coleman

5th Edition

1951058097, 978-1951058098

More Books

Students also viewed these Accounting questions

Question

Prove Eq. (2.13) from the equation

Answered: 1 week ago