Calculate the financial indicators on the excel template

Assignment Help Accounting Basics

Reference no: EM133738580

Assignment: Accounting Budgeting and Miami Dade County

Below is a chosen set of financial indicators used to assess the financial condition of local governments in Florida by the Auditor General. Using the EXCEL template, assess the financial condition of Miami-Dade County using the four financial indicators for the past five years and answer the following questions. Note that "Benchmarks" indicate the average value of the specific indicator of counties with similar population size and taxable value with Miami-Dade County.

Financial Indicators Formula Warning Trend

Cash ratio Cash and Investments / Current liabilities Decreasing trend may indicate that the local government has overextended itself in the long run or may be having difficulty raising the cash needed to meet its current needs

Fund balance ratio Unassigned and Assigned FB / Total Expenditures Decreasing trend may indicate unstructured budgets that could lead to future budgetary problems for the local government even if the current fund balance is positive.

Operating ratio Excess Revenue Over (Under) Expenditures / Total Revenues Decreasing surpluses or increasing deficits may indicate that current revenues are not supporting current expenditures

Long-term debt per capita Long-term debt / Population Increasing trend may indicate that the local government has a decreasing level of flexibility in how resources are allocated or decreasing ability to pay its long-term debt.

1) Calculate the financial indicators on the EXCEL template so that you complete the four graphs. Copy and paste the graphs here.

2) Assess the historical trend for each indicator and compare it against the benchmark. Is Miami-Dade County under a favorable trend? Is the county financially healthier than its peers?

3) If you have identified warning trends, the next question is what to do about it.

The list below identifies possible financial strategies. Based on your analysis above, which strategy would you recommend to the county for what reasons? Choose at least two strategies and explain how those strategies can improve financial condition.

1) Shift resources to safe investments
2) Invest in capital equipment, facilities
3) Invest in revenue-generating programs, services
4) Restructure/Refinance long-term liabilities
5) Cut expenditures
6) Outsource key public services
7) Short-term borrowing to smooth cash-flow
8) Sell or lease capital assets

Reference no: EM133738580

Questions Cloud

Explain aspects of conducting an investigation of workplace : HRM 5118 Capella University- Explain these aspects of conducting an investigation of a workplace discrimination complaint: the limits of confidentiality.

What is the name of the band leader and band : What's the name of the band leader and/or band? Describe the general character of the music: what's the atmosphere, vibe or emotional content of the piece?

Made mistakes and suffered disappointments : When shame is managed well, and people have the opportunity to acknowledge they made mistakes and suffered disappointments

Impact of integrating cultural intelligence : How can organizations effectively measure the impact of integrating cultural intelligence within their leadership development programs?

Calculate the financial indicators on the excel template : Calculate the financial indicators on the EXCEL template so that you complete the four graphs. Copy and paste the graphs here.

What concerns have been raised about the faas role in boeing : What concerns have been raised about the FAAs role in Boeing Max scandal? How did Boeing's shift in interest towards having a shareholder first mentality affect

Demonstrate your understanding of cyber security concepts : TECH2400 Introduction to Cyber Security, Kaplan Business School - Contextualise the terminology associated with cyber security for diverse stakeholders

Explain what do you consider to be representative of latino : LAC 231 Lehman College- Write reflection about that image. Describe image chosen and explain what do you consider to be representative of Latino Identity?

Service-level agreements : Service-level agreements (SLAs) need to be established so that customers and the help desk both know what is expected of them.

User Account

All Pages