Question

The comparative financial statements of the Summer Company are as follows. The market price of the...

The comparative financial statements of the Summer Company are as follows.
The market price of the Summer Company common stock was $36 on
December 31, 2016 and $11.20 on December 31, 2017.
          Summer Company
Comparative Balance Sheet
December 31, 2017, 2016 and 2015
ASSETS
2017 2016 2015
Current Assets
Cash $176,200 $253,100 $26,500
Accounts Receivable 238,850 31,850 67,350
Merchandise Inventory 62,500 42,500 130,000
Prepaid Expenses 700 1,700 2,200
Total Current Assets $478,250 $329,150 $226,050
Plant Assets 696,100 726,100 786,100
Less: Accumulated Depreciation (70,000) (60,000) (80,000)
Plant Assets (net) 626,100 666,100 706,100
Total Assets $1,104,350 $995,250 $932,150
Liabilities and Stockholder's Equity
Current Liabilites
Accounts Payable $55,000 $30,000 $60,000
Accrued Liabilities 1,000 8,000 12,000
Dividends Payable 0 10,000 2,000
Total Current Liabilities $56,000 $48,000 $74,000
Long-Term Liabilities
Mortgage Note Payable $9,000 $29,000 $49,000
Bonds Payable 240,000 340,000 290,000
Less: Discount on Bonds Payable (4,500) (5,500) (4,500)
Total Long-Term Liabilities $244,500 $363,500 $334,500
Total Liabilities $300,500 $411,500 $408,500
Stockholders' Equity
Common Stock, $10 Par $411,900 $311,900 $311,900
Paid in Capital in Excess of Par 162,350 72,350 72,350
Retained Earnings 236,600 209,500 149,400
Less: Treasury Stock (7,000) (10,000) (10,000)
Total Stockholders' Equity $803,850 $583,750 $523,650
Total Liabilities and
Stockholders' Equity $1,104,350 $995,250 $932,150
The Summer Company
Retained Earnings Statement
                  For the years Ended December 31, 2011 and 2010
2017 2016
Retained Earnings. Jan. 1, $209,500 $149,400
Add: Net Income 27,100 70,100
Less: Dividends Declared (10,000)
Retained Earnings Dec. 31 $236,600 $209,500
The Summer Company
Income Statement
For the years ended December 31, 2011 and 2010
2017 2016
Sales $260,000 $521,000
less: Cost of Merchandise Sold 200,000 387,500
Gross Profit 60,000 133,500
less: Operating Expenses; excluding Depreciation 11,000 8,500
        Depreciation Expense 20,000 20,000
Income from Operations $29,000 $105,000
Add: Other Income: Gain on sale of equipment 10,000 0
Less: Other Expenses: Loss on sale of equipment 8,000
$39,000 $97,000
Less: Interest Expense 3,900 5,900
Income before Income Tax $35,100 $91,100
Less: Income Tax expense 8,000 21,000
$27,100 $70,100
The Summer Company
Statement of Cash Flows
       For the year ended December 31, 2016
Cash Flow From Operating Activities:
Net Income $70,100
Add: Net decrease in Accounts Receivable $35,500
Net decrease in Merchandise Inventory 87,500
Net decrease in Prepaid Expenses 500
Loss on Sale of Plant Assets (1) 8,000
Depreciation Expense (1) 20,000
Amortization of Bond Discount (2) 1,000 152,500
222,600
Deduct: Decrease in Accounts Payable $30,000
Decrease in Accrued Liabilities 4,000 34,000
Cash Flow From Operating Activities 188,600
Cash Flow from Investing Activities:
Sale of Plant Assets for cash (1) 12,000
Cash Flow from Investing Activities 12,000
Cash Flow from Financing Activities
Issued Bonds for cash (2) 48,000
Deduct: Cash Dividends Paid 2,000
Mortgage paid 20,000 22,000
Cash Flow from Financing Activities 26,000
Net Increase in Cash 226,600
1/1/2016 Cash Balance 26,500
12/31/2016 Cash Balance 253,100
(1) Sold Plant Assets with a book value of $20,000.
(2) Issued bonds for $48,000. Face Value $50,000.
The following transactions occurred during 2017 to assist you in preparing the Statement
of Cash Flows for 2017.
A. Dividends were declared in 2016 and paid 2017.
B. Purchased Treasury Stock for $10,000 on 1/1/2017.
C. Sold Treasury Stock receiving cash.
D. Sold Plant Assets, receiving cash. The net book value of the plant asset was $20,000.
E. Paid off a portion of the mortg age note.
F. Retired bonds at their maturity value.
G. Amortized the Discount on Bonds Payable.
H. Issued common stock, receiving cash.
Required: 1. Prepare the Statement of Cash Flows for the year ended December 31, 2017.
   (Show all required computations).
Assume that your manager, who has a marketing background ask you the
following questions 2-5, after reviewing the Statement of Cash Flows for 2017
and 2016.
As you can see from the premise of the questions, that your manager does not
have a basic understanding of the statement of cash flows. Take that into
consideration when answering questions 2-5.
2. "How can Depreciation be a cash flow"?
3. "How can a gain on the sale of non-current assets be a deduction from Net
    Income in determining the Cash Flow from Operating Activities?
4. "How can a Loss on the Sale of non current assets be be an
      addition to Net Income in determining Cash Flow from Operating Activities?
5. "Why does the bank need a Statement of Cash Flows anyway? They can
     compute the increase or decrease in cash flow from the Balance Sheet for the
     last two years"?
6. Prepare the following financial statement analysis for the 2017 and 2016.
     Define each measure and whether the Summer Company did better or worse
     and why?
    A. Current ratio.
    B. Quick ratio.
    C. Rate of Return on Total Assets.
    D. Rate of Return on Common Stockholders' Equity.
    E. Earnings Per Share on Common Sock. (When computing the earnings per
        share assume there is no Treasury Stock). Use the outstanding shares as of
        12/31/2017 for 2017 and the outstanding shares as of 12/31/ 2016 for 2016. Do
         not use the weighted average outstanding shares.
     F. Accounts Receivable Turnover. Assume all Sales are on account.
     G. Average collection period. Assume all Sales are on account.
     H. Inventory Turnover.
      I. Debt to equity ratio
      J. Times Interest Earned Ratio.
      K. Price Earnings Ratio.
      L. Operating Cash Flow to current liability ratio
      M. Vertical analysis for the Income Statement for 2017 and 2016.
    Below is an example of how you should present the information.
2011 2010
Working Capital:
Current Assets $478,250 $329,150
Current Liabilities 56,000 48,000
Net Working Capital 422,250 281,150
Strength or Weakness
Working Capital measures the ability of a company to meet it's short-term obligations with
current assets. In 2011 Summer is performing much better since they have more current
assets available to meet their short-term obligations.
7. From your analysis, summarize the major strenths and weaknesses comparing
    Summer's 2017 and 2016 performance. Summarize part 6 A through M.

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The comparative financial statements of Blige Inc. are as follows. The market price of Blige Inc....
The comparative financial statements of Blige Inc. are as follows. The market price of Blige Inc. common stock was $57 on December 31, 2016. Blige Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 2016 and 2015     2016     2015 Retained earnings, January 1 $1,944,750 $1,648,550 Add net income for year 432,000 337,700 Total $2,376,750 $1,986,250 Deduct dividends On preferred stock $7,000 $7,000 On common stock 34,500 34,500 Total $41,500 $41,500 Retained earnings, December 31 $2,335,250 $1,944,750 Blige Inc....
The comparative financial statements of Blige Inc. are as follows. The market price of Blige Inc....
The comparative financial statements of Blige Inc. are as follows. The market price of Blige Inc. common stock was $64 on December 31, 2016. Blige Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 2016 and 2015     2016     2015 Retained earnings, January 1 $2,464,650 $2,084,550 Add net income for year 577,600 427,000 Total $3,042,250 $2,511,550 Deduct dividends On preferred stock $7,000 $7,000 On common stock 39,900 39,900 Total $46,900 $46,900 Retained earnings, December 31 $2,995,350 $2,464,650 Blige Inc....
Comparative financial statements for Weaver Company follow: Weaver Company Comparative Balance Sheet at December 31 This...
Comparative financial statements for Weaver Company follow: Weaver Company Comparative Balance Sheet at December 31 This Year Last Year Assets Cash $ 16 $ 12 Accounts receivable 293 230 Inventory 157 195 Prepaid expenses 8 6 Total current assets 474 443 Property, plant, and equipment 513 434 Less accumulated depreciation (83 ) (71 ) Net property, plant, and equipment 430 363 Long-term investments 24 31 Total assets $ 928 $ 837 Liabilities and Stockholders' Equity Accounts payable $ 302 $...
Condensed financial data of Ayayai Company for 2017 and 2016 are presented below. AYAYAI COMPANY COMPARATIVE...
Condensed financial data of Ayayai Company for 2017 and 2016 are presented below. AYAYAI COMPANY COMPARATIVE BALANCE SHEET AS OF DECEMBER 31, 2017 AND 2016 2017 2016 Cash $1,770 $1,170 Receivables 1,790 1,320 Inventory 1,610 1,940 Plant assets 1,910 1,680 Accumulated depreciation (1,200) (1,190) Long-term investments (held-to-maturity) 1,300 1,420 $7,180 $6,340 Accounts payable $1,210 $910 Accrued liabilities 200 240 Bonds payable 1,370 1,560 Common stock 1,880 1,740 Retained earnings 2,520 1,890 $7,180 $6,340 AYAYAI COMPANY INCOME STATEMENT FOR THE YEAR...
Condensed financial data of Swifty Company for 2017 and 2016 are presented below. SWIFTY COMPANY COMPARATIVE...
Condensed financial data of Swifty Company for 2017 and 2016 are presented below. SWIFTY COMPANY COMPARATIVE BALANCE SHEET AS OF DECEMBER 31, 2017 AND 2016 2017 2016 Cash $1,830 $1,140 Receivables 1,720 1,280 Inventory 1,610 1,900 Plant assets 1,870 1,690 Accumulated depreciation (1,210) (1,190) Long-term investments (held-to-maturity) 1,270 1,410 $7,090 $6,230 Accounts payable $1,230 $910 Accrued liabilities 200 250 Bonds payable 1,410 1,540 Common stock 1,880 1,710 Retained earnings 2,370 1,820 $7,090 $6,230 SWIFTY COMPANY INCOME STATEMENT FOR THE YEAR...
The financial statements of Elcamino Company appear below: ELCAMINO COMPANY Comparative Balance Sheet December 31, ________________________________________________________...
The financial statements of Elcamino Company appear below: ELCAMINO COMPANY Comparative Balance Sheet December 31, ________________________________________________________ Assets                                                                                                        2017 2016    Cash ..................................................................................................    $ 25,000................................................................................................ $ 40,000 Debt investments ..............................................................................       20,000 60,000 Accounts receivable (net) .................................................................       50,000 30,000 Inventory ...........................................................................................       140,000 170,000 Property, plant and equipment (net) .................................................        170,000.............................................................................................. 200,000       Total assets ................................................................................       $405,000 $500,000 Liabilities and stockholders' equity Accounts payable .............................................................................    $ 25,000................................................................................................ $ 30,000 Short-term notes payable .................................................................       40,000...
Nineteen Measures of Solvency and Profitability The comparative financial statements of Bettancort Inc. are as follows....
Nineteen Measures of Solvency and Profitability The comparative financial statements of Bettancort Inc. are as follows. The market price of Bettancort Inc. common stock was $71.25 on December 31, 2016. Bettancort Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 2016 and 2015     2016     2015 Retained earnings, January 1 $2,655,000 $2,400,000 Add net income for year 300,000 280,000 Total $2,955,000 $2,680,000 Deduct dividends: On preferred stock $15,000 $15,000 On common stock 10,000 10,000 Total $25,000 $25,000 Retained earnings,...
Assignment Worksheet: Use the comparative balance sheets of Chandler Electric Company on December 31, 2016 to...
Assignment Worksheet: Use the comparative balance sheets of Chandler Electric Company on December 31, 2016 to prepare the two requirements: ---------------------------------------------------------------------------------------------------------------- 2016                                            2015 Current Assets Cash                                      $     85,400                                  $      21,500 Accounts Receivable                  14,800                                         21,500 Merchandise Inventory 63,000 59,400 Current Liabilities Accounts Payable $      27,100 $      26,100 Accrued Liabilities 10,400 10,900 --------------------------------------------------------------------------------------------------------------------------------------- Chandler Electric Company’s transactions during 2016 included the following: ---------------------------------------------------------------------------------------------------------------- Payment of cash dividends $ 20,200 Depreciation expense $   17,000 Purchase of equipment with cash 55,100 Purchase of building...
The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall common...
The comparative financial statements of Marshall Inc. are as follows. The market price of Marshall common stock was $ 59 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,945,250 $1,654,850 Net income 438,000 338,900 Total $2,383,250 $1,993,750 Dividends: On preferred stock $14,000 $14,000 On common stock 34,500 34,500 Total dividends $48,500 $48,500 Retained earnings, December 31 $2,334,750 $1,945,250 Marshall Inc. Comparative Income Statement...
1. Terry company's 2017 income statement and comparative balance sheets at December 31 of 2016 and...
1. Terry company's 2017 income statement and comparative balance sheets at December 31 of 2016 and 2017are shown. Terry Company                                                                    Income Statement        For the year Ended December 31, 2017    Sales                                                 $ 390,000    Cost of Goods Sold                            235,000                                                                                _______      Gross Profit                                                        $ 155,000    Wages Expenses                              $ 63,000    Depreciation Expense                        14,000    Other Operating Expenses                  26,000    Income Tax Expense                           17,000    120,000                                                                                 ______    ________      Net Income                                                          $ 35,000                                                  ...