please help in this asap

i need legder , worksheet, adjustments,statements, closing enteries, post closing trial balance

A24 Account Description C D E F G H 1 Part XXX Accounting Cyde 2 3 JM Travel and Tours is a travel agency that offers international and local travel services. The company is owned 4 and operated by Justine Mendoza. The closing balances at the end of March 2020 and the chart of accounts are 5 shown below 6 7 IM Travel and Tours B Balance Sheet 9 As at March 31, 2020 10 Assets Liabilities 11 Current Assets Current Liabilities 12 Cash $ 12,450 Accounts Payable $ 16,400 13 Accounts Receivable 6,420 Unearned Revenue 8,800 14 Prepaid Insurance Bank loan-current portion due 6,000 15 Totals Current Assets $ 18,870 Total Current Liabilities 31,200 16 Property, Plant & Equipment 17 Equipment $ 61,000 Bank Loan Non-current portion 24,000 18 Accumulated Depreciation IZA7001 Total Liabilities 55,200 19 Total Property, Plant & Equipment 53300 Owner's Equity 20 Mendoza Capital 16,970 21 Total Assets $ 22,170 Total Liabilities & Owners' 72,170 22 23 24 Account Description Account Account Description Account 25 ASSETS REVENUE 26 Cash 101 Travel Service Revenue 400 Journal Ledger Worlesheet Adjustments Statements Closing Entries Case Study Type here to search o te 1) A24 Account Description C D E F G H 1 Part XXX Accounting Cyde 2 3 JM Travel and Tours is a travel agency that offers international and local travel services. The company is owned 4 and operated by Justine Mendoza. The closing balances at the end of March 2020 and the chart of accounts are 5 shown below 6 7 IM Travel and Tours B Balance Sheet 9 As at March 31, 2020 10 Assets Liabilities 11 Current Assets Current Liabilities 12 Cash $ 12,450 Accounts Payable $ 16,400 13 Accounts Receivable 6,420 Unearned Revenue 8,800 14 Prepaid Insurance Bank loan-current portion due 6,000 15 Totals Current Assets $ 18,870 Total Current Liabilities 31,200 16 Property, Plant & Equipment 17 Equipment $ 61,000 Bank Loan Non-current portion 24,000 18 Accumulated Depreciation IZA7001 Total Liabilities 55,200 19 Total Property, Plant & Equipment 53300 Owner's Equity 20 Mendoza Capital 16,970 21 Total Assets $ 22,170 Total Liabilities & Owners' 72,170 22 23 24 Account Description Account Account Description Account 25 ASSETS REVENUE 26 Cash 101 Travel Service Revenue 400 Journal Ledger Worlesheet Adjustments Statements Closing Entries Case Study Type here to search o te 1) A24 Account Description H 74 T5 TO D G 71 Apr 26 Paid the monthly payment of the bank loan $500 plus interest of $75 72 Por 27. Provided travel services for clients for $30.000 cash Aer 28 Paid $3,000 advertising expense for the promotion of the travel and tours in the month of April for 29 The owner withdrew $2,500 cash for personal use 72 Since the loan is to be repaid in less than one year, use the Bank Loan Current Portion for the credit entry * Use the Bank Loan Non Current Portion for the credit entry since the same amount is still due over the next 12 78 months, therefore amount of current portion has not changed 30 Me the end of oril, the following adjustment had to be journalind to properly report the balances of the 81 company's accounts: Apt 30 Recopied $3.500 of Unearned Revenue as being earned during the month of April Apr 30 mesest of $50 has accrued on the bank loan Apr 303 One month of prepaid insurance worth 5600 has expired One month of depreciation for $500 needs to be recorded Apr 30 Accrued salary expense of 5720 needs to be recorded 79 83 14 85 56 07 00 Apr 30 89 Note: The bank loan is repayable in monthly payments of $500 plus interest Current portion is $6,000 90 5500x12) and long-term $24,000 When recording monthly payment please be sure to debit the non-current 91 portion and not the current portion as the latter will not change until the last year of the loan 92 93 94 Replied 95 ) Enter the opening balances from the March 2020 balance sheet into the general ledger accounts. Case Study Journal Ledger Worksheet Adjustments Statenents Closing Entries Pean Type here to search Post-Closing C H 86 Apr 30 One month of depreciation for $500 needs to be recorded. 57 Apr 30 Accrued salary expense of $720 needs to be recorded 89 Note: The bank loan is repayable in monthly payments of $500 plus interest Current portion is 56,000 90 issocx12) and long term is $24,000. When recording monthly payment, please be sure to debit the non current 9t portion and not the current portion as the latter will not change until the last year of the loan 92 98 94 Required: 95 ) Enter the opening balances from the March 2020 balance sheet into the peneral ledger accounts 96 ) Prepare the journal entries for the month of April and post them to the appropriate peneral ledger accounts 97 Create the trial balance in the worksheet, and then complete the remaining section of the worksheet 98 dCreate the income statement, statement of owner's equity and the classified balance sheet 99) Prepare the journal entries for the adjustments and post them to the appropriate general ledger accounts Prepare the journal entries to close the books for the month of April 2020 use the income summary account too and post the journal entries to the appropriate general ledger accounts 101 ) Create the post-closing trial balance 102 103 Note: Please read the instructions carefully and follow required steps in the order provided above. Refer to your textbook of needed (Chapter 6 for format of financial statement Templates have been set up using formats 104 shown in textbook 105 106 107 TOO Case Study Bora Ledger Worksheet Adjustments Statements Closing Entries Post-Closing Trial edi HE Type here to search ED A24 Account Description C D E F G H 1 Part XXX Accounting Cyde 2 3 JM Travel and Tours is a travel agency that offers international and local travel services. The company is owned 4 and operated by Justine Mendoza. The closing balances at the end of March 2020 and the chart of accounts are 5 shown below 6 7 IM Travel and Tours B Balance Sheet 9 As at March 31, 2020 10 Assets Liabilities 11 Current Assets Current Liabilities 12 Cash $ 12,450 Accounts Payable $ 16,400 13 Accounts Receivable 6,420 Unearned Revenue 8,800 14 Prepaid Insurance Bank loan-current portion due 6,000 15 Totals Current Assets $ 18,870 Total Current Liabilities 31,200 16 Property, Plant & Equipment 17 Equipment $ 61,000 Bank Loan Non-current portion 24,000 18 Accumulated Depreciation IZA7001 Total Liabilities 55,200 19 Total Property, Plant & Equipment 53300 Owner's Equity 20 Mendoza Capital 16,970 21 Total Assets $ 22,170 Total Liabilities & Owners' 72,170 22 23 24 Account Description Account Account Description Account 25 ASSETS REVENUE 26 Cash 101 Travel Service Revenue 400 Journal Ledger Worlesheet Adjustments Statements Closing Entries Case Study Type here to search o te 1) A24 Account Description C D E F G H 1 Part XXX Accounting Cyde 2 3 JM Travel and Tours is a travel agency that offers international and local travel services. The company is owned 4 and operated by Justine Mendoza. The closing balances at the end of March 2020 and the chart of accounts are 5 shown below 6 7 IM Travel and Tours B Balance Sheet 9 As at March 31, 2020 10 Assets Liabilities 11 Current Assets Current Liabilities 12 Cash $ 12,450 Accounts Payable $ 16,400 13 Accounts Receivable 6,420 Unearned Revenue 8,800 14 Prepaid Insurance Bank loan-current portion due 6,000 15 Totals Current Assets $ 18,870 Total Current Liabilities 31,200 16 Property, Plant & Equipment 17 Equipment $ 61,000 Bank Loan Non-current portion 24,000 18 Accumulated Depreciation IZA7001 Total Liabilities 55,200 19 Total Property, Plant & Equipment 53300 Owner's Equity 20 Mendoza Capital 16,970 21 Total Assets $ 22,170 Total Liabilities & Owners' 72,170 22 23 24 Account Description Account Account Description Account 25 ASSETS REVENUE 26 Cash 101 Travel Service Revenue 400 Journal Ledger Worlesheet Adjustments Statements Closing Entries Case Study Type here to search o te 1) A24 Account Description H 74 T5 TO D G 71 Apr 26 Paid the monthly payment of the bank loan $500 plus interest of $75 72 Por 27. Provided travel services for clients for $30.000 cash Aer 28 Paid $3,000 advertising expense for the promotion of the travel and tours in the month of April for 29 The owner withdrew $2,500 cash for personal use 72 Since the loan is to be repaid in less than one year, use the Bank Loan Current Portion for the credit entry * Use the Bank Loan Non Current Portion for the credit entry since the same amount is still due over the next 12 78 months, therefore amount of current portion has not changed 30 Me the end of oril, the following adjustment had to be journalind to properly report the balances of the 81 company's accounts: Apt 30 Recopied $3.500 of Unearned Revenue as being earned during the month of April Apr 30 mesest of $50 has accrued on the bank loan Apr 303 One month of prepaid insurance worth 5600 has expired One month of depreciation for $500 needs to be recorded Apr 30 Accrued salary expense of 5720 needs to be recorded 79 83 14 85 56 07 00 Apr 30 89 Note: The bank loan is repayable in monthly payments of $500 plus interest Current portion is $6,000 90 5500x12) and long-term $24,000 When recording monthly payment please be sure to debit the non-current 91 portion and not the current portion as the latter will not change until the last year of the loan 92 93 94 Replied 95 ) Enter the opening balances from the March 2020 balance sheet into the general ledger accounts. Case Study Journal Ledger Worksheet Adjustments Statenents Closing Entries Pean Type here to search Post-Closing C H 86 Apr 30 One month of depreciation for $500 needs to be recorded. 57 Apr 30 Accrued salary expense of $720 needs to be recorded 89 Note: The bank loan is repayable in monthly payments of $500 plus interest Current portion is 56,000 90 issocx12) and long term is $24,000. When recording monthly payment, please be sure to debit the non current 9t portion and not the current portion as the latter will not change until the last year of the loan 92 98 94 Required: 95 ) Enter the opening balances from the March 2020 balance sheet into the peneral ledger accounts 96 ) Prepare the journal entries for the month of April and post them to the appropriate peneral ledger accounts 97 Create the trial balance in the worksheet, and then complete the remaining section of the worksheet 98 dCreate the income statement, statement of owner's equity and the classified balance sheet 99) Prepare the journal entries for the adjustments and post them to the appropriate general ledger accounts Prepare the journal entries to close the books for the month of April 2020 use the income summary account too and post the journal entries to the appropriate general ledger accounts 101 ) Create the post-closing trial balance 102 103 Note: Please read the instructions carefully and follow required steps in the order provided above. Refer to your textbook of needed (Chapter 6 for format of financial statement Templates have been set up using formats 104 shown in textbook 105 106 107 TOO Case Study Bora Ledger Worksheet Adjustments Statements Closing Entries Post-Closing Trial edi HE Type here to search ED