In: Accounting
Financial Statements from the End-of-Period Spreadsheet
Triton Consulting is a consulting firm owned and operated by Jayson Neese. The following end-of-period spreadsheet was prepared for the year ended April 30, 20Y3:
| Triton Consulting | |||||||
| End-of-Period Spreadsheet | |||||||
| For the Year Ended April 30, 20Y3 | |||||||
| Unadjusted | Adjusted | ||||||
| Trial Balance | Adjustments | Trial Balance | |||||
| Account Title | Dr. | Cr. | Dr. | Cr. | Dr. | Cr. | |
| Cash | 16,930 | 16,930 | |||||
| Accounts Receivable | 40,310 | 40,310 | |||||
| Supplies | 4,270 | 3,590 | 680 | ||||
| Office Equipment | 32,650 | 32,650 | |||||
| Accumulated Depreciation | 4,470 | 2,140 | 6,610 | ||||
| Accounts Payable | 10,880 | 10,880 | |||||
| Salaries Payable | 520 | 520 | |||||
| Common Stock | 13,000 | 13,000 | |||||
| Retained Earnings | 28,120 | 28,120 | |||||
| Dividends | 5,240 | 5,240 | |||||
| Fees Earned | 75,980 | 75,980 | |||||
| Salary Expense | 29,830 | 520 | 30,350 | ||||
| Supplies Expense | 3,590 | 3,590 | |||||
| Depreciation Expense | 2,140 | 2,140 | |||||
| Miscellaneous Expense | 3,220 | 3,220 | |||||
| 132,450 | 132,450 | 6,250 | 6,250 | 135,110 | 135,110 | ||
Based on the preceding spreadsheet, prepare an income statement for Triton Consulting.
| Triton Consulting | ||
| Income Statement | ||
| For the Year Ended April 30, 20Y3 | ||
| $ | ||
| Expenses: | ||
| $ | ||
| Total expenses | ||
| $ | ||
Based on the preceding spreadsheet, prepare a statement of stockholders’ equity for Triton Consulting. During the year ended April 30, 20Y3, common stock of $5,000 was issued. If an amount box does not require an entry, leave it blank. If a net loss is incurred or dividends were paid, enter that amount as a negative number using a minus sign.
| Triton Consulting | |||
| Statement of Stockholders’ Equity | |||
| For the Year Ended April 30, 20Y3 | |||
| Common Stock | Retained Earnings | Total | |
| $ | $ | $ | |
| $ | $ | $ | |
Based on the preceding spreadsheet, prepare a balance sheet for Triton Consulting.
| Triton Consulting | ||
| Balance Sheet | ||
| April 30, 20Y3 | ||
| Assets | ||
| Current assets: | ||
| $ | ||
| Total current assets | $ | |
| Property, plant, and equipment: | ||
| $ | ||
| Total property, plant, and equipment | ||
| Total assets | $ | |
| Liabilities | ||
| Current liabilities: | ||
| $ | ||
| Total liabilities | $ | |
| Stockholders' Equity | ||
| Total stockholders' equity | ||
| Total liabilities and stockholders' equity | ||
| Income Statement | ||
| Revenue | ||
| Fees Earned | $ 75,980 | |
| Total Revenue | $ 75,980 | |
| Expenses | ||
| Salary expense | $ 30,350 | |
| Supplies Expense | $ 3,590 | |
| Depreciation Expense | $ 2,140 | |
| Misc Expense | $ 3,220 | |
| Total Expenses | $ 39,300 | |
| Net Income | $ 36,680 |
| Statement of Stockholder's Equity | |||
| Common Stock | Retained Earnings | Total | |
| Beginning Balance | $ 13,000 | $ 28,120 | $ 41,120 |
| Add Net Income | $ 36,680 | $ 36,680 | |
| $ 13,000 | $ 64,800 | $ 77,800 | |
| Less Dividends | $ (5,240) | $ (5,240) | |
| Ending Balance | $ 13,000 | $ 59,560 | $ 72,560 |
| Balance Sheet | ||
| Assets | ||
| Current Assets | ||
| Cash | $ 16,930 | |
| Accounts Receivable | $ 40,310 | |
| Supplies | $ 680 | |
| Total Current Assets | $ 57,920 | |
| Property, Plant and Equipment | ||
| Office Equipment | $ 32,650 | |
| Less : Accumulated Depreciation | $ (6,610) | |
| Total Property, Plant and Equipment | $ 26,040 | |
| Total Assets | $ 83,960 | |
| Liabilities & Stockholder's Equity | ||
| Current Liabilities | ||
| Accounts Payable | $ 10,880 | |
| Salaries Payable | $ 520 | |
| Total Current Liabilities | $ 11,400 | |
| Stockholder's Equity | ||
| Common Stock | $ 13,000 | |
| Retained Earnings | $ 59,560 | |
| Total Stockholder's Equity | $ 72,560 | |
| Total Liabilities & Stockholder's Equity | $ 83,960 | |