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

Image Transcription

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 Answer

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.
Tagged in
Business
Finance

Related Finance Q&A

Find answers to questions asked by students like you.

Q: Part E. Assume that the group plans to reinvest $50,000 of its profits in the practice by buying a n...

A: From the question and previous workings we have:Operating Profit :$1,190,745Cost of EKG Machine : $5...

Q: A company has just raised $6 million by issuing 4000 12-year 11% bond at par. It's predicted that th...

A: Current characterisitics of the bond:Time to maturity = 12-yearsCoupon = 11% bondPriced at par

Q: Capital budgeting problems  and what king of you used for solving (NPV and IRR PROBLEMS ) A firm has...

A: All the financials in this solution are in $. Figures in parenthesis mean negative values.Based on t...

Q: USE THE INFORMATION BELOW FOR THE FOLLOWING PROBLEM   Stock Rit Rmt ai Beta C 12 10 0 0.8 ...

A: Abnormal return = Return in excess of market return in the given period = Rit - RmtFor stock C, the ...

Q: I already ask this but I whant know how you do the calculation, please could you show me all the ste...

A: Calculating the price of bond if interest rate on the bond is 6%. We have,Price of bond = C [1- (1 /...

Q: Consider the following two mutually exclusive projects: Year   Cash Flow  Cash Flow B 0          -$3...

A: NPV (Net Present Value)NPV is the method of finding the worth of an investment or project by deducti...

Q: Block, S., Hirt, G., & Danielsen, B. (2017). Foundations of Financial Management. New York, NY: ...

A: a.Calculation of Break-Even point in bags:

Q: A stock is expected to pay a dividend of $1.67 at the end of the year. The required rate of return i...

A: A stock is expected to pay a dividend of D1 = $1.67 at the end of the year. The required rate of ret...

Q: The following are the current coupon yields to maturity and spot rates of interest for six U.S. Trea...

A: In the next step, we identify the values from the question.