In: Accounting
Required information
Exercise 7-21B Complete the accounting cycle using long-term asset transactions (LO7-4, 7-7)
5. Prepare a classified balance sheet as of January 31, Year 1.
[The following information applies to the questions
displayed below.]
On January 1, Year 1, the general ledger of a company includes the
following account balances:
| Accounts | Debit | Credit | |||||
| Cash | $ | 59,100 | |||||
| Accounts Receivable | 25,800 | ||||||
| Allowance for Uncollectible Accounts | $ | 2,600 | |||||
| Inventory | 36,700 | ||||||
| Notes Receivable (5%, due in 2 years) | 16,800 | ||||||
| Land | 159,000 | ||||||
| Accounts Payable | 15,200 | ||||||
| Common Stock | 224,000 | ||||||
| Retained Earnings | 55,600 | ||||||
| Totals | $ | 297,400 | $ | 297,400 | |||
During January Year 1, the following transactions occur:
| January | 1 | Purchase equipment for $19,900. The company estimates a residual value of $1,900 and a five-year service life. | ||
| January | 4 | Pay cash on accounts payable, $9,900. | ||
| January | 8 | Purchase additional inventory on account, $86,900. | ||
| January | 15 | Receive cash on accounts receivable, $22,400. | ||
| January | 19 | Pay cash for salaries, $30,200. | ||
| January | 28 | Pay cash for January utilities, $16,900. | ||
| January | 30 | Sales for January total $224,000. All of these sales are on account. The cost of the units sold is $117,000. |
Information for adjusting entries:
rev: 11_22_2018_QC_CS-148298, 06_13_2019_QC_CS-170054
Exercise 7-21B Part 5
5. Prepare a classified balance sheet as of January 31, Year 1.
Solution: According to the Question, we need to prepare classified Balance sheet of the company:
|
BALANCE SHEET As of January 31, Year 1 |
|||
| Particulars | ($) | Amount ($) | Total |
| 1. ASSETS: | |||
| Current Assets: | |||
| Cash | $4,600 | ||
| Accounts Receivable | $227,400 | ||
| Less:Allowance for Uncollectible Accounts | -$8,420 | ||
| Inventory | $6,600 | ||
| Interest Receivable/ Accrued Interest | $70 | ||
| Total Current Assets- | $230,250 | ||
| Non-Current Assets: | |||
| Notes Receivable (5% due in 2 years) | $16,800 | ||
| Land | $159,000 | ||
| Equipment | $19,900 | ||
| Less: Accumulated Depreciation | -$300 | ||
| Total Non-Current Assets- | $195,400 | ||
| Total Assets: | $425,650 | ||
| 2. LIABILITIES: | |||
| Current Liabilities: | |||
| Accounts Payable | $92,200 | ||
| Salaries Payable | $33,000 | ||
| Income Tax Payable | $9,400 | ||
| Total Current Liabilities | $134,600 | ||
| Stockholder's Equity: | |||
| Common Stock | $224,000 | ||
| Retained Earnings | $55,600 | ||
| (+)Net Income | $11,450 | ||
| Total Stockholder's Equity- | $291,050 | ||
| Total Liabilities and Stockholder's Equity: | $425,650 |
Working Notes:
1. For Net Income, we need to prepare Income Statement:
| INCOME STATEMENT | ||
| ($) | Amount ($) | |
| Sales | $224,000 | |
| Less:Cost of Goods sold- | $117,000 | |
| Gross profit | $107,000 | |
| Less: Operating Expenses | ||
| Salaries Expense | $63,200 | |
| Utilities Expense | $16,900 | |
| Depreciation-eqp. | $300 | |
| Bad Debts | $5,820 | |
| Total Operating Expenses- | $86,220 | |
| Operating Income | $20,780 | |
| Interest Income | $70 | |
| Net Income Before Taxes | $20,850 | |
| Income Tax | $9,400 | |
| Net Income- | $11,450 |
2.Calculation of Depreciation on Equipment= Cost-Residual Value/ Useful Life
={$19,900-$1,900/5}/12= $300
3.Calculation of Interest Receivable= {$16,800*5%}/12= $70