problem 3-5A please help me// Accounting

(added the excell templets too, belive there are 6 parts total)

Account and Account Numbe Date Explanation Unadjusted trial balance Account and Account Numbe Date Explanation Unadjusted trial balance Account and Account Numbe Date Explanation PR Debit Credit Balance Unadjusted trial balance Account and Account Numbe Date Explanation PR Debit. Credit Balance - - - Problem 3-5A Part: You: Fore The Cnapter 3 Adjusting Accounts for Financial Ststements lesatiaued from trevioos nazel Requlred Use the information in the adjusted trial balance to prepare (a) the income statement for the year ended December 31: (b) the statement of retained carnings for the year ended December 31 Wiste: Retaibed Earnings at December 31 of the prior year was $235,800); and (c) the balance sheet as of December 31 . On Apeil 1. Jiro Nozomi created a new travel agency. Adventure Travel. The followieg tratuctions eccurred daring the company's first nooth. Apt. I Nozomi invested $30,000 cash and compuaer equipment worth $20,000 in the company in exchange for common stock. 2 The company rented furnisbed office space by paying 51,800 cash for the first month's (April) rent. 3. The company purchased $1,000 of office supplies for cauh. 10 The company paid \$2,400 cash for the premium on a 12-month invarance policy. Coverage begins on April II. 14 The company paid $1,600 cash for two weeks' salaries earned b. Foyees. 24 The company collected $8,000 cash for conumiscions earned. 28 The company paid $1,600 cash for two weeks' salaries earned by employecs. 29 The company paid $350 cash for minor nepairs to the company's compuler. 30 The company paid $750 cash for this month's telephote bill. 30 The company paid $1.500 cash in dividends. The company's chart of accoants followx. Aequiled 1. Uve the balance column format to set up each ledger aceount listed in its chart of acoocanth. 2. Prepare journal entries to record the transactions for April and post them to the ledper accounts. The corrpany records prepaid and unearsed hemis in balance shect accosunts. 3. Propare an unadjusted srial balance as of April 30 4. Use the following information to journalize and post adjustieg entries for the monct: a. Prepaid insarasce of $133 has expired this mondh. b. At the end of the month, 5600 of office supplies ate sill avalable: c. This month's depreciation on the computer equipmest is 5500 . d. Employces carned $420 of unpaid and unreconded salaries as of moeth-end. -. The compuny tarned 51,750 of commisions that are not yes billed at month cond 5. Prepare the adjusted trial balance ax of A prit 30 . Prepare the income statement and the atalemene of retained earnings for the monith of A pril and the halance sheet at A pril 30 6. Prepare journal centries to close the temporary accounts and post these eterier to the ledper. 7. Propare a posi-closing trial balanse. art 6: Prepare and Post the Closing Entries and a Post Closing Trial Balance 3: Prepare a trial balance worksheet that includes columns for the Unadusted Trial Balance, Adjusting fntries, Ajusted Trial Balance, Income Statement, and Balance Sheet ke sure that you provide proper headings and follow the format given in the text book. art 4: Using the information from the information provided in the text book prepare he necessary 5 Adusting Entries. After preparing the entries post them to the general ledger. Then add those entries to the Adjusting Entries columns on the Trial Balance Worksheet and complete the Adjusted Trial Balance on the Worksheet. Problem 3-5A - Six Parts: Please see problem 3-5A (Attached) for the information to record the April Transactions and the Adjusting Entries 5 6 7 General Instructions: 8 Be sure to use the templates below and link numbers and show calculations in individual cells. 9 There are six major parts to this assignment. Be sure to follow the directions in the templates below. 10 Note: The numbering for the parts is different than the problem in the text book. Templates are not provide for all reports. 11 12 Part 1: Prepare general journal entries to record these transactions (use account titles listed in part 2). 13 You should include a brief explanation of each entry. Inclue the report headings. 14 15 Adventure Travel 16 17 General Journal Page 1 18 For April 2020 Transaction 19 Date Account Description 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Problem 3-5A