In: Accounting
STOCHOS INC.
STATEMENT of FINANCIAL POISTION
June 30, 2018
ASSETS LIABILITIES
Cash $222,000 Accounts Payable $150,000
Accounts Rec. 58,000 Mortgage Payable 500,000
Inventory 4,000
Supplies 6,000 TOTAL LIABILITIES $650,000
Land 210,000
Buildings $900,000 STOCKHOLDER EQUITY
Acc. Depr. <200,000> 700,000
Equipment 260,000 Common Stock $5 Par $500,000
Acc. Depr <60,000> 200,000 Excess $100,000
Retained Earnings $150,000
TOTAL EQUITY $750,000
TOTAL ASSETS $1,400,000 TOTAL LIAB. & EQUITY $1,400,000
July 1 Sold 220,000 shares of common stock for $6,600,000.
July 3 Purchased on account $100,000 of inventory for resale to customers.
July 5 Purchased a 2-year insurance policy for $4,800 in cash. Effective date is July 1.
July 7 Paid cash for $100,000 in inventory acquired July 3.
July 10 Sales revenue generated was $400,000. Cash received this date was $75,000 the
balance would be received later in the year.
July 30 Paid $40,000 in wages for the month of July.
July 30 Acquired $800,000 of equipment. Useful life is 10 years. Signed a note (12%)
for the full amount.
July 31 Paid $20,000 July monthly mortgage payment. The rate of interest on this
mortgage is 7 per cent.
Aug. 1 Stochos declared a dividend of $1 per share. Shareholders who owned shares on
August 15 would be paid the dividends in October.
Aug. 9 Stochos borrowed $180,000, and signed a note for this amount at 11 per cent.
Aug. 15 Customers returned $80,000 of items they acquired on July 10.
Aug. 18 Stochos sold 100,000 shares for $80 per share.
Aug. 30 Paid August wages – the $40,000 was paid in cash.
Aug. 31 Paid the August mortgage payment of $20,000.
Aug. 30 Paid $30,000 on the equipment note entered into on July 30 of this year.
Aug. 30 Received full amount due from the July 10 sale.
Sept. 30 Supply inventory valued at $200.
Sept. 30 Sales on account to customers amounted to $135,000. Stochos Inc. received
$33,000 in cash on this date from customers.
Sept. 30 Wages were accrued this day in the amount of $40,000. Stochos Inc. informed
their employee that their checks would be available October 5th.
OTHER INFORMATION
1. Tax rate is 20%.
2. Building has a 20-year useful life from date of purchase.
3. All equipment has a useful life of ten years.
4. Inventory at the end of the quarter was $10,000.
PREPARE THE FOLLOWING:
1.
| Stochos Inc. Income Statement For the period ended September 30, 2018 |
||
| $ | $ | |
| Sales Revenue | 488,000 | |
| Cost of Goods Sold | 94,000 | |
| Gross Profit | 394,000 | |
| Operating Expenses | ||
| Wages Expense | 120,000 | |
| Supplies Expense | 5,800 | |
| Insurance Expense | 600 | |
| Depreciation Expense: Building | 11,250 | |
| Depreciation Expense: Equipment | 19,833 | |
| Interest Expense | 27,091 | |
| Total Operating Expenses | 184,574 | |
| Earnings before Taxes | 209,426 | |
| Income Tax Expense ( 20% ) | 41,885 | |
| Net Income | 167,541 | |
2.
| Stochos Inc. Statement of Retained Earnings For the period ended September 30, 2018 |
|
| Balance, July 1 | $ 150,000 |
| Add: Net Income | 167,541 |
| Less: Cash Dividends | (320,000) |
| Balance, September 30 | $ (2,459) |
3.
| Stochos Inc. Balance Sheet September 30, 2018 |
|||||
| Assets | $ | $ | Liabilities and Stockholders' Equity | $ | $ |
| Cash | 15,100,200 | Accounts Payable | 150,000 | ||
| Accounts Receivable | 193,000 | Wages Payable | 40,000 | ||
| Inventory | 10,000 | Income Taxes Payable | 41,885 | ||
| Supplies | 200 | Dividends Payable | 320,000 | ||
| Prepaid Insurance | 4,200 | Interest Payable | 13,357 | ||
| Total Current Assets | 15,307,600 | Total Current Liabilities | 565,242 | ||
| Land | 210,000 | Mortgage Payable | 465,734 | ||
| Buildings,net | 688,750 | 12 % Note Payable | 778,000 | ||
| Equipment,net | 980,167 | 11% Note Payable | 180,000 | ||
| Total Fixed Assets | 1,878,917 | Total Liabilities | 1,988,976 | ||
| Common Stock | 2,100,000 | ||||
| Excess | 13,100,000 | ||||
| Retained Earnings | (2,459) | ||||
| Total Stockholders' Equity | 15,197,541 | ||||
| Total Assets | 17,186,517 | Total Liabilities and Stockholders' Equity | 17,186,517 | ||
Workings:
Mortgage Amortization Schedule:
| Month | Amount Paid / Payable | Interest Expense | Principal Repaid | Carrying Value of Mortgage Payable |
| $ 500,000 | ||||
| July | $ 20,000 | 2,917 | 17,083 | 482,917 |
| August | 20,000 | 2,817 | 17,183 | 465,734 |
| September | 20,000 | 2,717 | 17,283 | 448,451 |
| 8,451 |
Amortization Schedule: Note Payable ( 12 % )
| Month | Amount Paid / Payable | Interest Expense | Principal Repaid | Carrying Value |
| July | $ 800,000 | |||
| August | $ 30,000 | 8,000 | 22,000 | 778,000 |
| September | $ 30,000 | 7,780 | 22,220 | 755,780 |
| 15,780 |
Interest expense on the 11 % note payable = $ 180,000 x 11 % x 52 / 360 = $ 2,860