BUSINESS SOLVENCY RATIOS FOR EXCEL 2003-2007.

Is the clock ticking for any of your major customers or suppliers? You can run quick and easy checks on the solvency of companies you rely on to deliver services to you and to buy from you using this Excel Solvency workbook.

Excel Solvency Testing

Our Business Solvency workbook employs all the multivariate analysis equations published by Edward Altman. Altman is the Max L. Heine Professor of Finance at the Stern School of Business, New York University.

Prof. Altman has an international reputation as an expert on corporate bankruptcy, high yield bonds, distressed debt and credit risk analysis. He was named Laureate 1984 by the Hautes Etudes Commerciales Foundation in Paris for his accumulated works on corporate distress prediction models and procedures for firm financial rehabilitation and awarded the Graham & Dodd Scroll for 1985 by the Financial Analysts Federation for his work on Default Rates on High Yield Corporate Debt and was named "Profesor Honorario" by the University of Buenos Aires in 1996. He is currently an advisor to the Centrale dei Bilanci in Italy and to several foreign central banks. Prof. Altman is also the Chairman of the Academic Council of the Turnaround Management Association. Prof. Altman was named to the Max L. Heine endowed professorship at Stern in 1988. He was inducted into the Fixed Income Analysts Society Hall of Fame in 2001 and elected President of the Financial Management Association (2002). Professor Altman was named one of the 100 most influential people in the world in 2005 by the publication Treasury and Risk Management. He received his MBA and Ph.D. in Finance from the University of California, Los Angeles.

In the workbook supplied you can simply enter two comparative sets of financial data for any company (including your own). The Altman Z scores are readily computed using the multivariate formulas provided by Professor Altman.

Bonus Addition.

 

Financial Ratios with Excel.

Windex 2008 calculates all major financial ratios  in Excel from balance sheet, income statement and cash flow templates provided:

 

Rate of Return on Assets (ROA)

Rate of Return on Common Equity (ROE)

Return on Capital (ROIC)

Common Earnings Leverage

Cash Flow from Operations/Total Cash Flow Ratio

Cash Flow  from Investments/Total Cash Flow Ratio

Cash Flow from Financing/Total Cash Flow Ratio

Operating Cash Flow/Current Liabilities Ratio

Operating Cash Flow/Total Liabilities

Operating Cash Flow/Capital Expenditures

Working Capital/Current Liabilities Ratio

Working Capital/Long Term Liabilities Ratio

Working Capital/Total Debt Ratio

Working Capital/Current Assets Ratio

Working Capital/Total Assets Ratio

Income Tax Expense/Revenues Ratio

Total Assets Turnover Ratio

Fixed Assets Turnover

Current Ratio

Acid Test (See note for Quick Ratio)

Accounts Payables Turnover

Days Accounts Payables outstanding

Accounts Receivable Turnover Ratio

Days Receivables Outstanding Ratio

Inventory Turnover

Days Inventory Outstanding

Total Debt to Equity Ratio

Total Debt Coverage ratio

Long Term Debt Ratio

Long Term Debt to Total Assets

Long Term Debt to Shareholder Equity

Total Liabilities/Total Assets

Interest Coverage Ratio

 

Zip file download or select CD edition shipping.

 

   
.