Question

Presented below are financial statements (except cash flows) for two not-for-profit organizations. Neither organization has any permanently restricted net assets. ABC Not-for-profit Temporarily Unrestricted Restricted XYZ Not-for-Profit Temporarily Unrestricted Restricted $5,610,000 3,365,800 $ $2,280,000 3,275,000 780, eee 99,800 $1,628,800 25, eee 488, eee 9,480, eee (480, 800) 399, eee 392, eee 5,947, eee (392, 800) 636,800 Statement of Activities Revenues Program service revenue Contribution revenues Grant revenue Net gains on endowment investments Net assets released from restriction Satisfaction of program restrictions Total revenues Expenses Education program expenses Research program expense Total program service expenses Fund-raising Administration Total supporting service expenses Total expenses Increase in net assets Net assets January 1 Net assets December 31 5,666, eee 1,286, eee 6,952,800 580.009 680, 1,182.eee 8.132.ee 1.348, ege 4,238,808 $5,586,000 1,574,899 2,286. eee 3,860, 373,800 1, 244, eee 1,617,800 5,477,899 470.899 1,075, eee $1,545,800 399,000 774, eee $1,173,600 636, eee 350. eee 986,800 $ ABC Not-for-Profit XYZ Not-for-profit $ $ 265.603 280,899 39. see 447, eee 1,832, 100 371,800 106,500 225, ees 191,500 894,899 Statement of Net Assets Current assets Cash Short-term cash equivalents Supplies inventories Receivables Total current assets Noncurrent assets Noncurrent pledges receivable Endowment investments Land, buildings, and equipment (net) Total noncurrent assets Total assets Current liabilities Accounts payable Total current liabilities 268, eee 2,665.eas 3,182.509 6,115,500 $7,147,600 1,798, eee 1,798,800 $2,692,899 30,5ee $ 136,500 136, See 30, see

Answer 1

	ABC	XYZ
Program expense	$ 6,952,000	$ 3,860,000
Total Expense	$ 8,132,000	$ 5,477,000
Fund raising expense	$     500,000	$     373,000
Contribution revenue	$ 3,365,000	$ 3,275,000
Cash on hand	$     545,600	$     477,500
Operating expense	$ 8,132,000	$ 5,477,000
Depreciation expense	$     825,000	$     825,000
Current Assets	$ 1,832,100	$ 8,894,000
Current liabilities	$        30,500	$     136,500
Sales revenue	$ 9,480,000	$ 5,947,000

Ratio	Formula	ABC	XYZ	Stronger Ratio
Program Expense ratio	Program Expenses / Total Expenses	85%	70%	ABC
Fund raising efficiency	Fundraising Expense / Contribution Revenue	15%	11%	XYZ
Cash on hand	Cash on hand/(Operating expenses-non cash expenses)/365	27.25	37.47	XYZ
Days Working capital	Working capital/Sales revenue	0.19	1.47	ABC

Working capital - Current assets - Current liabilities

Show formula in excel

Ratio	Formula	ABC	XYZ	Stonger Ratio
Program Expense ratio	Program Expenses / Total Expenses	=+B14/B15	=+C14/C15	ABC
Fund raising efficiency	Fundraising Expense / Contribution Revenue	=+B16/B17	=+C16/C17	XYZ
Cash on hand	Cash on hand/(Operating expenses-non cash expenses)/365	=+B18/((B19-B20)/365)	=+C18/((C19-C20)/365)	XYZ
Days Working capital	Working capital/Sales revenue	=+(B21-B22)/B23	=+(C21-C22)/C23	ABC

Answer 2

How your current assets figure came ??