Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show all work. Thanks a lot! Jimenez Corporation: Forecasted Balance Sheet as of December 31, 2011 Assets Cash $72,000 Accounts receivable 439,000 Inventories 894,000

Please show all work. Thanks a lot!

Jimenez Corporation: Forecasted Balance Sheet as of December 31, 2011

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 and notes payable $432,000

Accruals 170,000

________

Total current liabilities $602,000

Long-term debt 404,290

Common stock 575,000

Retained earnings 254,710

____________

Total liabilities and equity $1,836,000

________

____________

Jimenez Corporation: Forecasted Income Statement for 2011

Sales $4,290,000

Cost of Goods Sold 3,580,000

Selling, general, and administrative expenses 370,320

Depreciation 159,000

Earnings before taxes (EBT) $180,680

Taxes (40%) 72,272

___________

Net income $108,408

___________

__________

Per share data

EPS $4.71

Cash dividends per share $0.95

P/E ratio 5

Market price (average) $23.57

Number of shares outstanding 23,000

Industry Financial Ratios (2010) - Industry average ratios have been constant for the past 4 years.

Quick ratio 1.0

Current ratio 2.7

Inventory turnover (based on year-end balance sheet figures) 7.0

Days sales outstanding (calculation is based on a 365-day year) 32 days

Fixed assets turnover (based on year-end balance sheet figures) 13.0

Total assets turnover (based on year-end balance sheet figures) 2.6

Return on assets 9.1%

Return on equity 18.2%

Debt ratio 50.0%

Profit margin on sales 3.5%

P/E ratio 6.0

Price/Cash flow ratio 3.5

a. Calculate Jimenez's 2011 forecasted ratios, compare them with the industry average data, and comment briefly on Jimenez's projected strengths and weaknesses.

b. What do you think would happen to Jimenez's ratios if the company initiated cost-cutting measures that allowed it to hold lower levels of inventory and substantially decreased the cost of goods sold. No calculations are necessary. Think about which ratios would be affected by changes in these two accounts.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Short Term Financial Management

Authors: Ned C. Hill, William L. Sartoris

3rd Edition

0023548320, 978-0023548321

More Books

Students also viewed these Finance questions

Question

What data type does the format specifier % d work with?

Answered: 1 week ago

Question

an element of formality in the workplace between different levels;

Answered: 1 week ago