Essentials Of Investments
Essentials Of Investments
11th Edition
ISBN: 9781260013924
Author: Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher: Mcgraw-hill Education,
Bartleby Related Questions Icon

Related questions

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
expand button
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
Check Mark
Blurred answer
Knowledge Booster
Finance
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…
    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?
    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
  • 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
    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.
    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…
  • 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…
    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…
    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…
  • 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…
    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…
    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…
    • SEE MORE QUESTIONS
    Recommended textbooks for you
  • Essentials Of Investments
    Finance
    ISBN:9781260013924
    Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
    Publisher:Mcgraw-hill Education,
    FUNDAMENTALS OF CORPORATE FINANCE
    Finance
    ISBN:9781260013962
    Author:BREALEY
    Publisher:RENT MCG
    Financial Management: Theory & Practice
    Finance
    ISBN:9781337909730
    Author:Brigham
    Publisher:Cengage
  • 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,
    FUNDAMENTALS OF CORPORATE FINANCE
    Finance
    ISBN:9781260013962
    Author:BREALEY
    Publisher:RENT MCG
    Financial Management: Theory & Practice
    Finance
    ISBN:9781337909730
    Author:Brigham
    Publisher:Cengage
    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