| ACT 231 Principles of Accounting End of Course Project |
| For this end of course project, you will create an Income Statement, Statement of Retained Earnings, and a Balance Sheet using the correct format. |
| The information is provided below. Using Excel will make it easier to line up the columns. |
| Check your print settings. Each statement should be formated to print on one page. Therefore, if printed you will have three pages. |
| Use this Excel file to complete the assignment. Place the appropriate financial statement on the Excel Worksheet labeled for that statement. |
| Spelling and format counts. Please use your textbook to prepare the financial statements in the appropriate format. |
| Save the file in the format, your last name, ACT 231, EOC Project (i.e. Jaridau ACT 231 EOC Project) |
| | | | TigerPortal Adjusted Trial Balance |
| | | | December 31, 2021 |
| Account | | | Debit | | Credit |
| Cash | | | $44,000 |
| Accounts Receivable | | | 13,800 |
| Prepaid Insurance | | | 6,400 |
| Land | | | 16,000 |
| Accounts Payable | | | | | $14,900 |
| Salaries Payable | | | | | 4,500 |
| Common Stock | | | | | 31,000 |
| Retained Earnings | | | | | 10,200 |
| Dividends | | | 12,000 |
| Service Revenue | | | | | 86,000 |
| Insurance Expense | | | 7,600 |
| Salaries Expense | | | 32,000 |
| Miscellaneous Expense | | | 14,800 |
| | | | $146,600 | | $146,600 |
niyathebaddest
ACT231EndofCourseProject.xlsx
