{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Profitability Ratios

Profitability Ratios - Free Excel workbooks and spreadshee...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
© Copyright, 2006, Jaxworks, All Rights Reserved. Profitability Ratios Company Name: XYZ Corporation As of date: October 1, 2006 Prepared on: December 1, 2006 Prepared by: Gross Profit Margin Sales $3,074,000 Cost of Goods Sold $2,088,000 The gross profit margin is: 32.1% Operating Profit Margin Operating profit $418,000 Sales $3,074,000 The operating profit margin is: 13.6% Net Profit Margin Net Profits After Taxes $231,000 Sales $3,074,000 The net profit margin is: 7.5% Return on Assets (ROA) Net Profits After Taxes $231,000 Total Assets $3,597,000 The return on assets is: 6.4% Return on Equity (ROE) Net Profits After Taxes $231,000 Stockholders' Equity $1,954,000 The return on equity is: 11.8% Earnings Per Share (EPS) Earnings Available to Common Stockholders' $221,000 Common Shares Outstanding 76,262 The earnings per share are: $2.90 Price/Earnings (P/E) Ratio Market Price per Share of Common Stock $32.25 Earnings Per Share $2.90 The price/earnings ratio is: 11.1
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
JaxWorks Small Business Spreadsheet Factory Since 1996, JaxWorks has offered a suite of
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Free Excel workbooks and spreadshee documents, that cover a number of financial, accounting and sales functions. These 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;- Altman Z-Score (covering publicly and privately held firms, and small businesses);- and payroll analysis. If you are involved in financial analysis at any level, or want to learn more about MS suite this site is invaluable. ry ets, and associated MS Word, PDF and HTML are invaluable small business tools. Excel and other applications in the Office...
View Full Document

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern