Question

In: Accounting

easures of liquidity, Solvency and Profitability The comparative financial statements of Marshall Inc. are as follows....

easures of liquidity, Solvency and Profitability The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall common stock was $ 62 on December 31, 20Y2. Marshall Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Retained earnings, January 1 $ 3,623,800 $ 3,083,800 Net income 784,000 631,600 Total $4,407,800 $ 3,715,400 Dividends: On preferred stock $ 13,300 $ 13,300 On common stock 78,300 78,300 Total dividends $ 91,600 $ 91,600 Retained earnings, December 31 $ 4,316,200 $ 3,623,800 Marshall Inc. Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 20Y2 20Y1 Sales $ 4,557,025 $ 4,198,590 Cost of goods sold 1,651,260 1,519,160 Gross profit $ 2,905,765 $ 2,679,430 Selling expenses $ 964,340 $ 1,169,030 Administrative expenses 821,475 686,580 Total operating expenses 1,785,815 1,855,610 Income from operations $ 1,119,950 $ 823,820 Other revenue 58,950 52,580 $ 1,178,900 $ 876,400 Other expense (interest) 288,000 158,400 Income before income tax $ 890,900 $ 718,000 Income tax expense 106,900 86,400 Net income $ 784,000 $ 631,600 Marshall Inc. Comparative Balance Sheet December 31, 20Y2 and 20Y1 Dec. 31, 20Y2 Dec. 31, 20Y1 Assets Current assets Cash $ 730,520 $ 806,250 Marketable securities 1,105,650 1,336,080 Accounts receivable (net) 854,100 803,000 Inventories 642,400 496,400 Prepaid expenses 138,210 161,250 Total current assets $ 3,470,880 $ 3,602,980 Long-term investments 3,272,280 1,620,769 Property, plant, and equipment (net) 3,960,000 3,564,000 Total assets $ 10,703,160 $ 8,787,749 Liabilities Current liabilities $ 1,156,960 $ 1,553,949 Long-term liabilities Mortgage note payable, 8 % $ 1,620,000 $ 0 Bonds payable, 8 % 1,980,000 1,980,000 Total long-term liabilities $ 3,600,000 $ 1,980,000 Total liabilities $ 4,756,960 $ 3,533,949 Stockholders' Equity Preferred $ 0.70 stock, $ 40 par $ 760,000 $ 760,000 Common stock, $ 10 par 870,000 870,000 Retained earnings 4,316,200 3,623,800 Total stockholders' equity $ 5,946,200 $ 5,253,800 Total liabilities and stockholders' equity $ 10,703,160 $ 8,787,749 Required: Determine the following measures for 20Y2, rounding to one decimal place, except for dollar amounts, which should be rounded to the nearest cent. Use the rounded answer of the requirement for subsequent requirement, if required. Assume 365 days a year. 1. Working capital $ 2. Current ratio 3. Quick ratio 4. Accounts receivable turnover 5. Number of days' sales in receivables days 6. Inventory turnover 7. Number of days' sales in inventory days 8. Ratio of fixed assets to long-term liabilities 9. Ratio of liabilities to stockholders' equity 10. Times interest earned 11. Asset turnover 12. Return on total assets % 13. Return on stockholders’ equity % 14. Return on common stockholders’ equity % 15. Earnings per share on common stock $ 16. Price-earnings ratio 17. Dividends per share of common stock $ 18. Dividend yield

Solutions

Expert Solution

Marshell Inc.
Given Year 20Y2 20Y1
Beginning Retained Earnings $    3,623,800.00 $ 3,083,800.00
Net Income $        784,000.00 $      631,600.00
Total $    4,407,800.00 $ 3,715,400.00
Less: Dividend to
Preferred Stock $          13,300.00 $        13,300.00
Common Stock $          78,300.00 $        78,300.00
Total Dividend $          91,600.00 $        91,600.00
Ending Retained Earnings $    4,316,200.00 $ 3,623,800.00
Marshell Inc.
COMPARATIVE INCOME STATEMENT
YEAR 20Y2 20Y1
Sales $    4,557,025.00 $ 4,198,590.00
Less: Cost of goods sold sold $    1,651,260.00 $ 1,519,160.00
Gross Profit $    2,905,765.00 $ 2,679,430.00
Selling Expenses $        964,340.00 $ 1,169,030.00
Administerative Expenses $        821,475.00 $      686,580.00
Total Operating Expense $    1,785,815.00 $ 1,855,610.00
Income from Operation $    1,119,950.00 $      823,820.00
Other Revenue $          58,950.00 $        52,580.00
Net Income before Interest and Taxes $    1,178,900.00 $      876,400.00
Interest $        288,000.00 $      158,400.00
Net Income before Taxes $        890,900.00 $      718,000.00
Provision for Income Taxes $        106,900.00 $        86,400.00
Net Income after tax $        784,000.00 $      631,600.00
Marshell Inc.
COMPARATIVE BALANCE SHEET
YEAR 20Y2 20Y1
ASSETS
CURRENT ASSETS
Cash $        730,520.00 $      806,250.00
Marketable Securities $    1,105,650.00 $ 1,336,080.00
Accounts Receivable $        854,100.00 $      803,000.00
Mercendise Inventory $        642,400.00 $      496,400.00
Prepaid Expenses $        138,210.00 $      161,250.00
Total Current Assets $    3,470,880.00 $ 3,602,980.00
Long Term Investments $    3,272,280.00 $ 1,620,769.00
PLANT & EQUIPMENT
Building(Net) $    3,960,000.00 $ 3,564,000.00
Total Assets $ 10,703,160.00 $ 8,787,749.00
LIABILITIES
CURRENT LIABILITIES $    1,156,960.00 $ 1,553,949.00
Mortgage Notes Payable $    1,620,000.00 $                       -  
Bonds Payable $    1,980,000.00 $ 1,980,000.00
Total Long tem Liabilities $    3,600,000.00 $ 1,980,000.00
Shareholder's Equity
Preferred Stock $        760,000.00 $      760,000.00
Common Stock $        870,000.00 $      870,000.00
Retained Earnings $    4,316,200.00 $ 3,623,800.00
Total Stock Holder's Equity $    5,946,200.00 $ 5,253,800.00
Total Liabilities & Stockholder's Equity $ 10,703,160.00 $ 8,787,749.00
Formulas
Year 20Y2
1) Working Capital=Current Assets-Current Liabilities
Total Current Assets $    3,470,880.00
Total Current Liabilities $    1,156,960.00
Working Capital=($3470880-$1156960) $    2,313,920.00
2) Current Ratio
Current Assets/Currrent liabilities
Current Assets $    3,470,880.00
Current Liabilities $    1,156,960.00
Current Assets/Currrent liabilities=($3470880/$1156960) 3 :1
3) Quick Ratio=(Quick Assets/Current Liabilities
Quick Assets=Current Assets-Inventory-Prepaid Expenses
Quick Assets=($3470880-$642400-$138210) $    2,690,270.00
Current Liabilities $    1,156,960.00
Quick Ratio=($2690270/$1156960) $                     2.33 :1
4) Accounts Receivable Turnover=Credit Sales/Average Accounts Receivable
Sales $    4,557,025.00
Beginning Accounts Receivable $        803,000.00
Ending Accounts Receivable $        854,100.00
Average Accounts Receivable=(Beginning Accounts Receivable+Ending Accounts Receivable)/2
Average Accounts Receivable=($803000+$854100)/2 $        828,550.00
Accounts Receivable Turnover=($4557025/$828550) 5.5 Times
5) Number of Days sales in receivable days=(Accounts Receivable/Sales)*365
Accounts Receivable $        854,100.00
Sales $    4,557,025.00
Number of days sales in receivable days=($854100/$4557025)*365 68.4 Days
6) Inventory Turnover =Cost of goods sold/Average Inventory
Cost of goods sold $    1,651,260.00
Beginning Inventory $        496,400.00
Ending Inventory $        642,400.00
Average Inventory=(Beginning Inventory+Ending Inventory)/2
Average Inventory=($496400+$642400)/2 $        569,400.00
Inventory Turnover =($1651260/$569400) 2.9 Times
7) Number of days sales in Inventory days=365/Inventory Turnover
Inventory Turnover 2.9
Number of days sales in Inventory days=365/2.90 125.9 Days
8) Ratio of Fixed Assets to Long Term Liabilities
Fixed Assets/Long Term Liabilities
Fixed Assets $    3,960,000.00
Long Term Liabilites $    3,600,000.00
Ratio of Fixed Assets to Long Term Liabilities=($3960000/$3600000) 1.1
9) Liabilities to stockholder's equity=(Total Liabilities/Stockholder's Equity)
Total Liabilities= $    4,756,960.00
Stock holder's Equity $    5,946,200.00
Liabilities to stockholder's equity=($4756960/$5946200) 0.8
10) Times Interest Earned=Net Income befor interest and tax/Interest
Net Income before interest and tax $    1,178,900.00
Interest $        288,000.00
Times Interest Earned=($1178900/$288000) 4.1 Times
11) Assets Turnover=Net Sales/Average Total Assets
Beginning Total Assets $    8,787,749.00
Ending Total Assets $ 10,703,160.00
Sales $    4,557,025.00
Average Total Assets=($8787749+$10703160)/2 $    9,745,454.50
Assets Turnover=($4557025/$9745454.50) 0.5 Times

Related Solutions

Measures of liquidity, Solvency, and Profitability The comparative financial statements of Marshall Inc. are as follows....
Measures of liquidity, Solvency, and Profitability The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall common stock was $ 69 on December 31, 20Y2. Marshall Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 20Y2 and 20Y1     20Y2     20Y1 Retained earnings, January 1 $3,577,150 $3,023,350 Net income 851,200 619,300 Total $4,428,350 $3,642,650 Dividends: On preferred stock $13,300 $13,300 On common stock 52,200 52,200 Total dividends $65,500 $65,500 Retained earnings, December 31 $4,362,850...
Measures of liquidity, Solvency and Profitability The comparative financial statements of Marshall Inc. are as follows....
Measures of liquidity, Solvency and Profitability The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall Inc. common stock was $ 66 on December 31, 20Y2. Marshall Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 20Y2 and 20Y1    20Y2    20Y1 Retained earnings, January 1 $ 1,413,000 $ 1,202,700 Net income 330,000 246,300 Total $ 1,671,000 $ 1,449,000 Dividends On preferred stock $ 10,500 $ 10,500 On common stock 25,500 25,500 Total dividends...
Measures of liquidity, Solvency, and Profitability The comparative financial statements of Marshall Inc. are as follows....
Measures of liquidity, Solvency, and Profitability The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall common stock was $ 65 on December 31, 20Y2. Marshall Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 20Y2 and 20Y1     20Y2     20Y1 Retained earnings, January 1 $3,356,900 $2,820,900 Net income 728,000 577,800 Total $4,084,900 $3,398,700 Dividends: On preferred stock $9,800 $9,800 On common stock 32,000 32,000 Total dividends $41,800 $41,800 Retained earnings, December 31 $4,043,100...
Measures of liquidity, Solvency and Profitability The comparative financial statements of Marshall Inc. are as follows....
Measures of liquidity, Solvency and Profitability The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall Inc. common stock was $ 61 on December 31, 20Y2. Marshall Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 20Y2 and 20Y1    20Y2    20Y1 Retained earnings, January 1 $ 920,575 $ 780,625 Net income 198,800 159,900 Total $ 1,119,375 $ 940,525 Dividends On preferred stock $ 6,300 $ 6,300 On common stock 13,650 13,650 Total dividends...
Measures of liquidity, Solvency, and Profitability The comparative financial statements of Marshall Inc. are as follows....
Measures of liquidity, Solvency, and Profitability The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall common stock was $ 56 on December 31, 20Y2. Marshall Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 20Y2 and 20Y1    20Y2    20Y1 Retained earnings, January 1 $2,541,175 $2,144,325 Net income 600,000 439,200 Total $3,141,175 $2,583,525 Dividends: On preferred stock $7,700 $7,700 On common stock 34,650 34,650 Total dividends $42,350 $42,350 Retained earnings, December 31 $3,098,825...
Measures of liquidity, Solvency, and Profitability The comparative financial statements of Marshall Inc. are as follows....
Measures of liquidity, Solvency, and Profitability The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall common stock was $ 67 on December 31, 20Y2. Marshall Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 20Y2 and 20Y1    20Y2    20Y1 Retained earnings, January 1 $3,346,500 $2,812,300 Net income 748,800 576,000 Total $4,095,300 $3,388,300 Dividends: On preferred stock $9,800 $9,800 On common stock 32,000 32,000 Total dividends $41,800 $41,800 Retained earnings, December 31 $4,053,500...
Measures of liquidity, Solvency, and Profitability The comparative financial statements of Marshall Inc. are as follows....
Measures of liquidity, Solvency, and Profitability The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall common stock was $ 55 on December 31, 20Y2. Marshall Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 20Y2 and 20Y1     20Y2     20Y1 Retained earnings, January 1 $1,651,550 $1,389,650 Net income 379,600 284,600 Total $2,031,150 $1,674,250 Dividends: On preferred stock $6,300 $6,300 On common stock 16,400 16,400 Total dividends $22,700 $22,700 Retained earnings, December 31 $2,008,450...
Measures of liquidity, Solvency and Profitability The comparative financial statements of Marshall Inc. are as follows....
Measures of liquidity, Solvency and Profitability The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall common stock was $ 56 on December 31, 20Y2. Marshall Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 20Y2 and 20Y1    20Y2    20Y1 Retained earnings, January 1 $ 1,265,300 $ 1,075,600 Net income 300,000 220,300 Total $1,565,300 $ 1,295,900 Dividends: On preferred stock $ 9,800 $ 9,800 On common stock 20,800 20,800 Total dividends...
Measures of liquidity, Solvency, and Profitability The comparative financial statements of Marshall Inc. are as follows....
Measures of liquidity, Solvency, and Profitability The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall common stock was $ 68 on December 31, 20Y2. Marshall Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 20Y2 and 20Y1    20Y2    20Y1 Retained earnings, January 1 $4,225,075 $3,589,925 Net income 990,000 735,300 Total $5,215,075 $4,325,225 Dividends: On preferred stock $12,600 $12,600 On common stock 87,550 87,550 Total dividends $100,150 $100,150 Retained earnings, December 31 $5,114,925...
Measures of liquidity, Solvency, and Profitability The comparative financial statements of Marshall Inc. are as follows....
Measures of liquidity, Solvency, and Profitability The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall common stock was $ 58 on December 31, 20Y2. Marshall Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 20Y2 and 20Y1     20Y2     20Y1 Retained earnings, January 1 $3,362,100 $2,825,200 Net income 717,600 578,700 Total $4,079,700 $3,403,900 Dividends: On preferred stock $9,800 $9,800 On common stock 32,000 32,000 Total dividends $41,800 $41,800 Retained earnings, December 31 $4,037,900...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT