Business
FinanceQ&A LibrarySJC 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

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. 

bartleby
  • Contact Research (Essays)
  • High School Textbooks
  • Literature Guides
  • Essay Help
  • Mobile App
    • © 2021 bartleby. All Rights Reserved.