Lydex Company Comparative Balance Sheet |
||||
This Year | Last Year | |||
Assets | ||||
Current assets: | ||||
Cash | $ | 960,000 | $ | 1,200,000 |
Marketable securities | 0 | 300,000 | ||
Accounts receivable, net | 2,700,000 | 1,800,000 | ||
Inventory | 3,600,000 | 2,000,000 | ||
Prepaid expenses | 260,000 | 200,000 | ||
Total current assets | 7,520,000 | 5,500,000 | ||
Plant and equipment, net | 9,520,000 | 9,050,000 | ||
Total assets | $ | 17,040,000 | $ | 14,550,000 |
Liabilities and Stockholders' Equity | ||||
Liabilities: | ||||
Current liabilities | $ | 4,010,000 | $ | 2,980,000 |
Note payable, 10% | 3,660,000 | 3,060,000 | ||
Total liabilities | 7,670,000 | 6,040,000 | ||
Stockholders' equity: | ||||
Common stock, $75 par value | 7,500,000 | 7,500,000 | ||
Retained earnings | 1,870,000 | 1,010,000 | ||
Total stockholders' equity | 9,370,000 | 8,510,000 | ||
Total liabilities and stockholders' equity | $ | 17,040,000 | $ | 14,550,000 |
Lydex Company Comparative Income Statement and Reconciliation |
||||
This Year | Last Year | |||
Sales (all on account) | $ | 15,860,000 | $ | 13,580,000 |
Cost of goods sold | 12,688,000 | 10,185,000 | ||
Gross margin | 3,172,000 | 3,395,000 | ||
Selling and administrative expenses | 1,006,000 | 1,604,000 | ||
Net operating income | 2,166,000 | 1,791,000 | ||
Interest expense | 366,000 | 306,000 | ||
Net income before taxes | 1,800,000 | 1,485,000 | ||
Income taxes (30%) | 540,000 | 445,500 | ||
Net income | 1,260,000 | 1,039,500 | ||
Common dividends | 400,000 | 519,750 | ||
Net income retained | 860,000 | 519,750 | ||
Beginning retained earnings | 1,010,000 | 490,250 | ||
Ending retained earnings | $ | 1,870,000 | $ | 1,010,000 |
Current ratio | 2.4 | |
Acid-test ratio | 1.1 | |
Average collection period | 40 | days |
Average sale period | 60 | days |
Return on assets | 9.3 | % |
Debt-to-equity ratio | 0.7 | |
Times interest earned ratio | 5.9 | |
Price-earnings ratio | 10 | |
You decide, finally, to assess the company’s liquidity and asset management. For both this year and last year, compute:
Working capital & The current ratio (Round your final answers to 2 decimal places) & The acid-test ratio (Round your final answers to 2 decimal places )The average collection period (The accounts receivable at the beginning of last year totaled $1,670,000) (Use 365 days in a year Round your intermediate calculations and final answer to 2 decimal place) The average sale period (The inventory at the beginning of last year totaled $2,030,000.) (Use 365 days in a year Round your intermediate calculations and final answer to 2 decimal place) The operating cycle (Round your intermediate calculations and final answer to 2 decimal place)The total asset turnover. (The total assets at the beginning of last year totaled $14,610,000) (Round your final answers to 2 decimal places)?
This Year | Last Year | |||
Working Capital Ratio | ||||
Current Assets minus Current Liabilities | ||||
7520000-4010000 | 5500000-2980000 | |||
i.e. | 3510000 | 2520000 | ||
Current Ratio | ||||
Current Assets/Current Liabilities | ||||
7520000/4010000 | 5500000/2980000 | |||
i.e. | 1.88 | 1.85 | ||
Acid Test Ratio | ||||
Quick Assets/ Current Liabiites | ||||
(960000+2700000)/4010000 | (1200000+300000+1800000)/2980000 | |||
i.e. | 0.91 | 1.11 | ||
Average Collection Period | ||||
365/Debtor turover ratio | 51.77 | 46.62 | ||
where Debtor turnover ratio means | 15860000 /{(27 Lacs +18 Lacs)/2} | 13580000 /{(18Lacs +16.7 Lacs)/2} | ||
(Net Credit Sales/ Avg Debtors) | 7.05 | 7.83 | ||
Average Sales Period | ||||
365/Inventory Turover Ratio | 80.57 | 72.28 | ||
where Inventory turnover ratio means | 12688000/ {(36 Lacs + 20 Lacs)/2} | 10185000/ {(20 Lacs + 20.3 Lacs)/2} | ||
(COGS/ Avg Inventory) | 4.53 | 5.05 | ||
Operating Cycle Period | ||||
Average Collection Period + Average Sales Period | 132.35 | 118.89 | ||
Assets Turover ratio | ||||
Net Sales/ Avg Fixed Assets | 1.71 | 1.15 | ||
15860000/{(9520000+9050000)/2} | 13580000/{(9050000+14610000)/2} | |||
Lydex Company Comparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 960,000 $...
Lydex Company Comparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 960,000 $ 1,200,000 Marketable securities 0 300,000 Accounts receivable, net 2,700,000 1,800,000 Inventory 3,600,000 2,000,000 Prepaid expenses 260,000 200,000 Total current assets 7,520,000 5,500,000 Plant and equipment, net 9,520,000 9,050,000 Total assets $ 17,040,000 $ 14,550,000 Liabilities and Stockholders' Equity Liabilities: Current liabilities $ 4,010,000 $ 2,980,000 Note payable, 10% 3,660,000 3,060,000 Total liabilities 7,670,000 6,040,000 Stockholders' equity: Common stock, $75 par value 7,500,000 7,500,000 Retained...
Lydex Company Comparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 960,000 $ 1,200,000 Marketable securities 0 300,000 Accounts receivable, net 2,700,000 1,800,000 Inventory 3,600,000 2,000,000 Prepaid expenses 260,000 200,000 Total current assets 7,520,000 5,500,000 Plant and equipment, net 9,520,000 9,050,000 Total assets $ 17,040,000 $ 14,550,000 Liabilities and Stockholders' Equity Liabilities: Current liabilities $ 4,010,000 $ 2,980,000 Note payable, 10% 3,660,000 3,060,000 Total liabilities 7,670,000 6,040,000 Stockholders' equity: Common stock, $75 par value 7,500,000 7,500,000 Retained...
every question requires this year and last year 1) working capital (this and last year) 2) the current ratio 3) average collection period (use 365 days in a year) (accounts recievable at the beginning if kast year totaled 1,670,000) 4) average sale period (365 days in a year, inventory of beginning of kast year is 2,030,000) 5) operating cycle 6) total asset turnover (totaled at the beginning if last year at 14,610,000) Lydex Company Comparative Balance Sheet This Year Last...
1) earninggs per share for this year and last year 2) dividend yield ratio in % this and last year 3) dividend payout ratio in % this and last year 4) price earning ratio this and last year 5) book value per share of common stock this and last year Comparative Balance Sheet This Year Last Year $ 960,000 2,700,000 3,600,000 • 260,000 7,520,000 9,520,000 $17,040,000 $ 1,200,000 300,000 1,800,000 2,000,000 200,000 5,500,000 9 ,050,000 $14,550,000 Assets Current assets: Cash...
You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company’s financial statements, including comparing Lydex’s performance to its major competitors. The company’s financial statements for the last two years are as follows: Lydex Company Comparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 960,000 $ 1,200,000 Marketable securities 0 300,000 Accounts receivable, net 2,700,000 1,800,000 Inventory 3,600,000...
14-15 p3 Lydex Company Comparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 980,000 $ 1,220,000 Marketable securities 0 300,000 Accounts receivable, net 2,780,000 1,880,000 Inventory 3,620,000 2,200,000 Prepaid expenses 260,000 200,000 Total current assets 7,640,000 5,800,000 Plant and equipment, net 9,560,000 9,070,000 Total assets $ 17,200,000 $ 14,870,000 Liabilities and Stockholders' Equity Liabilities: Current liabilities $ 4,030,000 $ 3,020,000 Note payable, 10% 3,680,000 3,080,000 Total liabilities 7,710,000 6,100,000 Stockholders' equity: Common stock, $75 par value 7,500,000...
Lydex Company Comparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 860,000 $ 1,230,000 Marketable securities 0 300,000 Accounts receivable, net 2,820,000 1,920,000 Inventory 3,630,000 2,300,000 Prepaid expenses 260,000 200,000 Total current assets 7,570,000 5,950,000 Plant and equipment, net 9,580,000 9,080,000 Total assets $ 17,150,000 $ 15,030,000 Liabilities and Stockholders' Equity Liabilities: Current liabilities $ 4,550,000 $ 3,040,000 Note payable, 10% 3,680,000 3,080,000 Total liabilities 8,230,000 6,120,000 Stockholders' equity: Common stock, $70 par value 7,000,000 7,000,000 Retained...
1) the times interest earned ratio 2) the debt to equity ratio 3) the gross margin percentage 4) the return on total assets (total assets at the beginning of last hear were 13,070,000) 5) the return on equity(stockholders equity at the beginning of last year totaled 7,990,250) no change in common stock over two years 6) ks the companys financial leverage positive ir negative? $ 960.000 2,700.000 3.600.000 260.000 7.520.000 9.520.000 $17,040,000 $ 1.200.000 300,000 1.800.000 2.000.000 200.000 5,500,000 9.050.000...
You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company’s financial statements, including comparing Lydex’s performance to its major competitors. The company’s financial statements for the last two years are as follows: Lydex Company Comparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 1,000,000 $ 1,240,000 Marketable securities 0 300,000 Accounts receivable, net 2,860,000 1,960,000 Inventory 3,640,000...
You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company's financial statements, including comparing Lydex's performance to its major competitors. The company's financial statements for the last two years are as follows: Lydex Company Comparative Balance Sheet This Year Last Year $ 845,000 Assets Current assets: Cash Marketable securities Accounts receivable, net Inventory Prepaid expenses Total current assets Plant and...