Question

You are given the below figures from the Income statement and Balance sheet of ABC Ltd at the end of year 2018. Calculate the

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer:

(a) Quick (acid test) ratio:

Quick(Acid Test) Ratio = Current Assets (Excl. Inventory)/Current Liabilities

Proforma Balance Sheet from the given information:

Liabilities Amount Assets Amount
Shareholders Equity 2,550,000 Inventory 1,800,000
Long Term Liabilities 2,000,000 Current Assets (Excl. Inventory) 650,000
Current Liabilities 900,000 Non Current Assets (Balancing figure) 3,000,000
TOTAL 5,450,000 TOTAL 5,450,000

Quick(Acid Test) Ratio = 650000/900000 = 0.72:1

(b) Return on Equity:

Return on Equity = Net Profit for Equity Shareholders/Shareholders Equity * 100

Given information:

Profit after Tax (For Equity Shareholders) [150000*3] 450,000
Number of Equity Shares 150,000
Earnings Per Share [45/15] 3
Market Price per share 45
P/E Ratio {Market Price per share/Earnings Per Share} 15

Return on Equity = 450000/2550000*100 = 17.65%

(c) Net Profit Margin:

Net Profit Margin = Net Profit after tax/Sales*100

Cost of Inventory Sold = 500,000

Gross Profit Margin = 55%

Hence Cost of inventory sold = 100-55 = 45%

Hence Sales = 500000/0.45 = 1,111,111

Net Profit Margin = 450000/1111111*100 = 40.50%

Add a comment
Know the answer?
Add Answer to:
You are given the below figures from the Income statement and Balance sheet of ABC Ltd...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Use the information from the Income Statement and Balance Sheet to construct the ratios and answer...

    Use the information from the Income Statement and Balance Sheet to construct the ratios and answer the questions below. Downloadable Financial statements HW 4 SXP 19.docxPreview the document hw3 ratios.jpg Barry Computers Income statement DEC 31, 2016 Sales 1,607,500 GOGS 1,392,500 Gross Profit 215,000 SG&A 145,000 EBIT 70,000 Interest Expenses 24,500 EBT 45,500 TX (40%) 18,200 NI 27,300 Barry Computers Balance Sheet DEC 31, 2016 Cash 77,500 Accounts Payable 129,000 Accounts receivables 336,000 Accruals 117,000 Inventory 241,500 Notes Payable 84,000...

  • F G 4 D BALANCE SHEET (s in millions) INCOME STATEMENT (S in millions) 5 6...

    F G 4 D BALANCE SHEET (s in millions) INCOME STATEMENT (S in millions) 5 6 7 8 #VALUE! ASSETS Cash & Marketable Securities Accounts Receivable Inventories Other Current Assets Total Current Assets 449.90 954.80 3,645.20 9 10 LIABILITIES Accounts Payable Salanes Payable Other Current Liabilities Total Current Liabilities Revenue Cost Of Goods Sold Gross Profit 1,611 20 20520 1.118.80 2955.20 28,681.10 20.768.80 7,912.30 11659 5,166.50 Other Libilities 693.40 11 12 13 14 15 16 17 18 19 Operating Expenses...

  • 2016 4. Katy Co's Balance Sheet and Income Statement are given below 2020 220,000 Balance Sheet...

    2016 4. Katy Co's Balance Sheet and Income Statement are given below 2020 220,000 Balance Sheet December 31, 2000 Cash Accounts Receivable, less allowance of $10,000 Inventory, LIFO Total Current Assets Land Buildings and Equipe Les accurated depreciation Total Long-term Assets Total Aucts Accounts Payable Accrued Compensation Total Current Liabilities Long-Term Debt Total Liabilities Common Shares Retained Earnings Total Shareholders' Equity Total Liabilities and Shareholders' Equity (120.000) 510.000 15.000 140,000 230.000 380.000 520.000 140.000 220.000 380.000 510.000 2019 Income Statement...

  • Problem # 1 (50 points) Given the Income Statement and Balance Sheet Compute: Current Ratio Acid-Test...

    Problem # 1 (50 points) Given the Income Statement and Balance Sheet Compute: Current Ratio Acid-Test Ratio Days in Receivable Days in Inventory Operating Profit Margin Total Asset Tumover Fixed-asset turnover Debt Ratio Times Interest Earned Return on Equity Income Statement Balance Sheet Assets Cash Accounts Receivable Inventory Prepaid Expenses Total Current Assets Gross Plant and Equipment Accumulated Depreciation Net Fixed Assets Total Assets $200,000 $60,000 $100,000 $20,000 $380,000 $802,000 -$132,000 $670,000 $1,050,000 Sales (all credit) Cost of Goods Sold...

  • Condensed statement of financial position and income statement data for Elkhardt Ltd. are shown below: ELKHARDT...

    Condensed statement of financial position and income statement data for Elkhardt Ltd. are shown below: ELKHARDT LTD. Statement of Financial Position December 31 (in thousands) 2018 2017 2016 Assets Current assets    Cash $29 $79 $199    Accounts receivable 898 706 502    Inventory 1,198 798 498 Total current assets 2,125 1,583 1,199 Property, plant, and equipment (net) 4,124 3,777 3,168 Total assets $6,249 $5,360 $4,367 Liabilities and Shareholders’ Equity Liabilities    Current liabilities $600 $547 $502    Non-current liabilities 3,044 2,307 1,505       Total liabilities...

  • II. Problem Solving. Show all the necessary computations. No solutions, no credit. Round off final answers...

    II. Problem Solving. Show all the necessary computations. No solutions, no credit. Round off final answers to two decimal places. BA220 Corporation Income Statement Sales Cost of Goods Sold Gross Profit Margin Operating Expenses Depreciation Earnings Before interest & taxes Interest Earnings Before taxes Taxes (25%) Earnings after taxes 2019 15,000,000.00 9,750,000.00 5,250,000.00 3,000,000.00 500,000.00 1,750,000.00 500,000.00 1,250,000.00 312,500.00 937,500.00 2018 12,000,000.00 7,800,000.00 4,200,000.00 2,500,000.00 400,000.00 1,300,000.00 300,000.00 1,000,000.00 250,000.00 750,000.00 2019 2018 Balance Sheet Assets Cash Accounts Receivable Inventory...

  • Create two years (2020 and 2021) of pro forma income statements and balance sheets and the...

    Create two years (2020 and 2021) of pro forma income statements and balance sheets and the statement of cash flows, including operating, investing, and financing sections for 2020 only. Additional Information: The relationship between cost of goods sold and sales revenue Is expected to continue in the near term and no inflation is expected. Operating expenses include $200,000 in depreciation (fixed expense), the remainder is variable costs tied to sales revenue. Fixed assets are adequate to support sales growth for...

  • g 3. Given the balance sheet and income state for Simmons Maintenaethet Simmons & Professional Studies...

    g 3. Given the balance sheet and income state for Simmons Maintenaethet Simmons & Professional Studies ratios that are also shown for the industry average. For each ratio,indica is better or worse than the industry average. For inventory turn cost of goods sold. Company, compute the use sales rather than SIMMONS MAINTENANCE COMPANY Assets Cash Acets. Receivable Inventory Current Assets Net Fixed Assets Liabilities S 15,000 Accounts Payable S 21,000 22,000 Notes Payable 20,000 30,000 Accrued Expenses 67,000 Current Liabilities...

  • The Balance Sheet and the Income Statement for ABC Manufacturing Corporation are as follows: DATA (All...

    The Balance Sheet and the Income Statement for ABC Manufacturing Corporation are as follows: DATA (All amounts in SAR unless otherwise indicated, all sales are on credit and no hard keys.) Balance Sheet: ABC Corporation Balance Sheet 2019 Cash 310 Accounts receivable 685 Inventories 600 Other current assets 105 Total current assets 1,700 Gross fixed assets 3,750 Accumulated depreciation -1,500 Net fixed assets 2,250 Total assets 3,950 LIABILITIES (DEBT) AND EQUITY Accounts payable 350 Short-term notes payable 250 Total current...

  • The balance sheet and income statement for Covid19 Bhd is presented below. BALANCE SHEET (000) Cash...

    The balance sheet and income statement for Covid19 Bhd is presented below. BALANCE SHEET (000) Cash $   500 Accounts receivable 1,500 Inventories                                                  500 Current assets 2,500 Net fixed assets                                        5,000 Total Assets $ 7,500 Accounts payable                                     1,200 Bank note                                                    300 Total current liabilities 1,500 Long term debt 4,000 Common stock                                            300 Retained earnings                                     1,700 Total liabilities and owner's equity $ 7,500 INCOME STATEMENT (000) Net sales                                                 $ 8,500 Cost of goods sold                                   (3,400) Gross profit 5,100 Operating expenses                                 (2,900) Net...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT