ST. JOHNS COUNTY, FLORIDA STATEMENT OF NET POSITION PROPRIETARY FUNDS SEPTEMBER 30, 2015 Business-type Activities t. Johns County Ponte Vedra Sold ASSETS Current assets 923.306 3093 284 5.133.860 629536 Equity in pooled cash and cash equivalents 6,391 551 2.881.802 93403 23.886 ,611,78 Accounts recelvable, net unit corrอction foe notes receivable Interest receivable Other assets Due from other funds Due from other government Inventon 81.485 50,921 114,855 38.728 488 219 42.651 1,170 1,180,324 Cash and cash equivalents 4,918,673 4,104,102 253.390 4640 87S 27 831 Total ourrent assets Capital assets: 00,752,0E6 54,395 2,821,851 49,645,275 6,742,632 46.788.727 26. 381 2019.934 20,794 856 1,140.339 727,127 8182 789 1324.104 3.359,789) Water and sewer systems Furnture and equipment 126,289,877 7,301,996) 6 238 307 Total non-current assets TOTAL ASSETS ,632,784 266,744 161 570 TOTAL DEFERRED OUTFLOWS OF RESOURCES 536.996 Accounts payable and acarued labilities Unit connection fee contract payable Esimated lablity for self insured losses Customer deposits Due to other funds Due to other goverrments Landfil closure and post-closure costs Revenue bonds and notes payable Interest payable State loan payable 2,276,718 187,877 253 390 7 979 1,043,620 323.553 2,655,340 1,018,281 1,610.000 911,376 191,870 14,108 50.607 20,101 Pension labities Total current liabilities Apcrued landtl closure and post-closure costs bonds and notes payable 14,324,282 7,846,729 054 265 4.692 347 State loan payable Capital lease payable Apcrued compensated absences Total long-term liabilities TOTAL LIABILITIES DEFERRED INFLOWS OF RESOURCES TOTAL DEFERRED INFLOWS OF RESOURCES NET POSITION Net investment in capital assets 153.655 51,065 268 418 1,269,788 158 269 231,526,183 Debt service Renewal and replacement reserve 4,128,809 1,748,916 1,384,023 4.149 744 TOTAL NET POSITION The accompanving 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

ST. JOHNS COUNTY, FLORIDA
STATEMENT OF NET POSITION PROPRIETARY FUNDS
SEPTEMBER 30, 2015
Business-type Activities
t. Johns County
Ponte Vedra
Sold
ASSETS
Current assets
923.306 3093 284
5.133.860
629536
Equity in pooled cash and cash equivalents
6,391 551
2.881.802
93403
23.886
,611,78
Accounts recelvable, net
unit corrอction foe notes receivable
Interest receivable
Other assets
Due from other funds
Due from other government
Inventon
81.485
50,921
114,855
38.728
488 219
42.651
1,170
1,180,324
Cash and cash equivalents
4,918,673
4,104,102
253.390
4640 87S
27 831
Total ourrent assets
Capital assets:
00,752,0E6
54,395
2,821,851
49,645,275
6,742,632
46.788.727
26. 381
2019.934
20,794 856
1,140.339
727,127
8182 789
1324.104
3.359,789)
Water and sewer systems
Furnture and equipment
126,289,877
7,301,996)
6 238 307
Total non-current assets
TOTAL ASSETS
,632,784
266,744
161 570
TOTAL DEFERRED OUTFLOWS OF RESOURCES
536.996
Accounts payable and acarued labilities
Unit connection fee contract payable
Esimated lablity for self insured losses
Customer deposits
Due to other funds
Due to other goverrments
Landfil closure and post-closure costs
Revenue bonds and notes payable
Interest payable
State loan payable
2,276,718
187,877
253 390
7 979
1,043,620
323.553
2,655,340
1,018,281
1,610.000
911,376
191,870
14,108
50.607
20,101
Pension labities
Total current liabilities
Apcrued landtl closure and post-closure costs
bonds and
notes payable
14,324,282
7,846,729
054 265
4.692 347
State loan payable
Capital lease payable
Apcrued compensated absences
Total long-term liabilities
TOTAL LIABILITIES
DEFERRED INFLOWS OF RESOURCES
TOTAL DEFERRED INFLOWS OF RESOURCES
NET POSITION
Net investment in capital assets
153.655
51,065
268 418
1,269,788
158 269
231,526,183
Debt service
Renewal and replacement reserve
4,128,809
1,748,916
1,384,023
4.149 744
TOTAL NET POSITION
The accompanving notes are an integral part of the financial statements
Expand
Transcribed Image Text

ST. JOHNS COUNTY, FLORIDA STATEMENT OF NET POSITION PROPRIETARY FUNDS SEPTEMBER 30, 2015 Business-type Activities t. Johns County Ponte Vedra Sold ASSETS Current assets 923.306 3093 284 5.133.860 629536 Equity in pooled cash and cash equivalents 6,391 551 2.881.802 93403 23.886 ,611,78 Accounts recelvable, net unit corrอction foe notes receivable Interest receivable Other assets Due from other funds Due from other government Inventon 81.485 50,921 114,855 38.728 488 219 42.651 1,170 1,180,324 Cash and cash equivalents 4,918,673 4,104,102 253.390 4640 87S 27 831 Total ourrent assets Capital assets: 00,752,0E6 54,395 2,821,851 49,645,275 6,742,632 46.788.727 26. 381 2019.934 20,794 856 1,140.339 727,127 8182 789 1324.104 3.359,789) Water and sewer systems Furnture and equipment 126,289,877 7,301,996) 6 238 307 Total non-current assets TOTAL ASSETS ,632,784 266,744 161 570 TOTAL DEFERRED OUTFLOWS OF RESOURCES 536.996 Accounts payable and acarued labilities Unit connection fee contract payable Esimated lablity for self insured losses Customer deposits Due to other funds Due to other goverrments Landfil closure and post-closure costs Revenue bonds and notes payable Interest payable State loan payable 2,276,718 187,877 253 390 7 979 1,043,620 323.553 2,655,340 1,018,281 1,610.000 911,376 191,870 14,108 50.607 20,101 Pension labities Total current liabilities Apcrued landtl closure and post-closure costs bonds and notes payable 14,324,282 7,846,729 054 265 4.692 347 State loan payable Capital lease payable Apcrued compensated absences Total long-term liabilities TOTAL LIABILITIES DEFERRED INFLOWS OF RESOURCES TOTAL DEFERRED INFLOWS OF RESOURCES NET POSITION Net investment in capital assets 153.655 51,065 268 418 1,269,788 158 269 231,526,183 Debt service Renewal and replacement reserve 4,128,809 1,748,916 1,384,023 4.149 744 TOTAL NET POSITION The accompanving 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

Pro Forma Analysis

Related Finance Q&A

Find answers to questions asked by students like you.

Q: Finding the Interest Rate: Concept Connection Example 6-3 (page 237) 18. What interest rates are imp...

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

Q: Global Products plans to issue long-term bonds to raise funds to finance its growth. The company has...

A: a)Calculation of Coupon Rate on the New Bond Issue:

Q: Participation #3:   Discuss mortgage loans in terms of the time value of money and loan amortization...

A: A mortgage loan originates when an asset is purchased with loan. The mortgage loan is repaid in inte...

Q: how to solve a-c?

A: Calculating the value of each amount in the flexible budget. We have,

Q: The manufacturer of a product that a variable cost of $2.50 per unit and total fixed cost of $125,00...

A: The manufacturer of a product that a variable cost of $2.50 per unit and total fixed cost of $125,00...

Q: The Company dividend appears to grow smoothly at a constant rate of 5.5%. Analysts forecast that nex...

A: Recall the Gordan Growth Model with constant growth. Price at any time t is given byPt = Dt+1 / (ke ...

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: The following table shows the nominal returns on Brazilian stocks and the rate of inflation. Nominal...

A: Excel spread sheet of calculation of standard deviation of the market returns:

Q: I got an answer of 6.2% for this question, Can you confirm or deny my answer? R.S. Green has 250,000...

A: The final answer is 6.16% that can be rounded off to 6.2%. Hence, your answer is correct.Let's assig...

Q: A 25-year annuity was purchased with $225,000 that had accumulated in a RRSP.  The annuity provides ...

A: This question is based solved using Excel functions:PMT: Tells us monthly mortgage payment on a loan...

Q: Ed Draycutt is the engineering manager of Airway Technologies, a firm that makes computer systems fo...

A: You have asked a case sudy with four sub parts. I will answer the first three sub parts. Please post...

Q: The four different bond ratings below have a yeild to maturity for 10 year bonds. Baa 9.40% Ba1 9.60...

A: The bonds of Parrot Corp. were rated as Baa  and issued at par a few weeks ago. The yiled correspond...

Q: The potential loss incurred from purchasing a call option is finite, but the potential loss to the s...

A: Let's figure out the payoff to the seller  or writer of the call option at the time of expiration of...

Q: Kose, Inc., has a target debt-equity ratio of 1.31. Its WACC is 8.1 percent, and the tax rate is 22 ...

A: Kose, Inc., has a target debt-equity ratio of 1.31. Its WACC is 8.1 percent, and the tax rate is 22 ...

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

A: Calculating the anticipated return after financing costs with the most aggressive asset financing mi...

Q: Compute the Macaulay duration under the following conditions: a. A bond with a four-year term ...

A: Part (a)Let's assume that the bond has a face value of $ 1,000. (Please note that this assumption wi...

Q: Your client is currently 19 years old. Your client wishes to retire at age 71. Your client's expecte...

A: Two assumptions are required to be made because the question is silent about them:All cash flows i.e...

Q: This project must fund the construction of an on/off-interchange from an adjacent highway, a 2-mile ...

A: Such a problem is beteer solved in an excel. Hence, I have solved it in excel and provided a snapsho...

Q: ck my ork The Titanic Shipbuilding Company has a noncancelable contract to build a small cargo vesse...

A: Calculation of Range of Opportunity Cost of Capital using IRR rule:The cash flows in the initial yea...

Q: 1  Borrow $178,000 at 5.25% for 30 years 2  Borrow $178,000 at 4.00% for 15 years What are the 2 pay...

A: Calculation of Payments and Total Interest Paid for 2 Mortgages:Assuming both the mortgages is paid ...

Q: The company yesterday paid their annual dividend of $2.00 and the expected price in 2 years is $100....

A: Stock’s Required Return:Stock’s required return is the minimum amount or rate of return which an inv...

Q: Growth Company's current share price is $19.95 and it is expected to pay a $1.00 dividend per share ...

A: Since your question has multiple sub parts, I will address first three of them. Please post the bala...

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: You can afford monthly deposits of $100 into an account that pays 5.3% compounded monthly. How long ...

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

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

A: Part (A)City Farm has $5 million per day in collections and $3 million per day in disbursementsColle...

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: How do I calculate free cash flow?

A: Introduction: FCF or Free Cash Flow is a proportion of the amount of money a business creates in the...

Q: Part 1 and Part II are independent. Please answer both parts. Part I: You are advising company ABC o...

A: Part I:Company ABC should choose Option #1. Because after one year Option #1 will have a present val...

Q: Suppose that the value of an investment in the stock market has increased at an average compound rat...

A: Calculation of Worth of Investment Today:With the current year being 2016, there are totally 112 yea...

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: First and Ten Corporation’s stock returns have a covariance with the market portfolio of .0506. The ...

A: Calculation of Beta:

Q: A project costs $1 million and has a base-case NPV of exactly zero (NPV sign. Enter your answers in ...

A: a.Calculation of Adjusted Present Value:

Q: can I have this explained? After 20 years, 100 shares of stock originally purchased for $1000 was so...

A: The formula to calculate the yield on investment:Yield on investment can be determined using the CAG...

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

A: Suppose the recent dividend paid=$xDividend in year 1=x*(1+growth rate)Dividend in year 2=x*(1+growt...

Q: Save Help Subr Exit Check my work Marsha Jones has bought a used Mercedes horse transporter for her ...

A: Calculation of NPV of the Investment:The renting is done for every other week which means there are ...

Q: Decide whether the following statement makes sense​ (or is clearly​ true) or does not make sense​ (o...

A: The correct answer is “Statement B”.

Q: Simone's Sweets is an all-equity firm that has 9,100 shares of stock outstanding at a market price o...

A: As is situation: All equity, no debt, hence no interest payment, Let T be the tax rate.Hence, Pre ta...

Q: Ornaments, Inc., is an all-equity firm with a total market value of $641,000 and 30,600 shares of st...

A: Scenario: RecessionEBIT = EBIT when economy is normal x (1 - 15%) = $ 91,700 x (1 - 15%) = $ 77,945 

Q: sugey communication has a balance at december 31 cash    $37,000 office equipment  $51,250 building ...

A: Balance sheet It is a part of the financial statements which shows any company’s standings with resp...

Q: Assume​ Evco, Inc., has a current stock price of $39 and will pay a $1.80 dividend in one​ year; its...

A: Calculation of Expected Price:

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: 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: 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: Assume that you purchased an 8 percent, 20-year, $1,000 par, semiannual payment bond priced at $1,01...

A: We can find the yield using the RATE function of excel.Payment frequency = semi annual; Hence, perio...

Q: The Greenbriar is an all-equity firm with a total market value of $530,000 and 21,000 shares of stoc...

A: Calculation of current market price per share:

Q: Let C be the price of a call option that enables its holder to buy one share of a stock at an exerci...

A: Given that, K is the exercise price, S is stock price at time 0.

Q: Better Mousetraps has developed a new trap. It can go into production for an initial investment in e...

A: Calculation of Increase in Project NPV:

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: Assume that you purchase a five-year, $1,000 par value bond, with a 6 percent coupon and a yield of ...

A: Calculating the current price of the bond. We have,Current price of bond = C [1 – (1 / (1+r)n ] / r ...

Q: Critique this statement: “The use of debt financing lowers the net income of the firm, and hence deb...

A: The statement has two parts:The use of debt financing lowers the net income of the firm,Hence debt f...