Question

In: Finance

The Jimenez Corporation's forecasted 2020 financial statements follow, along with some industry average ratios. Jimenez Corporation:...

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    120,000
Accruals 150,000
  Total current liabilities $   602,000
Long-term debt 403,510
Common stock 575,780
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,719,000
Selling, general, and administrative expenses 396,456
  Earnings before interest and taxes (EBIT) $   174,544
Interest expense 30,000
  Earnings before taxes (EBT) $   144,544
Taxes (25%) 36,136
Net income $   108,408
Jimenez Corporation: Per Share Data for 2020
EPS $  4.71
Cash dividends per share $  0.95
P/E ratio 4.0
Market price (average) $18.85
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.

Solutions

Expert Solution


Related Solutions

Comprehensive Ratio Analysis The Jimenez Corporation's forecasted 2020 financial statements follow, along with some industry average...
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 $    71,000 Accounts receivable 439,000 Inventories 895,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    110,000 Accruals 160,000   Total current liabilities $   602,000 Long-term debt 403,490 Common stock 575,800 Retained earnings 254,710 Total liabilities and equity $1,836,000 Jimenez Corporation: Forecasted Income Statement for...
Comprehensive Ratio Analysis The Jimenez Corporation's forecasted 2019 financial statements follow, along with some industry average...
Comprehensive Ratio Analysis The Jimenez Corporation's forecasted 2019 financial statements follow, along with some industry average ratios. Jimenez Corporation: Forecasted Balance Sheet as of December 31, 2019 Assets Cash $    68,000 Accounts receivable 439,000 Inventories 898,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    118,000 Accruals 152,000   Total current liabilities $   602,000 Long-term debt 403,750 Common stock 575,540 Retained earnings 254,710 Total liabilities and equity $1,836,000 Jimenez Corporation: Forecasted Income Statement for...
Problem 7-14 Comprehensive Ratio Analysis The Jimenez Corporation's forecasted 2016 financial statements follow, along with some...
Problem 7-14 Comprehensive Ratio Analysis The Jimenez Corporation's forecasted 2016 financial statements follow, along with some industry average ratios. Jimenez Corporation: Forecasted Balance Sheet as of December 31, 2016 Assets Cash $    78,000 Accounts receivable 462,000 Inventories 875,000   Total current assets $1,415,000 Fixed assets 432,000 Total assets $1,847,000 Liabilities and Equity Accounts payable $   335,000 Notes payable    95,000 Accruals 176,000   Total current liabilities $   606,000 Long-term debt 405,590 Common stock 555,000 Retained earnings 280,410 Total liabilities and equity $1,847,000 Jimenez Corporation: Forecasted Income...
Question C Company’s forecasted 2020 financial statements are given below, along with industry average ratios.                         
Question C Company’s forecasted 2020 financial statements are given below, along with industry average ratios.                                                                                     C Company: Forecasted Balance sheet as of December 31, 2020 Cash 72,000 Accounts Receivable 439,000 Inventories 894,000 Total Current Assets 1,405,000 Land and Buildings 238,000 Machinery 132,000 Other Fixed assets 61,000 Total Assets ,1,836,000 Equity & Liabilities Accounts and Notes Payable 432,000 Accrued liabilities 170,000 Total Current liabilities 602,000 Long term Debt 404,290 Common stock 575,000 Retained earnings 254,710 Total Equity & Liabilities...
Show ALL work Ratio Analysis. The Williams Corporation’s forecasted 2010 financial statements follow, along with some...
Show ALL work Ratio Analysis. The Williams Corporation’s forecasted 2010 financial statements follow, along with some industry average ratios. Forecasted Balance Sheet as of December 31, 2010 Cash $ 72,000 Accounts receivables $ 439,000 Accounts and notes payable $ 432,000 Inventories $ 894,000 Accruals $ 170,000 Total current assets $1,405,000 Total current liabilities $ 602,000 Land and building $ 238,000 Long-term debt $ 404,290 Machinery $ 132,000 Common stock $ 575,000 Other fixed assets $ 61,000 Retained earnings $ 254,710...
Question No. 1 (Marks 15) C Company’s forecasted 2020 financial statements are given below, along with...
Question No. 1 (Marks 15) C Company’s forecasted 2020 financial statements are given below, along with industry average ratios.                                                                                     C Company: Forecasted Balance sheet as of December 31, 2020 Cash 72,000 Accounts Receivable 439,000 Inventories 894,000 Total Current Assets 1,405,000 Land and Buildings 238,000 Machinery 132,000 Other Fixed assets 61,000 Total Assets ,1,836,000 Equity & Liabilities Accounts and Notes Payable 432,000 Accrued liabilities 170,000 Total Current liabilities 602,000 Long term Debt 404,290 Common stock 575,000 Retained earnings 254,710...
Facebook industry average financial ratios FACEBOOK, INC. RATIO ANALYSIS Industry Average Profitability Ratios Operating Margin Net...
Facebook industry average financial ratios FACEBOOK, INC. RATIO ANALYSIS Industry Average Profitability Ratios Operating Margin Net Profit Margin Return on Equity Financial Strength Ratios Current Ratio Debt-Equity Ratio
Select all the correct statements based on the following company and industry ratios Company Industry average...
Select all the correct statements based on the following company and industry ratios Company Industry average ROE 15% 18% ROA 13% 10% PM 11% 11.5% FATO 38 97 EM 14% 12% . The company should reevaluate its pricing strategy and seek higher quality suppliers . The company should rely more on debt financing . The company should issue more stock and use the proceeds to pay down debt . The company should invest more in property plant and equipment. ....
Problem 3-29 Market Value Ratios [LO2] Some recent financial statements for Smolira Golf Corp. follow.   ...
Problem 3-29 Market Value Ratios [LO2] Some recent financial statements for Smolira Golf Corp. follow.    SMOLIRA GOLF CORP. 2014 and 2015 Balance Sheets Assets Liabilities and Owners’ Equity 2014 2015 2014 2015   Current assets   Current liabilities       Cash $ 24,086 $ 24,500       Accounts payable $ 23,584 $ 27,500       Accounts receivable 12,848 15,600       Notes payable 15,000 11,200       Inventory 26,042 27,500       Other 11,971 18,300         Total $ 62,976 $ 67,600         Total $ 50,555 $ 57,000   Long-term debt $ 60,000 $ 73,000   Owners’ equity...
Financial Statements and Ratios
Problem:4The Fashion Place has an inventory valued at $875,000 on January 1. During January, stock costing $235,800 was purchased. At the end of January, the merchandise inventory is $685,255. What is the cost of goods sold for January? Problem:5The Luggage Emporium had net sales of $87,657 in October. The cost of goods sold in October was $43,775. What was the gross profit for October?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT