Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Accounting 122 Group Project Problem 1 100 Points The comparative financial statements of the Summer Company are as follows. The market price of the Summer

Accounting 122
Group Project Problem 1 100 Points
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.

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

Essentials Of Auditing And Assurance Services An Integrated Approach

Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley, Al Arens

1st Edition

0130463035, 9780130463036

More Books

Students also viewed these Accounting questions

Question

Evaluate the expression. Assume x 0. a) 4 5 /4 2 b) (-4) 5 /(-4) 2

Answered: 1 week ago

Question

What is the purpose of the EEOC?

Answered: 1 week ago