For use in Excel, copy this table to Excel, column A, then hide columns B and C because they aren't formated correctly.
Then adjust the column widths and make all the row heights about 25. Next, fill in the numerator and denominator
amounts manually into column D, or get them using the "sumif" function from the trial balance you created in Excel
(by using the Excel trial balance tool instructions for account groupings). After that, compute the ratios in column E
by using a simple Excel math formula for dividing the numerator amounts by the denominator amounts.
NOTFORPROFIT ORGANIZATION SAMPLE RATIOS 

Defensive interval ratio 



Liquidity Ratio 



Contributions and Grants Ratio 



Voluntary Contributions Ratio 



Grants Ratio 



Future Leaning Ratios: 

Liquid Funds Indicator 



Operating Strength 



Net Temporarily Restricted Asset Ratio 



Endowment Ratio 



Debt Ratio 



Coverage Derivation of Debt Ratio 



Accounts Receivable Ratios: 

Days Revenue in Net Accounts Receivable 



Percentage of gross receivables reserved 



Backward Leaning Ratios: 

Accounts Payable Aging Indicator 



Savings Indicator 



Fundraising, Admin, or Program Ratio: 





