ST. JOHNS COUNTY, FLORIDA BALANCE SHEET-GOVERNMENTAL FUNDS September 30, 2015 St. Johns County Transportation Redevelopment Governmental Govenmental Equity in pooled cash and cash equivalents $25,584,658 2,304,434 S 20,804 30,711,687 58,601,581 107,463,868 Accounts and notes receivable (net of Advances to ather funds LIABILITIES AND FUND BALANCES $5,278,481 2,843,117 S 3,378 3,771,189 11,696,165 Advances from other funds 8.449,1042,812,7723,378 9312,18920,577443 274,899 2,838 Committed 4,590 41,047 447 32,568 496 17,428 TOTAL LIABILITIES AND FUND BALANCES 59,193,902 35,379,267 S 20,804 83,299,320 177,893 293 The accompanying notes are an integral part of the financial statements.

Question

Using the Balance Sheet in the St. Johns County, Florida 2015 CAFR calculate the following ratios for each of the five (5) funds shown and for the “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

Reconciliation of the Governmental Funds Balance Sheet
to the Statement of Net Position September 30, 2015

Total fund balances- governmental funds $ 157,315,850
Amounts reported for governmental activities in the statement of net
position are different because:
Capital assets used in governmental activities are not current financial
resources and therefore are not reported in the governmental funds. 1,241,213,205
Net OPEB obligations are created through the estimated calculation of the county's
employer contribution toward the retiree's benefits. The amount greater or less than the 5,549,497
annual required contribution is posted as an asset/(liability).
Deferred outflows for bond refunding losses are not reported in the governmental funds. 10,107,759
Deferred pension outflows are not reported in the governmental funds. 38,159,262
Bonds and notes payable ($201,892,655); unamortized bond premiums and
discounts (14,487,603); lease obligations ($4,811,609); compensated absences for
governmental funds ($10,170,840); and net pension liabilities ($87,159,647) are not due
and payable in the current period and therefore are not reported in the funds. (318,522,354)
Accrued interest payable is not reported in the governmental funds. (1,308,354)
Deferred pension inflows are not reported in the governmental funds. (37,379,857)
Internal service funds are used by management to charge the costs of certain activities,
such as insurance, to individual funds. The assets and liabilities of internal service
funds are included in governmental activities in the statement of net assets. 8,330,909
Net position of governmental activities $ 1,103,465,917

ST. JOHNS COUNTY, FLORIDA
BALANCE SHEET-GOVERNMENTAL FUNDS
September 30, 2015
St. Johns County
Transportation Redevelopment Governmental Govenmental
Equity in pooled cash and cash equivalents
$25,584,658 2,304,434 S
20,804
30,711,687
58,601,581
107,463,868
Accounts and notes receivable (net of
Advances to ather funds
LIABILITIES AND FUND BALANCES
$5,278,481 2,843,117 S
3,378
3,771,189 11,696,165
Advances from other funds
8.449,1042,812,7723,378
9312,18920,577443
274,899
2,838
Committed
4,590
41,047 447
32,568 496
17,428
TOTAL LIABILITIES AND FUND BALANCES
59,193,902
35,379,267 S
20,804
83,299,320 177,893 293
The accompanying notes are an integral part of the financial statements.
Expand
Transcribed Image Text

ST. JOHNS COUNTY, FLORIDA BALANCE SHEET-GOVERNMENTAL FUNDS September 30, 2015 St. Johns County Transportation Redevelopment Governmental Govenmental Equity in pooled cash and cash equivalents $25,584,658 2,304,434 S 20,804 30,711,687 58,601,581 107,463,868 Accounts and notes receivable (net of Advances to ather funds LIABILITIES AND FUND BALANCES $5,278,481 2,843,117 S 3,378 3,771,189 11,696,165 Advances from other funds 8.449,1042,812,7723,378 9312,18920,577443 274,899 2,838 Committed 4,590 41,047 447 32,568 496 17,428 TOTAL LIABILITIES AND FUND BALANCES 59,193,902 35,379,267 S 20,804 83,299,320 177,893 293 The accompanying notes are an integral part of the financial statements.

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: The following problem refers to the stock table for ABC Inc.​ (a tire​ company) given below. Use the...

A: Hi, I’m answering the first 3 subparts of the question as the given question consists of multiple su...

Q: A firm has two possible investment with the following cash inflows. Each investment cost $480, and t...

A: Upon visula Inspection, we can deduce that investment A will have shorter payback period (<2 year...

Q: Which are the main legislative acts governing the Mergers & Aquisition activities in the United ...

A: Mergers and Acquisitions (M&A) are transactions of uniting two or more companies into one. The m...

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

A: Calculating of the expected retained profit for the next year. We have,Profit margin = 12 % of sales...

Q: Bethesda Water has an issue of preferred stock outstanding with a coupon rate of 3.80 percent that s...

A: Calculation of the cost of preferred stock of the company. We have,Cost of preferred stock = Annual ...

Q: Book Value versus Market Value Dinklage Corp. has 8 million shares of common stock outstanding. The ...

A: Equity Details:Dinklage Corp. has Ns = 8 million shares of common stock outstanding.The current shar...

Q: Todd Foley is applying for a $290,000 mortgage. He can get a $2,030 monthly payment for principal an...

A: Calculation of number of months:Excel spreadsheet for calculation of number of months 

Q: What are some of the possible consequences should a home owner allow the policy to lapse?

A: If the policyholder of the property insurance fails to make multiple payments, then the homeowners i...

Q: Porter’s five-factor model provides a structure for analyzing the investment value of an industry or...

A: Porter’s Five Forces Analysis: Porter’s five forces framework is a method to analyze competition for...

Q: How to calculate breakeven balance

A: Break even analysis explains how much total revenue is required to cover both the fixed and variable...

Q: Kelso Electric is an all-equity firm with 43,250 shares of stock outstanding. The company is conside...

A: As is situation: All equity, no debt, hence no interest payment, ignor taxes.Hence, Net income = EBI...

Q: The company stock increases dividend by 5% each year and the expecteddividend in 5 years is $5. Anal...

A: Suppose the dividend paid recently=$xDividend paid in year 1=x*(1+growth rate)^1Dividend paid in yea...

Q: As the chief investment officer for a money management firm specializing in taxable individual inves...

A: Part (a)Expected Utility function = E(U) = ER - σ2 / Risk Tolerance FactorPlease see the table below...

Q: I now have $16,000 in the bank earning interest of 1.00% per month. I need $26,000 to make a down pa...

A: Calculation of Duration of the Investment:

Q: Energetic Engines is trying to estimate its cost bonds that pay $20 interest every six months. Each ...

A: Calculating the value of bond yield. We have,Bond yield = Coupon Payment / Face value of bondHere,Co...

Q: If the interest rate per day is 0.014%, then what is the annual rate?

A: Interest rate:An interest rate is a percentage on the principal amount at which a lender gives money...

Q: Find the following values assuming a regular, or ordinary, annuity: The present value of $400 per...

A: Calculation of present value of $400 per year for 10 years at 10%: Excel spread sheet:

Q: Insigne Corporation is considering two investment projects (projects A and project B) that are mutua...

A: We have the following data regarding outflows and inflows for the two projects: 

Q: The following problem refers to the stock table for ABC Inc.​ (a tire​ company) given below. Use the...

A: A.The amount of shares traded yesterday is nothing but the total volume of shares which is 591,500 s...

Q: Assume that the agreed-upon price is $90,000. What is the expected profiton the contract assuming th...

A: In the earlier part, the marginal cost for hospital 4 was calculated as $ 71,468 Marginal cost / pat...

Q: Here is the problem: Famas's LLamas has a weighted average cost of capital of  7.9%. The company's c...

A: Calculation of Weight of Debt:The weight of debt is calculated using the WACC formula, where the wei...

Q: Find the following values for a lump sum assuming annual compounding: The future value of $500 inve...

A: Before we get into the solution, let's understand two reciprocal concepts:If present value (PV) is k...

Q: Given the following informations annual sales in units                   30,000 cost of placing an o...

A: a.Calculation of EOQ:

Q: Gulf Shores Inn is comparing two separate capital structures. The first structure consists of 315,00...

A: Calculating the price per share of equity of the company. We have,Let the price of equity share be X...

Q: The Shamrock Corporation has just isssued a $1,000 par value zero-coupon bond with an 8 percent yiel...

A: FV =  Par Value = $ 1,000Yield, y = 8%Since we have been asked to assume semi annual compounding, we...

Q: Multinational corporations are exposed to higher risks that primarily come from two significant sour...

A: Expropriation is the act in which taking  over of privately owned property by the government.While, ...

Q: Case Study #3: Chapter 6 Business Analysis  A business can be valued by capitalizing its earnings st...

A: A business can be valued by capitalizing its earnings stream. In fact, the valuation of any asset or...

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

A: a)Formula for calculation of EOQ:

Q: National governments issue debt securities known as sovereign bonds, which can be denominated in eit...

A: Note:Since, we are entitled to answer up to 3 sub-parts, we shall answer the first 3 as you have not...

Q: Bill Clinton reportedly was paid $10 million to write his book My Life. Suppose the book took three ...

A: Since you have specifically asked for excel workings, a snpashot of the excel model is attached for ...

Q: What are the major flaws with NPV? What are the major flaws with IRR? If you are going to a bank and...

A: Major flaws with NPV:Requires an assumption of discount rate which is not directly observable in the...

Q: Rappaport Industries has 6,250 perpetual bonds outstanding with a face value of $2,000 each. The bon...

A: Calculating the value of interest tax shield. We have,Interest payment per year = Face Value of bond...

Q: Given relatively stable financial market conditions, determine which one of the followingbonds would...

A: The bonds that would exhibit the least price volatility is “5-year, 10% coupon bond”.

Q: how I can fill the blanc with correct entries Assets Current Assets Cash                            ...

A: Hi. Since all the other figures are in millions, we have assumed the inventory value to be $1,410,00...

Q: A 10-year bond has a coupon rate of 11%, a par value of $1000. If the bond’s YTM is 7%, what is the ...

A: Assume semi annual coupon bond (Such an assumption is customary to bonds in US market). This means c...

Q: I was asked to repost the question.  It is as follows: Assume a security follows a geometric Brownia...

A: In mathematical finance, risk neutral is a probability measure used to support in pricing financial ...

Q: If the annual geometric mean for the equity risk premium is 8.4 percent, what percentage of the equi...

A: Calculation of Percentage of Equity Risk Premium:

Q: I have been working on the question below and I'm stuck on how to finish it up.  I have provided wha...

A: The below are the possible considerations:It is characterized as a connection between the prices of ...

Q: please colud you explain me what how you using calculator or computation to determine NPV or IRR. A ...

A: a.Calculation of Internal Rate of Return for each investment:The Internal Rate of Return or IRR for ...

Q: The common stock of Sophia Enterprises serves as the underlying asset for the following derivative s...

A: Forwards contract price, F = Strike price of the option, K  = $ 50Price of a call option, C = $ 5.20

Q: If one British pound can purchase $1.85 U.S. dollars, how many British pounds can one U.S. dollar bu...

A: Excel spread sheet for calculation of British pounds:

Q: Blue Angel, Inc., a private firm in the holiday gift industry, is considering a new project. The com...

A: Since the question involves interplay of lots of variable, we will resort to Microsoft excel to solv...

Q: In Porter's five-factor model why does Porter not include market size and growth rate when determini...

A: Porter's five forces analysis is a structural framework to evaluate the attractiveness of an industr...

Q: Hi, I'm looking for help with solving the answer for the following question. I've tried it myself se...

A: Calculation of future value:There are 525,600 minutes in a year. So there are 10,512,000 minutes for...

Q: The credit card with the transactions described in the popup below uses the average daily balance me...

A: Credit CardIt is a card issued to customers for making payment towards goods and services. These car...

Q: Why might an investor-owned firm choose to issue different classes of common stock?

A: An investor owned firm issues different classes of common stock mainly due to the difference in voti...

Q: What finances do you need to have to achieve getting somewhere with Cosmetology?  For instance to bu...

A: Some essential costs that are needed to be assessed before building a salon are:Cosmetics: A salon h...

Q: a. If you borrow $1,100 and agree to repay the loan in six equal annual payments at an interest rate...

A: Part (a)Let the annual payment be P. Interest rate, i = 11%; n = period = number of payment = 6Hence...

Q: Bonds of Francesca Corporation with a par value of $1,000 sell for $960, mature in five years, and h...

A: We have :Fac Value of the bond : $1,000Current Market Price : $960Years to Maturity : 5 yearsCoupon ...

Q: Use the compound interest formula A = P(1 + i)n to find the indicated values A = $6,000; i = 0.03; n...

A: Compounded Interest:           It is the method for computing interest at the initial amount of prin...