– Public Budgeting and Financial Management Topic 6 – Budget Justifications Benchmark – Module 26 Summary: Using ratios to conduct financial analysis must be done with care. One year’s worth of data...

1 answer below »

View more »
Answered Same DayMay 09, 2021

Answer To: – Public Budgeting and Financial Management Topic 6 – Budget Justifications Benchmark – Module 26...

Ayush answered on May 11 2021
154 Votes
1.Here is an analysis of years 2012 and 2013 for City of Charlottesville, Virginia.
    Liquidity Ratios
     
     
     
     
     
    2012
    2013
    1.Current Ratio
    Current Asse
ts
    12.9
    9.1
     
    Current Liabilities
     
     
     
     
     
     
    2. Working Capital
    Current Assets- Current liabilities
    $ 89574711
    $ 80435197
     
     
     
     
     
    
     
     
    3. Quick Ratio
    Quick Assets
    12.9
    9.1
     
    Current Liabilities
     
     
     
     
     
     
     
     
     
     
    Solvency Ratios
     
     
     
     
     
     
     
    1. Debt to Assets Ratio
    Total Liabilities
    36%
    40%
     
    Total Assets
     
     
     
     
     
     
    2. Interest Coverage Ratio
    Earnings before Interest (EBI)
    0.83
    4.32
     
    Interest
     
     
     
     
     
     
    3. Days Payable Ratio
    All Accounts Payable x 365 Days
    7.4
    13.2
     
    Total current expenses
    days
    days
     
     
     
     
    4. Debt Service
    
    $ 20876589
    $ 30351183
    
    
    
    
    Profitability ratio
     
     
     
     
     
     
     
    1. Profit Margin Ratio
    Surplus
    -11.32%
    -10.89%
     
    Revenue
     
     
     
     
     
     
    Common Size Ratios
     
     
     
     
    Line Item
     
     
     
    Total Revenue
     
     
     Revenue Diversification
     
     
     
     Total Revenues
     
     170034969
     17,44,51,120
     Taxes
     
    55.5%
    54.9%
     Fees & permits
     
    1.2%
    1.4%
     Intergovernmental
     
    35.9%
    34.5%
     Charges for Services
     
    5.9%
    6.1%
     Fines
     
    0.3%
    0.2%
     Investment earnings
     
    0.2%
    0.2%
     Miscellaneous
     
    1.0%
    2.7%
     Total Revenues
     
    100.0%
    100.0%
     
     
     
     
    Total Expenditure
    
    167672170
    16,38,47,268
    Expenditure Diversification
     
     
     
     General...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
April
January
February
March
April
May
June
July
August
September
October
November
December
2025
2025
2026
2027
SunMonTueWedThuFriSat
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
00:00
00:30
01:00
01:30
02:00
02:30
03:00
03:30
04:00
04:30
05:00
05:30
06:00
06:30
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
21:30
22:00
22:30
23:00
23:30