Could you please help me with this work? it is an excel doc, I have them as screen shots in order.
AutoSave () OFF THE6 6 7 ACCT500 Course Project Template (1) Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments A % " Conditional Formatting Format as Table v Paste Font Alignment Number Cell Styles v Cells Editing Ideas Sensitivity A1 X V fx ACCT500: Course Project A B C D E ACCT500: Course Project Requirement Worksheet Name 2 Requirement Description Prepare the Journal Entries In the General Journal 1 - Journal Entries Post Journal Entries to the General Ledger 2 - General Ledger 3 Prepare a Trial Balance 3 - Trial Balance 5 10 11 Menu April Transactions Chart of Accounts 1 - Journal Entries 2 - General Ledger 3 - Trial Balance + + 91%Date Transaction Description April 1 Started a landscaping business by making a $50,000 deposit in a company bank account, in exchange for 5,000 shares of $10 par value common stock. April 1 Purchased insurance for the year and paid $3,600 cash. April 1 Paid monthly rental of $2,500 cash on a warehouse to store the landscaping equipment. April 3 Purchased landscaping equipment from Toro for $15,000, paying a downpayment of $10,000 cash, and $5,000 on account. April 5 Purchased landscaping supplies of $750 on account. i Paid $500 cash for advertising in local newspapers. April 10 Received $12,500 in cash for landscaping services provided. April 12 Paid $2,000 on account for landscaping equipment previously purchased on April 3rd. April 15 Provided landscaping services on account for $1,200. April 20 Received $10,500 in cash for landscaping services provided. April 28 Received $600 cash on account for landscaping services performed on April 15th. April 30 Received $4,000 cash for landscaping services provided. April 30 Paid a utility bill of $700 cash. April 30 Paid dividends of $3,000 cash April 30 The inventory of landscaping supplies showed a balance of $300 on hand at the end of the month.Use the following account descriptions for journal entries. Chart of Accounts Account Account Type Number Account Title Normal Balance Assets 111 Cash Debit 115 Accounts Receivable Debit 117 Prepaid Insurance Debit 119 Landscaping Supplies Debit 144 Landscaping Equipment Debit Liabilities 212 Accounts Payable Credit Stockholders Equity 311 Common Stock Credit 313 Dividends Debit Revenue 411 Landscape Services Revenue Credit Expenses 511 Warehouse Rent Expense Debit 512 Advertising Expense Debit 514 Landscaping Supplies Expense Debit 517 Utility Expense DebitA B C D E REQUIREMENT #1: Prepare journal entries to record the the April transactions in the General Journal below. Remember that Debits must equal Credits-AN of your Journal Entries should balance. General Journal Account Number from Chart of Date Accounts tab Account Title from Chart of Accounts tab Debit Credit ConditiB C D E Format as Table H K L REQUIREMENT #2: Post the April journal entries to the following T-Accounts and compute ending balances Date Cash (111) Date Landscape Service Revenue (411) Prepaid Insurance (117) Warehouse Rent Expense (51 1) Landscaping Supplies (119) Common Stock (311) Landscaping Equipment (144) Dividends (313) Accounts Receivable (115) Advertising Expense (512) Accounts Payable (212) Landscaping Supplies Expense (514) Menu April Transactions Chart of Accounts 1 - Journal Entries 2 - General Ledger 3 - Trial Balance Grading Rubric +A2 X V fx Leondard's Landscaping Company A B C D E F G H 1 J K L M REQUIREMENT #3: Prepare a trial balance for March in the space below. Leondard's Landscaping Company Trial Balance April 30 Account Account Balance Number Title Debit Credit Formula Bar 59 Menu April Transactions Chart of Accounts 1 - Journal Entries 2 - General Ledger 3 - Trial Balance Grading Rubric +C29 X V fx A B C D E F G H 7 Course Project Grading Rubric 8 Points Your Points 9 Excellent Good Fair Poor Unacceptable Available 10 Step 1 Journal entries use accurate Journal entries mostly use Journal entries have some Journal entries have some The submission does -Journal Entries accounts and amounts; accurate accounts and errors in use of accounts errors in use of accounts and not meet this and debits and credits are amounts; and debits and and amounts; and debits amounts; and debits and requirement. used correctly. credits are used correctly. and credits are only credits are not used correctly. 11 somewhat used correctly. 12 Step 1 Grading Scale 45-40 39-35 34-30 29-25 24-0 45 Step 2 Ledger Posting Posting is done in the Posting is done mostly in the Posting has errors with Listing of accounts is mostly The submission does and Balancing correct accounts and at correct accounts and mostly incorrect accounts and incorrect with most incorrect not meet this the correct side (Dr./Cr.) at the correct side(Dr./Cr.) incorrect debits/credits and accounts and incorrect requirement, or posting and balances are correct. and balances are mostly incorrect balances. Dr./Cr. Most ledger balances is not done at all. 13 correct. are incorrect. 14 Step 2 Grading Scale 45-40 39-35 34-30 29-25 24-0 45 Step 3 - Unadjusted Trial Accounts are listed Most accounts are listed Listing of accounts has Listing of accounts is done The submission does Balance correctly and in the proper correctly leading to a several errors leading to poorly or not at all, leading not meet this order leading to an mostly correct trial balance. incorrect trial balance. to inaccurate or no trial requirement. 15 accurate trial balance. balance. 16 Step 3 Grading Scale 30-27 26-24 23-21 20-18 17-0 30 17 120
