SJC 2015_CAFR-1.pdf Q ST. JOHNS COUNTY, FLORIDA BALANCE SHEET-GOVERNMENTAL FUNDS September 30, 2015 St. Johns County Community Other General Transportation Redevelopment Governmental Governmental Funds ASSETS Trust Funds Equity in pooled cash and cash Investments Accounts and notes receivable (net of allowance for uncollectibles) Notes receivable S 25,564,656 2,304,434 S 20,804 30,711,687 58,601,581 07 463,868 25,357,773 31,198,759 50,907,336 1,105,035 448,450 60,773 2,434,739 2,002,123 1,959,864 2,218,389 748.450 238,773 2.484,320 2,204,662 3,340,936 272,977 319,337 177,893,293 308,617 804,737 300,000 127,910 t receivable Advances to other funds Due from other funds Due from other governments Inventory Other assets 50,090 49,581 136,640 1,094,042 225,318 65,899 260,489 S 59,193,902 47,659 47,062 83,299,320 TOTAL ASSETS LIABILITIES AND FUND BALANCES LIABILITIES 35,379,267 S 20,804 Accounts payable and $ 5,278,481 2,643,117$ accrued liabilities Customer deposits Advances from other funds Due to other funds Due to other governments 3,378 3,771,189 11,696,165 115 2484,320 2,997,718 2,067,079 490, 131 2.484,320 2,293,186 95,261 409,984 75,000 609,967 1,971,728 94,565 90 Unearned revenue 178,944 663,102 8,449,1 842,046 20,577,443 TOTAL LIABILITIES FUND BALANCES ble 2,883,189 290,808 274,899 347,659 67,183,188 225,361 8,751,261 (2.520.338) 3,505,747 67,486,832 225,361 1,047,447 5,050,463 12,836 32,291,596 Unas TOTAL FUND BALANCES TOTAL LIABILITIES AND FUND BALANCES 47,570,801 50 744 798 32 566,495 73.987 131 157 315,850 S 59,193,902 35,379,267$ 20,804 83,299,320 $177,893,293 The accompanying notes are an integral part of the financial statements Dashboard Calendar Notifications Inbox

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question

Solve using excel......Using the Balance Sheet in the St. Johns County, Florida 2015 CAFR calculate the following ratios for each of the five (5) funds shown, including “Total Governmental Funds:”
a. Current Ratio
b. Net Working Capital
c. Debt Ratio 1
d. Debt Ratio 2
e. Unrestricted Net Assets Ratio
f. Response Ratio

SJC 2015_CAFR-1.pdf Q
ST. JOHNS COUNTY, FLORIDA
BALANCE SHEET-GOVERNMENTAL FUNDS
September 30, 2015
St. Johns County
Community
Other
General
Transportation Redevelopment Governmental
Governmental
Funds
ASSETS
Trust
Funds
Equity in pooled cash and cash
Investments
Accounts and notes receivable (net of
allowance for uncollectibles)
Notes receivable
S 25,564,656 2,304,434 S
20,804 30,711,687 58,601,581
07 463,868
25,357,773
31,198,759
50,907,336
1,105,035
448,450
60,773
2,434,739
2,002,123
1,959,864
2,218,389
748.450
238,773
2.484,320
2,204,662
3,340,936
272,977
319,337
177,893,293
308,617
804,737
300,000
127,910
t receivable
Advances to other funds
Due from other funds
Due from other governments
Inventory
Other assets
50,090
49,581
136,640
1,094,042
225,318
65,899
260,489
S 59,193,902
47,659
47,062
83,299,320
TOTAL ASSETS
LIABILITIES AND FUND BALANCES
LIABILITIES
35,379,267 S
20,804
Accounts payable and
$ 5,278,481 2,643,117$
accrued liabilities
Customer deposits
Advances from other funds
Due to other funds
Due to other governments
3,378
3,771,189 11,696,165
115
2484,320
2,997,718
2,067,079
490,
131
2.484,320
2,293,186
95,261
409,984
75,000
609,967
1,971,728
94,565
90
Unearned revenue
178,944
663,102
8,449,1
842,046
20,577,443
TOTAL LIABILITIES
FUND BALANCES
ble
2,883,189
290,808
274,899
347,659
67,183,188
225,361
8,751,261
(2.520.338)
3,505,747
67,486,832
225,361
1,047,447
5,050,463
12,836
32,291,596
Unas
TOTAL FUND BALANCES
TOTAL LIABILITIES AND FUND BALANCES
47,570,801
50 744 798 32 566,495
73.987 131
157 315,850
S 59,193,902
35,379,267$
20,804
83,299,320 $177,893,293
The accompanying notes are an integral part of the financial statements
Dashboard
Calendar
Notifications
Inbox
Transcribed Image Text:SJC 2015_CAFR-1.pdf Q ST. JOHNS COUNTY, FLORIDA BALANCE SHEET-GOVERNMENTAL FUNDS September 30, 2015 St. Johns County Community Other General Transportation Redevelopment Governmental Governmental Funds ASSETS Trust Funds Equity in pooled cash and cash Investments Accounts and notes receivable (net of allowance for uncollectibles) Notes receivable S 25,564,656 2,304,434 S 20,804 30,711,687 58,601,581 07 463,868 25,357,773 31,198,759 50,907,336 1,105,035 448,450 60,773 2,434,739 2,002,123 1,959,864 2,218,389 748.450 238,773 2.484,320 2,204,662 3,340,936 272,977 319,337 177,893,293 308,617 804,737 300,000 127,910 t receivable Advances to other funds Due from other funds Due from other governments Inventory Other assets 50,090 49,581 136,640 1,094,042 225,318 65,899 260,489 S 59,193,902 47,659 47,062 83,299,320 TOTAL ASSETS LIABILITIES AND FUND BALANCES LIABILITIES 35,379,267 S 20,804 Accounts payable and $ 5,278,481 2,643,117$ accrued liabilities Customer deposits Advances from other funds Due to other funds Due to other governments 3,378 3,771,189 11,696,165 115 2484,320 2,997,718 2,067,079 490, 131 2.484,320 2,293,186 95,261 409,984 75,000 609,967 1,971,728 94,565 90 Unearned revenue 178,944 663,102 8,449,1 842,046 20,577,443 TOTAL LIABILITIES FUND BALANCES ble 2,883,189 290,808 274,899 347,659 67,183,188 225,361 8,751,261 (2.520.338) 3,505,747 67,486,832 225,361 1,047,447 5,050,463 12,836 32,291,596 Unas TOTAL FUND BALANCES TOTAL LIABILITIES AND FUND BALANCES 47,570,801 50 744 798 32 566,495 73.987 131 157 315,850 S 59,193,902 35,379,267$ 20,804 83,299,320 $177,893,293 The accompanying notes are an integral part of the financial statements Dashboard Calendar Notifications Inbox
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps

Blurred answer
Knowledge Booster
Introduction to Governmental accounting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education