
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
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

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
E7-23 Enterprise Fund Statement of Cash Flows [LO 7-5]
Inglis City had a beginning cash balance in its enterprise fund of $895,635. During 2017, the following transactions occurred:
1.
Interest received on investments totaled $42,400.
2.
The city acquired additional equity investments totaling $75,000.
3.
A grant was received from the state in the amount of $50,000 for summer interns.
4.
Receipts from sales of goods or services totaled $2,915,500.
5.
Payments for supplies were made in the amount of $1,642,100.
6.
Payments to employees for salaries amounted to $479,300.
7.
Equipment was sold for $57,500. It had a book value of $56,625.
8.
$25,000 was transferred to the General Fund.
9.
Other cash expenses for operations were $89,200.
10.
Long-term debt payments totaled $525,000.
Required
Prepare a statement of cash flows for the Inglis City enterprise fund. (Negative amounts should be indicated by a minus sign.)
Do not give answer in image…
arrow_forward
The following were the selected transactions of a National Government Agency during the period of FY 2022:· Received Notice of Cash Allocation (NCA) amounting to P10,000,000.· Earned total revenue of P2,500,000 from billings and collections of unbilled income.· Incurred total expenses of P8,000,000.· Remitted total taxes withheld of P1,500,000 to the BIR through Tax Remittance Advice (TRA).· The unused NCA balance is P1,000,000 at the end of the period.How much is the net surplus/(deficit) for the period in the statement of financial performance?
arrow_forward
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 Ratiob. Net Working Capitalc. Debt Ratio 1d. Debt Ratio 2e. Unrestricted Net Assets Ratiof. Response Ratio
arrow_forward
Prepare the journal entries for the following transactions to consolidate financial statements from fund-level statements to government-wide statements.
1....An internal service fund had a loss of $50
2.....An internal service fund had interest expense of $30
arrow_forward
Governmental funds report current financial resources. However, governmental funds may report some assets which are not current financial resources. Which of the assets below is acurrent financial resource at December 31, 2022?
A. An advance to an enterprise fund that is scheduled to be repaid in February, 2024.
B. Due from other funds.
C.A and B.
D.Neither A nor B.
arrow_forward
Question
You are provided with the following information relating to the Consolidated Fund for the year ended 31st December, 2019.
Debit
Credit
GHC'000
GHc'000
Corporate taxes
200,000
Personal income taxes
120,000
Capital gain taxes and sundries
50,000
Taxes on general goods and services
180,000
Fees, fines and penalties
80,000
Investment income
20,000
Custom duties
250,000
Grants
150,000
Communication service taxes
100,000
Royalties
40,000
Established post
240,000
Casual labour
60,000
Travel and transport
70,000
Repairs and maintenance
50,000
13% Social security contribution
26,000
Gratuity and end of service benefit
168,000
State protocol
180,000
Independence Day celebration
205,000
Seminar and conferences
30,000
Probation
25,000
Property plant and equipment (at cost)
300,000
Infrastructure (at…
arrow_forward
Question
The following are the balances extracted from the public Accounts on the consolidated fund from the year ended 31 December 2016.
GHS000
Direct Tax 1044460
compensation of employee 808672
Goods and Services 404336
Non-financial Assets 134779
Indirect tax 939556
Grants 28110
Interest Expenses 398138
Social benefits 238882
Other Expenses 159255
Other revenue…
arrow_forward
The following are the balances extracted from the public Accounts on the consolidated fund from the year ended 31 December 2016.
GHS000
Direct Tax 1044460
compensation of employee 808672
Goods and Services 404336
Non-financial Assets 134779
Indirect tax 939556
Grants 28110
Interest Expenses 398138
Social benefits 238882
Other Expenses 159255
Other revenue 50928…
arrow_forward
I have completed everything except for the unrestricted amounts. I can't seem to figure those out.
Can someone please help?
Problem:
The following information is available for the preparation of the government-wide financial statements for the City of Southern Springs as of April 30, 2020:
Cash and cash equivalents, governmental activities
$
420,000
Cash and cash equivalents, business-type activities
884,000
Receivables, governmental activities
498,000
Receivables, business-type activities
1,471,000
Inventories, business-type activities
576,000
Capital assets, net, governmental activities
14,953,000
Capital assets, net, business-type activities
7,864,000
Accounts payable, governmental activities
719,000
Accounts payable, business-type activities
619,000
General obligation bonds, governmental activities
8,637,000
Revenue bonds, business-type activities
3,554,000
Long-term liability for compensated…
arrow_forward
The following information is available for the preperation of the Government- wide financial statements for the City of Southren Springs as of April 30, 2020:
Cash and cash equivalents, governmental activities $480,000; Cash and cash equivalents, business- type activities $700,000; Receivables, Governemntal activities $450,000; Receivables, business-type activites $1,330,000; Inventories, business - type activities $520,000; Capitol assets, net governmental activities $12,500,000; Capitol Assets, net, business-type activities $7,200,000; Accounts payable, Governmental activites $650,000; Accounts payable, business - type activities $559,000; General obligation bonds, governmental activities $7,800,00; Revenue binds, business -type activities$3,210,000 Long term liability for compensated absences, governmental activities $359,000
From the preceeding information, prepare (in good form) a statement of Net Position for the City of Southern Springs as of April 30,2020. Assume that…
arrow_forward
Entity XYZ is a national government agency. Some of the major transactions of the agency for the year 202X were as follows:
1.The approved legislative appropriation for the year was 1 Billion. 10% of this appropriation was alloted by the Department of Budget and Management (DBM) to Entity XYZ.This allotment is broken down as follows:
Capital Outlay 50%
Maintenance and other operating expenses (MOOE) 40%
Personnel Services (PS) 10%
2.Received Notice of Cash Allocation (NCA) from DBM, P20 million,net of tax
3.Obligations were incurred as follows:
Capital Outlay 5million
Obligation for (MOOE) 3million
Personnel Services (PS) 2million
4. Delivery of office equipment and office supplies on account:
office equipment 3million
office supplies 200,000
5.Payable to officers and employees upon approval of payroll:
Salaries and wages P1,000,000
Personnel economic relief allowance(PERA) 150,000
Gross Payroll 1,150,000
Less:Deductions
Withholding Tax P35,000
Government service Insurance…
arrow_forward
Entity XYZ is a national government agency. Some of the major transactions of the agency for the year 202X were as follows:
1.The approved legislative appropriation for the year was 1 Billion. 10% of this appropriation was alloted by the Department of Budget and Management (DBM) to Entity XYZ.This allotment is broken down as follows:
Capital Outlay 50%
Maintenance and other operating expenses (MOOE) 40%
Personnel Services (PS) 10%
2.Received Notice of Cash Allocation (NCA) from DBM, P20 million,net of tax
3.Obligations were incurred as follows:
Capital Outlay 5million
Obligation for (MOOE) 3million
Personnel Services (PS) 2million
4. Delivery of office equipment and office supplies on account:
office equipment 3million
office supplies 200,000
5.Payable to officers and employees upon approval of payroll:
Salaries and wages P1,000,000
Personnel economic relief allowance(PERA) 150,000
Gross Payroll 1,150,000
Less:Deductions
Withholding Tax P35,000
Government service Insurance…
arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you

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

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