Question

In: Finance

Rainbow Beauty Goods just provided the following balance sheet and income statement items. Assume that the...

Rainbow Beauty Goods just provided the following balance sheet and income statement items. Assume that the stock price is $10 per share. All data are in thousands of dollars.

Net income                                                                             400

Net plant and equipment                                                        2500

Notes payable                                                                         300

Accounts Payable                                                                   500

Accounts Receivable                                                              600

Addition to retained earnings                                                 250

Cash and equivalents                                                              200

Common stock                                                                       100

Cost of goods sold                                                                  3700

Depreciation                                                                           300

Dividends on common shares                                                150

Gross profit                                                                            2300

Interest expense                                                                      100

Inventories                                                                              700

Long term debt                                                                       1100

Other current liabilities                                                          500

Retained earnings                                                                   1500

Sales                                                                                       6000

Selling, general and administrative expenses                        1200

Taxes                                                                                      300

Total Shares Outstanding                                                       800

  1. Calculate firm’s Current ratio.
  2. Calculate firm’s Quick Ratio
  3. Calculate firm’s ROE.
  4. Calculate firm’s Net Profit Margin.
  5. Calculate firm’s EPS (Earnings per Share).

Solutions

Expert Solution

Answer of Part a:

Current Assets = Accounts Receivable + Cash and Equivalents + Inventories
Current Assets = $600 + $200 + $700
Current Assets = $1,500

Current Liabilities = Notes Payable + Accounts Payable + Other Current Liabilities
Current Liabilities = $300 + $500 + $500
Current Liabilities = $1,300

Current Ratio = Current Assets / Current Liabilities
Current Ratio = $1,500 / $1,300
Current Ratio = 1.15

Answer of Part b:

Quick ratio = (Current Assets - Inventories) / Current Liabilities
Quick ratio = ($1,500 - $700) / $1,300
Quick Ratio = $800 / $1,300
Quick Ratio = 0.62

Answer of Part c:

Total Equity = Common Stock + Retained Earnings
Total Equity = $100 + $1,500
Total Equity = $1,600

ROE = Net Income / Total Equity
ROE = $400 / $1,600
ROE = 25.00%

Answer of Part d:

Net Profit Margin = Net Income / Sales * 100
Net Profit Margin = $400 / $6,000 * 100
Net Profit Margin = 6.67%

Answer of Part e:

EPS = Earnings Available for Common Stockholders / Total Share Outstanding
EPS = $400 / 800
EPS = $0.5

jeff jeffy answered 8 months ago
Next > < Previous

Related Solutions

Forecasting the Income Statement, Balance Sheet, and Statement of Cash Flows Assume the following are the...
Forecasting the Income Statement, Balance Sheet, and Statement of Cash Flows Assume the following are the financial statements of Nike, Inc. Consolidated Statements of Income Year ended May 31 In Millions 2011 2010 Revenues $ 21,862 $ 20,014 Cost of sales 11,354 10,214 Gross profit 10,508 9,800 Demand creation expense 3,248 2,356 Operating overhead expense 4,345 3,970 Total selling and administrative expense 7,593 6,326 Interest expense (income), net 4 6 Other (income) (33) (49) Income before income taxes 2,944 3,517...
Forecasting the Income Statement, Balance Sheet, and Statement of Cash Flows Assume the following are the...
Forecasting the Income Statement, Balance Sheet, and Statement of Cash Flows Assume the following are the financial statements of Nike, Inc. Consolidated Statements of Income Year ended May 31 In Millions 2011 2010 Revenues $ 21,862 $ 19,014 Cost of sales 11,354 10,214 Gross profit 10,508 8,800 Demand creation expense 2,948 2,356 Operating overhead expense 4,845 3,970 Total selling and administrative expense 7,793 6,326 Interest expense (income), net 4 6 Other (income) (33) (49) Income before income taxes 2,744 2,517...
Edman Company is a merchandiser that has provided the following balance sheet and income statement for...
Edman Company is a merchandiser that has provided the following balance sheet and income statement for this year. Beginning Balance Ending Balance Assets Cash $ 62,800 $ 150,000 Accounts receivable 160,000 180,000 Inventory 230,000 240,000 Property, plant & equipment (net) 833,000 793,000 Other assets 37,000 37,000 Total assets $ 1,322,800 $ 1,400,000 Liabilities & Stockholders’ Equity Accounts payable $ 70,000 $ 80,000 Bonds payable 550,000 550,000 Common stock 410,000 410,000 Retained earnings 292,800 360,000 Total liabilities & stockholders’ equity $...
Edman Company is a merchandiser that has provided the following balance sheet and income statement for...
Edman Company is a merchandiser that has provided the following balance sheet and income statement for this year. Beginning Balance Ending Balance Assets Cash $ 62,800 $ 150,000 Accounts receivable 160,000 180,000 Inventory 230,000 240,000 Property, plant & equipment (net) 833,000 793,000 Other assets 37,000 37,000 Total assets $ 1,322,800 $ 1,400,000 Liabilities & Stockholders’ Equity Accounts payable $ 70,000 $ 80,000 Bonds payable 550,000 550,000 Common stock 410,000 410,000 Retained earnings 292,800 360,000 Total liabilities & stockholders’ equity $...
Edman Company is a merchandiser that has provided the following balance sheet and income statement for...
Edman Company is a merchandiser that has provided the following balance sheet and income statement for this year. Beginning Balance Ending Balance Assets Cash $ 62,800 $ 150,000 Accounts receivable 160,000 180,000 Inventory 230,000 240,000 Property, plant & equipment (net) 833,000 793,000 Other assets 37,000 37,000 Total assets $ 1,322,800 $ 1,400,000 Liabilities & Stockholders’ Equity Accounts payable $ 70,000 $ 80,000 Bonds payable 550,000 550,000 Common stock 410,000 410,000 Retained earnings 292,800 360,000 Total liabilities & stockholders’ equity $...
Arrange the following items in the appropriate income statement and balance sheet formats. Determine in which...
Arrange the following items in the appropriate income statement and balance sheet formats. Determine in which of these two documents each of these items belongs, then include all appropriate items in outlines of an income statement and balance sheet. Prepare your response as a Word document. Sales Cash Depreciation expense Inventory Accounts payable Cost of goods sold Long-term debt Accrued expenses Accounts receivable Income tax payable Income tax expense Retained earnings Accumulated depreciation Prepaid expenses Interest expense Sales tax payable...
Two items are omitted from each of the following summaries of balance sheet and income statement...
Two items are omitted from each of the following summaries of balance sheet and income statement data for two proprietorships for the year 2020, Pharoah's Goods and Cullumber Enterprises. Determine the missing amounts. Pharoah's Goods Cullumber Enterprises Beginning of year:     Total assets $154,000 $180,600     Total liabilities 119,000 $enter a dollar amount (c)     Total owner’s equity $enter a dollar amount (a) 112,000 End of year:     Total assets 224,000 252,000     Total liabilities 168,000 70,000     Total owner’s equity 56,000 182,000 Changes during year...
Two items are omitted from each of the following summaries of balance sheet and income statement...
Two items are omitted from each of the following summaries of balance sheet and income statement data for two corporations for the year 2019, Blue Spruce Corp. and Ayayai Enterprises. Determine the missing amounts. Blue Spruce Corp. Ayayai Enterprises Beginning of year:     Total assets $137,740 $183,180     Total liabilities 120,700 (c)     Total stockholders’ equity (a) 106,500 End of year:     Total assets 227,200 255,600     Total liabilities 170,400 71,000     Total stockholders’ equity 56,800 184,600 Changes during year in stockholders’ equity:     Additional investment (b)...
USE THE FOLLOWING INFORMATION TO CONSTRUCT AN INCOME STATEMENT AND BALANCE SHEET FOR 2011. ASSUME THE...
USE THE FOLLOWING INFORMATION TO CONSTRUCT AN INCOME STATEMENT AND BALANCE SHEET FOR 2011. ASSUME THE TAX RATE IS 40%. (COMMON EQUITY IS A PLUG IN NUMBER) ITEM 2010 2011 SALES 10,000 12,000 DEPRECIATION 3,000 3,000 COST OF GOODS SOLD 2,000 2,000 OTHER EXPENSES 3,000 4,000 INTEREST 1,000 1,000 CASH 1,000 1,000 ACCOUNTS RECEIVABLE 3,000 3,000 S.T. NOTES PAYABLE 1,000 1,000 L.T. DEBT 10,000 11,000 NET FIXED ASSETS 20,000 20,000 ACCOUNTS PAYABLE 2,000 2,000 INVENTORY 3,000 3,000 DIVIDENDS 600 600...
Fill in the blanks in the following Income Statement and Balance Sheet for Screven Industries. Assume...
Fill in the blanks in the following Income Statement and Balance Sheet for Screven Industries. Assume that there are 360 days in a year and that Credit Sales are 75% of total sales. Net Income is $1,200,000 Cash                            $750,000         Current Debt               ________ Acct. Rec.                   _________      L-T Debt                     ________ Inventory                    _________      Total Debt                   ________ T. Current Assets        _________      Stockholders’ Equity ________ Net Fixed Assets         _________      Total Debt and Total Assets                _________      Stockholders’ Equity ________ Total Asset Turnover                    2.5             ACP                            30 days...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT