Unofficial blog for XLRI – PGCBM 14 Batch

Colloborate… Conquer…

Archive for the ‘Management Accounting’ Category

Ratio Analysis – MAC – 29-June-2008

Posted by shyamrajagopalan on July 6, 2008

Ratio Analysis : – Ratio of selected values based on the company’s financial statement. There are many standard ratios used to evaluate the overall financial condition of a corporation or other organization.

Who Uses the Ratios : – Corporate Finance Managers, Current/Potential Shareholders, Creditors

Common Size Analysis – Ratio comparisons are done on Past performances, Competing Firms, Absolute Standards, Industry Trends, Budgets – Planning/Control

Profitability For shareholders, employees, creditors, investors, management.
Liquidity For shareholders, management, suppliers, creditor and competitors.
Efficiency For management, shareholders, creditors and competitors.
Gearing For shareholders, lenders, creditor and potential investors.
Investment For shareholders, potential investors, management.

Ideally companies should be Liquid and Profitable, and hence we pay more attention to the Liquidity Ratios and the Profitability Ratios.

Key Liquidity Ratios

    Current Assets
  Current Ratio = ————————
    Current Liabilities
      
 
    Quick Assets
  Quick Ratio = ———————-
    Current Liabilities
     
Quick Assets = Current Assets – Inventories

Quick Ratio is significant in Industries where Inventory is more or less the finished product. e.g. Pen Industry.

Case Study on HUL, MARICO and Doctors Soap, and discussion about Monopoly (Market)  and Monopsony(Creditors). HUL though having lesser ratio has higher Monopoly and Monopsony, indicating there are no benchmarks for these numbers and are dependent on the Industry/Competetive positions.

Long Term Solvency Ratios

    Total Liabilities
  Debt to Equity Ratio = ———————————-
    Total Stockholders’ Equity
     
     
 
    Long Term Liability
  LT Debt Equity Ratio = ——————————————————-
    Networth/ Total Stockholder’s Equity 

Times Interest Earned Ratio (TIE Ratio)

    PBIT (Before Interest and Tax)
  TIE ———————————-
    Interest Expense

TIE Ratio of > 1 is necessary to pay bare interest necessities

A ratio of > 10 is considered a very safe position.

Inventory Turnover Ratio : – A ratio showing how many times a company’s inventory is sold and replaced over a period.

    Cost Of Goods Sold
  Inventory Turnover Ratio —————————-
    Average Inventory

A low turnover rate may point to overstocking, obsolescence, or deficiencies in the product line or marketing effort. A high turnover rate may indicate inadequate inventory levels, which may lead to a loss in business.

Effeciency Ratios : – Inventory Collection Period, Average Collection Period, Average Payment period

Inventory Collection Period : – (Inventory * 365)/Cost of Goods Sold

Average Collection Period :-  (Acc. recievable * 365)/ Credit Sales (The collection period or average collection period must be compared to competitors to see whether the credit given, and customer risk, is in line with the industry. A high collection period shows a high cost in extending credit to customers). Lower ACP means more Monopoly.

Average Payment Period :- (Acc. Payable * 365) / Purchases. Lesser APP means lower Monopsony.

e.g. ICP = 70 Days, ACP = 85 Days, APP = 45 Days. Deduction Cycle = 155 days on which the company has to self finance for 110 days.

Profitability Analysis Ratios   
 
    PAT + Interest + Taxes
  Return on Assets (ROA) = ———————————-
    Average Total Assets
     
Average Total Assets = (Beginning Total Assets + Ending Total Assets) / 2
   
 
    PAT
  Return on Equity (ROE) = ————————
    Stockholders’ Equity
     
 
   
 
    PAT + Interest
  Return on Common Equity (ROCE) = ——————————————–
    Stockholders’ Equity
     
 
   
 
    Net Income
  Profit Margin = —————–
    Sales
     
     
    Net Income
  Earnings Per Share (EPS) = ———————————————
    Number of Common Shares Outstanding
   

Return on Equity (ROE)

    PAT                 Sales                          Total Assets
  Return on Equity (ROE) = ——–  *      ———————-  *     ————————
    Sales           Total Assets                      Networth
     

In essence ROE = Margin * Asset Turnover Ratio * Leverage

Things to remember about Asset Turnover Ratio

  • Companies with low profit margins tend to have high asset turnover, those with high profit margins have low asset turnover – it indicates pricing strategy.
  • This ratio is more useful for growth companies to check if in fact they are growing revenue in proportion to sales.

Market Ratios

    Market Price of Common Share            Mkt Cap
  PE Ratio = ————————————– =                  ———————–
    Earnings Per Share                              Profit After Tax
   
    Annual Dividends Per Common Share
  Dividend Yield = ————————————–
    Market Price Per Share
   

Posted in Financial Analysis, MAC, Management Accounting, Ratios | 2 Comments »

Updates from Rohit – Sessions Rescheduled and Exam Dates

Posted by shyamrajagopalan on June 12, 2008

Due to the technical failure last Sunday, an additional session has been scheduled on the 21st of June from 5:00 PM to 6:30 PM. Normal classes will continue post 6:30 PM.

Please find the dates and pattern of End term examination for the course of MANAC & Principles of Marketing.

Mode of examination – Hardcopy

Date 20-Jul-08, Sunday

Posted in Exam, Management Accounting, POM | Tagged: , | Leave a Comment »

MAC Assignment 2 – Case 1

Posted by shyamrajagopalan on June 8, 2008

I literally plucked all the remaining hair (as if much was left) doing this. To the best of my understanding, I arrived at the numbers for Mar 20X6. My profit numbers still wound not tally with the balance sheet (off by 60). Adding insult to injury was the next accounting period. I am sure I got it all messed up with the second one. A crushing blow to my confidence on this subject…. I am sharing the work (err… the mess) I have done as a part of this. More than doing it as a part of the assignment, I would appreciate if the experts help me put together the answer to this puzzle… Lingering Questions (on the second period, how do we account for depreciation, interest amount, Loan value of the Overdraft – 70% of current asset – which value do we take, depreciated value?).

Accountants.. anyone?… Phew…..

http://spreadsheets.google.com/ccc?key=pFjLyBrmhza_jlNIV7cYCfg&hl=en

Posted in Assignment, Management Accounting | Tagged: , | 3 Comments »

MAC – Management Accounting Session 2/3 – 05/25/2008

Posted by shyamrajagopalan on May 27, 2008

Date :- 25-May-2008

Attendees : 195 (dropped to 192 during the later stages :))

Session Summary :- Balance Sheet, Assets, Liabilities, Personal Example, Types of Assets, Types of Liabilities, Owner’s Equity, Class Questions, Balance Sheet Exercise (8 Step Problem), Split up of Owner’s Equity, Standard Format/Vertical Format, Formulations between Asset/Liability/OE

Misc on a lighter vein :- Maa (Asset), Pet me Laath (On book download) 🙂

Balance Sheet (Class Defn) – Position Statement at a point in time. Statement of what you Own vs Owe.

Kapil’s case (Fellow Student) – Asset, Liability, OE build up.

ASSETS = LIABILITY + OWNER’S EQUITY

Owner’s Equity is also known as Book value worth or Residual Value as it is residual in nature.

Types of Business Transactions (Pertaining to the above equation)

  1. Asset Increases, Cash Decreases – E.g. Usage of Cash to buy an Asset (e.g. Buy a Computer paying Cash)
  2. Asset Increases, Liability Increases – E.g. Take a loan to buy an Asset
  3. Asset Decreases, Liability Decreases – E.g. Pay a loan using Cash
  4. Asset Increases, No change in Liability – OE Increases and vice verca

Assets are classified into

  1. Current Assets :- Cash, Checks at hand, Bank balances, Marketable Securities, Trade receivables, Inventory, Employee Loans/Advances
  2. Fixed Assets :- Land, Plant/Machinery, Vehicles, Computers/Fixtures/Furniture, Buildings
  3. Other Assets :- Long Term Investments – 5/10 Yr timeframe, Intangibles (Deferred Revenue Expenditure, Loyalties)

In a few cases a Fixed asset can be a current asset. e.g. Furniture for a Furniture Maker, Car for a Car Dealer.

Liabilities are classified into

  1. Current Liability :- Working Capital Loan, Supplier Credit, Accounts Payable, Salary (Till it is paid), Other Payables, Advances from Customers, Overdrafts
  2. Long Term Liability :- Loans from Investors, Equipment Credit, Unsecured Loans, Pensions/Gratuities

Owner’s Equity – (Asset – Liabilities), still reported under Liabilities as it is owed to Owners, Share holders

  1. Share Capital/Initial Capital
  2. Reserves/Surplus – Post the first yr of operations, the amount/profit accrued less the Initial Capital

Reserves are classified into 1. Retained Earnings (General, Investments, Dividend etc) 2. Capital Reserves – 1 Time Event (Selling an Asset, e.g. Finolex Industries selling its land in Chinchwad, Pune as a 1 time event and recorded in the Balance Sheet as a Capital Reserve)

Class Questions and Answers

1. What is a Deferred Revenue Expenditure? Can we have some examples?

Deferred Revenue Expenditure is a classification of Asset, though it is an expenditure incurred by the Enterprise to create a long term value for the company. Examples include 1. Advertisements for a new product launch 2. VRS Scheme offered by companies 3. Listing cost (Brokerage, Underwriting costs)

Added Masala :- In case, the DRE does not pay out in the long run (for e.g. the Product being launched is pulled off, it will be written off the balance sheet)

2. Can you give us an example of a case where the Liability increases and the OE reduces with the Asset being retained as is?

For e.g A fine incurred during an accident. Till the cash is paid, L decreases, once the cash is paid, Asset reduces bringing the OE down.

3. Convention to be followed while writing a balance sheet?

A|L or L|A

Purely a convention. Former is US based, while the later is UK based.

We will follow A|L, and a few other conventions followed are

1. List assets from more liquid to less liquid – Current, Fixed and Other in that Order

2. List liabilities from more liquid to less liquid – Current, Limited and OE in that order

Class Exercise – 8 Step Transaction building up the balance sheet.

Other Notes – Sundry Creditors (Accounts Payable), Sundry Debtors (Accounts Receivable)

Some Formulae

Working Capital/Net Current Assets = CA – CL (Current Asset – Liability)

WC + FA + OA = LTL + OE

CA + FA + OA = LL + CL +(SC + RE)

First month of business

CA + FA + OA = LL + CL + (SC + (SALES – EXPENSES))

Further Months

CA + FA + OA = LL + CL + (SC + RE + (SALES – EXPENSES))

Pls do the assignments as requested by the Professor and be ready for next week.

Happy Tallying the balance sheet!

Posted in Balance Sheet, Maa, MAC, Management Accounting, Uncategorized | Leave a Comment »

MAC – Management Accounting

Posted by shyamrajagopalan on May 20, 2008

By now all of you would have received the syllabus for MAC (Management Accounting) and the course contents. In case you have not seen it yet, login to the email ID you have subscribed for the egroups, and check it out.

The primary reading material for the course is “Financial Accounting For Management” by Ramachandran and Kakani, 2nd Edition, McGraw Hill Publications.

Just in case you failed to notice, this is the same Dr.Rama Kumar Kakani who will be our course instructor. Some more insight on Mr.Kakani (Best Young Teacher Award, AIMS 2005), Please refer http://kimelody.blogspot.com/2005_08_01_archive.html

So it is indeed a great privilege to have Dr.Kakani as our course instructor.

Happy Accounting!

Posted in MAC, Management Accounting, PGCBM-14 | Tagged: , , | 1 Comment »