Ans. A | Working capital = Total current assets - Total current liabilities | |||
This year | $7,580,000 - $4,020,000 | 3560000 | ||
Last year | $5,650,000 - $3,000,000 | 2650000 | ||
Ans. B | Current ratio = Total current assets / Total current liabilities | |||
This year | $7,580,000 / $4,020,000 | 1.83 : 1 | ||
Last year | $5,650,000 / $3,000,000 | 1.86 : 1 | ||
Ans. C | Quick ratio = (Total current assets - Inventory - Prepaid expenses) / Total current liabilities | |||
This year | ($7,580,000 - $3,610,000 - $260,000) / $4,020,000 | 0.92 : 1 | ||
Last year | ($5,650,000 - $2,100,000 - $200,000) / $3,000,000 | 1.12 : 1 | ||
Ans. D | Average collection period = No. of days in year / Net credit sales * Average accounts receivables | |||
This year | 365 / $15,870,000 * $2,290,000 | 52.67 | days | |
Last year | 365 / $13,680,000 * $1,760,000 | 46.96 | days | |
*Average receivable = (Beginning receivables + Ending receivables) / 2 | ||||
This year | ($1,840,000 + $2,740,000) / 2 | $2,290,000 | ||
Last year | ($1,680,000 + $1,840,000) / 2 | $1,760,000 | ||
Ans. E | Average sales period = No. of days in year / Cost of goods sold * Average inventory | |||
This year | 365 / $12,696,000 * $2,855,000 | 82.08 | days | |
Last year | 365 / $10,260,000 * $2,070,000 | 73.64 | days | |
*Average inventory = (Beginning inventory + Ending inventory) / 2 | ||||
This year | ($2,100,000 + $3,610,000) / 2 | $2,855,000 | ||
Last year | ($2,040,000 + $2,100,000) / 2 | $2,070,000 | ||
Ans. F | Operating cycle = Average collection period + Average sales period | |||
This year | 52.67 + 82.08 | 134.75 | days | |
Last year | 46.96 + 73.64 | 120.60 | days | |
Ans. G | Total assets turnover = Sales / Average operating assets | |||
This year | $15,870,000 / $15,915,000 | 1.00 | times | |
Last year | $13,680,000 / $14,665,000 | 0.93 | times | |
*Average assets = (Beginning assets + Ending assets) / 2 | ||||
This year | ($14,710,000 + $17,120,000) / 2 | $15,915,000 | ||
Last year | ($14,620,000 + $14,710,000) / 2 | $14,665,000 | ||
Problem 14-15 Comprehensive Ratio Analysis (LO14-2, LO14-3, LO14-4, LO14-5, LO14-6) [The following information applies to the...
Required information Problem 14-15 Comprehensive Ratio Analysis [LO14-2, LO14-3, LO14-4, LO14-5, LO14-6] [The following information applies to the questions displayed below.] 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...
Problem 14-15 Comprehensive Ratio Analysis [LO14-2, LO14-3, LO14-4, LO14-5, LO14-6] [The following information applies to the questions displayed below.] 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...
Required information Problem 14-15 Comprehensive Ratio Analysis [LO14-2, LO14-3, LO14-4, LO14-5, LO14-6] [The following information applies to the questions displayed below.] 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...
Required information Problem 14-15 Comprehensive Ratio Analysis [LO14-2, LO14-3, LO14-4, LO14-5, LO14-6] [The following information applies to the questions displayed below.] 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...
Required information Problem 14-15 Comprehensive Ratio Analysis [LO14-2, LO14-3, LO14-4, LO14-5, LO14-6] [The following information applies to the questions displayed below.] 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...
Please answer part 1, 2 and 3.
Required information Problem 15-15 Comprehensive Ratio Analysis [L015-2, Lo15-3, LO15-4, Lo15-5, LO15-6) The following information applies to the questions displayed below] 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:...
Required information [The following information applies to the questions displayed below.] 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 $ 970,000 $ 1,210,000...
PLEASE HELP!
Problem 15-15 Comprehensive Ratio Analysis [LO15-2, LO15-3,
LO15-4, LO15-5, LO15-6]
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
$
900,000
$...
Required information [The following information applies to the questions displayed below.] 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 $ 970,000 $ 1,210,000...
Required information [The following information applies to the questions displayed below.] 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 $ 980,000 0 2,780,000 3,620,000 260,000 7,640,000 9,560,000...