Rate of return on assets, Financial Accounting

          EVERLIGHT COMPANY LIMITED

Comparative Balance Sheet

December 31, Year 1 and Year 2

 

 

Year 1

      Year2

Assets

Rs.

Rs.

Cash

1,000

1,200

Bank

6,000

7,500

Accounts Receivable

12,600

14,800

Inventory

18,400

20,500

Repayments

800

850

Land and Building

20,000

24,000

 

 

December 31st

Plant and Machinery

30,000

 

32,000

 

 

88,800

 

1,00,850

 

Liabilities and Shareholders' Equity

 

4,000

 

 

7,850

 

Bills Payable

 

 

 

 

Accounts Payable

6,400

 

6,000

 

Other Current Liabilities

2,000

 

2,200

 

Debentures (10%)

20,000

 

18,000

 

Preference Shares (12%)

10,000

 

10,000

 

Ordinary Shares. Rs. 10 each

40,000

 

50,000

 

Retained Earnings

6,400

 

6,800

 

 

88,800

 

1,00,850

 

 

Income and Retained Earnings Statement of the Year Ending December 31, Year 2

 

Sales Revenue

 

Less Expenses:

 

 

 

Rs. 28,000

 

Rs. 60,000

Cost of Goods Sold

 

 

Selling

8,000

 

Administrative

6,000

 

Interest

2,000

 

Income Tax

6,400

 

Total Expenses

 

50,400

Net Income

 

9,600

Less Dividend : Preferred

1,200

 

 

Ordinary

 

8,000

 

 

 

9,200

Increase in Retained Earning for Year 2

 

400

Retained Earnings, December 31, Year 1

 

6,400

Retained Earnings, December 31, Year 2

 

6,800

 

Along with the above information, here we compute the subsequent ratios

1)      Rate of Return on Assets

2)      Profit Margin (before interest and related tax effect)

3)      Cost of Goods Sold to Sales Percentage

4)      Selling Expenses to Sales Percentage

5)      Operating Expense Ratio

6)      Total Assets Turnover

7)      Accounts Receivable Turnover

8)      Inventory Turnover

9)      Rate of Return on Ordinary Share Equity

10)  Current Ratio

11)  Quick Ratio

12)  Long-Term Debt Ratio

13)  Debt Equity Ratio                                                                                                                                    

14)  Times interest Charges Earned

15)  Earnings per (Ordinary) Share

16)  Price Earnings Ratio

17)  Book Value per Ordinary Share

 The income tax price is 40 percent. The market price of an ordinary share in the ending of Year 2 was as Rs. 14.80.

Here we take all such ratios individually.

1)      Rate of Return on Assets

= (Rs. 9,600 + (1- .40) (Rs. 2, 000))/( .5 (Rs. 88,800 + Rs.1,00,850))

 = 11.39 percent

2)      Profit Margin (before interest and related tax effect)

= (Rs. 9,600 + (1-40) (Rs. 2,000))/ Rs. 60,000

 = 18 percent

3)      Cost of Goods Sold to Sales Percentage

= Rs. 28,000/ Rs. 60,000

 = 46.67 percent

4)      Selling expenses to Sales Percentage

= Rs. 8,000/ Rs. 60,000

  = 13.33 percent

5)      Operating Expense Ratio

=  (Rs. 8,000+ Rs. 6,000)/ Rs. 60,000

   = 23.33 percent

6)      Total Asset Turnover

= Rs. 60,000 / (.5 (Rs. 88,800 + Rs.1,00,850))

= .63 times per year

7)      Accounts Receivable Turnover

= Rs. 60,000 / (.5 (Rs. 12,600 + Rs. 1,4,800))

= 4.3 8 times per year

8)      Inventory Turnover Ratio

= Rs.28,000 /.5 (Rs. 18,400 + Rs. 20,500)

= 1.44 times per year

9)      Rate of Return or Ordinary Share Equity

= (Rs. 9,600 - Rs. 1,200 x 100)/ .5 (Rs. 46,400 + Rs. 56,800)

 = 16.28 per cent

 

 

10)  Current Ratio

December 31, Year 1 : Rs.38,800/ Rs.12,400

 = 3.13:1

December 31, Year 2 : Rs. 44,850/ Rs.16,050

 = 2.79 : 1

11)  Quick Ratio:

December 31, Year 1 : Rs.19,600/ Rs.12,400

 = 1.56 :1

December 31, Year 2: Rs.23500/ Rs.16,050

 = 1.46 :1

12)  Long-term Debt Ratio

December 31, Year 1: Rs.20,000/ Rs. 80,400

 = 24.86 percent

December 31, Year 2: Rs. 18,000/ Rs. 84,800

 = 21.23 percent

13)  Debt Equity Ratio

December31, Year 1 : Rs.20,000/ Rs.46,400

    = 43.1

December 31, Year 2 : Rs.18,000/ Rs. 56,800

    = 31.69

(Equity might or not comprise retained earnings. Now, retained earnings have been comprised)

14)  Times Interest Charges Earned

(Rs. 9,600 + Rs. 6,400 + Rs: 2,000)/ Rs: 2,000

= 9 times

15)  Earnings per Ordinary Share (EPS)

December 31 Year 2:

= Rs. 8,40 0/.5 (4000 + 5000)

       = Rs.1.87

16)  Price-Earnings Ratio

December 31, Year 2 as:

=  14.80 /1.87                    

= 7.91 times

17)  Book Value per Ordinary Share

December 31, Year 1 : = Rs. 46,400/4,000

 = Rs.11.60

December 31, Year 2 : = Rs. 56,800/5,000

 = Rs.11.36

Posted Date: 4/9/2013 2:16:37 AM | Location : United States







Related Discussions:- Rate of return on assets, Assignment Help, Ask Question on Rate of return on assets, Get Answer, Expert's Help, Rate of return on assets Discussions

Write discussion on Rate of return on assets
Your posts are moderated
Related Questions
The costs that follow were extracted from the accounting records of various different manufacturers: 1.    Weekly wages of an equipment maintenance worker 2.    Marketing costs

My trial balance is off by $304 and I can''t find my error

For a capital lease the lessee records the lease payments as rent expense, but for an operating lease the lessee reports the lease payments as depreciation expense For an operating

The family next door just received a $300,000,000 cash payout after winning the lottery. You talked with them and are trying to convince them to let you manage a portfolio of inves

when youre using accounting software why would you use hot keys and shortcuts a.to quickly access commands b.to input data for you c.to start the program d.to write checks

speciman of accounts preparation in stock and debtor system.

Much of the supply-side, fiscally conservative economic policies of Margaret Thatcher, Ronald Reagan, and even Mike Harris in Ontario were predicated on the belief that high income

Oswald Corporation reported the following information on operations for 2009: Revenue = $2,000 Cost of goods sold = $850 Operating expenses =$395 Depreciation =$248

Assume you are receiving an amount of Rs.5000 twice in a year for subsequent five years one time at the starting of the year and another amount of Rs. 5000 at the ending of the yea

Presented below are four independent situations which you as a Manager Trainee employed with Your Company have been asked to evaluate. Evaluate each situation based on what each re