Description of this paper

Will you be able to help me or not? I've been soli...

Description

Solution


Question

Will you be able to help me or not? I've been soliciting your help and keep getting denied with every excuse. Please help. All of the Data provided is relevant. The attachment is all needed and a Comprehensive Annual Financial Report. 1. Review the information in the Statement of Net Assets (page 11) and answer the following questions: a. What assets are included in Governmental Activities Depreciable Capital Assets? What is the capitalization threshold (policy)? Provide a breakdown of the 2009 change in accumulated depreciation by type of asset and amount. (6 points) b. What are the restrictions placed on the Business-Type Activities Restricted Assets? Identify the purposes (restrictions) and amounts. (4 points) c. What is the breakdown of Governmental Activities Non-current Liabilities (including amounts due within one year & due in more than one year) by type of obligation and amount? Provide a list of obligations and amounts totaling $32,252,113. (4 points) d. What percentage of Governmental Activities Net Assets are unrestricted? What percentage of Business Activities Net Assets are unrestricted? What can you learn from these percentages? (6 points) 2. Review the information in the Statement of Activities (page 12) and answer the following questions: a. Based on Net Expense, which three Governmental Activities had the highest net expenses? Identify the activities and the amounts. (6 points) b. Which Business-type Activities had Net Revenues (i.e., Program Revenues higher than Expenses)? Identify the activities and the amounts. (3 points) c. What were the four largest General Revenues for Governmental Activities? Identify the revenue items and the amounts. (4 points) d. What was the amount of the Change in Net Assets for Business-Type Activities? (1 point) 3. Review the information reported in the Governmental Funds Balance Sheet (page 14) and answer the following questions: a. What are the names of the major government funds? (4 points) b. Describe the transactions that are accounted for in each of the major governmental funds. (8 points) c. A significant portion of Total Fund Balance for the General Fund is reserved. Identify the purposes for which the General Fund fund balance is reserved and the amounts that are reserved for each purpose. (6 points) d. The total fund balance for Other Governmental Funds is $1,892,231. Identify the names of the funds that are combined into the Other Governmental Funds column and list the total fund balance for each of these funds. Make sure you tie back to the total fund balance of $1,892,231. Hint: You will need information that is reported combining schedules. See the Table of Contents to locate those schedules. There are many nonmajor funds, and you will have to look carefully to find all of them. (9 points),TOWN OF JUPITER, FLORIDA STATEMENT OF NET ASSETS September 30, 2009 ASSETS Cash and cash equivalents $ 29,910,876 $ 14,761,105 $ 44,671,981 Investments 9,325,147 25,246,653 34,571,800 Accounts receivable, net 1,572,240 1,349,418 2,921,658 Grants receivable 123,973 - 123,973 Inventory 32,348 - 32,348 Internal balances (38,000) 38,000 - Prepaid expenses 163,087 460,654 623,741 Restricted assets Investments 6,280,758 9,907,499 16,188,257 Notes receivable 350,000 - 350,000 Noncurrent receivables - 5,296,770 5,296,770 Net pension asset 239,096 - 239,096 Unamortized debt issue costs 186,746 260,693 447,439 Capital assets, not being depreciated Land 37,255,406 554,753 37,810,159 Construction in progress - 34,240,718 34,240,718 Capital assets, net of accumulated depreciation Buildings and plant 9,687,698 41,473,442 51,161,140 Improvements 19,945,495 119,334,142 139,279,637 Machinery and equipment 2,820,619 4,962,840 7,783,459 Infrastructure 12,653,903 - 12,653,903 Total Assets 130,509,392 257,886,687 388,396,079 LIABILITIES Accounts payable 1,483,202 2,578,339 4,061,541 Accrued expenses 1,458,214 476,940 1,935,154 Deposits 5,118,132 1,298,102 6,416,234 Unearned revenue 325,410 5,442,966 5,768,376 Liabilities payable from restricted assets - 1,003,834 1,003,834 Net other postemployment benefits obligation 88,918 26,082 115,000 Noncurrent liabilities Due within one year 2,293,205 101,800 2,395,005 Due in more than one year 32,252,113 42,359,417 74,611,530 Total Liabilities 43,019,194 53,287,480 96,306,674 NET ASSETS Invested in capital assets, net of related debt 55,852,845 163,110,644 218,963,489 Restricted for: Debt retirement 256,017 1,347,211 1,603,228 Capital projects 6,599,310 7,556,454 14,155,764 Law enforcement 139,275 - 139,275 Unrestricted 24,642,751 32,584,898 57,227,649 Total Net Assets $ 87,490,198 $ 204,599,207 $ 292,089,405 Business-Type Activities Total Governmental Activities The notes to the financial statements are an integral part of this statement. 11 TOWN OF JUPITER, FLORIDA STATEMENT OF ACTIVITIES For the Year Ended September 30, 2009 Functions/Programs GOVERNMENTAL ACTIVITIES General government $ 15,353,666 $ 1,967,052 $ 528,545 $ - Public safety 18,486,726 495,734 1,792,267 14,611 Engineering and public works 5,241,771 3,732,945 66,270 211,386 Culture and recreation 4,821,268 1,046,308 1,252 231,106 Interest on long-term debt 1,503,512 - - - Total Governmental Activities 45,406,943 7,242,039 2,388,334 457,103 BUSINESS-TYPE ACTIVITIES Water System 19,073,788 19,315,320 - 2,065,213 Building 1,595,607 2,199,206 - - Stormwater 3,508,053 2,197,749 - 62,348 Total Business-type Activities 24,177,448 23,712,275 - 2,127,561 Total $ 69,584,391 $ 30,954,314 $ 2,388,334 $ 2,584,664 General revenues Taxes Property taxes Franchise fees Public service taxes Communications services taxes Sales taxes Gas taxes Intergovernmental not restricted to specific programs Investment earnings Change in net assets Net assets at beginning of year Net assets at end of year Program Revenues Expenses Services Charges for Operating Contributions and Grants Capital Contributions and Grants Total general revenues and transfers Transfers 12 $ (12,858,069) $ - $ (12,858,069) (16,184,114) - (16,184,114) (1,231,170) - (1,231,170) (3,542,602) - (3,542,602) (1,503,512) - (1,503,512) (35,319,467) - (35,319,467) - 2,306,745 2,306,745 - 603,599 603,599 - (1,247,956) (1,247,956) - 1,662,388 1,662,388 (35,319,467) 1,662,388 (33,657,079) 2 2,750,485 - 22,750,485 4 ,715,332 - 4,715,332 3,337,851 - 3,337,851 3,697,912 - 3,697,912 3,077,029 - 3,077,029 9 90,923 - 990,923 9 91,315 71,747 1,063,062 3 1,685 195,879 227,564 1 18,250 (118,250) - 3 9,710,782 149,376 39,860,158 4 ,391,315 1,811,764 6,203,079 8 3,098,883 202,787,443 285,886,326 $ 8 7,490,198 $ 204,599,207 $ 292,089,405 Governmental Activities Total Changes in Net Assets Net Revenues (Expenses) and Business-type Activities The notes to the financial statements are an integral part of this statement. 13 TOWN OF JUPITER, FLORIDA BALANCE SHEET - GOVERNMENTAL FUNDS September 30, 2009 ASSETS Cash and cash equivalents $ 9,007,646 $ 17,450,134 $ 3,453,096 $ 2 9,910,876 Investments 7,927,697 283,421 1,114,029 9 ,325,147 Accounts receivable, net 1,418,898 - 1 53,342 1 ,572,240 Grants receivable 8,077 115,896 - 123,973 Due from other funds 2,698,823 - - 2,698,823 Inventory 32,348 - - 3 2,348 Prepaid items 161,645 - 1 ,442 163,087 Restricted assets Investments 941,250 5,339,508 - 6,280,758 Note receivable 3 50,000 - - 350,000 Total Assets $ 22,546,384 $ 23,188,959 $ 4,721,909 $ 50,457,252 LIABILITIES AND FUND BALANCES LIABILITIES Accounts payable $ 1,291,200 $ 61,147 $ 130,855 $ 1,483,202 Accrued liabilities 1,184,341 - - 1,184,341 Due to other funds 38,000 - 2,698,823 2 ,736,823 Deposits 784,493 4,333,639 - 5,118,132 Deferred revenue 325,410 - - 325,410 Total Liabilities 3 ,623,444 4,394,786 2,829,678 10,847,908 FUND BALANCES Reserved 4,305,920 5,406,298 1,656,536 11,368,754 Unreserved Designated for subsequent year's budget - 114,576 - 114,576 Undesignated reported in: General Fund 1 4,617,020 - - 14,617,020 Special Revenue Funds - - (179,513) ( 179,513) Capital Projects Fund - 13,273,299 - 13,273,299 Debt Service Funds - - 4 15,208 415,208 Total Fund Balances 18,922,940 18,794,173 1 ,892,231 39,609,344 Total Liabilities and Fund Balances $ 22,546,384 $ 23,188,959 $ 4,721,909 $ 50,457,252 Fund Fund Funds Funds Governmental Nonmajor Governmental Major Governmental Funds Capital Total General Improvements The notes to the financial statements are an integral part of this statement. 14

 

Paper#6370 | Written in 18-Jul-2015

Price : $25
SiteLock