Nordic Travel Agency Income Statement Excel Templates

Nordic Travel Agency Income Statement Excel Templates

 
Paper Instructions



Trial balance Score: 39% Key Code: 2 Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. Enter the appropriate amounts/formulas in the answer cells, or select from the drop-down list. An asterisk (*) will appear to the right of incorrect entries in outlined answer cells. For correct grading, enter a zero where you would otherwise leave an amount cell blank. a. WYOMING TOURS CO. Unadjusted Trial Balance June 30, 2016 Cash Accounts Receivable Supplies Equipment Accounts Payable Lorene Jones, Capital Lorene Jones, Drawing Service Revenue Operating Expenses * * * * * * * * * * * * b. Service revenue Operating expenses Net income (loss) . * * * Exercise 4-24 Name: Section: Score: 0% Key Code: 2 Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. An asterisk (*) will appear to the right of an incorrect entry. For correct grading in the work sheet, enter a zero in cells you would otherwise leave blank. ALERT SECURITY SERVICES CO. End-of-Period Spreadsheet (Work Sheet) For the Year Ended October 31, 2016 Account Title Cash Accounts Receivable Supplies Prepaid Insurance Land Equipment Accum. Depreciation Accounts Payable Wages Payable Brenda Schultz, Capital Brenda Schultz, Drawing Fees Earned Wages Expense Rent Expense Insurance Expense Utilities Expense Supplies Expense Depreciation Expense Miscellaneous Expense Unadjusted Trial Balance Dr. Cr. 12 90 8 12 190 50 8 110 12 6 2 500 4 36 260 200 500 Adjustments Dr. Cr. Adjusted Trial Balance Dr. Cr. Exercise 4-25 Name: Section: Score: 26% Key Code: 2 Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. An asterisk (*) will appear to the right of an incorrect entry. For correct grading in the work sheet, enter a zero in cells you would otherwise leave blank. ALERT SECURITY SERVICES CO. End-of-Period Spreadsheet (Work Sheet) For the Year Ended October 31, 2016 Account Title Cash Accounts Receivable Supplies Prepaid Insurance Land Equipment Accum. Depreciation Accounts Payable Wages Payable Brenda Schultz, Capital Brenda Schultz, Drawing Fees Earned Wages Expense Rent Expense Insurance Expense Utilities Expense Supplies Expense Depreciation Expense Miscellaneous Expense Adjusted Trial Balance Dr. Cr. 12 103 4 2 190 50 8 111 12 10 6 4 3 2 517 7 36 1 260 213 517 Income Statement Dr. Cr. Balance Sheet Dr. Cr. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Problem 1-2A Name: Karel Vidal Section: PR 1-2A Score: 0% Key Code: 2 Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. Enter the appropriate amounts/formulas in the answer cells, or select from the drop-down list. An asterisk (*) will appear to the right of an incorrect entry. 1. NORDIC TRAVEL AGENCY Income Statement Expenses: Total expenses Net income 2. NORDIC TRAVEL AGENCY Statement of Owner's Equity Ian Eisele, capital, January 1, 2016 Ian Eisele, capital, December 31, 2016 3. NORDIC TRAVEL AGENCY Balance Sheet Assets Cash Accounts receivable Supplies Land Total assets 4. Liabilities Owner's Equity Total liabilities and owner's equity Problem 2-3A Name: Section: Score: 0% Key Code: 2 Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. Enter the appropriate amounts/formulas in the answer cells, or select from the drop-down list. In journal entries, dates will not be graded. In the general ledger accounts, only the final balance of the account will be graded. For correct grading in the trial balance, enter a zero where you would otherwise leave an amount cell blank. An asterisk (*) will appear to the right of incorrect entries in outlined answer cells. 1. Page 1 JOURNAL Date 2016 Nov. Description Post Ref. Debit Page 2 JOURNAL Date 2016 Nov. Description Credit Post Ref. Debit Credit 2. GENERAL LEDGER Cash Date 2016 Nov. 11 Item Post Ref. Balance Dr. Cr. Dr. Cr. Accounts Receivable Date 2016 Nov. 12 Item Post Ref. Item Post Ref. Item Post Ref. Item Post Ref. Item Post Ref. Balance Dr. Cr. Dr. Cr. Supplies Date 2016 Nov. 13 Balance Dr. Cr. Dr. Cr. Prepaid Insurance Date 2016 Nov. 14 Balance Dr. Cr. Dr. Cr. Equipment Date 2016 Nov. 16 Balance Dr. Cr. Dr. Cr. Truck Date 2016 Nov. 18 Balance Dr. Cr. Dr. Cr. Notes Payable Date 2016 Nov. 21 Item Post Ref. Item Post Ref. Balance Dr. Cr. Dr. Cr. Accounts Payable Date 2016 Nov. 22 Balance Dr. Cr. Dr. Cr. Patty Cosgrove, Capital Date 2016 Nov. Item 31 Post Ref. Balance Dr. Cr. Dr. Cr. Patty Cosgrove, Drawing Date 2016 Nov. 32 Item Post Ref. Item Post Ref. Balance Dr. Cr. Dr. Cr. Fees Earned Date 2016 Nov. 41 Balance Dr. Cr. Dr. Cr. Wages Expense Date 2016 Nov. 51 Item Post Ref. Item Post Ref. Item Post Ref. Item Post Ref. Balance Dr. Cr. Dr. Cr. Rent Expense Date 2016 Nov. 53 Balance Dr. Cr. Dr. Cr. Utilities Expense Date 2016 Nov. 54 Balance Dr. Cr. Dr. Cr. Truck Expense Date 2016 Nov. 55 Balance Dr. Cr. Dr. Cr. Miscellaneous Expense Date 2016 Nov. Item 3. Balance Dr. Cr. Debit Balances Credit Balances CLASSIC DESIGNS Unadjusted Trial Balance November 30, 2016 Cash Accounts Receivable Supplies Prepaid Insurance Equipment Truck Notes Payable Accounts Payable Patty Cosgrove, Capital Patty Cosgrove, Drawing Fees Earned Wages Expense Rent Expense Utilities Expense Truck Expense Miscellaneous Expense 4. 59 Post Ref. Dr. Cr. # Incorrect N-box and B-box entries COUNTIF(B7:AT41,"~*") 0 # N-box Incorrects due to blanks COUNTIF(B7:AT41," ") 144 # N-box +B-box corrects COUNTIF(B7:AT41," ") 0 Total SUM(AV13:AV15) 144 Percentage =(AV16-AV13-AV14)/AV16 0% Notes: If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces If number-entry or blank-entry box is incorrect, returns "*" If number-entry or blank-entry box is correct, returns single space, " " Use data verification to set data entry to whole number >= 0, and use drop-downs for lables and names, so that students can't enter Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if and names, so that students can't enter a space in a box and have it counted as correct. symbols. If A1 = "~*", then font = red, if something else, then font = background color. ...
Purchase answer to see full attachment



 



Do you have a similar assignment and would want someone to complete it for you? Click on the ORDER NOW option to get instant services at essayloop.com