Froehle & Co.
Certified Public Accountants For:
Businesses
Individuals
Educational Institutions
 
Froehle & Co.
"Financial Stability" Determination Worksheet
Using the formulas developed by the U. S. Department of Education

For use by "Not-for-Profit" Institutions Only!

To complete this worksheet, please determine the following values from your most recent audited financial statements. Such statements should cover a full year's (i.e. 12 months) operations. Please contact your accountant/CPA for assistance if needed.
1. Unrestricted net assets. Unrestricted net assets is the result of subtracting from total assets, the total liabilities. ___________ (1)
2. Temporarily restricted net assets. This amount is the total net assets that are restricted for use, as opposed to the preceding Unrestricted net assets. Both values come straight from the balance sheet. ___________ (2)
3. Annuities, term endowments, life insurance funds. Any amounts that have been restricted by the board of directors for such use. ___________ (3)
4. Intangible assets. This amount is the total of such assets as goodwill, non-compete agreements, licenses and franchise, net of amortization. __________ (4)
5. Net Property, Plant and Equipment. The total of all "fixed" assets, such as furniture, fixtures, equipment, vehicles, buildings, land, library, etc., less all allowances for depreciation and amortization of those same assets. Capitalized lease obligations, net of related depreciation, are to be included. __________ (5)
6. Total Assets. This amount is the total amount of assets shown on the final line of the assets portion of the balance sheet. __________ (6)
7. Post Employment and Retirement Liabilities. Amounts owed to, or on behalf of, former employees for items such as retirement benefits, accumulated sick pay, bonus arrangements are examples of such liabilities. Such liabilities that have been identified and determined are generally required to be recorded in the accounting records, but are frequently missed. If determined and known, such amounts are to be recorded here. __________ (7)
8. Total Long-Term Debt. "Long-term" debt means an obligation that will not be totally repaid within one year, or the operating cycle of the business, whichever is longer. Total long-term debt includes debt such as notes payable, bonds payable, capitalized leases, mortgages and notes owed to stockholders (depending upon the nature of the obligation), etc. The total long-term debt is determined before the deduction of current maturities, i.e. that part that will be repaid within one year, or the operating cycle of the business. __________ (8)
9. Total Expenses. Total expenses is all expenses from the statement of activities, but only for expenses included in "Other Income and Expenses". However, income tax expense, expense of discontinued operations, extraordinary losses, or changes in accounting principles are not included. __________ (9)
10. Unsecured related-party receivables. Any amounts owed to the school by directors, related other business entities, direct family members thereof, which are not secured, are to be included. __________ (10)
11. Permanently restricted assets. Assets that are unavailable for disposal or alteration without board approval or usually very restrictive actions or unusual circumstances __________ (11)
12. Change in Unrestricted Net Assets. This amount is taken directly from the audited financial statements and is the change in the amount of net assets - unrestricted - for the fiscal year. __________ (12)
13. Total Unrestricted Revenue. This amount is taken directly from the financial statements. This amount includes net assets released from restriction during the fiscal year. __________ (13)
Once you have determined that above amounts, continue to calculate the following ratios:
Primary Reserve STEP 1: Write the value of (1) - Unrestricted net assets - here:__________ (A)
STEP 2: Write the value of (2) - Temporarily restricted net assets - here:__________ (B)
STEP 3: Write the value of (3) - Annuities, life insurance income funds, etc. - here:__________ (C)
STEP 4: Write the value of (4) - Intangible assets - here:__________ (D)
STEP 5: Write the value of (5) - Net property, plant and equipment - here:__________ (E)
STEP 6: Write the value of (7) - Post employment and retirement liabilities - here: __________ (F)
STEP 7: Write the value of (8) - Total Long-Term Debt - here: _____________ (G1)
Write the value of (5) again here: _____________ (G2)
Compare (G1) and (G2) and write the small amount here:
__________ (G)
STEP 8: To (A): add (B), subtract (C), (D) and (E) and add (F) and add (G). Enter the result: __________ (H)
STEP 9: Write the value of (9) - Total Expenses - here: __________ (I)
STEP 10: Divide the value of (H) by (I) and enter the result here: __________ (I)
Equity
STEP 11: Write the value of (1) - Unrestricted net assets - here: __________ (A)
STEP 12: Write the value of (2) - Temporarily restricted net assets - here: __________ (B)
STEP 13: Write the value of (11) - Permanently restricted assets - here: __________ (C)
STEP 14: Write the value of (4) - Intangible assets - here:__________ (D)
STEP 15: Write the value of (10) - Unsecured related-party receivables - here: __________ (E)
STEP 16: To (A) add (B) and (C), then subtract (D) and (E). Enter the result here:__________ (F)
STEP 17: Write the value of (6) - Total Assets - here:__________ (G)
STEP 18: From (G) subtract (D) and (E). Enter the result here: __________ (H)
STEP 19: Divide the value of (F) by the value of (H). Enter the result here: __________ (II)
Net Income
STEP 20: Write the value of (12) - Change in Unrestricted Net Assets - here: __________ (A)
STEP 21: Write the value of (13) - Total Unrestricted Revenue - here: __________ (B)
STEP 22: Divide the value of (A) by the value of (B). Enter the result here:__________ (III)
After calculating the above ratios, those ratios must then be converted to a "Strength-Factor Score". Therefore, proceed as follows. HOWEVER, NO VALUE DETERMINED IN THIS STEP CAN RESULT IN A VALUE GREATER THAN 3.0 OR LESS THAN -1.0!
STEP 23: Record the Primary Reserve ratio - (I) above - here: __________
Multiply the Primary Reserve ratio by 10 and record the result here:
__________ (IV)
STEP 24: Record the Equity ratio - (II) above - here: __________
Multiply the Equity ratio by 6 and record the result here:
__________ (V)
STEP 25: Record the Net Income ratio - (III) above - here: __________
Multiply the Net Income ratio by 50 and add 1 to the result if the Net Income ratio if a positive number. If the Net Income ratio is a negative number, multiply by 25 and add 1. If the Net Income ratio is 0, then just write the number "1". Record the result here:
__________ (VI)
After calculating the "Strength-Factor" scores above, the next step is to calculate the "Weighted" score as follows:
STEP 26: Multiply the Primary Reserve strength-factor score - (IV) - by 40% (.3)__________
STEP 27: Multiply the Equity strength-factor score - (V) - by 40% (.4)__________
STEP 28: Multiply the Net Income strength-factor score - (VI) - by 20% (.3)__________
Final Step: Add the values determined in STEPS 26, 27 and 28 together. The result is your final Composite score: =========
Institutions with Composite scores less than 1.0 will be required to submit financial guarantees. Institutions with Composite scores between 1.0 and 1.4 will be considered "in the zone" and will be subject to additional monitoring. Institutions with Composite scores 1.5 or greater will be considered fully financial responsible.

Services

Careers

Search

Contact


 
©2000 Froehle & Co., Inc., P.C.
Please read our legal disclaimer and
privacy policy.