Question

In: Finance

The following information relates to ABC Ltd., for the year ended 31st December, 2019.

The following information relates to ABC Ltd., for the year ended 31st December, 2019.

            Sales……………………………………………………………….. Rs.2,000,000.

            EBID ………………………………………………………………. 40% of sales.

            Ordinary Shares capital of par value Rs.10/each……………… Rs.800,000.

            8% Preference shares Capital of par value Rs.100/ each………. Rs.500,000.

            10% Bonds payable of par value Rs.1000/each…………………. Rs.400,000.

            Reserves and surplus………………………………………………Rs.250,000.

            Current liabilities…………………………………………………..Rs.250,000.

Tax rate is 30%.

            Market price of share is Rs.20 each.

            Dividend payout ratio is 60%.

Required; Compute and comments on each of the following ratios

a)Earning per share.                         b)         Dividend per share.

c)Price earning ration.                      d)         Earning yield ratio.

e)Dividend yield ratio.                       f)         Return on assets.

g)Return on Equity.                          h)         Capital/Assets turn over.

i) Equity multiplier.                           J)         Debt ratio      

Solutions

Expert Solution

Answer
Income Statement
Sales 2000000
EBID 800000
Interest 40000
EBD 760000
Tax 228000
Post tax EBD 532000
Preference Dividend 40000
Earning available to equity shareholders 492000
Equity dividend 295200
Balance T/f to Reserves and surplus 196800
Equity & Liabilities
Equity Share capital 800000
Reserves & Surplus 250000
Equity 1050000
8% Preference Share Capital 500000
10% Bonds 400000
Current Laibilities 250000
Total Liabilities 650000
Total Euity & Liabilities 2200000
So, Total Assets 2200000
A Earning per share.   
Earnings Per share Earning available to equity shareholders/No.of Equity Shares
Earning available to equity shareholders 492000
No.of Equity Shares 80000
EPS 6.15
B Dividend per share
Dividend per share Dividend Paid/No.of Equity Shares
Dividend paid 295200
No.of Equity Shares 80000
DPS 3.69
C Price Earnings Ratio
Price Earnings Ratio Market Price per share/Earnings Per share
Market Price per share 20
Earnings per Share 6.15
P/E 3.25
D Earnings Yield ratio
Earnings Yield ratio Earnings Per share/Market Price Share
Earnings Per share 6.15
Market Price per share 20
Earnings Yield ratio 0.31
E Dividend Yield ratio
Dividend Yield ratio Dividend Per share/Market Price Per Share
Dividend per share 3.69
Market price per share 20
Dividend Yield ratio 18%
F Return on Assets
Return on Assets Net Income/Total Assets
Net Income 532000
Total Assets 2200000
ROA 24.18%
G Return on Equity
Return on Equity Net Income/Equity
Net Income 532000
Equity 750000
ROE 70.93%
H Capital / asset Turnover ratio
Asset Turnover Ratio Net sales / Average Total assets
Net sales 2000000
Avg Total assets 1100000
Capital / asset Turnover ratio 182%
I Equity multiplier
Equity Multiplier Total Assets / Stockholder's Equity
Total Assets 2200000
Shareholders Equity 1050000
Equity Multiplier 2.10
J Debt Ratio
Debt Ratio Total Liabilities / Total Assets
Total Liabilities 650000
Total Assets 2200000
Debt Ratio 29.55%

Related Solutions

The following information relates to Egoly Ltd for the year ended 30th June 2019: EGOLY LTD...
The following information relates to Egoly Ltd for the year ended 30th June 2019: EGOLY LTD BALANCE SHEET AS AT 30th JUNE 2019 2019 2018 $ $ ASSETS Current Assets    Cash at bank 67,710 59,666    Accounts receivable 252,760 283,290    Inventory 1,107,600 951,400    Prepaid expenses 113,600 35,500 Total current assets 1,541,670 1,329,856 Non-current assets    Equipment 1,263,800 823,600    Accumulated depreciation – equipment (238,560) (143,136) Total non-current assets 1,025,240 680,464 TOTAL ASSETS 2,566,910 2,010,320 LIABILITIES & SHAREHOLDERS...
The following information relates to a company ABC Ltd for the year ended 30 June 2020:...
The following information relates to a company ABC Ltd for the year ended 30 June 2020: Transaction totals for the year ended 30 June 2020 R Credit purchases of raw materials 503750 Freight on raw materiasl purchased (on credit) 99833 Sales of finished producgts 11440000 Direct Labour: Factory wages 828600 Pension fund contributions paid by employer 172500 Medical aid paid by employer 227200 UIF Contributions paid by employer 8144 Indirect Labour 500250 Electricity Factory 211450 Administration offices 127900 Rent Expenses...
The following information relates to Walnut Ltd. for the year ended December 31, 2013: Sales                          &nbsp
The following information relates to Walnut Ltd. for the year ended December 31, 2013: Sales                                                                                                         $3,500,000 Purchases: Direct materials                                                                                   $700,000 Indirect materials                                                                                 $50,000 Office supplies                                                                                     $20,000       Salaries                                                                                                      $500,000 * Direct labour                                                                                              $800,000       Rent                                                                                                          $100,000 *       Utilities                                                                                                     $80,000 *       Advertising and promotional                                                                     $30,000       Inventories:                             Dec. 31, 2012                      Dec. 31, 2013 Direct materials                $45,000                                $62,000 Indirect materials                 -----                                  $ 9,000 Office supplies                  $1,000                                     ----- Work-in-process               $4,100                                   $3,300 Finished goods                  $90,000                                 $81,700 *Of these costs, 80 % are assigned to manufacturing activities and the remainder pertain to selling and administrative functions.                         (Assume that there is no "over-or-under" applied overhead.) Instructions: Prepare in good form...
The following information relates to ABC Pty Ltd for the years ended 30 June Year 3...
The following information relates to ABC Pty Ltd for the years ended 30 June Year 3 and Year 2: Year 3 $ Year 2 $ Total assets Owners’ equity 6,020,000 3,250,000 5,470,000 3,200,000 Annual sales Net profit (after tax) Weighted average number of ordinary shares issued 6,100,000 810,000 10,234,518 3,154,350 475,200 10,046,430 Required: Calculate the net profit margin, asset turnover, earnings per share and debt to total assets ratios for ABC Ltd for the year ended 30 June Year 3
The following information is available from the books of Exclusive Ltd. for the year ended 31st...
The following information is available from the books of Exclusive Ltd. for the year ended 31st March 2016: (a) Cash sales for the year were Rs.10,00,000 and sales on account Rs.12,00,000. (b) Payments on accounts payable for inventory totaled Rs.7,80,000. (c) Collection against accounts receivable were Rs.7,60,000. (d) Rent paid in cash Rs.2,20,000, outstanding rent being Rs.20,000. (e) 4,00,000 Equity shares of Rs.10 par value were issued for Rs.48,00,000. (f) Equipment was purchased for cash Rs.16,80,000. (g) Dividend amounting to...
The following data relates to ABC Ltd: • Profit for the year ended 30 June 20X1,...
The following data relates to ABC Ltd: • Profit for the year ended 30 June 20X1, $500,000. • On 31 March 20X1, the directors decided to pay an interim cash dividend of $100,000. • On 7 April 20X1, the interim dividend was paid. • For final dividends, the company’s constitution provides that the directors can recommend a dividend to be subsequently declared by a resolution of the members in a general meeting. • The directors recommended a final dividend of...
Madhuri Ltd. gives you the following information for the year ended 31st March 2016: (a) Sales...
Madhuri Ltd. gives you the following information for the year ended 31st March 2016: (a) Sales for the year totaled Rs.96,00,000. The company sells goods for cash only. (b) Cost of goods sold was 60% of sales. (c) Closing inventory was higher than opening inventory by Rs.43,000. (d) Trade creditors on 31st March 2016 exceeded those on 31st March 2015 by Rs.23,000. (e) Tax paid amounted to Rs.7,00,000. (f) Depreciation on fixed assets for the year was Rs.3,15,000 whereas other...
he following data relates to ABC Ltd: • Profit for the year ended 30 June 20X1,...
he following data relates to ABC Ltd: • Profit for the year ended 30 June 20X1, $500,000. • On 31 March 20X1, the directors decided to pay an interim cash dividend of $100,000. • On 7 April 20X1, the interim dividend was paid. • For final dividends, the company’s constitution provides that the directors can recommend a dividend to be subsequently declared by a resolution of the members in a general meeting. • The directors recommended a final dividend of...
Music Magic Income Statement For the Year Ended December 31st,2019 2019 2018 Revenues Service Revenue...
Music Magic Income Statement For the Year Ended December 31st, 2019 2019 2018 Revenues Service Revenue $6,500 $6,000 Expenses Advertising Expense $800 $750 Depreciation Expense 400 350 Interest Expense 100 100 Rent Expense 500 500 Salaries Expense 2,400 2,200 Supplies Expense 900 800 Total Expenses $5,100 $4,700 Net Income $1,400 $1,300You will need to complete a horizontal analysis on the income statement and a vertical analysis on the Balance sheet. The information for the assignment can be found in the...
The following information relates to Husk Corn Co. for the year ended December 31, 2018: The...
The following information relates to Husk Corn Co. for the year ended December 31, 2018: The company tells you that Income from Continuing Operations PRE Taxes is $ 300,000. However, this amount was computed before the company considered these items: (i.e. none of the items listed below are factored into the $300,000) Restructuring Costs incurred in 2018 were $25,000 When recording depreciation expense for the previous year (2017), they mistakenly recorded depreciation twice for the same asset. The amount of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT