
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 cap 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
PreTax Profit
PreTax 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
$169.95 $69.95
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 Addins 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 special@ozgrid.com 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