Docstoc

ratios

Document Sample
ratios Powered By Docstoc
					Calculate Ratios

Use this worksheet to calculate your financial ratios from month to month. You will use the results in
the Ratio Analysis Worksheet to help you track financial trends in your business
To use, just insert the requested values and the Ratios will be automatically calculated for you.
Note: Calculations may not work properly if both numbers are negative. Numbers that appear in red are negative.
                                                                                                                    Ratio
                                                        Insert cash & near cash       Insert current liabilities
Acid Test                      cash & near cash         below                         below
                                current liabilities
                                                                                                                    #DIV/0!

                                                                                    Insert current liabilities
Current Ratio                    current assets         Insert current assets below below
                                current liabilities
                                                                                                                    #DIV/0!


Receivables Turnover                  sales             Insert sales below            Insert receivables below
                                   receivables
                                                                                                                    #DIV/0!

                                                                                      Insert receivables turn
Days Receivables                       30                                             below
                                receivables turn
                                                                     30                                             #DIV/0!

                                                        Insert cost of goods sold     Insert average inventory
Inventory Turnover             cost of goods sold       below                         below
                               average inventory
                                                                                                                    #DIV/0!


Days Inventory                        30                                              Insert inventory turn below
                                 inventory turn
                                                                     30                                             #DIV/0!


Gross Margin Rate                 gross margin          Insert gross margin below     Insert sales below
                                      sales
                                                                                                                    #DIV/0!


Net Profit Rate                     net profit          Insert net profit below       Insert sales below
                                     sales
                                                                                                                    #DIV/0!


ROI                                 net profit          Insert net profit below       Insert net worth below
                                    net worth
(Return on Investment)                                                                                              #DIV/0!
Note: Net Worth could also show up on your financial statements as Owners' Equity or Shareholders' Equity


ROA                                  net profit         Insert net profit below       Insert total assets
                                   total assets
(Return on Assets)                                                                                                  #DIV/0!
Note: First use the Calculate Ratios worksheet (see tab below) to calculate your ratios. Then use this worksheet to track the change in your figures from
month to month. Negative numbers will appear in red .


Ratio Analysis Worksheet

                                                                 (A)                     (B)                 (B-A)
                               Definition                    Last Month              This Month             Change                 Comments

Acid Test                         cash & near cash
                                   current liabilities                                                      0.0000
Current Ratio                      current assets
                                  current liabilities                                                       0.0000
Receivables Turnover                    sales
                                     receivables                                                            0.0000

Days Receivables                          30
                                   receivables turn
                                                                                                            0.0000
Inventory Turnover               cost of goods sold
                                 average inventory                                                          0.0000
Days Inventory                           30
                                    inventory turn                                                          0.0000
Gross Margin Rate                   gross margin
                                        sales                                                               0.0000
Net Profit Rate                        net profit
                                        sales                                                               0.0000
ROI                                   net profit
(Return on Investment)                net worth                                                             0.0000
Note: Net Worth could also show up on your financial statements at Owners' Equity or Shareholders' Equity

ROA                                    net profit
(Return on Assets)                   total assets                                                           0.0000

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:9
posted:8/13/2012
language:English
pages:2