i just need to complete the worksheet but i suck at excel and dont know what formulas to use.

X Cut . General Copy Wrap Text Merge & Center - Paste Geneva - 9AA BIU.E. A. Font Format Painter = $ - % , Alignment Number H31 CD PROJECT INFORMATION 23 You have been hired as an accountant for BeeMoor Consulting Inc. This business was created when some friends decided to make use of their newly minted college degrees and go into business together The business was created on January 1, 2019. The company will have a fiscal year end of December 31. The initial formation transactions and early purchases for BeeMoor Consulting Inc. resulted in the balances that are included in the first 2 columns of the Worksheet. (see the worksheet tab) Amount 0 .02 interest rate During January, the first month of operations, the following transactions occurred: 27 Date Event Amount 28 1 Jan Paid for 12 months rent on office space 11,400 29 3-Jan Purchased additional office supplies on account. 9,562 30 4-Jan Purchased office furniture. 8,590 Borrowed cash from the bank for operating expenses. The note charges simple interest and is to be paid 31 8-Jan back in 5 years 30,000 loan amt 32 10-Jan Paid for utilities. 1,650 33 14-Jan Received cash in advance from Stanley Inc. for work to be performed over the next 12 months. 13,200 34 15-Jan Performed services for various customers for cash and on account. 11,560 cash 35 26-Jan Paid the bill for supplies purchased previously 9,860 36 28-Jan Paid salaries to employees for 1 week. 4,650 37 29-Jan Dividends were declared and paid 1,000 38 31-Jan Collected payments for amounts previously billed. 19,650 22560 on account At the end of January, the following additional information is available to help determine what adjustments are needed: Amount Amount instead of the numbers. Save your file with the formulas displayed. Prepare adjusting entries for the month of January given the information provided. Post the adjusting entries to the Adjusting entries columns on the worksheet Prepare an adjusted trial balance as of January 31, 2019. This will be part of the Worksheet you prepare. There is a tab in this file that you will use for this Copy the Worksheet from the Worksheet tab to the Worksheet formulas tab. Highlight the entire worksheet area and press the "ctrl" key and the "-"key. This will cause the formulas used to display instead of the numbers. Save your file with the formulas displayed. repare financial statement for the month and in I . 21. 2018 A r BEGINNING NUMBERS Worksheet - BeeMoor Consulting Inc UNADJUSTED TRIAL JANUARY ENTRIES BALANCE DEBIT CREDIT DEBIT CREDIT ADJUSTMENTS ADJUSTED TRIAL BALANCE DEBIT CREDIT ACCOUNT DEBIT CREDIT DEBIT CREDIT Cash 88,500 5 Accounts Receivable 6 Supplies 9.800 7 Prepaid Rent 8 Land 35,000 9 Computer Equipment 36,500 10 Accumulated Depreciation Comp Equip 11 Office Furniture 12 Accumulated Depreciation Off Furn 13 Accounts Payable 14 Salaries Payable 15 Interest Payable 16 Uneamed Revenue 17 Long term Notes Payable 18 Common Stock 180.000 19 Retained Earnings 20 Dividends 21 Service Revenue 22 Salaties Expense 23 Rent Expense info Sheet1 JE ADJUSTING JE CLOSING JE Ready O Type here to search Worksheet statements worksheet formulas financial staten Jennifer Camarena Project 1 Part Tell me what you want to do File Home Insert Page Layout Formulas Data Review View Help XLSTAT = Custom X Cut Copy Format Painter Clipboard Times New Rom: - 12 B IU.L. A A S.A. = = Wrap Text Merge & Center - = E $ - % Font Alignment Number X 30000 C D E F At the end of January, the following additional information is available to help determine what adjustments are needed: Amount Amount 5670 3 4 5 31-Jan Supplies were counted at month end 31-Jan One month of the services for Stanley Inc. has been performed (see above). 31 Jan One month of interest has accrued on the note payable for the bank loan. Additional work for customers has been performed during the last week of January but not billed yet 31-Jan 31-Jan One month of the prepaid rent has been used up Depreciation expense needs to be recognized for the computer equipment and for the office furniture 31-Jan Salaries are paid every Friday (for a 5 day work week). January 31, 2019 was a Thursday 6 7 6580 165 comp equip 4,650 190 off furn # You are encourated to get help from the tutors in the Accounting Lab. You can also get help by email puudu X for 30000 Response time for emails sent to the accounting lab should be within 12 hours. Also, there will be no mely response to project emails sent after 2p on the project due dates. Don't wait until the last minute. There will be no response to accounting lab emails on Sundays. SUGGESTED STEPS FOR COMPLETION OF THE PROJECT: Prepare journal entries to record the January transactions given. Please refer to the Worksheet tab for Account Titles you may need Add the January journal entry information to the Worksheet in the January columns. You can do this in one of 2 ways -(1) Post the journal entries to ledger accounts using T-accounts to represent ledger accounts and then use those totals to post to the worksheet or (2) use excel to add all entries for a particular account into the correct column in the worksheet Ge.. add all cash debits from the journal entries into the cash debit column for January entries). There is a tab to use for T Accounts if you want but the T Accounts are NOT required Prepare an unadjusted trial balance as of January 31, 2019. This will be part of the Worksheet you prepare. There is a tab in this file that you will use for this. Excel formulas must be used throughout the project to obtain full credit Copy the Worksheet from the Worksheet tab to the Worksheet formulas tab.. Highlight the entire worksheet area and press the "ctrl key and the key. This will cause the formulas used to display instead of the numbers. Save your file with the formulas displayed Prepare adjusting entries for the month of January given the information provided Post the adjusting entries to the Adjusting entries columns on the worksheet Prepare an adjusted trial balance as of January 31, 2019. This will be part of the Worksheet you prepare. There is a tab in this file that you will use for this. Copy the Worksheet from the Worksheet tab to the Worksheet formulas tab. Highlight the entire worksheet area and press the "ctrl key and the key. This will cause the formulas used to display instead of the numbers. Save your file with the formulas displayed Prepare financial statements for the month ending January 31, 2019. (Income Statement, Statement of Retained Earnings, Classified Balance Sheet). Formatting is important and will be graded so be sure you info Sheet1 JE ADJUSTING JE CLOSING JE Worksheet statements Type here to search W Clipboard Font Alignment X fr 30000 Copy the Worksheet from the Worksheet tab to the Worksheet formulas tab. Highlight the entire worksheet area and press the "ctrl key and the "-"key. This will cause the formulas used to display instead of the numbers. Save your file with the formulas displayed. Prepare financial statements for the month ending January 31, 2019. (Income Statement, Statement of Retained Earnings, Classified Balance Sheet). Formatting is important and will be graded so be sure you use dollar signs and underlines as appropriate. Also be sure you have headings and proper column usage for all statements. There is a tab for these statements. Heading are PARTIALLY completed for the 3 statements Prepare closing entries for the end of the period Copy the Worksheet from the Worksheet tab to the Worksheet formulas tab and the Financial Statements from the Financial Statements tab to the Financial Statements tab. Highlight the entire worksheet/financial statements area respecively and press the "ctrl" key and the "-"key. This will cause the formulas used to display instead of the numbers. Save your file with the formulas displayed. Each student met submit ORICINLAT N ICI. AL.. . your file correctly will result in a l point deduction PARTIAL CREDIT FOR LATE SUBMISSION OF PARTS 1 AND 2 Because you will need to complete Part 1 to be able to complete Part 2 and complete Part 2 to complete Part 3 you may earn partial credit for an earlier part of the Project that you did NOT submit in a timely fashion when you submit the subsequent part of the project. For example, if you do not complete and submit Part 1 of the project by the due date you will lose the 10 points alloccated to that part of the project. If you complete that part of the project and submit it to the part 1 link before the final due date for the complete project, you can earn up to 50% of the possible points. There is NO late submission for part 3 of the project. YOU MUST USE FORMULAS TO BE CONSIDERED FOR FULL CREDIT ON THE PROJECTS PROJECT INFORMATION You have been hired as an accountant for Bee Moor Consulting Inc. This business was created when some friends decided to make use of their newly minted college degrees and go into business together The business was created on January 1, 2019. The company will have a fiscal year end of December 31. The initial formation transactions and early purchases for Bee Moor Consulting Inc. resulted in the balances that are included in the first 2 columns of the Worksheet (see the worksheet tab) Amount During January, the first month of operations, the following transactions occurred: Date Event 1-Jan Paid for 12 months rent on office space 3-Jan Purchased additional office supplies on account 1. lan Dew a fiwa info Sheet1 JE ADJUSTING JE CLOSING JE Worksheet 9,562 500 statements O Type here to search X Cut . General Copy Wrap Text Merge & Center - Paste Geneva - 9AA BIU.E. A. Font Format Painter = $ - % , Alignment Number H31 CD PROJECT INFORMATION 23 You have been hired as an accountant for BeeMoor Consulting Inc. This business was created when some friends decided to make use of their newly minted college degrees and go into business together The business was created on January 1, 2019. The company will have a fiscal year end of December 31. The initial formation transactions and early purchases for BeeMoor Consulting Inc. resulted in the balances that are included in the first 2 columns of the Worksheet. (see the worksheet tab) Amount 0 .02 interest rate During January, the first month of operations, the following transactions occurred: 27 Date Event Amount 28 1 Jan Paid for 12 months rent on office space 11,400 29 3-Jan Purchased additional office supplies on account. 9,562 30 4-Jan Purchased office furniture. 8,590 Borrowed cash from the bank for operating expenses. The note charges simple interest and is to be paid 31 8-Jan back in 5 years 30,000 loan amt 32 10-Jan Paid for utilities. 1,650 33 14-Jan Received cash in advance from Stanley Inc. for work to be performed over the next 12 months. 13,200 34 15-Jan Performed services for various customers for cash and on account. 11,560 cash 35 26-Jan Paid the bill for supplies purchased previously 9,860 36 28-Jan Paid salaries to employees for 1 week. 4,650 37 29-Jan Dividends were declared and paid 1,000 38 31-Jan Collected payments for amounts previously billed. 19,650 22560 on account At the end of January, the following additional information is available to help determine what adjustments are needed: Amount Amount instead of the numbers. Save your file with the formulas displayed. Prepare adjusting entries for the month of January given the information provided. Post the adjusting entries to the Adjusting entries columns on the worksheet Prepare an adjusted trial balance as of January 31, 2019. This will be part of the Worksheet you prepare. There is a tab in this file that you will use for this Copy the Worksheet from the Worksheet tab to the Worksheet formulas tab. Highlight the entire worksheet area and press the "ctrl" key and the "-"key. This will cause the formulas used to display instead of the numbers. Save your file with the formulas displayed. repare financial statement for the month and in I . 21. 2018 A r BEGINNING NUMBERS Worksheet - BeeMoor Consulting Inc UNADJUSTED TRIAL JANUARY ENTRIES BALANCE DEBIT CREDIT DEBIT CREDIT ADJUSTMENTS ADJUSTED TRIAL BALANCE DEBIT CREDIT ACCOUNT DEBIT CREDIT DEBIT CREDIT Cash 88,500 5 Accounts Receivable 6 Supplies 9.800 7 Prepaid Rent 8 Land 35,000 9 Computer Equipment 36,500 10 Accumulated Depreciation Comp Equip 11 Office Furniture 12 Accumulated Depreciation Off Furn 13 Accounts Payable 14 Salaries Payable 15 Interest Payable 16 Uneamed Revenue 17 Long term Notes Payable 18 Common Stock 180.000 19 Retained Earnings 20 Dividends 21 Service Revenue 22 Salaties Expense 23 Rent Expense info Sheet1 JE ADJUSTING JE CLOSING JE Ready O Type here to search Worksheet statements worksheet formulas financial staten Jennifer Camarena Project 1 Part Tell me what you want to do File Home Insert Page Layout Formulas Data Review View Help XLSTAT = Custom X Cut Copy Format Painter Clipboard Times New Rom: - 12 B IU.L. A A S.A. = = Wrap Text Merge & Center - = E $ - % Font Alignment Number X 30000 C D E F At the end of January, the following additional information is available to help determine what adjustments are needed: Amount Amount 5670 3 4 5 31-Jan Supplies were counted at month end 31-Jan One month of the services for Stanley Inc. has been performed (see above). 31 Jan One month of interest has accrued on the note payable for the bank loan. Additional work for customers has been performed during the last week of January but not billed yet 31-Jan 31-Jan One month of the prepaid rent has been used up Depreciation expense needs to be recognized for the computer equipment and for the office furniture 31-Jan Salaries are paid every Friday (for a 5 day work week). January 31, 2019 was a Thursday 6 7 6580 165 comp equip 4,650 190 off furn # You are encourated to get help from the tutors in the Accounting Lab. You can also get help by email puudu X for 30000 Response time for emails sent to the accounting lab should be within 12 hours. Also, there will be no mely response to project emails sent after 2p on the project due dates. Don't wait until the last minute. There will be no response to accounting lab emails on Sundays. SUGGESTED STEPS FOR COMPLETION OF THE PROJECT: Prepare journal entries to record the January transactions given. Please refer to the Worksheet tab for Account Titles you may need Add the January journal entry information to the Worksheet in the January columns. You can do this in one of 2 ways -(1) Post the journal entries to ledger accounts using T-accounts to represent ledger accounts and then use those totals to post to the worksheet or (2) use excel to add all entries for a particular account into the correct column in the worksheet Ge.. add all cash debits from the journal entries into the cash debit column for January entries). There is a tab to use for T Accounts if you want but the T Accounts are NOT required Prepare an unadjusted trial balance as of January 31, 2019. This will be part of the Worksheet you prepare. There is a tab in this file that you will use for this. Excel formulas must be used throughout the project to obtain full credit Copy the Worksheet from the Worksheet tab to the Worksheet formulas tab.. Highlight the entire worksheet area and press the "ctrl key and the key. This will cause the formulas used to display instead of the numbers. Save your file with the formulas displayed Prepare adjusting entries for the month of January given the information provided Post the adjusting entries to the Adjusting entries columns on the worksheet Prepare an adjusted trial balance as of January 31, 2019. This will be part of the Worksheet you prepare. There is a tab in this file that you will use for this. Copy the Worksheet from the Worksheet tab to the Worksheet formulas tab. Highlight the entire worksheet area and press the "ctrl key and the key. This will cause the formulas used to display instead of the numbers. Save your file with the formulas displayed Prepare financial statements for the month ending January 31, 2019. (Income Statement, Statement of Retained Earnings, Classified Balance Sheet). Formatting is important and will be graded so be sure you info Sheet1 JE ADJUSTING JE CLOSING JE Worksheet statements Type here to search W Clipboard Font Alignment X fr 30000 Copy the Worksheet from the Worksheet tab to the Worksheet formulas tab. Highlight the entire worksheet area and press the "ctrl key and the "-"key. This will cause the formulas used to display instead of the numbers. Save your file with the formulas displayed. Prepare financial statements for the month ending January 31, 2019. (Income Statement, Statement of Retained Earnings, Classified Balance Sheet). Formatting is important and will be graded so be sure you use dollar signs and underlines as appropriate. Also be sure you have headings and proper column usage for all statements. There is a tab for these statements. Heading are PARTIALLY completed for the 3 statements Prepare closing entries for the end of the period Copy the Worksheet from the Worksheet tab to the Worksheet formulas tab and the Financial Statements from the Financial Statements tab to the Financial Statements tab. Highlight the entire worksheet/financial statements area respecively and press the "ctrl" key and the "-"key. This will cause the formulas used to display instead of the numbers. Save your file with the formulas displayed. Each student met submit ORICINLAT N ICI. AL.. . your file correctly will result in a l point deduction PARTIAL CREDIT FOR LATE SUBMISSION OF PARTS 1 AND 2 Because you will need to complete Part 1 to be able to complete Part 2 and complete Part 2 to complete Part 3 you may earn partial credit for an earlier part of the Project that you did NOT submit in a timely fashion when you submit the subsequent part of the project. For example, if you do not complete and submit Part 1 of the project by the due date you will lose the 10 points alloccated to that part of the project. If you complete that part of the project and submit it to the part 1 link before the final due date for the complete project, you can earn up to 50% of the possible points. There is NO late submission for part 3 of the project. YOU MUST USE FORMULAS TO BE CONSIDERED FOR FULL CREDIT ON THE PROJECTS PROJECT INFORMATION You have been hired as an accountant for Bee Moor Consulting Inc. This business was created when some friends decided to make use of their newly minted college degrees and go into business together The business was created on January 1, 2019. The company will have a fiscal year end of December 31. The initial formation transactions and early purchases for Bee Moor Consulting Inc. resulted in the balances that are included in the first 2 columns of the Worksheet (see the worksheet tab) Amount During January, the first month of operations, the following transactions occurred: Date Event 1-Jan Paid for 12 months rent on office space 3-Jan Purchased additional office supplies on account 1. lan Dew a fiwa info Sheet1 JE ADJUSTING JE CLOSING JE Worksheet 9,562 500 statements O Type here to search