Comprehensive Ratio Analysis The Jimenez Corporation's forecasted 2019 financial statements follow, along with some industry average ratios. Jimenez...

50.1K

Verified Solution

Question

Accounting

Comprehensive Ratio Analysis

The Jimenez Corporation's forecasted 2019 financial statementsfollow, along with some industry average ratios.

Jimenez Corporation: Forecasted Balance Sheet as ofDecember 31, 2019

Assets
Cash$    68,000
Accounts receivable439,000
Inventories898,000
  Total current assets$1,405,000
Fixed assets431,000
Total assets$1,836,000
Liabilities and Equity
Accounts payable$   332,000
Notes payable   118,000
Accruals152,000
  Total current liabilities$   602,000
Long-term debt403,750
Common stock575,540
Retained earnings254,710
Total liabilities and equity$1,836,000

Jimenez Corporation: Forecasted Income Statement for2019

Sales$4,290,000
Cost of goods sold (excluding depreciation)3,580,000
Selling, general, and administrative expenses379,320
Depreciation150,000
  Earnings before taxes (EBT)$   180,680
Taxes (40%)72,272
Net income$   108,408
Jimenez Corporation: Per Share Data for2019
EPS$        4.71
Cash dividends per share$        0.95
P/E ratio4.0
Market price (average)$      18.85
Number of shares outstanding23,000

Industry Ratiosa
Quick ratio1.0
Current ratio2.7
Inventory turnoverb7.0
Days sales outstandingc32.0days
Fixed assets turnoverb13.0
Total assets turnoverb2.6
Return on assets9.1%
Return on equity18.2%
Profit margin on sales3.5%
Debt-to-assets ratio21.0%
Liabilities-to-assets ratio50.0%
P/E ratio5.0
Price/Cash flow ratio3.5
Market/Book ratio3.5
Notes:
aIndustry average ratios have beenstable for the past 4 years.
bBased on year-end balance sheetfigures.
cCalculation is based on a 365-dayyear.

Calculate Jimenez's 2019 forecasted ratios, compare them withthe industry average data, and comment briefly on Jimenez'sprojected strengths and weaknesses. Assume that there are nochanges from the prior period to any of the operating balance sheetaccounts. Do not round intermediate calculation. Round DSO to thenearest whole number. Round the other ratios to one decimalplace.

RatiosFirmIndustryComment
Quick ratio1.0-Select-StrongWeakItem 2
Current ratio2.7-Select-StrongWeakItem 4
Inventory turnover7.0-Select-PoorHighItem 6
Days sales outstandingdays32 days   -Select-PoorHighItem 8
Fixed assets turnover13.0  -Select-PoorHighItem 10
Total assets turnover2.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 ratio%21.0%-Select-LowHighItem 20
Liabilities-to-assets%50.0%-Select-LowHighItem 22
EPS$4.71n.a.--
Stock Price$23.57n.a.--
P/E ratio5.0-Select-PoorHighItem 24
Price/Cash flow ratio3.5-Select-PoorHighItem 26
Market/Book ratio3.5-Select-PoorHighItem 28

So, the firm appears to be -Select- managed.

The "Comment" section column is blank.

Answer & Explanation Solved by verified expert
4.0 Ratings (744 Votes)
Ratios Computation Firm Industry Comment Each compared to industry average Quick ratio Quick assets current liabilities 68000 439000 602000 08 10 Weak Current ratio Current assets current liabilities 1405000602000 23 27 weak Inventory turnover Cogs Average    See Answer
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

Other questions asked by students