Photos- 3010,1.PNG See all photos + Add to Woriboek Views Show Zoom Window Macros F23 A. JOURNAL ENTRIES - AugFig Consuting Inc 1. DATE ACCOUNT DEBIT CREDIT cash in cash out 3. *5 7. 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 JE ADIUSTING CLOSINGJE Worksheet Statements worksheet formulas financial statement formulas READY P Type here to search II Jee all piUIUS twaAMAnminan A1 ADJUSTING JOURNAL ENTRIES- AugFig Consulting Inc A. ADJUSTING JOURNAL ENTRIES - AugFig Consulting Inc DATE ACCOUNT DEBIT CREDIT 4. 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 JE ADJUSTING JE CLOSING JE Worksheet Statements worksheet formulas financial statement formulas P Type here to search 5, See all photos Add to - H18 CLOSING JOURNAL ENTRIES -AugFig Consulting Inc 2. DATE ACCOUNT DEBIT CREDIT 3. 4. 6. 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 ADJUSTING JE worksheet formulas financial statement formulas JE CLOSING JE Worksheet Statements See all photos + Add to N25 C. D. H. Worksheet - AugFig Consuting Inc UNADJUSTED TRIAL ADJUSTED TRIAL BALNCE BEGNNING NUMBERS JANUARY ENTRIES ADJUSTMENTS BALANCE 14 Salanes Payable 15 Interest Payable 16 Unearned Rovenue 17 Long-term Notes Payable 18 Common Stock 120.000 19 Retained Earnings 20 Dividends 21 Service Revenue 22 Salares Expense 23 Rent Expense 24 Supplies Expense 25 Utilities Expense 26 Interest Expense 27 Depreciation Expense, Comp Equip 28 Depreciation Expense, Office Furniture 29 30 128 650 128.650 31 32 33 34 35 36 Statements financial statement formulas worksheet formulas JE ADJUSTING JE CLOSING JE Worksheet O Type ere to search 20 See all photos + Add to W UUR VINWS D10 AugFig Consulting Inc Income Statement 3. AugFig Consulting Inc Balance Sheet 10 11 12 13 14 15 16 17 18 19 21 22 23 24 25 ADIUSTING JE CLOSING E Worksheet Statements worksheet formulas inancial statement formulas READY F20 D. IF 4. 6. 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 JE ADJUSTING JE CLOSING JE Worksheet Statements worksheet formulas financial statement formulas READY E21 H. 3. *8 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 30. JE ADJUSTING E CLOSING JE Worksheet Statements worksheet formulas financial statement formulas READY 20 Ver x Delay During January, the first month of operations, the following transactions occurred: Date 1-Jan Purchased additionial office supplies on account 3-Jan Received cash in advance from Stanley Ine. for work to be performed over the next 12 months. 4-Jan Borrowed cash from the bank for operating expenses. The note charges simple interest and is to be paid back in 5 Event Amount Amount 6,850 11,760 years 26,000 loan amt 8,100 3% interest rate S-Jan Paid for 12 months rent on office space 10-Jan Purchased office furniture. 14-Jan Paid for utilities. 11,260 2,340 9,750 cash 4,375 15-Jan Performed services for various customers for cash and on account. 26-Jan Paid salaries to employees for 1 week 28-Jan Collected payments for amounts previously billed. 29-Jan Paid the bill for supplies purchased previously. 18,950 on account 16,850 8,650 31-Jan Dividends were declared and paid. 2,000 At the end of January, the following additional information is available to help determine what adjustments are needed: Amount Amount 31-Jan One month of the prepaid rent has been used up 31-Jan One month of the services for Stanley Inc. has been performed (see above). 31-Jan Supplies were counted at month end 31-Jan One month of interest has accrued on the note payable for the bank loan. 31-Jan Additional work for customers has been performed during the last week of January but not billed yet 31-Jan Salaries are paid every Friday (for a 5 day work week). January 31, 2019 was a Tuesday 31-Jan Depreciation expense needs to be recognized for the computer equipment and for the office fumiture 675 086 11,120 4,380 65 5,480 4,375 185 comp equip 1,750 135 off fum Search SUGGESTED STEPS FOR COMPLETION OF THE PROJECT: Prepare joumal entries to record the January transactions given. Please refer to the Worksheet tab for Account Titles Vou may need Add the January journal entry information to the Worksheet in the January columns. You can do this in one of2 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 (ie., 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 gren 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 fomulas 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 Eamings, 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. SUGGESTED STEPS FOR COMMPLETION OF THE PROJECT: Prepare joumal 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 (ie, add all cash debits from the journal entries into the cash debit column for January entries). There is a tab to use forT 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 Eamings, 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 the for mlas used to display instead of the Photos- 3010,1.PNG See all photos + Add to Woriboek Views Show Zoom Window Macros F23 A. JOURNAL ENTRIES - AugFig Consuting Inc 1. DATE ACCOUNT DEBIT CREDIT cash in cash out 3. *5 7. 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 JE ADIUSTING CLOSINGJE Worksheet Statements worksheet formulas financial statement formulas READY P Type here to search II Jee all piUIUS twaAMAnminan A1 ADJUSTING JOURNAL ENTRIES- AugFig Consulting Inc A. ADJUSTING JOURNAL ENTRIES - AugFig Consulting Inc DATE ACCOUNT DEBIT CREDIT 4. 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 JE ADJUSTING JE CLOSING JE Worksheet Statements worksheet formulas financial statement formulas P Type here to search 5, See all photos Add to - H18 CLOSING JOURNAL ENTRIES -AugFig Consulting Inc 2. DATE ACCOUNT DEBIT CREDIT 3. 4. 6. 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 ADJUSTING JE worksheet formulas financial statement formulas JE CLOSING JE Worksheet Statements See all photos + Add to N25 C. D. H. Worksheet - AugFig Consuting Inc UNADJUSTED TRIAL ADJUSTED TRIAL BALNCE BEGNNING NUMBERS JANUARY ENTRIES ADJUSTMENTS BALANCE 14 Salanes Payable 15 Interest Payable 16 Unearned Rovenue 17 Long-term Notes Payable 18 Common Stock 120.000 19 Retained Earnings 20 Dividends 21 Service Revenue 22 Salares Expense 23 Rent Expense 24 Supplies Expense 25 Utilities Expense 26 Interest Expense 27 Depreciation Expense, Comp Equip 28 Depreciation Expense, Office Furniture 29 30 128 650 128.650 31 32 33 34 35 36 Statements financial statement formulas worksheet formulas JE ADJUSTING JE CLOSING JE Worksheet O Type ere to search 20 See all photos + Add to W UUR VINWS D10 AugFig Consulting Inc Income Statement 3. AugFig Consulting Inc Balance Sheet 10 11 12 13 14 15 16 17 18 19 21 22 23 24 25 ADIUSTING JE CLOSING E Worksheet Statements worksheet formulas inancial statement formulas READY F20 D. IF 4. 6. 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 JE ADJUSTING JE CLOSING JE Worksheet Statements worksheet formulas financial statement formulas READY E21 H. 3. *8 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 30. JE ADJUSTING E CLOSING JE Worksheet Statements worksheet formulas financial statement formulas READY 20 Ver x Delay During January, the first month of operations, the following transactions occurred: Date 1-Jan Purchased additionial office supplies on account 3-Jan Received cash in advance from Stanley Ine. for work to be performed over the next 12 months. 4-Jan Borrowed cash from the bank for operating expenses. The note charges simple interest and is to be paid back in 5 Event Amount Amount 6,850 11,760 years 26,000 loan amt 8,100 3% interest rate S-Jan Paid for 12 months rent on office space 10-Jan Purchased office furniture. 14-Jan Paid for utilities. 11,260 2,340 9,750 cash 4,375 15-Jan Performed services for various customers for cash and on account. 26-Jan Paid salaries to employees for 1 week 28-Jan Collected payments for amounts previously billed. 29-Jan Paid the bill for supplies purchased previously. 18,950 on account 16,850 8,650 31-Jan Dividends were declared and paid. 2,000 At the end of January, the following additional information is available to help determine what adjustments are needed: Amount Amount 31-Jan One month of the prepaid rent has been used up 31-Jan One month of the services for Stanley Inc. has been performed (see above). 31-Jan Supplies were counted at month end 31-Jan One month of interest has accrued on the note payable for the bank loan. 31-Jan Additional work for customers has been performed during the last week of January but not billed yet 31-Jan Salaries are paid every Friday (for a 5 day work week). January 31, 2019 was a Tuesday 31-Jan Depreciation expense needs to be recognized for the computer equipment and for the office fumiture 675 086 11,120 4,380 65 5,480 4,375 185 comp equip 1,750 135 off fum Search SUGGESTED STEPS FOR COMPLETION OF THE PROJECT: Prepare joumal entries to record the January transactions given. Please refer to the Worksheet tab for Account Titles Vou may need Add the January journal entry information to the Worksheet in the January columns. You can do this in one of2 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 (ie., 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 gren 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 fomulas 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 Eamings, 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. SUGGESTED STEPS FOR COMMPLETION OF THE PROJECT: Prepare joumal 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 (ie, add all cash debits from the journal entries into the cash debit column for January entries). There is a tab to use forT 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 Eamings, 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 the for mlas used to display instead of the