In: Accounting
The following events were completed by Dana’s Imports in September 2018:
Sept. | 1 | Acquired $54,000 cash from the issue of common stock. |
1 | Purchased $35,000 of merchandise on account with terms 2/10, n/30. | |
5 | Paid $1,000 cash for freight to obtain merchandise purchased on September 1. | |
8 | Sold merchandise that cost $12,500 to customers for $18,000 on account, with terms 2/10, n/30. | |
8 | Returned $1,100 of defective merchandise from the September 1 purchase to the supplier. | |
10 | Paid cash for the balance due on the merchandise purchased on September 1. | |
20 | Received cash from customers of September 8 sale in settlement of the account balances, but not within the discount period. | |
30 | Paid $3,450 cash for selling expenses. |
Required
Record each event in a statements model like the following one. In the Cash Flow column, use OA to designate operating activity, IA for investment activity, FA for financing activity, or NC for net change in cash. If the element is not affected by the event, leave the cell blank. The first event is recorded as an example.
Prepare an income statement for the month ending September 30.
Prepare a statement of cash flows for the month ending September 30.
A.
|
B.
Prepare an income statement for the month ending September 30.
|
C.
Prepare a statement of cash flows for the month ending September 30. (Enter cash outflows as negative amounts.)
|
Answer to part A is as under:
DANA'S IMPORTS | ||||||||||||||||||
Effect of Transactions on Financial Statements Using Horizontal Statements Model | ||||||||||||||||||
Date | Balance Sheet | Income Statement | Statement of Cash Flows | |||||||||||||||
Assets | = | Liabilities | + | Stockholders’ Equity | Revenue | – | Expenses | = | Net Income | |||||||||
Cash | + | Accounts Receivable | + | Inventory | = | Accounts Payable | + | Common Stock | + | Retained Earnings | ||||||||
9/1 | 54,000 | + | + | = | + | 54,000 | + | – | = | 54,000 | FA | |||||||
9/1 |
54,000 |
+ | + | 35,000 | = | 35,000 | + | 54,000 | + | – | = | |||||||
9/5 | 53,000 | + | + | 35,000 | = | 35,000 | + | 54,000 | + | -1000 | – | 1000 | = | -1000 | -1000 | OA | ||
9/8a. | 53,000 | + | 18,000 | + | 22,500 | = | 35,000 | + | 54,000 | + | 4500 | 18,000 | – | 12,500 | = | 5,500 | ||
9/8b. | 53,000 | + | 18,000 | + | 21,400 | = | 33,900 | + | 54,000 | + | 4,500 | – | = | |||||
9/8c. | + | + | = | + | + | – | = | |||||||||||
9/10 | 19,778 | + | 18,000 | + | 21,400 | = | + | 54,000 | + | 5178 | 678 | – | = | 678 | -33,222 | OA | ||
9/20 | 37,778 | + | + | 21,400 | = | + | 54,000 | + | 5178 | – | = | 18,000 | OA | |||||
9/30 | 34,328 | + | + | 21,400 | = | + | 54,000 | + | 1728 | – | 3,450 | = | -3,450 | -3,450 | OA | |||
Total | + | + | = | + | + | 18,678 | – | 16,950 | = | 1,728 | 34,328 |
Answer to part B is as under
DANA'S IMPORTS | |
Income Statement | |
For the Month Ended September 30, 2018 | |
Income | Amt (INR) |
Sales | 18,000 |
Cash Discount Received | 678 |
Operating expenses | |
Cost of Goods Sold | -12,500 |
Freight Charges | -1000 |
Sales Expense | -3,450 |
Net Income for the period | 1,728 |
Answer to part C is as under
DANA'S IMPORTS | ||
Statement of Cash Flows | ||
For the Month ended September 30, 2018 | ||
Cash flows from operating activities | ||
Net operating income as per income statement | 1,728 | |
Decrease in Inventory | 13,600 | |
Decrease in Accounts Payable | -35,000 | |
Net cash flow from operating activities | -19,672 | |
Cash flows from investing activities | ||
Cash flows from financing activities | ||
Issue of common stock | 54,000 | |
Net cash flow from financing activities | ||
Net change in cash | 34,328 | |
Opening cash balance | 0 | |
Ending cash balance | 34,328 |
Above mentioned are the answer of your questions in required table format.