In: Accounting
Create a balance sheet (assets, liabilities, equity, liabilities + equity) for Tech Co using the following information:
| Adjusted Trial Balance | ||
| As of December 31, 2014 | ||
| Debits | Credits | |
| Cash | 278,554,562 | |
| Accounts Receivable | 128,102,723 | |
| Allowance for Doubtful Accounts | 5,764,623 | |
| Inventory | 1,438,773,206 | |
| Merchandise Purchases | 2,363,146,864 | |
| Buildings | 198,895,751 | |
| Accumulated Depreciation - Building | 84,843,130 | |
| Equipment | 104,891,998 | |
| Accumulated Depreciation - Equipment | 42,768,575 | |
| Trademark | 80,000 | |
| Accounts Payable | 1,243,547,398 | |
| Interest Payable | 2,258,179 | |
| Taxes Payable | 9,015,728 | |
| Notes Payable | 160,391,997 | |
| Bonds Payable | 200,000 | |
| Premium on Bonds Payable | 3,600 | |
| Dividends Payable | 1,500,000 | |
| Unearned Sales Revenue | 108,892,400 | |
| Unearned Consulting Revenue | 15,000 | |
| Common Stock | 32,000 | |
| Add'l Paid in Capital | 8,853,900 | |
| Retained Earnings | 230,336,598 | |
| Sales Revenue | 3,300,237,000 | |
| Sales Discount | 38,407 | |
| Salary Expense | 234,555,520 | |
| Interest Expense | 60,188,228 | |
| Advertising Expense | 293,199,650 | |
| COGS | 71,249,808 | |
| Bad Debt Expense | 992,884 | |
| Depreciation Expense | 25,990,526 | |
| Total | 5,198,660,127 | 5,198,660,128 |
Ans.
| INCOME STATEMENT | |
| Sales | 3,300,237,000 |
| Less: Sales Discount | 38,407 |
| Net Sales | 3,300,198,593 |
| Less: Merchandise Purchases | 2,363,146,864 |
| Less: Cost of Goods Sold | 71,249,808 |
| Less : Other Expenses : | |
| Salaries expense | 234,555,520 |
| Interest Expense | 60,188,228 |
| Advertising Expense | 293,199,650 |
| Bad Debt Expense | 992,884 |
| Depreciation | 25,990,526 |
| Net Income | 250,875,113.00 |
| Dividends | - |
| Addition to retained earnings | 250,875,113.00 |
| BALANCE SHEET | |||||
| Assets | Amount | Amount | Liabillities & Owner’s Equity | Amount | Amount |
| Current Assets | Current Liabilities | ||||
| Accounts payable | 1,243,547,398 | ||||
| Cash | 278,554,562 | Unearned Sales Revenue | 108,892,400 | ||
| Accounts receivable | 128,102,723 | Unearned Consulting Revenue | 15,000 | ||
| Less : Allowance for doubtful accounts | 5,764,623 | 122,338,100 | Interest Payable | 2,258,179 | |
| Inventory | 1,438,773,206 | Taxes Payable | 9,015,728 | ||
| Dividend Payable | 1,500,000 | ||||
| Total | 1,365,228,705 | ||||
| Total | 1,839,665,868 | ||||
| Long-term Liabilities | |||||
| Notes Payable | 160,391,997 | ||||
| Bond Payable | 200,000 | ||||
| Fixed Assets | Add : Premium on Bonds payable | 3,600 | 203,600 | ||
| Tangible Fixed Assets | Total Liabilities | 1,525,824,302 | |||
| Building | 198,895,752 | ||||
| Less: Accumulated Depreciation | 84,843,130 | 114,052,622 | Owner’s Equity | ||
| Equipment | 104,891,998 | Common Stock | 32,000 | ||
| Less: Accumulated Depreciation | 42,768,575 | 62,123,423 | Additional paid in capital | 8,853,900 | |
| Intangible Fixed Assets | Total paid in capital | 8,885,900 | |||
| Trademark | 80,000 | ||||
| Total | 176,256,045 | Retained Earnings | 481,211,711 | ||
| Subtotal | 490,097,611 | ||||
| Total | 490,097,611 | ||||
| Total Assets | 2,015,921,913 | Total Liabilities &Owner’s Equity | 2,015,921,913 |
| Statement of Retained Earnings | |
| Beginning Balance | 230,336,598.00 |
| Add : Net Income | 250,875,113.00 |
| Less : Dividend Paid | - |
| Ending Retained Earnings | 481,211,711.00 |
Note : There is a difference in Trial Balance of 1 so it is adjusted by increasing the balance of Building. It may be possible that some other balance may be rectified to match the Trial Balance.