a ratios
DESCRIPTION
ARATIOSTRANSCRIPT
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.
© 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.