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 TRAINING / 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 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 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