You have just been hired as a financial analyst for LydexCompany, a manufacturer of...

Free

90.2K

Verified Solution

Question

Accounting

You have just been hired as a financial analyst for LydexCompany, a manufacturer of safety helmets. Your boss has asked youto perform a comprehensive analysis of the company’s financialstatements, including comparing Lydex’s performance to its majorcompetitors. The company’s financial statements for the last twoyears are as follows:

Lydex Company
Comparative Balance Sheet
This YearLast Year
Assets
Current assets:
Cash$920,000$1,250,000
Marketable securities0300,000
Accounts receivable, net2,540,0001,640,000
Inventory3,560,0002,100,000
Prepaid expenses250,000190,000
Total current assets7,270,0005,480,000
Plant and equipment, net9,440,0009,010,000
Total assets$16,710,000$14,490,000
Liabilities and Stockholders' Equity
Liabilities:
Current liabilities$3,600,000$2,900,000
Note payable, 10%3,640,0003,040,000
Total liabilities7,240,0005,940,000
Stockholders' equity:
Common stock, $75 par value7,500,0007,500,000
Retained earnings1,970,0001,050,000
Total stockholders' equity9,470,0008,550,000
Total liabilities and stockholders' equity$16,710,000$14,490,000
Lydex Company
Comparative Income Statement and Reconciliation
This YearLast Year
Sales (all on account)$15,820,000$13,180,000
Cost of goods sold12,656,0009,885,000
Gross margin3,164,0003,295,000
Selling and administrative expenses1,000,0001,588,000
Net operating income2,164,0001,707,000
Interest expense364,000304,000
Net income before taxes1,800,0001,403,000
Income taxes (30%)540,000420,900
Net income1,260,000982,100
Common dividends340,000491,050
Net income retained920,000491,050
Beginning retained earnings1,050,000558,950
Ending retained earnings$1,970,000$1,050,000

To begin your assignment you gather the following financial dataand ratios that are typical of companies in Lydex Company’sindustry:

Current ratio2.3
Acid-test ratio1.2
Average collection period40days
Average sale period60days
Return on assets8.8%
Debt-to-equity ratio0.67
Times interest earned ratio5.8
Price-earnings ratio10

Required:

1. Present the balance sheet in common-size format.

Present the balance sheet in common-size format. (Round youranswers to 1 decimal place. Due to rounding, figures may not fullyreconcile down a column.)

Lydex Company
Common-Size Balance Sheets
This YearLast Year
Assets
Current assets:
Cash%%
Marketable securities
Accounts receivable, net
Inventory
Prepaid expenses
Total current assets
Plant and equipment, net
Total assets%%
Liabilities and Stockholders'Equity
Liabilities:
Current liabilities%%
Note payable, 10%
Total liabilities
Stockholders’ equity:
Common stock, $75 par value
Retained earnings
Total stockholders’ equity
Total liabilities andequity%%

2. Present the income statement in common-size format downthrough net income

Present the income statement in common-size format down throughnet income. (Round your answers to 1 decimal place. Due torounding, figures may not fully reconcile down a column.)

Lydex Company
Common-Size Income Statements
This YearLast Year
Sales%%
Cost of goods sold
Gross margin
Selling and administrativeexpenses
Net operating income
Interest expense
Net income before taxes
Income taxes (30%)
Net income%%

.

Answer & Explanation Solved by verified expert
3.8 Ratings (610 Votes)

Solution

Lydex Company
Common size Balance Sheet
This Year Last Year
Assets
Current assets:
Cash 5.5% 8.6%
Marketable securities 0.0% 2.1%
Accounts receivable, net 15.2% 11.3%
Inventory 21.3% 14.5%
Prepaid expenses 1.5% 1.3%
Total current assets 43.5% 37.8%
Plant and equipment, net 56.5% 62.2%
Total assets 100.0% 100.0%
Liabilities and Stockholders' Equity
Liabilities:
Current liabilities 21.5% 20.0%
Bonds payable, 12% 21.8% 21.0%
Total liabilities 43.3% 41.0%
Stockholders' equity:
Common stock, $15 par value 44.9% 51.8%
Retained earnings 11.8% 7.2%
Total stockholders' equity 56.7% 59.0%
Total liabilities and stockholders' equity 100.0% 100.0%

.

Lydex Company
Common size income statement
This Year Last Year
Sales (all on account) 100.0% 100.0%
Cost of goods sold 80.0% 75.0%
Gross margin 20.0% 25.0%
Selling and administrative expenses 6.3% 12.0%
Net operating income 13.7% 13.0%
Interest expense 2.3% 2.3%
Net income before taxes 11.4% 10.6%
Income taxes (30%) 3.4% 3.2%
Net income 8.0% 7.5%

.


Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

In: AccountingYou have just been hired as a financial analyst for LydexCompany, a manufacturer of safety...You have just been hired as a financial analyst for LydexCompany, a manufacturer of safety helmets. Your boss has asked youto perform a comprehensive analysis of the company’s financialstatements, including comparing Lydex’s performance to its majorcompetitors. The company’s financial statements for the last twoyears are as follows:Lydex CompanyComparative Balance SheetThis YearLast YearAssetsCurrent assets:Cash$920,000$1,250,000Marketable securities0300,000Accounts receivable, net2,540,0001,640,000Inventory3,560,0002,100,000Prepaid expenses250,000190,000Total current assets7,270,0005,480,000Plant and equipment, net9,440,0009,010,000Total assets$16,710,000$14,490,000Liabilities and Stockholders' EquityLiabilities:Current liabilities$3,600,000$2,900,000Note payable, 10%3,640,0003,040,000Total liabilities7,240,0005,940,000Stockholders' equity:Common stock, $75 par value7,500,0007,500,000Retained earnings1,970,0001,050,000Total stockholders' equity9,470,0008,550,000Total liabilities and stockholders' equity$16,710,000$14,490,000Lydex CompanyComparative Income Statement and ReconciliationThis YearLast YearSales (all on account)$15,820,000$13,180,000Cost of goods sold12,656,0009,885,000Gross margin3,164,0003,295,000Selling and administrative expenses1,000,0001,588,000Net operating income2,164,0001,707,000Interest expense364,000304,000Net income before taxes1,800,0001,403,000Income taxes (30%)540,000420,900Net income1,260,000982,100Common dividends340,000491,050Net income retained920,000491,050Beginning retained earnings1,050,000558,950Ending retained earnings$1,970,000$1,050,000To begin your assignment you gather the following financial dataand ratios that are typical of companies in Lydex Company’sindustry:Current ratio2.3Acid-test ratio1.2Average collection period40daysAverage sale period60daysReturn on assets8.8%Debt-to-equity ratio0.67Times interest earned ratio5.8Price-earnings ratio10Required:1. Present the balance sheet in common-size format.Present the balance sheet in common-size format. (Round youranswers to 1 decimal place. Due to rounding, figures may not fullyreconcile down a column.)Lydex CompanyCommon-Size Balance SheetsThis YearLast YearAssetsCurrent assets:Cash%%Marketable securitiesAccounts receivable, netInventoryPrepaid expensesTotal current assetsPlant and equipment, netTotal assets%%Liabilities and Stockholders'EquityLiabilities:Current liabilities%%Note payable, 10%Total liabilitiesStockholders’ equity:Common stock, $75 par valueRetained earningsTotal stockholders’ equityTotal liabilities andequity%%2. Present the income statement in common-size format downthrough net incomePresent the income statement in common-size format down throughnet income. (Round your answers to 1 decimal place. Due torounding, figures may not fully reconcile down a column.)Lydex CompanyCommon-Size Income StatementsThis YearLast YearSales%%Cost of goods soldGross marginSelling and administrativeexpensesNet operating incomeInterest expenseNet income before taxesIncome taxes (30%)Net income%%.

Other questions asked by students