Software Search, Categories and Specials
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/Balance Sheet Data

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

 

Financial Ratios For Business Performance Measures Details>>

For quick calculation of financial ratios Start by entering your balance sheet data for 2 or 5 periods into Windex.

Runs in Windows & Mac OS Excel.

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.

Index of pages and spreadsheets:

Index of pages and spreadsheets

WINDEX (5) supplies ready made balance sheets and income statement templates for quick calculation of financial ratios for five annual periods.

The program applies the averaging formula to calculate:

  • Accounts receivable turnover.
  • Accounts payable turnover.
  • Inventory turnover.
The program applies the averaging formula to calculate accounts receivable turnover, accounts payable turnover and inventory turnover

Open the balance sheet template, switch to the industry sector of your choice to bring comparative benchmarks into the spreadsheet. There are 51 main stream business categories to choose.

Open the balance sheet template, switch to the industry sector of your choice to bring comparative benchmarks into the spreadsheet. There are 51 main stream business categories to choose

Lower half of the balance sheet templates. Change the row title headers in column B to suit your specific requirements if you wish.

Lower half of the balance sheet templates. Change the row title headers in column B to suit your specific requirements if you wish

Income statement templates.

Income statement templates

Cash Flows calculations.

Cash Flows calculations

Financial summary of significant ratios.

Financial summary of significant ratios

The complete set – financial ratios report.

The complete set – financial ratios report

Back To: Financial Ratios For Business Performance Measures Details>>

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