Introduction: Company description (include the points below) Assume a service company of your own Give a suitable name to your company, Describe the nature of service it provides Date when business was started Location of business Owners- names Capital investment in the business Prepare an Unadjusted Trial Balance of xxx Company for the month or year using proper format in EXCEL. Home Insert Page Layout Formules Rachna Barjee & Share X Arty 13. Til balanc Excel spise - Excel Osta Review View Alat Pone Pivot tel me what you want to do Wire Tout Merge Center $% Conditional Formats Cell Formatting Tool Style -11 AA GRY C BIU Fumatut Find a Select Editing C20 D E F G H 1 FAST FORWARD TRIAL BALANCE 31-Dec 12 3 CREDIT DEBIT 4,275 9,720 2.400 25,000 5 ACCOUNT TITLE 6 Cash 1 Supplies & Prepaid insurance Equipment 10 Account payable 11 Unearned consulting revenue 12 Taylor, Capital 13 Taylor, withdrawal 14 Consulting revenue 15 Rental revenue 16 Salary expense 17 Rent expense 18 Ulties expense 19 Total 6.200 3,000 10,000 200 5,800 300 1,400 1,000 305 45,300 45,300 21 Sheet1 Disebord Transactions for making Adjustment entries Mention required transactions for adjusting entries- transactions that have occurred but no entrywas made. Therefore, your company needs to record adjusting entries for these transactions. Listed below are a number of Adjusting entries that need to be taken into account before preparing the Financial Statements for a service Company: 1. Service provided on credit to a customer but not recorded ( Account receivable/accrued revenue) 2. Supplies at hand and used at the end of year 3. Atleast 2 Prepaid expenses expired 4. Depreciation expense on equipment using straight line method 5. Atleast 2 Accrued expense (expense payable) 6. Portion of Unearned service revenue expired (revenue earned) Record Adjustment entries Using proper templates for all the schedules, prepare record the adjusting entries for thetransactions selected in the previous section. Adjusted Trial Balance Prepare an adjusted trial balance to reflect the above adjustments in EXCEL Financial statements (EXCEL) Prepare the following financial statements for your Company at the end of the month or year: i. Income statement ii. Statement of changes in equity iii. Classified balance sheet canalucian