In: Accounting
At the beginning of 2019, three entrepreneurs decided to form a small business and organize as a corporation. Their business is called The Property People, and they will serve homeowners who require assistance with home maintenance and small home improvement projects. Until the business is established, the owners will not leave their full-time jobs. However, they all have flexibility to arrange their work schedules and cover for one another. Each investor received 100 shares of stock. In return for the shares of stock, the company received a total of $10,000 in cash from two investors who each contributed $5,000 in cash; the other investor contributed equipment valued at $5,000. The equipment has a useful life of 10 years, and the company records depreciation using the straight-line method (i.e., equal amounts each period).
During the first six-months of the year, The Property People completed jobs totaling $94,000. On June 30th, at the end of first six months, the company owners had received cash payments of $72,000. The owners expect to collect the remainder of the outstanding balance. At the end of June, the owners were offered an opportunity to purchase some generators at a terrific bargain price. The owners decided that in addition to providing maintenance they will also sell and install generators. At the end of June, they purchased the generators paying $4,000 in cash. They are storing the generators in their garages, and they are confident they will be able to sell them to customers in the future (no generators were sold in June). Expenses for the first six months total $48,000, which they have paid in cash except for $6,000 that they currently owe to suppliers. The only other cash outlay is the $1,800 annual premium for liability insurance they paid at the beginning of the year.
Upload an Excel file that includes the following components:
Income Statement for Six Months ended June 30,2019 | ||||
Revenues | ||||
Service Revenue | 94,000 | |||
Total Revenues | 94,000 | |||
Expenses:- | ||||
Expense | 48,000 | |||
Depreciation (5,000 / 10) x 6/12 | 250 | |||
Insurance ( 1,800 x 6 ) /12 | 900 | |||
Total Expenses | 49,150 | |||
Net Income | 44,850 | |||
Balance Sheet as of June 30,2019 | ||||
Assets | Amount | |||
Non-current assets | ||||
Equipment | 5,000 | |||
Less: Accumulated Depreciation | 250 | |||
4,750 | ||||
Current assets | ||||
Cash (10,000 + 72,000 - 4,000 - 42,000 - 1,800 ) | 34,200 | |||
Accounts Receivables (94,000 - 72,000 ) | 22,000 | |||
Inventory | 4,000 | |||
Prepaid Insurance ( 1,800 - 900 ) | 900 | |||
61,100 | ||||
Total Assets | 65,850 | |||
Liabilities & Equity | ||||
Current Liabilities | ||||
Accounts Payable | 6,000 | |||
6,000 | ||||
Equity | ||||
Common stock (5,000 x 3 ) | 15,000 | |||
Opening Retained Earnings | - | |||
Add: Profit during the year | 44,850 | |||
59,850 | ||||
Total Equity & Liabilities | 65,850 | |||
- |