Compare the financial condition of the two cities based on the following indicators. Compare the financial condition of the two cities based on the following additional measures:

	Lake Grove	Lake Meade
	(dollar amounts in thousands)
Population	92,000	96,000
Number of employees	1,050	1,420
Total operating revenues	$120,000	$170,000
Property Tax levy	83,000	102,000
Total operating expenditures	112,000	174,000
Cash, investments and receivables	27,000	15,000
Current liabilities	9,000	12,000
Unassigned general fund balance	7,000	1,000
General obligation debt	21,000	32,000
Total appraised value of property	965,000	1,620,000

1. Compare the financial condition of the two cities based on the following indicators:
   1. Per capita operating expenditures
   2. Per capita general obligation debt
   3. Operating surplus (deficit)
   4. Liquid assets/current liabilities
   5. Unassigned general‐fund balance/total operating revenues
   6. Per capita number of employee
2. Compare the financial condition of the two cities based on the following additional measures:

a. Operating revenue/total appraised value of the property

1. Property taxes/total appraised value of the property
2. Per capita total appraised the value of the property

Problem 2: Which not-for-profit is more fiscally sound?

Visit GuideStar at www.guidestar.org. Select two organizations that have a similar mission and are of relatively similar size (e.g., Parkinson’s Disease Foundation and American Parkinson Disease Association).

Let’s assume that you are a financial analyst for a foundation, and you are concerned with the long-term fiscal viability of the two entities.

Requirements:
1. Compare the two as to:

a. The proportion of resources directed to fund-raising
b. The proportion of resources directed to program activities
c. Percentage of revenues from contributions and grants
d. Percentage of revenues from user charges and other sources e. Short-term liquidity
f. The burden of debt
g. Adequacy of fiscal resources
h. Current fiscal performance

2. Discuss your findings by commenting on which appears to be more fiscally sound.

Instructions:

 Answer all the questions completely showing your solutions in completing all the requirements as stated at the end of each problem above.

Requirements:

•  When preparing your responses, indicate the problem that you are writing a response on.
•  Use spreadsheets using MS Excel and create a workbook to respond to the problems. Create a separate worksheet for each problem and label each tab properly.
•  If narratives are required to complete your answer, submit them as an MS Word documents.