[19 points in total; 12, 3 and 4 points] Referring to the following GPC Corporat
ID: 2567152 • Letter: #
Question
[19 points in total; 12, 3 and 4 points] Referring to the following GPC Corporation’s financial statements answer the questions below:
TABLE 1: Balance Sheet of GPC Corporation as of December 31, 2016 and 2015
ASSETS
2015
2016
Current Assets
Cash and Marketable Securities
100
120
Receivables
50
60
Inventories
150
180
Total Current Assets
300
360
Property, Plant, and Equipment (PP&E)
400
490
Less: Accumulated depreciation
100
130
Net PP&E
300
360
Total Assets
600
720
LIABILITIES AND STOCKHOLDERS'S EQUITY
Current Liabilities
Accounts Payable
60
72
Short-term debt
90
184.6
Total Current Liabilities
150
256.6
Long-term debt (8% interest bonds maturing in 20x7)
150
150
Stockholders' equity (1 million shares outstanding)
300
313.4
Paid-in capital
200
200
Retained earnings
100
113.4
Total Liabilities and Equity
600
720
All figures are in millions of U.S. dollars
TABLE 2: Income Statement of GPC Corporation for 2016
Sales revenue
200
Cost of goods sold
-110
Gross margin
90
General, Selling, and Administrative expenses
-30
Operating Income
60
Interest expenses
-21
Taxable income
39
Income tax (40%)
-15.6
Net Income (= Net Profits or Earnings after tax)
23.4
Allocation of net income:
Dividends
10
Change in retained earnings
13.4
All figures are in millions of U.S. dollars.
————————————————————————————————————————————
Construct GPC Corporation’s Statement of Cash Flows for 2016. Clearly show the three major cash flow categories and how each was obtained. (Use Excel spreadsheet and follow the format in the notes.)
TABLE 1: Balance Sheet of GPC Corporation as of December 31, 2016 and 2015
ASSETS
2015
2016
Current Assets
Cash and Marketable Securities
100
120
Receivables
50
60
Inventories
150
180
Total Current Assets
300
360
Property, Plant, and Equipment (PP&E)
400
490
Less: Accumulated depreciation
100
130
Net PP&E
300
360
Total Assets
600
720
LIABILITIES AND STOCKHOLDERS'S EQUITY
Current Liabilities
Accounts Payable
60
72
Short-term debt
90
184.6
Total Current Liabilities
150
256.6
Long-term debt (8% interest bonds maturing in 20x7)
150
150
Stockholders' equity (1 million shares outstanding)
300
313.4
Paid-in capital
200
200
Retained earnings
100
113.4
Total Liabilities and Equity
600
720
All figures are in millions of U.S. dollars
TABLE 2: Income Statement of GPC Corporation for 2016
Sales revenue
200
Cost of goods sold
-110
Gross margin
90
General, Selling, and Administrative expenses
-30
Operating Income
60
Interest expenses
-21
Taxable income
39
Income tax (40%)
-15.6
Net Income (= Net Profits or Earnings after tax)
23.4
Allocation of net income:
Dividends
10
Change in retained earnings
13.4
All figures are in millions of U.S. dollars.
————————————————————————————————————————————
Explanation / Answer
GPC Corporation Statement of Cash Flows For the year ended Amount Cash flows from operating activities Net Income $60.00 Adjust to reconcile net income to net cash provided Depreciation expenses $30.00 Changes in current assets and current liabilities Increase in Accounts receivable -$10.00 Increase in Inventory -$30.00 Increase in Accounts Payable $12.00 Increase in Short-term debt $94.60 Income tax paid -$15.60 Net cash provided by operating activities $141.00 Cash flows from investing activities Purchase of Property, Plant, and Equipment (PP&E) -$90.00 Net cash used in investing activities -$90.00 Cash flows from financing activities Interest Expenses -$21.00 Payment of Dividends -$10.00 Net cash used in financing activities -$31.00 Net increase in cash $20.00 Cash at Beginning of Period $100.00 Cash at End of Period $120.00 Supplemental Disclosures:
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.