Reference no: EM134006243

Government and Non-Profit Accounting

Assessment Design Philosophy (CBE Alignment)

This assessment is designed to evaluate observable competencies, not memorization.

Students must demonstrate:
Data extraction competency
Analytical reasoning
Application of standards
Professional judgment
Excel-based accounting skills

Each question explicitly maps to:
CLO
CBE domain (Analyze / Apply)
Real-world accounting artifacts (CAFR, University & Hospital Financial Statements)

Questions 1 (Governmental Accounting)

Each student must select a different CAFR / ACFR from a U.S. state, county, or large municipality.

Acceptable sources:
State governments (e.g., Texas, California, New York)
Large cities (e.g., Chicago, Los Angeles)
Counties (e.g., Orange County, Cook County)

Students must clearly state the name of the government, fiscal year, and CAFR URL.

Question 4 (Non-Profit Accounting)

Students must select both of the following:
Public University or College (Higher Education)
Non-profit Hospital or Health Care Provider

Acceptable documents:
Audited Financial Statements (PDF)
Annual Report with full financial statements
IRS Form 990 (supplementary, not standalone)

QUESTION 1

CLO1 - Comparative Analysis of Accounting Basis & Financial Statements
Task Type
Data Extraction (Excel) + Analysis (Word)

Student Instructions
Using your selected CAFR, extract information from:
Governmental Funds Balance Sheet
Statement of Net Position (Government-Wide)
Then compare these with a for-profit company of your choice (annual report).

Analysis Requirement (600-800 words):
Analyze why different bases of accounting are used
Evaluate decision-usefulness for stakeholders
Link findings to accountability vs profitability objectives

QUESTION 2

CLO2 - Application of Revenue and Expenditure Accounting (Governmental Funds)
Task Type
Student Instructions

From the General Fund section of your CAFR:
Identify three revenue sources
Identify three expenditure categories
Apply modified accrual accounting rules

Required Excel Output (Q2_CLO2_Excel.xlsx)

Sheet 1: Revenue Recognition

Sheet 2: Expenditure Recognition

Sheet 3: Adjustment Scenario
Students must:
Adjust recognition
Show revised fund balance impact

CBE Focus
Application of rules
Correct judgment under modified accrual

QUESTION 3

CLO3 - Government-Wide Capital Assets & Long-Term Debt Analysis
Task Type
Advanced Excel Analysis + Interpretive Commentary

Student Instructions

Using government-wide statements in your CAFR:
Extract:
Capital Assets (beginning, additions, depreciation, ending) No AI shortcuts — Get expert assignment help from real, qualified tutors today.
Long-term Debt (beginning, issuances, repayments, ending)
Analyze the impact on Net Position

Required Excel Output (Template 3: Q3_GovEide.xlsx)

Sheet 1: Capital Assets Roll-Forward

Sheet 2: Long-Term Debt Roll-Forward

Sheet 3: Net Position Impact

Required Word Output (Q3_CLO3_Words_Analysis.docx)

Analysis Requirement (800-1,000 words):
Explain why capital assets and long-term debt appear only at government-wide level. No AI shortcuts — Get expert assignment help from real, qualified tutors today.
Analyze fiscal sustainability
Comment on interperiod equity

QUESTION 4

MANDATORY: Higher Education AND Hospital
Assessment Type: Major Practical Case

Tools Required: Microsoft Excel (primary), Microsoft Word (analysis)

CBE Level: Apply (with embedded professional judgment)