Docstoc

cfi worksheet

Document Sample
cfi worksheet Powered By Docstoc
					              COMPOSITE FINANCIAL INDEX (CFI) WORKSHEET
Institution Name                                                                   Date
                                                       COMPUTATION TABLES
#                       RATIOS
                                                              Year One
1 PRIMARY RESERVE
  add unrestricted net assets
  add temprarily restricted net assets
  subtract property, plant, equipment (net of depreciation)
  add long-term debt
  numerator = total expendable net assets                       0         A
  denominator = total expenses                                            B
                                             RATIO =        #DIV/0!      A/B
2 NET INCOME USING AN OPERATING INDICATOR
  add unrestricted operating revenue
  subtract unrestricted operating expenses
  numerator = net operating income                              0
  add total unrestricted revenues and gains
  add net assets released from restriction
  denominator = total unrestricted operating income             0         B
                                             RATIO =        #DIV/0!      A/B
3 RETURN ON NET ASSETS
  numerator = change in net assets                                        A
  denominator = total net assets (beginning of year)                      B
                                             RATIO =        #DIV/0!      A/B
4 VIABILITY
  add unrestricted net assets
  add temporarily restricted net assets
  subtract property, plant, and equipment (net of depreciation)
  add long-term debt
  numerator = expendable net assets                             0         A
  denominator = long-term debt                                            B
                                             RATIO =        #DIV/0!      A/B

                   CFI SCORING SHEET - INSTITUTIONS WITH LONG-TERM DEBT
 STRENGTHS AND                                             STRENGTH:            WEIGHT:              CFI
                            RATIO VALUE
      WEIGHTS                                             DIVIDE RATIO          MULTIPLY            SCORE
        Primary Reserve        #DIV/0!                        / 0.133             x 0.35            #DIV/0!
  Net Income Operations        #DIV/0!                        / 0.007            x 0.10             #DIV/0!
    Return on Net Assets       #DIV/0!                         / 0.02             x 0.20            #DIV/0!
               Viability       #DIV/0!                        / 0.417             x 0.36            #DIV/0!
CFI SCORE - sum last column                                                                         #DIV/0!
Salluzzo, Ronald E.; Philip Tahey, and Frederic J. Prager;Ratio Analysis in Higher Education. 4th
                    edition; KPMG LLP and Prager,McCarthy & Sealy; 1999




                                                                                       9:13 AM 11/26/2011

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:7
posted:11/26/2011
language:English
pages:1