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%
You are given the below figures from the Income statement and Balance sheet of ABC Ltd...
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 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 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 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 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 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 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 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 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 $ 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...