Financial Ratios with Excel

Excel balance sheets help you quickly calculate financial ratios for two and five periods. Rate of Return on Assets (ROA) Rate of Return on Common Equity (ROE) Return on Capital (ROIC) Common Earnings Leverage. Operating Cash Flow/Current Liabilities Ratio Operating Cash Flow/Total Liabilities Cost of Goods Sold/Revenues Ratio Depreciation Expense/Revenues Ratio Selling & Admin Expenses/Revenues 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 Altman's Z (Solvency) Ratio The CD edition provides the following extra document files: Share Offering Memorandum pro-forma wording and layout to make it quick and easy for you to raise $1,000,000 new equity or loan capital. Save $10,000 - $25,000 on legal fees. Just add the figures and your business plan into the document provided following the guidance notes. Share subscription agreements are supplied. Help provided for non US companies how to structure an offering to secure finance. Popular with start ups, franchises, entrepreneurs and small businesses. List of capital sources supplied. Zip file download or select CD edition shipping.