Software Search, Categories and Specials Similar Products
Operations Management Templates | Invoice Template | Investment and Business Valuation Templates
Profit & Loss Spreadsheet | Multiple Regression Analysis & Forecasting Template | Portfolio Optimization Template
Portfolio Tracking & Monitoring Templates | Project Planning & Management Template | Real Option Valuation Template
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download

 

AnalyserXL - Download

 

DownloaderXL - Download

 

Smart VBA - Download

 

TraderXL - Download

Calculation of Financial Ratios

EXCEL VIDEO TUTORIALS / EXCEL DASHBOARD REPORTS

 

Monthly Financial Ratios and Five Year Balance Sheets

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
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 $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 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 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