Generic Financial Statement Ratio Analysis

					Financial Statement Ratio Analysis

An effective way to measure the efficiency of a business is through financial ratios. The
Financial Statement Ratio Analysis has financial statement templates to help calculate various
ratios. Start by entering your periodic financial data within the templates.

              Go to Income Statement

              Go to Balance Sheet

Financial Ratios

Profitability Ratios

 Gross Margin              (Gross Profit divided by Net Sales)                             -

 Profit Margin             (Net Profit divided by Net Sales)                               -

 Return on Assets          (Net Income divided by Total Assets)                            -

 Return on Investment      (Net Income divided by Average Total Assets)                    -
                           Enter the previous period's Total Assets

 Return on Equity          (Net Income divided by Average Shareholder's Equity)            -
                           Enter the previous period's Shareholder's Equity

Liquidity Ratios

 Working Capital           (Current Assets less Current Liabilities)                       -

 Current Ratio             (Current Assets divided by Current Liabilities)                 -

 Acid-test Ratio           (Quick Assets divided by Current Liabilities)                   -

Debt Ratios

 Debt Ratio                (Total Liabilities divided by Total Assets)                     -

 Long-Term Debt to Equity(Long-Term Debt divided by Total Assets)                          -
Go to Financial Ratios                                                         Go to Income Statement
                                   [COMPANY NAME]
                                 Balance Sheet Forecast

ASSETS                                            LIABILITIES

Current Assets                                    Current Liabilities
 Checking Account            $   -                 Accounts Payable                $             -
 Accounts Receivable             -                 Business Credit Cards                         -
 Prepaid Insurance               -                 Operating Line of Credit                      -
 Inventory                       -                 Sales Tax Payable                             -
                                 -                 Payroll Liabilities                           -
Fixed Assets
  Furniture and Equipment        -                Long-term Liabilities
  (Accum Dep. - Furniture)       -                 Car Loan Payable                              -
  Computer Equipment             -                 Business Loan                                 -
  (Accum Dep. - Computers)       -                 Shareholder's Loan                            -
  Vehicles                       -                                                               -
  (Accum Dep. - Vehicles)        -
  Buildings                      -                EQUITY
  (Accum Dep. - Buildings)       -                 Opening Balance Equity                        -
  Land                           -                 Capital Stock                                 -
                                 -                 Dividends Paid                                -
                                                   Owners Draw                                   -
Other Assets                                       Retained Earnings                             -
 Patents                         -                                                               -
 Other Investments               -
 Other Assets                    -

TOTAL ASSETS                 $   -                TOTAL LIABILITIES & EQUITY       $             -
           [COMPANY NAME]
         Balance Sheet Forecast

ASSETS                    LIABILITIES
           [COMPANY NAME]
         Balance Sheet Forecast

ASSETS                    LIABILITIES
Go to Financial Ratios                                              Go to Balance Sheet
                                            [COMPANY NAME]
                                        Income Statement Forecast

 Operating Income                                                   $               -
 Interest Income                                                                    -
 Direct Labor                                                                       -
 Subcontractor                                                                      -
 Sales Commissions                                                                  -
 Inventory Sold - Cost of Sales                                                     -
GROSS PROFIT (LOSS)                                                                 -
 Advertising and Promotion                                                          -
 Automobile Expense                                                                 -
 Bank Service Charges                                                               -
 Business Licenses and Permits                                                      -
 Charitable Contributions                                                           -
 Computer and Internet Expenses                                                     -
 Continuing Education                                                               -
 Depreciation Expense                                                               -
 Dues and Subscriptions                                                             -
 Insurance Expense                                                                  -
 Interest Expense                                                                   -
 Meals and Entertainment                                                            -
 Miscellaneous Expense                                                              -
 Networking/ Bus. Development                                                       -
 Office Supplies                                                                    -
 Payroll Expenses                                                                   -
 Postage and Delivery                                                               -
 Printing and Reproduction                                                          -
 Professional Services (Legal, Accounting)                                          -
 Rent Expense                                                                       -
 Telephone Expense                                                                  -
 Travel Expense                                                                     -
 Utilities                                                                          -
 Website Development                                                                -
Description: A company can use this document to calculate various financial ratios. This document provides a template balance sheet and income (profit and loss) statement whereby users should input the proper values. The spreadsheet then calculates profitability ratios (gross margin, profit margin, return on assets, return on investment, and return on equity), liquidity ratios (working capital, current ratio, and quick ratio), and debt ratios (debt ratio and long-term debt to equity ratio). Financial ratios are used to perform quantitative analysis; they show the statistical relationships between pieces of financial data. Such ratios can be used to evaluate past, current, and projected performance of a company, or they can be used to compare two different companies.
PARTNER Docstoc Premium
Docstoc Premium is a collection of documents, forms, and templates created by our professional staff to help you with a variety of business needs. These quality documents have been vetted by top professionals to help you find the documents you most need for a variety of professional purposes.