In: Accounting
The following balances were included in the Adjusting Trial Balance of Q-Mart, Inc. at September 31, 2018
Note: not all balances from the adjusting trial balance were given:
| Sales | $5,375,000 |
| Depreciation Expense (admin) | 91,300 |
| Sales Discounts | 15,000 |
| Cost of Goods Sold | 3,589,000 |
| Property Tax Expense (admin) | 17,000 |
| Sales Salaries Expense | 57,000 |
| Bad Debt Expense (selling) | 18,500 |
| Sales Bonus Expense | 17,500 |
| Building expense (admin) | 225,000 |
| Travel expense | 28,500 |
| Freight-out (shipping) | 37,000 |
| Miscellaneous Expenses (admin) | 15,000 |
| Entertainment expense (customers) | 6,000 |
| Sales Returns | 55,000 |
| Telephone and Internet expense (selling) | 15,000 |
| Dividend Revenue | 29,000 |
| Depreciation Expense (selling) | 6,000 |
| Bond Interest expense | 39,000 |
| Building expense (selling) | 16,000 |
| Income taxes Expense | 350,000 |
| Miscellaneous expense (selling) | 4,700 |
| Depreciation understated due to error in 2015 (net of tax) | 73,000 |
| Office Supplies Expense - admin | 5,100 |
| telephone and internet expense | 3,500 |
| rent expense (admin) | 75,000 |
| rent expense (admin) | 35,000 |
| dividends declared on preferred stock | 275,000 |
| dividends declared on common stock | 158,000 |
The retained earnings account had a balance of $229,000 at October 1, 2017 (at the start of the fiscal year)
There were 50,000 shares of common stock outstanding for the entire year.
Instructions
Create:
1. a multiple-step income statement for the year ending September
31, 2018
2. A retained earning statement for the year ending September 31,
2018
1. Multistep Income Statement is as below:
| Particulars | Amount ($) | Amount ($) |
| Sales | 5375000 | |
| Less: Sales discounts | 15000 | |
| : Freight out | 37000 | |
| : Sales returns | 55000 | |
| Net Revenue | 5268000 | |
| Cost of goods sold | 3589000 | |
| Gross Profit | 1679000 | |
| Less: Selling & Administrative Expenses: | ||
| Administrative Expenses | ||
| Depreciation | 91300 | |
| Property tax | 17000 | |
| Building expenses | 225000 | |
| Miscellaneous expenses | 15000 | |
| Office supplies | 5100 | |
| Telephone & internet expense | 3500 | |
| Rent | 110000 | |
| Total Administrative expenses | 466900 | |
| Selling Expenses: | ||
| Sales salaries expense | 57000 | |
| Bad debt expense | 18500 | |
| Sales bonus expenses | 17500 | |
| Travel expense | 28500 | |
| Entertainment expense | 6000 | |
| Telephone & internet expense | 15000 | |
| Depreciation | 6000 | |
| Building expenses | 16000 | |
| Miscellaneous expenses | 4700 | |
| Total Selling Expenses | 169200 | |
| Less: Income tax expense | 350000 | |
| Operating Income | 692900 | |
| Non operating items: | ||
| Dividend revenue | 29000 | |
| Less: Bond interest expense | 39000 | |
| Net non operating expense | 10000 | |
| Net Income before extraordinary item | 682900 | |
| Less: depreciation due to error in 2015 | 75000 | |
| Net Income | 607900 | |
| Number of common shares | 50000 | |
| Earnings per share | $12.16 |
2. Retained Earnings Statement is as below:
| Particulars | Amount ($) |
| Beginning retained earnings | 229000 |
| Add: Net Income | 692900 |
| Less: Preferred dividend | 275000 |
| Less: Common stock dividend | 158000 |
| Ending Retained Earnings | 488900 |