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 balance sheet and income statement for Bingle Ltd is presented to you as follows: Balance Sheet Extract as at 30 June 2012 with comparatives

VED Analysis: VED i.e. Vital, Essential and Desirable analysis is a technique employed for spare part inventory analysis and is broadly used in the automobile industry particul

While many people know that Sonora, Mexico is a beautiful vacation spot, it is also a large furniture manufacturing location in North America. Guillermo Navallez made furniture for

The following items are found in the trial balance of M/s Sharada Enterprise on 31st December, 2000. 10 marks Summer 2013 Sundry Debtors Rs.160000 Bad Debts written off Rs 9000 Dis

What is the objective of performing this test? What is the sampling unit? What is the population? These are the questions I am confused on the sampling and population I have som

1. Would export businesses prefer a rising or declining dollar? Would it be the same for a European tourist on a budget and visiting the Grand Canyon? Explain your answer. 2. Wh

Financials Investments, a group of financial advisors and retirement planners, has been requested to provide advice on how to invest $200,000 for one of its clients. The client has

Your mother-in-law is fretting about paying her mortgage. She refinanced her mortgage loan a while back, and now is thinking about refinancing again. You are going to help her eval

How useful is accounting information? No one would seriously claim that accounting information fully meets all of the needs of every various user groups. Accounting is still a

#questionBroadway Scripts is a service-type enterprise in the entertainment field, and its manager, Joe Numbers, has only a limited knowledge of accounting. Joe prepared the follo