In: Accounting
ABC inc builds and sells single-family homes. the company had the following transactions during q1 2016 period that ended on march 31, 2016:
1. purchased a single-family home on january 10, 2016 which it plans to renovate and resell. the home was purchased for $200,000 with $150,000 paid in cash and the remainder to be paid upon sale of the property.
2. Purchased $10,000 worth of building materials at home depot used in the renovation. The purchased was paid in cash.
3. Hired a contractor to perform the renovation of the house. The renovation was completed on feb. 10, 2016 and the contractor billed ABC inc $50,000 for this renovation. ABC paid $30,000 upon completion of the work. The balance was due in Q2 2016.
4. Paid office employee salaries of $10,000 during Q1 2016.
5. Sold the home for $290,000 on March 30th 2016 of which $250,000 was received and the rest due on April 20th 2016.
At the beginning of the quarter, (1/1/16) ABC inc balance sheet had only $300,000 in cash and $300,000 in owners equity.
1. present income statement for Q1
2. create ABC inc balance sheet at the end of Q1 2016
3. present statement of Cash flow
1.
ABC Inc. | |
Income Statement | |
For the Quarter Ended March 31, 2016 | |
Sales revenue | 290000 |
Cost of goods sold | 260000 |
Gross profit | 30000 |
Operating expenses | 10000 |
Net income | 20000 |
Cost of goods sold = $200000 + $10000 + $50000 = $260000
2.
ABC Inc. | |
Balance Sheet | |
March 31, 2016 | |
Assets | |
Cash | 350000 |
Accounts receivable | 40000 |
Total assets | 390000 |
Liabilities and Owner's Equity | |
Accounts payable | 70000 |
Owner's equity | 320000 |
Total liabilities and owner's equity | 390000 |
Cash = $300000 - 150000 - 10000 - 30000 - 10000 + 250000 = $350000
Accounts receivable = $290000 - 250000 = $40000
Accounts payable = ($200000 - 150000) + ($50000 - 30000) = $50000 + $20000 = $70000
Owner's equity = $300000 + $20000 = $320000
3.
ABC Inc. | ||
Statement of Cash Flows | ||
For the Quarter Ended March 31, 2016 | ||
Cash flows from operating activities: | ||
Cash received from customer | 250000 | |
Cash paid to suppliers | -190000 | |
Cash paid to employees for salaries | -10000 | |
Net cash provided by operating activities | 50000 | |
Net increase (decrease) in cash | 50000 | |
Cash balance, beginning | 300000 | |
Cash balance, ending | 350000 |