this is my final project. i would really apprecite it if someone would help me.
For the past severat years, Jeff Horton has operated a part-time consulting business from his home. As of April 1, 20Y9, Jeff decided to move to rented quarters and to operate the business, which was to be known as Rosebud Consulting, on a full-time basis, Rosebud Consulting entered into the following transactions during Aprit: Apr: The following assets were received from Jeff Horton: cash, $20,000; accounts receivable, $14,700; supplies, $3,300; and 1. office equipment, $12,000. There were no liabilities received. 1. Paid three month's rent on a lease rental contract, $6,000. 2. Paid the premiums on property and casualty insurance policies, $4,200. 4. Received cash from clients as an advance payment for services to be provided and recorded it as unearned fees, $9,400. 5. Purchased additional office equipment on account from Smith Office Supply Co, $8,000. 6. Received cash from dients on account, $11,700. 10. Paid cash for a newipaper advertsement, $350. 12. Paid Simith Office Supply Co. for part of the debt incurred on Apra 5,$6,400. 12. Provided services on account for the peried Apni 1-12, $21,900. 14. Paid receptionist for two weeks' 2 alary, $1,650. Record the following transactions on Page 2 of the journal: 17. Received cash from cash clients for fees eamed during the period April 1=16,56,600. 18. Paid cash for supplies, 5725 . Record the following transactions on Page 2 of the fournal: 17. Received cash from cash clients for fees earned during the period April 116,$6,600. 18. Paid cash for supplies, $725. 20: Provided sorvicos on account for the period April 13-20, $16,800. 24. Received cash from cash clients for fees earned for the period April 17-24, $4,450 26. Recelyed cash from cliems on account, 526,500 27. Pald receptionist for two weeks' salary, $1,650. 29. Paid telephone bill for Apri, \$S40, 30 Pald electrickty bill for April, $760. 30. Received cash from cash clients for fees earned for the period Appil 25-30, \$5, 160 . 30. Provided services on account for the remainder of April, $2,590. 30. Jeff withdrew $18,000 for personal use. 1. Journalize esch transaction, in chronological ordec, in a two-column journal starting on Page 1 , referring to the following chart of accounts in selecting the accounts to be dobited and credited. If there is more than one entry on the same date, be sure to enter the transactions in the exact order as presented in the data. (Do not insert the account numbers in the journal at this time.) If an amount box does not require an entry, leave it blank. Apr. 6 Apr. 10 Apr. 12 Apr. 12 Apr. 14 Apr. 27 Apr. 29 Apr. 30 Apr. 30 Apr. 30 Apr. 30 You will use the attached spreadsheet to complete several of the remaining parts of this problem. Click on the Spreadsheet icon above to open and save the Excel file to you computer. Your Input into the spreadsheet will not be included in your grade in CerigageNow on this problem. 2. Post the transactions from part 1 to the general ledger in the attached spreadsheet. The posting must be in chronological order. Be sure to go back and enter the appropnate posting references in the journal. 3. In the spreadsheet, prepore an unadjusted trial balance. 4. At the end of Aprit, the following adjuttment data were assumbied, Analyze and use these dato to complete parts (5) and (6). a. Insurance expired during April is $350. b. Supplies on hand on Apri 30 are $1,225. c. Depreciation of offee equipment for Apti is $400. d. Accrued receptionist salary on Apct 30 is $275. e. Rent expired during April is $2,000. 1. Unearned fees on April 30 are $2,350. 5. (Optional) In the spreadsheet, notice that the unodjusted trial balance amounts have been entered. Enter the adjusting entries and complete the remainder of the worksheet. 6. Journalize the adjusting entries on Page 3 of the joumal. (Do not insert the account numbers in the journal at this time).) Fost the adjusting entries to the general iedper in the spreadsheet. The posting must be in chronological order. Then go back and enter the spproptiate posting references in the joumal, If an amount box does not require 6. Joumalize the adjusting entries on Page 3 of the journal. (Do not insert the account numbers in the journal at this time.) Post the adjusting entries to the general ledger in the spreadsheet. The posting must be in chronoliggical order. Then go back and enter the appropriate posting references in the journal. If an amount box does not require an entry, leave it blank. 7. In the spreadsheet, prepare an adjusted trial balance. 8. Prepare an income statement, a statement of owner's equity, and a balance sheet. 7. In the spreadsheet, prepare an adjusted trial balance. Rosebud Consulting Statement of Owner's Equity For the Month Ended April 30, 20 Y9 Rosebud Consulting Balance Sheet April 30, 20 Y9 Assets Current assets: Total current assets Property, plant and equipment Total property, phant and equipment Uatilibes Current tiabilites: Total liabilities Owner's Equity Rosebud Consulting Balance Sheet April 30, 20Y9 Uabilites Current liabilities: Total liabitities Owner's Equity Total liabilities and owner's equity 9. Journalize the closing entnes on Page 4 of the journal. (Do not insert the account numbers in the journal at this time.) Post the closing entries to the general ledger spreadsheet. Then go back and enter the appropriate posting references in the journal: Rosebud Consulting Post-Closing Trial Balance April 30, 20Y9 Debit Balances Credit Balances