Question

Comprehensive Ratio Analysis The Jimenez Corporation's forecasted 2020 financial statements follow, along with some industry average ratios. Jimenez Corporation: Forecasted Balance Sheet as of December 31, 2020 Assets Cash $    72,000 Accounts receivable 439,000 Inventories 894,000   Total current assets $1,405,000 Fixed assets 431,000 Total assets $1,836,000 Liabilities and Equity Accounts payable $   332,000 Notes payable    112,000 Accruals 158,000   Total current liabilities $   602,000 Long-term debt 404,230 Common stock 575,060 Retained earnings 254,710 Total liabilities and equity $1,836,000 Jimenez Corporation: Forecasted Income Statement for 2020 Sales $4,290,000 Cost of goods sold 3,690,000 Selling, general, and administrative expenses 414,456   Earnings before interest and taxes (EBIT) $   185,544 Interest expense 50,000   Earnings before taxes (EBT) $   135,544 Taxes (25%) 33,886 Net income $   101,658 Jimenez Corporation: Per Share Data for 2020 EPS $  4.42 Cash dividends per share $  0.95 P/E ratio 4.0 Market price (average) $17.68 Number of shares outstanding 23,000 Industry Ratiosa Quick ratio 1.0 Current ratio 2.7 Inventory turnoverb 7.0 Days sales outstandingc 32.0 days Fixed assets turnoverb 13.0 Total assets turnoverb 2.6 Return on assets 9.1 % Return on equity 18.2 % Profit margin on sales 3.5 % Debt-to-assets ratio 21.0 % Liabilities-to-assets ratio 50.0 % P/E ratio 5.0 Market/Book ratio 3.5 Notes: aIndustry average ratios have been stable for the past 4 years. bBased on year-end balance sheet figures. cCalculation is based on a 365-day year. Calculate Jimenez's 2020 forecasted ratios, compare them with the industry average data, and comment briefly on Jimenez's projected strengths and weaknesses. Assume that there are no changes from the prior period to any of the operating balance sheet accounts. Do not round intermediate calculation. Round your answers to two decimal places. Ratios Firm Industry Comment Quick ratio 1.0 -Select-StrongWeakItem 2 Current ratio 2.7 -Select-StrongWeakItem 4 Inventory turnover 7.0 -Select-PoorHighItem 6 Days sales outstanding days 32 days   -Select-PoorHighItem 8 Fixed assets turnover 13.0   -Select-PoorHighItem 10 Total assets turnover 2.6 -Select-PoorHighItem 12 Return on assets %    9.1% -Select-BadGoodItem 14 Return on equity % 18.2% -Select-BadGoodItem 16 Profit margin on sales %   3.5% -Select-BadGoodItem 18 Debt-to-assets ratio % 21.0% -Select-LowHighItem 20 Liabilities-to-assets ratio % 50.0% -Select-LowHighItem 22 P/E ratio 5.0 -Select-PoorHighItem 24 Market/Book ratio 3.5 -Select-PoorHighItem 26 So, the firm appears to be -Select-badlywellItem 27 managed.

		Continue without saving

Answer 1

Ratios	Firm	Industry	Comment
Quick ratio = (72000+439000)/602000 =	0.8	1.0	Weak
Current ratio = 1405000/602000 =	2.3	2.7	Weak
Inventory turnover = 3690000/894000 =	4.1	7.0	Poor
Days sales outstanding = 439000*365/4290000 =	37.4 days	32 days	Poor
Fixed assets turnover = 4290000/431000 =	10.0	13.0	Poor
Total assets turnover = 4290000/1836000 =	2.3	2.6	Poor
Return on assets =101658/1836000=	5.5%	9.1%	Bad
Return on equity = 101658/(575060+254710) =	12.3%	18.2%	Bad
Profit margin on sales = 101658/4290000 =	2.4%	3.5%	Bad
Debt-to-assets ratio = 404230/1836000 =	22.0%	21.0%	High
Liabilities-to-assets ratio = (602000+404230/1836000 =	54.81%	50.00%	High
P/E ratio = 17.68/4.42 =	4.0	5.0	Poor
Market/Book ratio =17.68/(829770/23000) =	0.5	3.5	Poor
So, the firm appears to be badly managed.