Unofficial blog for XLRI – PGCBM 14 Batch

Colloborate… Conquer…

Archive for the ‘MAC’ 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 »

Management Accounting – Sessions 4/5 – MAC

Posted by shyamrajagopalan on June 2, 2008

Attendees : 191

Date:- 31-May-2008

Summary :- Ram Trader’s Balance Sheet (Solved with Roll # 58), Deferred Revenue Expenditure, P&L Account, Income Statement, Difference between BS and PL Statement, Components of a P&L Statement, Various types of Profit, Adjustments for P&L Account, Basis of Accounting (Accrual Vs Cash), Formats, Warranties/Bad Debts, Depreciation, Methods of calculation of Depreciation, Sample P&L Statement

Ram Trader’s Balance sheet was solved in the class using the sample roll # 58. Pretty much done in the line of how I did my assignment. The only difference being I accounted for the rent for 1 month while the prof. did it for 29 days.

On the question of Ram traders spending a 1000 rupees being a Deferred Revenue expenditure, the Prof. addressed that the question was subjective and we will have to evaluate whether the expense took care of the business for years to come or applicable only for the year.

 On a lighter note, the prof indicated that he had caught sight (on the video) of Rajesh Ramani on a mobile, vehemently denied by Rajesh, and effectively getting 5 marks for his question.

Profit and Loss Statement

Statement of Revenue and Expenses of a company. It is also referred as the Income statement. Apart from the revenues and expenses accomodated in this statement, it also needs to accomodate items like Depreciation, Accrued Interest, Tax Provisions etc. P&L statement is also a summary of the companies operations and helps us analyze the company’s performance in greater detail.

Wikipedia states “An Income Statement, also called a Profit and Loss Statement (P&L), is a financial statement for companies that indicates how Revenue (money received from the sale of products and services before expenses are taken out, also known as the “top line”) is transformed into net income (the result after all revenues and expenses have been accounted for, also known as the “bottom line”). The purpose of the income statement is to show managers and investors whether the company made or lost money during the period being reported.”

As this deals with the Profit/Loss Statement, we come across various types of profits like Gross Profit, Operating Profit, Net Profit etc.

Gross Profit : Sales – Cost of Goods (Direct Costs)

Operating Profit : Gross Profit – Operating Expenses

Net Profit : Operating Profit – (Interest Amt to be Paid + Taxes)

Withdrawals and Dividends are supposed to be done on the Net Profit numbers.

 In Services Industry such as IT/ITeS (Gross Profit will be pretty much same as Net Profit numbers)

Past Earnings – Profits carried on in the companies books, from previous years.

Difference Between Balance Sheet and P&L Statement of Accounts

1. Balance Sheet is a Position Statement, while P&L is a Performance Statement

2. Balance Sheet is a statement of Assets, Liabilities and OE, while P&L Statement is a statement of revenue/expenses/profit.

3. Balance Sheet states the matter of fact with respect to the companie’s performance (OE) , while P&L Statement can be used to analyze the performance of the company and provides answers to questions around company’s performance, expenses incurred etc

 Types of Accounting

Cash Basis – Governments (Road Tax collected now for 15 yrs will come under the current reporting period), also allowed for professionals (Lawyers, Doctors). Cash-basis accounting is not considered to provide a true and fair view of the financial performance and hence not used by companies.

Accrual Basis – Followed by companies, Complies GAAP Standard.  It is based on Realization. A Sale is made when the goods are delivered. Under accrual accounting, revenue is recorded when it is earned and realized, regardless of when actual payment is received. Similarly, expenses are “matched” (a process known as matching or expense matching) revenue regardless of when they are actually paid.

 P&L accounts are reported in 2 formats (Horizontal and Vertical). Not sure which is the standard?

Bad debts/warranties needs to be shown in P&L Statements, and reported accordingly. These are also shown under respective sections in the balance sheet. Bad Debts Losses (To be deducted in Current Assets), while Warranties are liabilities arrived at based on experience in the industry.

Concept of Depreciation 

Depreciation is a concept of reflecting the decrease the future economic utility of an Asset. It is applicable for Tangible assets of a business. It is done to account the normal wear and tear of an asset. Depreciation does not figure in the cash flow statement as it is notional.

Various Methods of Calculating Depreciation

Straight Line Method :- The reduction in cost of the asset is linear year on year. The formula to calculate Depreciation under this method

Depreciation = (Initial Cost – Salvage Cost)/Life of the Asset. This is applicable for items with the same usage during all the time of its use. E.g Furniture

Book Value –
Beginning of Year
Depreciation
Expense
Accumulated
Depreciation
Book Value –
End of Year
$17,000 (Original Cost) $3,000 $3,000 $14,000
$14,000 $3,000 $6,000 $11,000
$11,000 $3,000 $9,000 $8,000
$8,000 $3,000 $12,000 $5,000
$5,000 $3,000 $15,000 $2,000 (Scrap Value)

WDV Method : The decrease in the value is based on a guidance percentage. e.g Computers in IT Industry (60 % YoY). Hence the decrease is more during initial years.

M.A.R.C.S Method : Modified Accelerated Cash Recovery System. US Concept. Decrease is more during the middle years. E.g Industrial Boilers, Pumps as it takes some time for such equipments to reach some optimal levels and then depreciates more from then on.

Companies may have 2 different P&L Accounts for a FY. i.e one for Investors and one for Tax authorites. (Different ways of Depreciation accounted for Assets in both cases)

P&L Statement also include schedule numbers, which provide details of the expense/sales and provides further break up of details.

Class work : – Preparing the P&L Statement for Ram Traders and Tallying the Retained Earnings in the BS problem with the Profit.

Some good read

http://ohioline.osu.edu/cd-fact/1153.html

http://en.allexperts.com/q/Managing-Business-1088/2008/3/balance-sheet-1.htm

Posted in Depreciation, MAC, P&L Statement | Tagged: , , | 3 Comments »

Updates from Rohit – 29/05/2008

Posted by shyamrajagopalan on May 29, 2008

MAC – Class Marks
Folks who have not been asked questions in the class (for the 12 sessions) will be awarded an average marks of students wh have been awarded.

POM – PPT
PPT for POM has been uploaded to AIS. For details, look into your egroup emails

MAC – ASSIGNMENT
We are giving you the option of 3 cases. Any ONE of them can be done by a student.
Case no. 2 (page no. 88), Case no. 3 (page no. 92) or Case no. 5 (page no. 94)
*** for case no 5, students may take the last two digit of their SID (e.g. DB06004 is the SID then 0 will be taken as first no. and4 will be taken as second no.)
Do not get confused with SID and SMS ID. Take only SID for the calculation. ***
This will be graded and last date for submission of the case is 31-05-2008, Saturday.

EMAIL COMMUNICATION
Pls do not use the yahoo groups to send any emails. It is for the use of Moderators only. For questions/queries, pls address it to the TAs directly. Email details have been provided by Rohit.

Posted in MAC, POM, Rohit | Leave a Comment »

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 »