Retail Financial Statement Ratio Analysis

VIEWS: 486 PAGES: 69

More Info
									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
                                         [Date]

ASSETS                                            LIABILITIES

Current Assets                                    Current Liabilities
 Cash in Drawer              $   -                 Accounts Payable                $             -
 Checking Account                -                 Business Credit Cards                         -
 Lay Away Receivable             -                 Customer Lay Away Deposits                    -
 Employee Advances               -                 Sales Tax Payable                             -
 Prepaid Insurance               -                 Payroll Liabilities                           -
 Merchandise                     -                                                               -
                                 -
                                                  Long-term Liabilities
Fixed Assets                                       Car Loan Payable                              -
  Furniture and Equipment        -                 Mortgage/ Lease                               -
  (Accum Dep. - Furniture)       -                 Shareholder's Loan                            -
  Computer Equipment             -                                                               -
  (Accum Dep. - Computers)       -
  Vehicles                       -                EQUITY
  (Accum Dep. - Vehicles)        -                 Opening Balance Equity                        -
  Buildings                      -                 Capital Stock                                 -
  (Accum Dep. - Buildings)       -                 Dividends Paid                                -
  Land                           -                 Owners Draw                                   -
                                 -                 Retained Earnings                             -
                                                                                                 -
Other Assets
 Security Deposits               -
                                 -

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

ASSETS                    LIABILITIES
           [COMPANY NAME]
         Balance Sheet Forecast
                 [Date]

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


REVENUES
 Merchandise Sales                                              $               -
 Retail Service Sales                                                           -
 Product Warranty Sales                                                         -
 Proceeds from Sale of Assets                                                   -
 Finance Charge/ Interest Income                                                -
                                                                                -
COST OF SALES
 Direct Labor                                                                   -
 Sales Commissions                                                              -
 Merchandise Sold                                                               -
 Merchant Account Fees                                                          -
 Warehousing and Storage Costs                                                  -
 Purchases - Resale Items                                                       -
 Product Samples Expense                                                        -
                                                                                -
GROSS PROFIT (LOSS)                                                             -
GENERAL & ADMINISTRATIVE EXPENSES
 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                                                         -
 Foreign Exchange Gain/ Loss                                                    -
 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)   -
 Property Tax                                -
 Rent Expense                                -
 Repairs and Maintenance                     -
 Telephone Expense                           -
 Travel Expense                              -
 Utilities                                   -
 Website Development                         -
                                             -

NET INCOME (LOSS)                            -
								
To top