Calculation of Financial Ratios/Balance Sheet Data

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:

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.

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.

Income statement templates.

Cash Flows calculations.

Financial summary of significant ratios.

The complete set – financial ratios report.

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

Monthly Financial Ratios Windex $99.95 Regular price is $125.00, reduced temporarily to $99.95 Payment Problems/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 $70.00. ALL purchases totaling over $150.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