Financial_Ratios_Template_PC_Sample

Document Sample
Financial_Ratios_Template_PC_Sample Powered By Docstoc
					      DO NOT CHANGE ANYTHING ON THIS SHEET
                                       Dell            HP            Lenovo            Apple
Profitability

            Revenue Growth                     2.08%         5.41%             9.10%           27.87%
            Gross Margin                      16.78%        24.25%            13.96%           28.98%
            EBITDA Margin                      5.57%         7.16%             1.33%           12.70%
            Net Income Margin                  4.58%         6.76%             1.10%           10.30%

Liquidity Ratios

            Quick Ratio                         1.11          1.35              0.87             2.24
            Debt Ratio                          1.22          1.87              1.26             2.38

Management

            Return on Assets (ROA)              0.11          0.08              0.03             0.12

Power

            Accounts Payable Days              75.59         63.62             57.49            90.21
            Accounts Receivable Days           26.14         53.01             16.05            23.66

Inventory

            Inventory Turnover Days             4.42         40.74             10.40             7.18

Equity

            Enterprise Value/Revenue            1.02          1.26              0.39             6.35
            Enterprise Value/EBITDA            18.37         17.64             29.01            49.96
            Price/Earnings                     24.84         20.91             39.05            64.83
            Price/Earnings to Growth           11.95          3.86              4.29             2.33
            Earnings per Share                  1.12          2.40              0.36             2.29
                   ENTER VALUES IN THE CELLS WITH BLUE TEXT
                                  DO NOT CHANGE OTHER CELLS
                                            Dell               HP                Lenovo
Income Statement

          Last Reported Revenue                    57,095.00         91,658.00        14,590.20
          Revenue Reported 1 Year Earlier          55,908.00         86,696.00        13,262.29
          Cost of goods sold                       47,514.00         69,427.00        12,553.56

          Gross Profit                              9,581.00         22,231.00            2,036.64

          Expenses                                  6,402.00         16,033.00            1,875.50

          Other Revenue                                 0.00              0.00             0.00
          Total Operating Expense                  53,916.00         85,098.00        14,395.54
          EBITDA                                    3,179.00          6,560.00           194.66
          Net Income                                2,614.00          6,198.00           161.14

Balance Sheet

          Total Assets                             23,109.00         81,981.00            5,449.12
          Cash and Cash Equivalents                 7,042.00         16,400.00            1,063.72
          Total Current Assets                     17,706.00         48,264.00            3,060.73
          Accounts Receivable                       4,089.00         13,313.00              641.59
          Total Inventory                             576.00          7,750.00              357.66

          Total Liabilities                        18,980.00         43,837.00            4,315.58
          Long term Debt                              504.00          2,490.00              417.50
          Minority Interest                             0.00              0.00                0.74
          Preferred Stock                               0.00              0.00                0.00
          Total Current Liabilities                15,927.00         35,850.00            3,525.78
          Accounts Payable                          9,840.00         12,102.00            1,977.21

Stock Market

          Number of Shares (in millions)               2,330             2,580                445
          Market Price                                 27.87             50.24               14.15
          Market Capitalization                    64,937.10        129,619.20            6,291.94
          Enterprise Value                         58,399.10        115,709.20            5,646.46
TEXT


       Apple


               19,315.00
               13,931.00
               13,717.00

                5,598.00

                3,609.00

                    0.00
               16,862.00
                2,453.00
                1,989.00




               17,205.00
                6,392.00
               14,509.00
                1,252.00
                  270.00

                7,221.00
                    0.00
                    0.00
                    0.00
                6,471.00
                3,390.00




                 870
               148.28
           128,950.22
           122,558.22

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:7
posted:9/17/2012
language:Unknown
pages:3