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.
Business Solvency:
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.
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.
Calculates these financial ratios 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
FILE CONVERSION. Convert Excel, Word files to pdf documents without any requirement for Acrobat using our web software add https:// web inks for safe secure document transmissions. Convert PowerPoint 2003-2007 to Flash presentations.
Zip file download or select CD edition shipping.
excel templates - financial analysis - business analysis - amortization.
Contentwise responsible person: Xdata Ltd
, tonybigs(at)me(dot)com