
Essentials Of Investments
11th Edition
ISBN: 9781260013924
Author: Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
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

Transcribed Image Text: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 Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 6 steps

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- The following transactions were among those reported by Corfe City's electric utility enterprise fund for Year 1: Cash paid to supplier $ 900,000 Cash received from customer households 2,700,000 Proceeds from the sale of revenue bonds 4,500,000 In the electric utility enterprise fund's statement of cash flows for the year ended December 31, Year 1, what amount should be reported as cash flows from capital and related financing activities? A.) $4,500,000 B.) $5,400,000 C.) $7,200,000 D.) $8,100,000arrow_forwardBased on the Republic Bank TT, an investment holding company, answer the following questions below using the following link below for help. Provide a detail explanation and examples to the answers. https://www.republictt.com/pdfs/annual- reports/RFHL-Annual-Report-2022.pdf 1. Assess the company's working capital position by analyzing its current assets and liabilities using common methods and measures( using the figures in the financial statements) 2. Evaluate the efficiency of the company's working capital management strategies, including inventory management, accounts receivable, and accounts payable( using figures from the financial statements) 3. Based on the assessment and evaluation above, provide ten recommendations for improving the company's working capital management practices.arrow_forwardplease show excel formulasarrow_forward
- Calculate the Rate of Return on Assets (ROA) for 2011. Disaggregate ROA into the profit margin for ROA and total assets turnover components. Calculate the Rate of Return on Common Stockholders’ Equity (ROCE) for 2011. Disaggregate ROCE into the profit margin for ROCE, total assets turnover and capital structure leverage components.arrow_forwardPlease do not give solution in image format thankuarrow_forwardUsing the following Balance Sheet summary information, calculate for the two companies presented:working capitalcurrent ratio Company L and Company M, respectively: Current assets $124,680, $180,550. Current liabilities 63,250, 153,250.arrow_forward
- Make comments on this tablearrow_forwardhttps://www.republictt.com/pdfs/annual-reports/RFHL-Annual-Report-2022.pdf (Use the link the answer the question below) Working Capital Management : Use Republic Bank Limited Annual Report 2022 to answer the Questions. Assess the company’s working capital position by analyzing its current assets and liabilities using common methods and measures. Evaluate the efficiency of the company’s working capital management strategies, including inventory management, accounts receivable, and accounts payable. Based on your assessment and evaluation above, provide brief recommendations in point form for improving the company’s working capital management practices.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education

Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,



Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,

Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education