bartleby
search
close search
Hit Return to see all results

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

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
help_outline

Image Transcriptionclose

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

fullscreen
check_circleAnswer
Step 1

Please do understand that we will not be upload an excel file with solution for you. However, we are providing all the steps that you need to complete this in an excel file. Please note the solution carefully. LInkage column indicates how each ratio has been calculated.

There’s more to the solution above. Sign up now to see!

Sign Up

Not ready to register yet? Check out a sample Q&A here.

Stuck on your homework?

Get expertly curated answers to your homework questions for just $9.99/month

Get As ASAP
Tagged in

Business

Finance

Sorry about that. What wasn’t helpful?