Overview and Guidelines

This Course Project is the signature assignment of the ACCT500.

Please submit the solution to the Course Project in the assignment section of the respective week.

The Course Project template has all of the information you will need to complete the project. The template also includes the following.

• Detailed project instructions with requirements
• A reference list of April transactions
• A chart of accounts reference sheet
• A grading rubric to help explain what is expected
• Each worksheet has the check figures embedded as a comment

Important

Download the following template to complete the Course Project.

Course Project Template

To complete the Course Project (due at the end of Week 5), do the following.

• Complete requirements 1-3 on the worksheets.
• Type your work directly into the worksheets.
• Save your workbook as "Accounting_Course_Project_ACCT500_YourName."
• Don't forget to submit your workbook by Tuesday, April 6th.

ACCT500_Course_Project_Template (1) - Excel Table Tools X File Home Insert Page Layout Formulas Data Review View PDF Architect 7 Creator Design Tell me what you want to do.. Normal 3 Normal & Cut Copy Formal Painter Clipboard Century Gothic- 11 - BIU. PA Paste 9 Wrap Text Es Merge Center Alignment Gascon Jesselle & Share AutoSum - 47 Sort & Find & Clear Filter Select Editing General 12 E Normal 2 $ - %$ Conditional Format as Bad Formatting Table Number Good Neural Insert Delele formal 9 - Fand Styles C4 2 - General Ledger Requirement Description Requrement Worksheet Nam D E F H ! . L 2 Post Joumal Entries to the General Ledger 2 - General Ledger 4. 4 3 Prepare a Trial Balance 3 Trial Balance 5 5 6 7 8 9 10 11 12 13 15 18 Menu April Transactions Chart of Accounts 1 Journal Entries 2 General Ledger 3 Trial Balance Grading Rubric Ready + 911 H ACCT500_Course_Project_Template (1) - Excel X File Home Insert Page Layout Formulas Data Review View PDF Architect 7 Creator Tell me what you want to do... Gascon, Jesselle & Share AutoSum - Arial 10 EWrap Text General Normal 3 Normal HA Cut E Copy Format Painter Fill - Paste BIU- a-A- Normal 2 Conditional Format as Bad Formatting Table Merge & Center - $ - % 0.00 .00 0 Good Neutral Insert Delete Format Clear Sort & Find & Filter - Select Editing Clipboard Font Alignment Number Styles Cells A8 X fie Date April 1 April 1 April 1 Transaction Description 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. Purchased insurance for the year and paid $3,600 cash. Paid monthly rental of $2,500 cash on a warehouse to store the landscaping equipment. Purchased landscaping equipment from Toro for $15,000, paying a downpayment of $10,000 cash, and $5,000 on account. April 3 April 5 i April 10 April 12 April 15 April 20 April 28 Purchased landscaping supplies of $750 on account. Paid $500 cash for advertising in local newspapers. Received $12,500 in cash for landscaping services provided. Paid $2,000 on account for landscaping equipment previously purchased on April 3rd. Provided landscaping services on account for $1,200. Received $10,500 in cash for landscaping services provided. Received $600 cash on account for landscaping services performed on April 15th. Received $4,000 cash for landscaping services provided. Paid a utility bill of $700 cash. Paid dividends of $3,000 cash The inventory of landscaping supplies showed a balance of $300 on hand at the end of the month. April 30 April 30 April 30 April 30 Menu April Transactions Chart of Accounts 1 - Journal Entries 2 - General Ledger 3 - Trial Balance Grading Rubric + > Ready + 100% H ACCT500_Course_Project_Template (1) - Excel X File Home Insert Page Layout Formulas Data Review View PDF Architect 7 Creator Tell me what you want to do... Gascon, Jesselle & Share AutoSum - Arial 10 A EWrap Text General Normal 3 Normal HA Cut E Copy Format Painter Fill - Paste BIU- - A - Normal 2 Conditional Format as Bad Formatting Table = Merge & Center - $ - %) .0 .00 .00 0 Good Neutral Insert Delete Format Clear Sort & Find & Filter - Select Editing Clipboard Font Alignment Number Styles Cells J22 : X fr Formula Bar Chart of Accounts Account Number Account Title Normal Balance Account Type Assets 111 115 117 119 144 Cash Accounts Receivable Prepaid Insurance Landscaping Supplies Landscaping Equipment Debit Debit Debit Debit Debit Liabilities 212 Accounts Payable Credit Stockholders Equity 311 313 Common Stock Dividends Credit Debit Revenue 411 Landscape Services Revenue Credit Expenses 511 512 514 517 Warehouse Rent Expense Advertising Expense Landscaping Supplies Expense Utility Expense Debit Debit Debit Debit Menu April Transactions Chart of Accounts 1 - Journal Entries 2 - General Ledger 3 - Trial Balance Grading Rubric + Ready + 100% X File Gascon Jesselle & Share - ACCT500_Course_Project_Template (1) - Excel Table Tools Home Insert Page Layout Formulas Data Review View PDF Architect 7 Creator Design Tell me what you want to do.. X Cut Century Gothic 10 - 9 Wrap Text Number Heading 4 Title Total Copy- Formal Painter BIU.. - A = Merge Center $ -% 51. Conditional Formal as 20% - Ace... 20%- Acc... 20%- Ace... Formatting Table Clipboard - Fan Alignment Number Styles f 47 0 Paste Insert Delele Formal Clear Suri & Find & Filter Select Editing B4 C E F H ! J K K 1 M N 0 F Q REQUIREMENT #1: Prepare Journal entries to record the the April transactions in the General Journal below. Remember that Debits must equal CreditsAll of your journal Entries should 1 balance. Debil Credil 2 General Journal Account Number from Chart of 3 3 Dale Accounts tab Account Title from Chart of Accounts tak 4 5 6 7 8 9 10 12 13 11 15 16 18 19 20 21 22 23 24 25 Menu April Transactions Chart of Accounts 1 - Journal Entries 2 General Ledger 3 Trial Balance Grading Rubric + 100% ACCT500_Course_Project_Template (1) - Excel X File Home Insert Page Layout Formulas Data Review View PDF Architect / Creator Tell me what you want to do Gascon Jesselle & Share AutoSum - - Accents Accento EX 47 0 Paste X Cut E Copy - *Formal Painter Clipboard Century Gothic- - Wrap Text BIU... A = = = = = Merge Center fan Alignment - Number E Accent $ %). Conditional Formal as Comma Formatting Table Number Comma (0) Currency Insert Delele Formal Clear Sort & Find & Filter Select Editing Styles G12 A H H 1 1 J M N 0 P 0 1 B D [ REQUIREMENT #2: Post the Aprl joumal entries to the folowing 1-Accounts and compute ending balances. Date Cash (111) Date Landscape Service Revenue (411) 2 3 4 5 6 7 Prepaid Insurance (117) Warehouse Rent Expense (511) 9 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 H Landscaping Supplies (119) Common Stock (311) 27 28 29 30 Menu April Transactions Chart of Accounts 1 Journal Entries 2 - General Ledger 3 Tal Balance Grading Rubric + Reacy + 100% ACCT500_Course_Project_Template (1) - Excel Tell me what you want to do.. File Data Review View PDF Architect / Creator Gascon Jesselle & Share AutoSum - - Wrap Text Normal 3 Normal Home Insert Page Layout Formulas X Cut Arial - 10 - E Copy Format Painter BIU... A Clipboard fan E. 47 Paste General Normal 2 $ -% $ Conditional format as Bad Formatting Table Number Good Neural Insert Delele Formal Merge Center - Alignment Clear Sort & Find & Filter Select Editing Styles F15 A E G H J K L M N 0 P Q D D REQUIREMENT #3: Prepare a trial balance for March in the space below. 1 Leondard's Landscaping Company Trial Balance April 30 Account Balance Title Debit Credit 2 3 Account 4 Number 5 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 28 27 Menu April Transactions Chart of Accounts 1 Journal Entries 2 General Ledger 3 . Trial Balance Grading Rubric Reacy + 100% X ACCT500_Course_Project Template (1) - Excel Tell me what you want to do.. File Review View PDF Architect 7 Creator Gascon Jesselle & Share Normal 3 AutoSum" Normal Home Insert Page Layout Formulas Data X Cut Arial - 10 - E Copy Format Painter BIU...A Clipboard Fan 47 Paste Wrap Text Merge Center - Alignment General Normal 2 $ %). Conditional Formal as Dad Formatting Table Number Good Neural Insert Delele Formal Clear Sort & Find & Filter Select - Editing Styles 029 fy A D F C H 2 K M N P R 3 T 4 NAME 7 Course Project Grading Rubric Your Points Points Excellent Good Thir Poor Unacceptable Available 10 Step 1 Journcl entries use Journal entries mostly we Journal entries have cumal entries have some the submission does - Journal Entries accurate accounts and accurate accounts and some errors in use of so in una of accounts not meat this amounts and cebits amounts: and debits and accounts and amounts: and amounts and debits requirement. and credits and credits ALSAC Correctly. and clits and credits and credit cre not used correctly. cre only somewhat used correctly. 11 COACH 12 Step 1 Grading Socie 45-41 39-15 21-0 45 Step 2 Ledger Posting Posting is core in the Pering is done mostly in Porting na oors with Listing of account is The submission docs and Balancing corecl cccounts and at the correct accounts incorrect accounts and mostly incorrect with monol meet this the correct side Dr.10r. Jare mostly at the incorrec debits/creat incomoct accounts and requirement, or und bounce correcs de Creordend incorrecl bulurces incorrect Dr./Cr. Mox posling is nol cor comet balonces are mostly ledger balances are et al. 13 correct Lincorrect 14 Sep 2 Brugt 31-35 34-30 Step 3. Unadjusted Accounts are listed Most accounts are listed Listing of accounts has Listing of accounts is dona The submission does Trial Balance correctly ord in the correctly leading to a several errors leading to poorly or not at all not meet this proper order leading to mostly correct trial incorrect trial balance Jiading to accurate or requirement. on accurate trial balance no trial balance 15 balance. 18 Seng ODA 20-24 21-18 17-0 30 17 120 Menu April Transactions Chart of Accounts 1 Journal Entries 2 General Ledger 3 Tal Balance Grading Rubric + + 70 ACCT500_Course_Project_Template (1) - Excel Table Tools X File Home Insert Page Layout Formulas Data Review View PDF Architect 7 Creator Design Tell me what you want to do.. Normal 3 Normal & Cut Copy Formal Painter Clipboard Century Gothic- 11 - BIU. PA Paste 9 Wrap Text Es Merge Center Alignment Gascon Jesselle & Share AutoSum - 47 Sort & Find & Clear Filter Select Editing General 12 E Normal 2 $ - %$ Conditional Format as Bad Formatting Table Number Good Neural Insert Delele formal 9 - Fand Styles C4 2 - General Ledger Requirement Description Requrement Worksheet Nam D E F H ! . L 2 Post Joumal Entries to the General Ledger 2 - General Ledger 4. 4 3 Prepare a Trial Balance 3 Trial Balance 5 5 6 7 8 9 10 11 12 13 15 18 Menu April Transactions Chart of Accounts 1 Journal Entries 2 General Ledger 3 Trial Balance Grading Rubric Ready + 911 H ACCT500_Course_Project_Template (1) - Excel X File Home Insert Page Layout Formulas Data Review View PDF Architect 7 Creator Tell me what you want to do... Gascon, Jesselle & Share AutoSum - Arial 10 EWrap Text General Normal 3 Normal HA Cut E Copy Format Painter Fill - Paste BIU- a-A- Normal 2 Conditional Format as Bad Formatting Table Merge & Center - $ - % 0.00 .00 0 Good Neutral Insert Delete Format Clear Sort & Find & Filter - Select Editing Clipboard Font Alignment Number Styles Cells A8 X fie Date April 1 April 1 April 1 Transaction Description 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. Purchased insurance for the year and paid $3,600 cash. Paid monthly rental of $2,500 cash on a warehouse to store the landscaping equipment. Purchased landscaping equipment from Toro for $15,000, paying a downpayment of $10,000 cash, and $5,000 on account. April 3 April 5 i April 10 April 12 April 15 April 20 April 28 Purchased landscaping supplies of $750 on account. Paid $500 cash for advertising in local newspapers. Received $12,500 in cash for landscaping services provided. Paid $2,000 on account for landscaping equipment previously purchased on April 3rd. Provided landscaping services on account for $1,200. Received $10,500 in cash for landscaping services provided. Received $600 cash on account for landscaping services performed on April 15th. Received $4,000 cash for landscaping services provided. Paid a utility bill of $700 cash. Paid dividends of $3,000 cash The inventory of landscaping supplies showed a balance of $300 on hand at the end of the month. April 30 April 30 April 30 April 30 Menu April Transactions Chart of Accounts 1 - Journal Entries 2 - General Ledger 3 - Trial Balance Grading Rubric + > Ready + 100% H ACCT500_Course_Project_Template (1) - Excel X File Home Insert Page Layout Formulas Data Review View PDF Architect 7 Creator Tell me what you want to do... Gascon, Jesselle & Share AutoSum - Arial 10 A EWrap Text General Normal 3 Normal HA Cut E Copy Format Painter Fill - Paste BIU- - A - Normal 2 Conditional Format as Bad Formatting Table = Merge & Center - $ - %) .0 .00 .00 0 Good Neutral Insert Delete Format Clear Sort & Find & Filter - Select Editing Clipboard Font Alignment Number Styles Cells J22 : X fr Formula Bar Chart of Accounts Account Number Account Title Normal Balance Account Type Assets 111 115 117 119 144 Cash Accounts Receivable Prepaid Insurance Landscaping Supplies Landscaping Equipment Debit Debit Debit Debit Debit Liabilities 212 Accounts Payable Credit Stockholders Equity 311 313 Common Stock Dividends Credit Debit Revenue 411 Landscape Services Revenue Credit Expenses 511 512 514 517 Warehouse Rent Expense Advertising Expense Landscaping Supplies Expense Utility Expense Debit Debit Debit Debit Menu April Transactions Chart of Accounts 1 - Journal Entries 2 - General Ledger 3 - Trial Balance Grading Rubric + Ready + 100% X File Gascon Jesselle & Share - ACCT500_Course_Project_Template (1) - Excel Table Tools Home Insert Page Layout Formulas Data Review View PDF Architect 7 Creator Design Tell me what you want to do.. X Cut Century Gothic 10 - 9 Wrap Text Number Heading 4 Title Total Copy- Formal Painter BIU.. - A = Merge Center $ -% 51. Conditional Formal as 20% - Ace... 20%- Acc... 20%- Ace... Formatting Table Clipboard - Fan Alignment Number Styles f 47 0 Paste Insert Delele Formal Clear Suri & Find & Filter Select Editing B4 C E F H ! J K K 1 M N 0 F Q REQUIREMENT #1: Prepare Journal entries to record the the April transactions in the General Journal below. Remember that Debits must equal CreditsAll of your journal Entries should 1 balance. Debil Credil 2 General Journal Account Number from Chart of 3 3 Dale Accounts tab Account Title from Chart of Accounts tak 4 5 6 7 8 9 10 12 13 11 15 16 18 19 20 21 22 23 24 25 Menu April Transactions Chart of Accounts 1 - Journal Entries 2 General Ledger 3 Trial Balance Grading Rubric + 100% ACCT500_Course_Project_Template (1) - Excel X File Home Insert Page Layout Formulas Data Review View PDF Architect / Creator Tell me what you want to do Gascon Jesselle & Share AutoSum - - Accents Accento EX 47 0 Paste X Cut E Copy - *Formal Painter Clipboard Century Gothic- - Wrap Text BIU... A = = = = = Merge Center fan Alignment - Number E Accent $ %). Conditional Formal as Comma Formatting Table Number Comma (0) Currency Insert Delele Formal Clear Sort & Find & Filter Select Editing Styles G12 A H H 1 1 J M N 0 P 0 1 B D [ REQUIREMENT #2: Post the Aprl joumal entries to the folowing 1-Accounts and compute ending balances. Date Cash (111) Date Landscape Service Revenue (411) 2 3 4 5 6 7 Prepaid Insurance (117) Warehouse Rent Expense (511) 9 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 H Landscaping Supplies (119) Common Stock (311) 27 28 29 30 Menu April Transactions Chart of Accounts 1 Journal Entries 2 - General Ledger 3 Tal Balance Grading Rubric + Reacy + 100% ACCT500_Course_Project_Template (1) - Excel Tell me what you want to do.. File Data Review View PDF Architect / Creator Gascon Jesselle & Share AutoSum - - Wrap Text Normal 3 Normal Home Insert Page Layout Formulas X Cut Arial - 10 - E Copy Format Painter BIU... A Clipboard fan E. 47 Paste General Normal 2 $ -% $ Conditional format as Bad Formatting Table Number Good Neural Insert Delele Formal Merge Center - Alignment Clear Sort & Find & Filter Select Editing Styles F15 A E G H J K L M N 0 P Q D D REQUIREMENT #3: Prepare a trial balance for March in the space below. 1 Leondard's Landscaping Company Trial Balance April 30 Account Balance Title Debit Credit 2 3 Account 4 Number 5 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 28 27 Menu April Transactions Chart of Accounts 1 Journal Entries 2 General Ledger 3 . Trial Balance Grading Rubric Reacy + 100% X ACCT500_Course_Project Template (1) - Excel Tell me what you want to do.. File Review View PDF Architect 7 Creator Gascon Jesselle & Share Normal 3 AutoSum" Normal Home Insert Page Layout Formulas Data X Cut Arial - 10 - E Copy Format Painter BIU...A Clipboard Fan 47 Paste Wrap Text Merge Center - Alignment General Normal 2 $ %). Conditional Formal as Dad Formatting Table Number Good Neural Insert Delele Formal Clear Sort & Find & Filter Select - Editing Styles 029 fy A D F C H 2 K M N P R 3 T 4 NAME 7 Course Project Grading Rubric Your Points Points Excellent Good Thir Poor Unacceptable Available 10 Step 1 Journcl entries use Journal entries mostly we Journal entries have cumal entries have some the submission does - Journal Entries accurate accounts and accurate accounts and some errors in use of so in una of accounts not meat this amounts and cebits amounts: and debits and accounts and amounts: and amounts and debits requirement. and credits and credits ALSAC Correctly. and clits and credits and credit cre not used correctly. cre only somewhat used correctly. 11 COACH 12 Step 1 Grading Socie 45-41 39-15 21-0 45 Step 2 Ledger Posting Posting is core in the Pering is done mostly in Porting na oors with Listing of account is The submission docs and Balancing corecl cccounts and at the correct accounts incorrect accounts and mostly incorrect with monol meet this the correct side Dr.10r. Jare mostly at the incorrec debits/creat incomoct accounts and requirement, or und bounce correcs de Creordend incorrecl bulurces incorrect Dr./Cr. Mox posling is nol cor comet balonces are mostly ledger balances are et al. 13 correct Lincorrect 14 Sep 2 Brugt 31-35 34-30 Step 3. Unadjusted Accounts are listed Most accounts are listed Listing of accounts has Listing of accounts is dona The submission does Trial Balance correctly ord in the correctly leading to a several errors leading to poorly or not at all not meet this proper order leading to mostly correct trial incorrect trial balance Jiading to accurate or requirement. on accurate trial balance no trial balance 15 balance. 18 Seng ODA 20-24 21-18 17-0 30 17 120 Menu April Transactions Chart of Accounts 1 Journal Entries 2 General Ledger 3 Tal Balance Grading Rubric + + 70