 |
|
|
|
|
|
|
|
|
Excel Financial Ratios templates supply five year balance sheets, income statements and cash flow spreadsheets. Windex calculates fifty key financial ratios, including ROA, ROIC, EVA, EPS, acid test, quick ratio, interest coverage, debt ratios, working capital and cash flow ratios, inventory days, asset turnover and much more. All ratio equations are listed. Runs in Windows & Mac OS Excel.
Monthly Financial Ratio Templates - for Excel
Compare two consecutive monthly periods with Windex. Calculates all the major financial
ratios for comparison between periods.
Ratios supplied include profit ratios, return on assets, return on equity, economic
value added, return on invested capital, working capital ratios, cash flow ratios,
operating ratios, asset ratios, inventory ratios, payables and receivable ratios,
acid test, quick ratio, debt ratios, solvency ratios, DuPont Ratios, Core Ratios.
CURRENCY > You can set the currency to any symbol by opening the Format menu in
Excel and selecting Cells from the drop down list, which produces the Format Cells
table. Click Currency and then choose the currency you want to work with from the
Symbol panel.
Excel Financial Ratios
Two valuable ready to use Excel applications help you quickly compare financial ratios for both two and five successive periods - includes spreadsheet to enter balance sheets and income statement data for quick production of all the ratios listed below.
* Gross Profit/Share
* Net income/Share
* Revenue/Share
* Dividends/Share
* Gross Profit Ratio
* Operating Income
* Operating Income Ratio
* Pre-Tax Profit
* Pre-Tax Profit Ratio
* Net Income After Tax
* Net Income to Sales
* Economic Value Added
* Economic Value Added per Share
* Cost of Capital
* Rate of Return on Assets (ROA)
* Rate of Return on Common Equity (ROE)
* Return on Capital (ROIC)
* Common Earnings Leverage
* Cash Flow from Operations to Net Income Ratio
* 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
* Working Capital/Net Sales Ratio
* Working Capital/Net Income Ratio
* 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
* 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
Excel Financial Ratios
$99.99
Secure Payment Options
Buy as part of
All Excel
Templates Gold Edition - HUGE Value
- 80% Discount!
Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $69.00. ALL purchases totaling over $138.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft