Posts Tagged ‘Ratio’

Specimen of Comparative and Common size P&L and B/S, and Ratio Analysis

COMPARATIVE INCOME STATEMENT

 

Particulars

Previous Year

Current Year

Increase or decrease

Amount

Percentage

Net Sales/ Sales (Gross sales – Sales Returns)

   

 

 

 

Less: Cost of Goods Sold

               Raw materials

               Direct Wages/ Labor

               Direct / Manufacturing expenses

 

 

 

 

Add: Opening stock of Finished Goods

Less: Closing stock of Finished Goods

 

 

 

 

                                                       Gross Profit

 

 

 

 

Less: Operating Expenses

          Administration Expenses

          Selling and Distribution Expenses

 

 

 

 

                                               Operating Profit

 

 

 

 

Add: Non-trading/ Non-operating  Income (dividend, interest etc)

 

 

 

 

Less: Non-trading/ Non-operating  Expenses

 

 

 

 

  Income or Earnings Before Interest and Tax

 

 

 

 

Less: Interest on Debentures/ Bonds

 

 

 

 

                Net income of Earnings Before Tax

 

 

 

 

Less: Tax

 

 

 

 

                                Income or Profit After Tax

 

 

 

 

 

 

COMMONSIZE INCOME STATEMENT

 

Particulars

Previous Year

Current Year

Amount

Percentage

Amount

Percentage

Net Sales/ Sales (Gross sales – Sales Returns)

   

 

 

 

Less: Cost of Goods Sold

               Raw materials

               Direct Wages/ Labor

               Direct / Manufacturing expenses

 

 

 

 

Add: Opening stock of Finished Goods

Less: Closing stock of Finished Goods

 

 

 

 

                                                       Gross Profit

 

 

 

 

Less: Operating Expenses

          Administration Expenses

          Selling and Distribution Expenses

 

 

 

 

                                               Operating Profit

 

 

 

 

Add: Non-trading/ Non-operating  Income (dividend, interest etc)

 

 

 

 

Less: Non-trading/ Non-operating  Expenses

 

 

 

 

  Income or Earnings Before Interest and Tax

 

 

 

 

Less: Interest on Debentures/ Bonds

 

 

 

 

                Net income of Earnings Before Tax

 

 

 

 

Less: Tax

 

 

 

 

                                Income or Profit After Tax

 

 

 

 

 

 

COMPARATIVE BALANCE SHEET

 

Particulars

Previous Year

Current Year

Increase or decrease

Amount

Percentage

ASSETS

   

 

 

 

Current Assets

          Cash / Bank

          Stock/ Inventory

          Debtors

          Bills Receivable

          Prepaid Expenses

 

 

 

 

                               Total Current Assets (A)

 

 

 

 

Fixed Assets

         Land & Buildings

         Plant & Machinery

         Furniture & Fittings

 

 

 

 

                              Total Fixed Assets (B)

 

 

 

 

Total Assets (A + B)

 

 

 

 

LIABILITIES

 

 

 

 

Current Liabilities & Provisions

         Creditors

         Bills Payable

         Outstanding Expenses

         Provisions

 

 

 

 

                             Total Current Liabilities (C)

 

 

 

 

Long – Term Liabilities

          Debentures/ Bonds/ Bank Loan

 

 

 

 

                       Total Long-Term Liabilities (D)

 

 

 

 

Capital and Reserves

          Share Capital

          Reserves and Surplus

          Retained Earnings

 

 

 

 

                           Total Shareholders Funds (E)

 

 

 

 

               Total liabilities and Capital(C+D+E)

 

 

 

 

 

Problem 1:

The following are the income statements of X Ltd., for the year ending 31.12.2008 and 2007. You are required to prepare a comparative income statement for the two years.

31.12.2007      31.12.2008

Net Sales                                                                                                         10,00,000        12,00,000

Cost of Goods Sold (CGS)                                                                              5,50,000          6,05,000

Operating expenses    

                 Administration                                                                                    80,000          1,00,000

                 Selling                                                                                                 60,000             80,000

Non-Operating Expenses       

                 Interest                                                                                                40,000            50,000

                 Income – Tax                                                                                      50,000            80,000

 

 

 

RATIO ANALYSIS

 

A ratio us a mathematical relationship between two items expressed in a quantitative form. Basically ratios can be classified as

Profitability ratio
Turnover ratio
Solvency ratio

 

PROFITABILITY RATIO

FORMULA

EXPLANATION

1. Return on Investment (or) Overall Profitability ratio

 

                           Operating Profit

            R.O.I = ————————- x 100

                           Capital Employed

 

 

Operating Profit = Profit before interest and tax

Capital Employed = Total Assets (or) Total Fixed Assets (or) Net Working Capital  (or) Share Capital + Reserves and Surplus + Long term Loans) – (Non business assets – Fictitious Assets)

a. Return on Shareholders

“My ERP prospect connection ratio is really good! I am able to reach someone more than 90% of the time I try calling the numbers in my ERP Database”Wait chap, aren’t we missing some key point here? On how many calls are you reaching a top official or a decision maker or a sales influencer? Many a times, calls end after coming to know that the person you reached is not the right to one to speak with.

A report from a well-known research center says that more than 30% of the sales persons’ time might be spent only on searching for the right ERP sales influencer or an ERP decision maker!

What are you doing to help your sales guy meet the right person on his sales calls? Whats your role in reducing the sales cycle time? How soon are you able to close your deals?Its high time one learns that, simply reaching a person on a list isn’t actual prospect connection if he is not the right one to pitch your message. This just wastes valuable time, energy and resources, in other words kills turnaround or productivity of the sales team. The lesson learned is to NEVER COMPROMISE with your data quality. Do all that is possible to ensure you have the best quality data in hand before you start calling or sending targeted email campaigns. Know all that you MUST know about the person you are going to approach. Believe me, having the basic groundwork done speeds up the sales process by at least 65%. A sales person armed with accurate ERP job descriptions and responsibilities can make wonders. Quality data results in easy conversions, faster deals and high turnaround. Are you looking for the quality ERP Users database?

We, at ERP Lists, give utmost importance to the quality of the database we have. Hence we take meticulous measures to meet and exceed the data standards in the industry. Our ERP database is well maintained and updated regularly.

Our website can help you build, manage, maintain and use your ERP database in the best possible manner. Our experts will help you learn and implement different tips and recent trends of using ERP database in a smart and systematic way.