Question

In: Finance

The condensed financial statements of Jenner Corporation for 2011 are presented below. Malli Burton Malli Burton...

The condensed financial statements of Jenner Corporation for 2011 are presented below.

Malli Burton Malli Burton

Balance Sheet Income Statement

December 31, 2014 For the Year Ended December 31, 2014

Assets Revenues $500,000

Current assets Expenses

Cash and short-term Cost of goods sold 255,000

investments $ 15,000 Selling and administrative

Accounts receivable 17,500 expenses 170,000

Inventories 35,000 Interest expense 12,500

Total current assets 67,500 Total expenses 437,500

Property, plant, and Income before income taxes 62,500

equipment (net) 182,500 Income tax expense 25,000

Total assets $250,000 Net income $ 37,500

Liabilities and Stockholders' Equity

Current liabilities $ 25,000

Long-term liabilities 95,000

Stockholders' equity 130,000

Total liabilities and

stockholders' equity $250,000

Additional data as of December 31, 2013: Inventory = $31,000; Total assets = $210,000; Stockholders' equity = $140,000.

Instructions: Compute the following ratios for 2014 showing supporting calculations.

(a) Current ratio = .

(b) Debt to total assets ratio = .

(c) Times interest earned = .

(d) Inventory turnover = .

(e) Profit margin = .

(f) Return on stockholders' equity = .

(g) Return on assets = .

Solutions

Expert Solution

Jenner Corporation
a) Current Ratio
Current Assets/Current Liabilites
Current Assets
Cash & Short term Investment $                  15,000.00
Accounts Receivable $                  17,500.00
Inventories $                  35,000.00
Total Current Assets=(A) $                  67,500.00
Current Liabities
Total Current Liabilites=(B) $                  25,000.00
Current Ratio=(A)/(B) 2.70:1
b) Debt to Assets Ratio=Total Debt/Total Assets
Total Debt=Current liabilites+ Long Term liabilities=($25000+$95000)=(A) $              1,20,000.00
Total Assets=(B) $              2,50,000.00
Debt Ratio=Total Debt/Total Assets=(A)/(B)=($16238/$28362) 0.48
c ) Times Interest Earned=Income before interest and inome tax/Interest
Income before interest and income tax=($62500+$12500)=(A) $                  75,000.00
Interest=(B) $                  12,500.00
Times Interest Earned=(A)/(B) 6.00 Times
d) Inventory Turnover
Cost of goods sold=(A) $              2,55,000.00
Beginning Inventoery $                  31,000.00
Ending Inventory $                  35,000.00
Average Inventory=(Beginning Inventory+Ending Inventory/2)=($31000+$35000)/2=(B) $                  33,000.00
Accounts Receivable Turnover=Sales/Average accounts receivable=(A)/(B) 7.73 Times
e) Profit Margin=Net Income after tax/Sales
Net Income after tax=(A) $                  37,500.00
Sales=(B) $              5,00,000.00
Profit Margin=Net Income after tax/Sales=(A)/(B) 7.50%
f) Return on Stockholder's Equity
Net Income after tax/Total Stockholders equity
Net Income after tax=(A) $                  37,500.00
Total Stockholders Equity=(B) $              1,30,000.00
Return on Stockholder's Equity=(A)/(B) 28.85%
OR
Return on Average stockholder's Equity
Net Income after tax/Average Stockholders equity
Net Income after tax=(A) $                  37,500.00
Beginning Equity $              1,40,000.00
Ending Equity $              1,30,000.00
Average Stockholder's equity=(Beginning Equity+Ending Eqity)/2=($140000+$130000)/2=(B) $              1,35,000.00
Return on Average stockholder's Equity=(A)/(B) 27.78%
g) Return on Assets
Return on total assets=Earnings before interest and income tax/Total Assets
Earnings before interest and income tax($62500+$12500)=(A) $                  75,000.00
Total Assets=(B) $              2,50,000.00
Return on Total Assets=(A)/(B) $                             0.30
OR
Return on Total Assets
Net Income before interest and tax/Average Total Assets
NEt Income before interest and tax=(A) $                  75,000.00
Beginning Total Assets $              2,10,000.00
Ending Total Assets $              2,50,000.00
Average Total Assets=(Beginning Total Assets+Ending Total Assets)/2=($210000+$250000)/2=(B) $              2,30,000.00
Return on Total Assets=(A)/(B) 32.61%

Related Solutions

The condensed financial statements of Murawski Company for the years 2014 and 2015 are presented below....
The condensed financial statements of Murawski Company for the years 2014 and 2015 are presented below. MURAWSKI COMPANY Balance Sheets December 31 2015 2014 Current assets     Cash and cash equivalents $ 364 $ 367     Accounts receivable (net) 387 466     Inventory 373 446     Prepaid expenses 140 131       Total current assets 1,264 1,410 Property, plant, and equipment 363 434 Investments 11 11 Intangibles and other assets 530 545       Total assets $2,168 $2,400 Current liabilities $ 801 $ 881 Long-term liabilities 355 406...
The condensed financial statements of Ness Company for the years 2016 and 2017 are presented below....
The condensed financial statements of Ness Company for the years 2016 and 2017 are presented below. NESS COMPANY Balance Sheets December 31 (in thousands) 2017 2016 Current assets Cash and cash equivalents $330 $360 Accounts receivable (net) 470 400 Inventory 460 390 Prepaid expenses 130 160 Total current assets 1,390 1,310 Property, plant, and equipment (net) 410 380 Investments 10 10 Intangibles and other assets 530 510 Total assets $2,340 $2,210 Current liabilities $820 $790 Long-term liabilities 480 380 Stockholders’...
Presented below are condensed financial statements adapted from those of two actual companies competing in the...
Presented below are condensed financial statements adapted from those of two actual companies competing in the pharmaceutical industry—Benatar and Jett, Inc. ($ in millions, except per share amounts). Balance Sheets ($ in millions, except per share data) Benatar Jett Assets: Cash $ 18,143 $ 12,398 Short-term investments 6,390 12,646 Accounts receivable (net) 9,184 11,385 Inventory 6,016 10,135 Other current assets 6,100 5,965 Current assets 45,833 52,529 Property, plant, and equipment (net) 16,254 24,695 Intangibles and other assets 20,030 73,355 Total...
The condensed financial statements of Murawski Company for the years 2016 and 2017 are presented below. (Amounts in thousands.)
The condensed financial statements of Murawski Company for the years 2016 and 2017 are presented below. (Amounts in thousands.)     Compute the following ratios for 2017 and 2016. (a) Current ratio. (b) Inventory turnover. (Inventory on 12/31/15 was $340.) (c) Profit margin. (d) Return on assets. (Assets on 12/31/15 were $1,900.) (e) Return on common stockholders’ equity. (Stockholders’ equity on 12/31/15 was $900.) (f) Debt to assets ratio. (g) Times interest earned.
The condensed financial statements of Marks Company for the years 2014-2015 are presented below: Marks Company...
The condensed financial statements of Marks Company for the years 2014-2015 are presented below: Marks Company Comparative Balance Sheets As of December 31, 2014 and 2015 2015    2014    Cash $367,000 $134,000 Accounts receivable (net) 373,000    308,000    Inventories 379,000    342,000    Plant and equipment 1,850,000 1,116,000 Accumulated depreciation (263,000 ) (192,000 )    $2,706,000 $1,708,000    Accounts payable $342,000 $163,000 Dividends payable -0-    43,000    Bonds payable 400,000    -0- Common stock ($10 par) 1,523,000...
Presented below are condensed financial statements adapted from those of two actual companies competing in the...
Presented below are condensed financial statements adapted from those of two actual companies competing in the pharmaceutical industry—Johnson and Johnson (J&J) and Pfizer, Inc. ($ in millions, except per share amounts). Balance Sheets ($ in millions, except per share data) J&J Pfizer Assets: Cash $ 5,377 $ 1,520 Short-term investments 4,146 10,432 Accounts receivable (net) 6,574 8,775 Inventories 3,588 5,837 Other current assets 3,310 3,177 Current assets 22,995 29,741 Property, plant, and equipment (net) 9,846 18,287 Intangibles and other assets...
The comparative condensed balance sheets of Gurley Corporation are presented below. GURLEY CORPORATION Comparative Condensed Balance...
The comparative condensed balance sheets of Gurley Corporation are presented below. GURLEY CORPORATION Comparative Condensed Balance Sheets December 31 2017 2016 Assets     Current assets $ 73,800 $ 79,400     Property, plant, and equipment (net) 97,100 91,200     Intangibles 27,400 40,200       Total assets $198,300 $210,800 Liabilities and stockholders’ equity     Current liabilities $ 40,400 $ 49,200     Long-term liabilities 143,200 148,000     Stockholders’ equity 14,700 13,600       Total liabilities and stockholders’ equity $198,300 $210,800 b) Prepare a vertical analysis of the balance sheet data for Gurley Corporation...
3. Presented below are condensed financial statements adapted from Target and Wal-Mart ($ in millions, except...
3. Presented below are condensed financial statements adapted from Target and Wal-Mart ($ in millions, except per share amounts). Balance Sheets ($ in millions, except per share data) Target Wal-Mart Assets: Cash and cash equivalents $ 2,643 $ 6,756 Accounts receivable (net) 416 5,614 Inventories 8,657 43,783 Other current assets 848 3,511 Current assets 12,564 59,664 Property, plant, and equipment (net) 25,018 107,675 Intangibles and other assets 1,417 37,183 Total assets $ 38,999 $ 204,522 Liabilities and Shareholders' Equity: Accounts...
The condensed financial statements of Oriole Company for the years 2019 and 2020 are presented as...
The condensed financial statements of Oriole Company for the years 2019 and 2020 are presented as follows. (Amounts in thousands.) ORIOLE COMPANY Balance Sheets December 31 2020 2019 Current assets    Cash and cash equivalents $330 $360    Accounts receivable (net) 660 590    Inventory 600 530    Prepaid expenses 120 160      Total current assets 1,710 1,640 Investments 200 200 Property, plant, and equipment 420 380 Intangibles and other assets 530 510      Total assets $2,860 $2,730 Current liabilities $1,090 $980 Long-term liabilities 550 520...
The condensed financial statements of Sunland Company for the years 2016 and 2017 are presented as...
The condensed financial statements of Sunland Company for the years 2016 and 2017 are presented as follows. (Amounts in thousands.) SUNLAND COMPANY Balance Sheets December 31 2017 2016 Current assets    Cash and cash equivalents $330 $360    Accounts receivable (net) 490 420    Inventory 660 590    Prepaid expenses 120 160      Total current assets 1,600 1,530 Investments 30 30 Property, plant, and equipment (net) 420 380 Intangibles and other assets 530 510      Total assets $2,580 $2,450 Current liabilities $920 $810 Long-term liabilities 610...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT