Question
Based on Problem 5-7 Skysong Inc. had the following balance sheet at December 31, 2016. SKYSONG INC. BALANCE SHEET DECEMBER 31, 2016 Cash $21,290 Accounts
Based on Problem 5-7
Skysong Inc. had the following balance sheet at December 31, 2016.
SKYSONG INC. BALANCE SHEET DECEMBER 31, 2016 | ||||||
Cash | $21,290 | Accounts payable | $31,290 | |||
Accounts receivable | 22,490 | Bonds payable | 42,290 | |||
Investments | 32,000 | Common stock | 101,290 | |||
Plant assets (net) | 82,290 | Retained earnings | 24,490 | |||
Land | 41,290 | $199,360 | ||||
$199,360 |
During 2017, the following occurred.
1. | Skysong liquidated its available-for-sale investment portfolio at a loss of $6,290. | |
2. | A tract of land was purchased for $39,290. | |
3. | An additional $30,000in common stock was issued at par. | |
4. | Dividends totaling $11,290were declared and paid to stockholders. | |
5. | Net income for 2017 was $36,290, including $13,290in depreciation expense. | |
6. | Land was purchased through the issuance of $31,290in additional bonds. | |
7. | At December 31, 2017, Cash was $71,490, Accounts Receivable was $43,290, and Accounts Payable was $41,290. |
DELIVERABLES:
1. In Excel prepare a statement of cash flows for the year 2017 for Skysong
2. In the same Excel workbook on a separate sheet prepare a balance sheet (unclassified) as it would appear at December 31, 2017.
3. Post to the link labeled Project #2 - Cash Flow (located in the Projects section
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started