Reference no: EM131868259
Homework -
Input: In Millions $
|
2016
|
2017
|
Cost of goods sold
|
$196,619
|
$248,263
|
Cash
|
28,372
|
42,865
|
Depreciation
|
55,506
|
62,738
|
Interest expense
|
12,067
|
13,831
|
Selling & Administrative
|
38,668
|
50,469
|
Accounts payable
|
20,143
|
34,091
|
Net fixed assets
|
244,881
|
298,350
|
Sales
|
385,724
|
470,172
|
Accounts receivable
|
20,104
|
26,078
|
Notes payable
|
22,855
|
24,955
|
Long-term debt
|
123,607
|
140,000
|
Inventory
|
38,706
|
52,057
|
New equity
|
-
|
15,000
|
|
|
|
Tax rate
|
30%
|
|
Dividend percentage
|
35%
|
|
Questions:
1. Complete Income Statement of 2016 & 2017
2. Complete Balance Sheet of 2016 & 2017
3. Work out 2017 Cash From Operating Activities.
4. Work out 2017 Cash From Investing Activities.
5. Work out 2017 Cash From Financing Activities.
6. How would you describe the company' cash flows for 2017? Write a brief discussion.
7. In light of your discussion in th eprevious quesiotn, do you think it is a good time for the company to expand business (i.e., buy more equipments/machines) at this time?
8. Please calculate the following Financial Ratios of the company, in year 2016 and 2017 respectively. Please briefly explain the trend of the company's financial position.
9. Please calculate the Du-Pont Ratio in 2016 and 2017, respectively.
10. By the end of year 2017, the firm has 100,000,000 common shares and stock price per share is $15. Please calculate the P/E ratio and EPS in 2017.
Attachment:- Assignment File.rar