a ratios

2
Also included Free are: - Business plan tools, including spreadsheets and excellent instructions - Excel functions glossary and guide; - Free training courses for most Microsoft Office applications. These guides are in PDF format and rival commercial books. - Comprehensive list of acronyms, ratios and formulas in customer financial analysis, and financial terms; - Suite of online calculators, including, breakeven analysis, productivity analysis, business evaluation; - and payroll analysis. JaxWorks Small Business Spreadsheet FactorySince 1996, JaxWorks has offered a suite of Free Excel workbooks and spreadsheets, and associated MS Word, PDF and HTML documents, that cover a number of financial, accounting and sales functions. These are invaluable small business tools. - Altman Z-Score (covering publicly and privately held firms, and small businesses); If you are involved in financial analysis at any level, or want to learn more about MS Excel and other applications in the Office suite this site is invaluable. © Copyright, 2014, Jaxworks, All Rights Reserved.

Upload: narasi64

Post on 03-Feb-2016

216 views

Category:

Documents


0 download

DESCRIPTION

ARATIOS

TRANSCRIPT

Page 1: A Ratios

Also included Free are: - Business plan tools, including spreadsheets and excellent instructions - Excel functions glossary and guide; - Free training courses for most Microsoft Office applications. These guides are in PDF format and rival commercial books. - Comprehensive list of acronyms, ratios and formulas in customer financial analysis, and financial terms; - Suite of online calculators, including, breakeven analysis, productivity analysis, business evaluation;

- and payroll analysis.

JaxWorks Small Business Spreadsheet Factory™

Since 1996, JaxWorks has offered a suite of Free Excel workbooks and spreadsheets, and associated MS Word, PDF and HTML documents, that cover a number of financial, accounting and sales functions. These are invaluable small business tools.

- Altman Z-Score (covering publicly and privately held firms, and small businesses);

If you are involved in financial analysis at any level, or want to learn more about MS Excel and other applications in the Office suite this site is invaluable.

© Copyright, 2014, Jaxworks, All Rights Reserved.

Page 2: A Ratios

© Copyright, 2010, JaxWorks, All Rights Reserved.

Activity RatiosXYZ Corporation

For Period Ending 12/31/2009

INVENTORY TURNOVERCost of Goods Sold $2,088,000

Inventory $289,000

The inventory turnover is: 7.22

AVERAGE COLLECTION PERIODAccounts Receivable $400,000

Annual Sales $3,074,000

The average collection period is: 46.84

FIXED ASSET TURNOVERSales $3,074,000

Net Fixed Assets $2,374,000

The fixed asset turnover is: 1.29

TOTAL ASSET TURNOVERSales $3,074,000

Total Assets $3,597,000

The total asset turnover is: 0.85

Prepared by: Prepared on: 02/01/10

© Copyright, 2014, Jaxworks, All Rights Reserved.

B6
Use this template to calculate a firm's activity ratios; such as inventory turnover, average collection period, and fixed asset turnover. Activity ratios help to measure a company's efficiency managing certain assets such as: inventory, accounts receivable, and also long-term and total assets.