Acct310 - CAFR Project

.xlsx

School

Saginaw Valley State University *

*We aren’t endorsed by this school

Course

310

Subject

Finance

Date

Feb 20, 2024

Type

xlsx

Pages

4

Uploaded by MinisterValor8403

Report
CAFR Project, Fall 2021 The following tabs provides information taken from the Comprehensive Annual Financial Report (CAFR) for a Michigan municipality. Using this information, please prepare: 1) A Government Wide Statement of Net Position 2) A Government Wide Statement of Activities Please note the following: a) Format will be carefully assessed. Please do not have a financial statement crossing page breaks, format numbers properly, prepare proper column headings, name the financial statements Saginaw's 2020 CAFR, pages 3-1 and 3-2 (Statement of Net Position) and page 3-3 (Statement of Activities). The focus of this assignment is format, carefully note where single and double lines are, dollar signs, etc. I will be looking at all of these when grading the assignment. Please be sure the Statement of Net Position is oriented as Portrait, and that the Statement of Activities is oriented as landscape. Also be sure that both financial statements fit to one page, that there is not a page break interrupting the financial statement. Saginaw's Statement of Net Position is shown on two pages, but please be sure that your Statements both are entirelly on one page each. b) Any number that is a total or a subtotal must be an excel formula. c) Each of the financial statements should be prepared in a separate excel worksheet (tab). Please submit an electronic version of this assignment through the Canvas Assignments link, appropriately. These need to be formatted as published financial statements . Please refer to no later than Tuesday, November 23, 11:30pm.
CAFR Project, Fall 2021 Government Wide Financial Statements, Trial Balances, Year ended March 31, 2020 Account Title Govt. Activities Business-Type Activities Component Units Debit ($) Credit ($) Debit ($) Credit ($) Debit ($) Credit ($) Cash 10,626,040 11,703,314 305,789 Investments 876,200 2,203,800 50,000 Receivables, net 914,253 1,318,294 6,068 Internal balances 443,252 443,252 Deposit held by Michigan Public Power Agency 427,777 Other assets 88,648 502,970 Capital assets not being depreciated 18,266,877 2,123,129 923,071 Capital assets being depreciated, net 12,046,474 36,177,595 2,118,393 Deferred Outflows of Resources 251,833 437,793 Accounts payable and accrued liabilities 970,886 1,025,069 24,337 Unearned revenue 45,066 16,037 850 Long-term debt due within one year 562,543 797,066 Long-term debt due in more than one year 11,636,377 10,621,959 Net pension liability 2,210,516 2,739,630 Deferred inflows of resources 121,663 150,783 Net Position - Beginning of Year 27,134,305 39,662,979 3,670,899 Charges for Services - Gen Govt. 242,045 Charges for Services - Legislative Charges for Services - Public Safety Charges for Services - Public works Charges for Services - Health and welfare 1,496,836 Charges for Services -Recreation and culture 308,219 Charges for Services - Interest Operating Grants & Contribution - Gen Govt. 693 Operating Grants & Contribution - Public Safety 37,299 Operating Grants & Contribution - Public works 549,895 Operating Grants & Contribution - Recreation and culture 46,181 Expenses - Gen Govt. 902,592 Expenses - Legislative 68,415 Expenses - Public Safety 1,539,898 Expenses - Public works 826,976 Expenses - Health and welfare 1,403,842 Expenses -Recreation and culture 1,303,118 Expenses - Interest 89,433 Charges for services - Electric utility 5,560,292 Charges for services - Sewage disposal utility 2,408,610 Charges for services - Water utility 1,651,326 Charges for services - Marina 461,957 Charges for services - Airport 1,445,492 Operating grants and contributions - Electric utility 62,566 Operating grants and contributions - Sewage disposal utility 39,475 Operating grants and contributions - Water utility 7,039 Operating grants and contributions - Marina 337,166 Capital grants and contributions - Airport 514,549 Expenses - Electric utility 5,856,299 Expenses - Sewage disposal utility 2,083,911 Expenses - Water utility 1,262,888 Expenses - Marina 1,123,176 Expenses - Airport 1,970,747 Charges for services - Downtown Development Authority 65,537 Operating grants and contributions - Downtown Development Authority 24,399 Expenses - Downtown Development Authority 897,977 General revenues: Property taxes 3,184,779 471,980 General revenues: State shared revenues 266,928 43,296 General revenues: Other revenue 29,384 General revenues: Gain on sale of capital assets 4,149 General revenues: Unrestricted investment earnings 46,533 General revenues: Transfers 132,950 132,950 TOTAL 49,337,549 49,337,549 67,634,945 67,634,945 4,301,298 4,301,298 For the "Net investment in capital assets" computation on the Statement of Net Position: (1) $3,192,892 of debt is related to capital assets for governmental activities. (2) $11,786,342 of debt is related to capital assets for business-type activities. (3) $0 of debt is related to capital assets for the component unit. Net position is restricted as follows: (1) $939,634 is restricted for governmental activities (2) $427,777 is restricted for business-type activities (3) $336,670 is restricted for the component unit Hint: If you prepare the financials correctly, Unrestricted net position will be a deficit for governmental activities and will be $0 for the component unit.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help