• Shockproof! Training
  • 1.866.237.7228
  • Non-Member

    Membership Check

    Please enter your email address and we will check to see if a membership exists for your organization.

    Check Cancel
  • Account
    • Sign in

      If you have an account, please enter your login information.

      Sign-in

      Find Enrollments

      To quickly access links to materials or Session Access instructions, enter the email address used when enrollment was performed.

      Click "Find Now" to begin search.

      Find Now

      Forgot your password?

      Please provide your email address and we'll email you a reminder.

      Send it to me!

      Subscribe

      Please provide the information below to receive our mailings.

      Subscribe!
      Account Options
      1. Sign In... enter the resource center
      2. Access Materials... find my enrollments
      3. Forgot password?... memories fade
      4. Subscribe... to receive our mailings
      5. Contact us... if you have any questions, just ask
      6. Create a User Account* requires membership
  • Sign-in
  • Home
  • Products
  • Learning Paths
  • Calendar
  • Pricing
  • Communications
  • Contact Us
  • Help
  • About Us
  • Membership Check
  • Account

Instructor Blog - Fund Accounting

  1. Home
  2. Communications
  3. Instructor Blog
  4. Fund Accounting

Fund Accounting and Municipality Analysis: Part I of II


  • admin

  • 6/30/2011 3:34:00 PM

  • 221

  • Fund Accounting
  • Copy / Share Link
Q: Is it safe to say that the General Fund is the sole fund that represents the risk when lending to a Municipality?  In my experience, I've seen the General Fund account for about 70-90% of district-wide revenue, but on the General Fund balance sheet, it usually only accounts for 20-30% of district-wide assets (since it does not contain any fixed or long term assets).

A. In many instances, this may indeed be true.  In the two municipalities we used in the webcast, revenues from governmental activities accounted for roughly 78% of all revenues for West Linn, Oregon but for only 60% for Calistoga, California.  In general, the General Fund dominates all other funds.  However, if the municipality includes substantial business-type activities, the relative importance of the General Fund may well decrease. 

Q: In terms of a debt service coverage ratio, the General Fund typically does not have any long-term debt or even any short-term debt and therefore typically has no debt service coverage ratio. Should debt service ability (EBITDA) / (CPLTD + Interest Expense) be calculated with emphasis on the district-wide financials?

A.    Definitely.  All governmental funds and business-type activities are really like divisions within a larger enterprise.  Cash moves back and forth depending on which divisions is running a cash flow surplus and which is suffering cash flow problems.  Note the frequent variances in net transfers from governmental activities to business-type activities and vice versa.  Therefore, it makes sense to approach any debt service estimate on an enterprise wide basis.

Q: What is the difference between general obligation and full faith and credit bonds?

A. In practice there is little difference.  Both reflect a municipality’s pledge to honor its obligations.  However, a general obligation bond is more specific in that it usually includes a pledge to levy property taxes, if necessary, to meet debt service requirement.  No such specific pledge is included in a full faith and credit bond.

Q: In addition to my debt service coverage concern, often I have school districts ask for a State Aid Note. The General Fund typically will show the liability on its balance sheet since it is short term and, therefore, I can calculate some sort of debt service coverage ratio. However, when a school district asks for a bus fleet loan (installment loan), the General Fund may show the principal and interest expense on the income statement, but the asset value of the buses and the corresponding liability will not be on the General Fund balance sheet. So in essence, when I risk rate the General Fund, in my experience, it can be different based on the type of commercial loan requested. Agree?

A: The debt service ratio computations should be conceptually similar.  In one instance, the debt service refers only to interest expense and, in the other, to the sum of interest expense and scheduled long-term debt repayment.  In either case, the numerator would be cash or near-cash available to service debt.  If the principal balance were identical for a short-term note and a long-term installment, the debt service ratio would be greater for the short-term facility than for the long-term facility.  However, if you supplement a debt service ratio as a measure of risk with a leverage ratio, then you would need to identify the long-term asset and long-term liabilities in constructing the leverage ratio.   The comprehensive statement of net assets will include all long-term assets and liabilities for governmental activities.

With respect to the numerator in debt service ratio computations using General Fund information only, note that the statement of revenues, expenditures, and changes in fund balances allows you to use near-cash amounts in computing cash available for debt service.  Referring to this statement for Calistoga, California on page 15 in its Comprehensive Annual Financial Report, the amount of cash available to service debt in 2008 was total governmental funds of $8,812,271 less total governmental expenditures (excluding debt service and capital outlays) of $6,652,711.  In effect, the municipality had $2,159,560 of cash or near-cash available to meet 2008 debt service of $391,762 – a coverage ratio of 5.51.

Yet this debt service coverage ratio is really misleading since it does not include business-type revenues, expenses, and debt service requirements.  You might consider a debt service coverage as really having three components – one for governmental activities, one for business-type activities, and one that applies to the enterprise as a whole. The enterprise debt service ratio may be more appropriate since municipalities are generally able to transfer cash back and forth between different “divisions”.

Q: In Pennsylvania we have the Government Unit Debt Act, by which the court can require the municipality to raise taxes to repay bank debt. Do you have experience with this type of law, and can we rely on it in the future?

A. I have no experience with such a law but, in today’s environment, I would be very reluctant to rely on such a legal provision.  The court may act and direct a municipality to raise taxes, but whether the municipality would do so is another question.  Its political will to act could vary greatly.  And if a municipality did honor the court’s ruling and increase local taxes, there is the issue of taxpayer reaction and their willingness to honor their new obligations.  Further, the municipality may or may not mount a vigorous tax collection effort in the face of taxpayer – and voter - resistance.

Q: Typically I see a portion of the Fund Equity labeled as “Reserved for Debt Service”. Would this number be a legitimate addback to EBITDA (or cash available for debt service)?  Or in particular, if they municipality has set up a sinking fund for debt service.

A: There may a couple of things to do. First, examine the balance sheet and see if there is sufficient cash or short-term investments to cover the amount labeled as the reserve for debt service.  If the amount has truly been reserved, it should be reflected in the cash account.
 
In addition, run a cash flow using unrestricted donations and contributions - some of which should represent amounts released from restriction for the payment of debt service - and see if the NFP did generate sufficient cash in the last historical period to cover its debt service.
 
You could run the numbers forward to project cash available to service debt.  In doing so, you would need information about the amount of funds that would be released in the coming period for debt service.  If there is no cash on the balance sheet, then there will virtually no cash released - unless some unusual circumstances exist.
 
I don't think I would do anything with addbacks or with adjustments to EBITDA.  It all truly comes out in a cash flow statement.
Categories
  • Commercial Real Estate(33)
    • Commercial Real Estate(32)
    • Questions: Commercial Real Estate - Hands On(1)
  • Contractors(52)
    • Understanding and Analyzing Contractor Financial Statements: Part I of II(32)
    • Understanding and Analyzing Contractor Financial Statements: Part II of II(20)
  • Covenants(11)
    • Complex Loan Structuring(1)
    • Covenant Testing(1)
    • Covenant Use in Controlling Cash Outflows(5)
    • Financial Gap Ratio(1)
    • Financing Gap revisited(1)
    • The Financing Gap Ratio - defined(1)
    • UCA cash flow and debt service coverage?(1)
  • Credit College - Accounting Essentials(107)
    • Session #1: Financial Statement Structure and Composition(39)
    • Session #2: Double Entry Accounting, the Accounting Equation, and Debits and Credits(24)
    • Session #3: Critical Accounting Principles and Assumptions and More Debits and Credits(23)
    • Session #4: Recording Transactions and Creating the Balance Sheet and Income Statement(21)
  • Credit College - Cash Flow(14)
    • Session #1: UCA Cash Flow Statement, Traditional "Cash Flow," and EBITDA(8)
    • Session #2: Cash Impact Analysis, Borrowing Causes Revisited, and Management Assessment(2)
    • Session #3: FASB 95 Statement of Cash Flows Conversion to UCA Cash Flow Statement(1)
    • Session #4: Cash Flow Proxies, Debt Capacity, and the UCA Cash Flow Statement(3)
  • Credit College - Commercial Business(208)
    • Session #1: Analytical Decision Tree and the Credit Write-Up(29)
    • Session #2: Financial Statement Review and Ratio Analysis(43)
    • Session #3: Cash Flow Analysis and Borrowing Causes(34)
    • Session #4: Management Assessment, Projected Cash Flow, and the First Way Out(20)
    • Session #5: Guarantor Analysis and the Second Way Out(30)
    • Session #6: Non-Financial Red Flags and Performance Implications(13)
    • Session #7: Identifying and Mitigating Repayment Risks(21)
    • Session #8: The Credit Write-Up Again(18)
  • Credit College - Commercial Real Estate(218)
    • Session #1: The Credit Write-Up and the CRE Analytical Process(28)
    • Session #2: Ratios, Borrower Cash Flow, and the First Way Out(33)
    • Session #3: Guarantor Analysis, Global Cash Flow, and the Second Way Out(40)
    • Session #4: The Appraisal Report and Approaches to Market Value(9)
    • Session #5: The Income Capitalization Approach and the Cap Rate(24)
    • Session #6: Underwriting Standards. Actual vs. Stabilized NOI, and Breakeven Analysis(54)
    • Session #7: Management Assessment, Competitive Forces, and Projected Performance(16)
    • Session #8: Repayment Risks, Covenants, and the Credit Write-Up Revisited(14)
  • Credit College - Credit Basics(93)
    • General(1)
    • Session #1: Understanding Financial Statements and Business Organizations(34)
    • Session #2: Personal Qualities and Competitive Advantages(8)
    • Session #3: Critical Ratios and The First Necessary Condition for Business Success(28)
    • Session #4: Non-Financial Red Flags, Cash Flow and Second Necessary Condition for Business Success(22)
  • Credit College - Taxes(213)
    • Analysis Using Business Tax Returns(1)
    • Converting business income tax returns into accrual financial statements(1)
    • Employee Retention Credit (ERC)(1)
    • Session #1: Business Income Tax Returns(21)
    • Session #2: The Section 179 Deduction(29)
    • Session #3: Understanding Schedules K-1(19)
    • Session #4: Personal Income Tax Returns and Cash Flow(14)
    • Session #5: Schedule M-1 and the Accrual Income Statement(25)
    • Session #6: Business Income Tax Returns and Ratio Analysis(58)
    • Session #7: Business Income Tax Returns and Cash Flow Analysis(23)
    • Session #8: Cash Based Income Tax Returns(21)
  • Credit Curriculum(1)
  • Credit Write Up(33)
    • Analytical Focus in the Credit Write Up(27)
    • Description and Analysis in the Credit Write-Up(6)
  • Debt Capacity(9)
  • Financial Analysis(55)
    • ACS (Accounting Standards Codification) 842(1)
    • Analysis when one spouse is not a guarantor(1)
    • Auto Dealer analysis(1)
    • Auto Dealership/UCA/Floor-Plan debt(1)
    • Capital Gains(1)
    • Cash distributions, Business cash flow and Guarantor global cash flow(1)
    • Corporate tax return or CPA prepared financial statements?(1)
    • CPA firms and legal firms(1)
    • Credit Analysis Question(1)
    • CSVLI - Cash Surrender Value of Life Insurance(1)
    • Depreciation FAQ(1)
    • Distributions(1)
    • Distributions taken from prior year earnings(1)
    • EBITDA, Defined(1)
    • ESOP financing(1)
    • FAQ - calculating Business Profit (1)
    • Financing Needs(2)
    • Flooring Lines(1)
    • Funded Debt to EBITDA(1)
    • Gain on sale and traditional cash flow(1)
    • Insurance Company statements(1)
    • Language of Business On-Line Classroom Q & A(1)
    • Lending to a Start-up(1)
    • Market and industry data sources(1)
    • More on Depreciation(1)
    • Participations and private equity firms(1)
    • Pitfalls of Partial Analysis(4)
    • Prior Period Adjustments to Retained Earnings(1)
    • Ratios and Messages about Profitability and Cash Flow(12)
    • Schedule L(1)
    • Section 263A(1)
    • Self-Employment Tax(1)
    • Session #1: Business Income Tax Returns(1)
    • Session #2: The Section 179 Deduction(1)
    • SG&A% - Another FAQ(1)
    • SG&BC Course Progress Check Question(1)
    • Syndicated Loans(1)
    • Tax Returns vs. Accrual Statements in Assessing Borrower Risk(2)
    • UCA debt coverage ratio for an interim(1)
  • Five Cs of Credit(10)
  • Fund Accounting(52)
    • Fund Accounting and Municipality Analysis: Part I of II(31)
    • Fund Accounting and Municipality Analysis: Part II of II(20)
    • GASB 68(1)
  • Global Cash Flow(51)
    • Borrower with many corporations(1)
    • Global Cash Flow(50)
  • Healthcare(18)
    • Assessing Hospital Financial Performance(6)
    • Assessing Medical Practices(9)
    • Forces Impacting Hospital Financial Performance(3)
  • Loan Documentation(53)
    • Commercial Loan Documentation(30)
    • Commercial Real Estate Loan Documentation(23)
  • Minimum Financial Data(14)
  • Not for Profit Analysis(24)
  • Personal Income Tax Returns and Cash Flow(65)
    • Session #3: Understanding Schedules K-1(27)
    • Session #4: Personal Income Tax Returns and Cash Flow(38)
  • Problem Loans - Loan Classification(2)
  • Projections(22)
    • Projections and Repayment Sources: Part I of II(13)
    • Projections and Repayment Sources: Part II of II(9)
  • Spreading Financial Statements(6)
  • Stress Testing(1)
  • Testing(2)
    • Exams(1)
    • How do the Credit College exams work?(1)
  • Trusts(2)
    • Trust Returns(1)
    • Trusts(1)
  • UCA Cash Flow(58)
    • Advanced UCA Cash Flow: Part I of II(51)
    • Advanced UCA Cash Flow: Part II of II(4)
    • Related Party Transactions and the UCA Cash Flow Statement(1)
    • Sales Neutral Business Cash Income(1)
    • UCA Cash Flow and Agricultural Loans(1)
  • Working Capital and UCA Cash Flow(27)
Shockproof! Training

PO Box 30304 Walnut Creek, CA 94598
1.866.237.7228 support@shockproof.com

  • About
  • Career Opportunities

© Copyright 2001-2025 Shockproof! Training