Accounting Project instructions attached

Menu
    ACCT 212: Course Project
    Requirement    Requirement Description    Worksheet Name
    1    Prepare the Journal Entries in the General Journal    1 - Journal Entries
    2    Post Journal Entries to the General Ledger    2 - General Ledge
    3    Prepare a Trial Balance    3 - Trial Balance
    4    Prepare the Adjusting Entries    4 &5 - Adjusting Entries
    5    Post Adjusting Entries to the General Ledger    4 &5 -Adjusting Entries ( Use worksheet #2)
    6    Prepare an Adjusted Trial Balance    6- Adjusted TB
    7    Prepare the Financial Statements    7 - Financial Statements
    8    Prepare the Closing Entries    8&9 - Closing Entries ( use worksheet #2)
    9    Post Closing Entries to the General Ledger    8&9- General Ledge
    10    Prepare the Post Closing Trial Balance    10 - Post Closing Trial Balance
    11    Compute Ratios    11-Ratios
    12    Interpret the Ratios    12-Interpretation of Ratios
Project Instructions
        Course Project Overview
            The Course Project consists of 10 Requirements for you to complete. The Course Project is due at the end of Week 6. See the Syllabus section ”Due Dates for Assignments & Exams” for due date information. All of the information you need to complete the Course Project is located in this Workbook.
• There are eight worksheets in the workbook you will need to complete.
• A list of March transactions
• A Chart of Accounts reference sheet
• A Grading Ru
ic to help explain what is expected.
• Each worksheet has the Check Figures embedded as a comment.
        Scenario
            You’ve just secured a new client in your accounting practice, Bethany's Bicycle Corporation (BBC), a
and new small business specializing in bicycle repair. The owner, Bethany Beck, is a te
ific cyclist and bike repair specialist, but definitely not an accountant. Your job is to helpBethany put his affairs in order. Luckily Bethany has only been in operation for a month and things have not gotten too out of hand yet! Bethany has to submit his financial statements to her investors and doesn’t know where to begin. It’s your job to go through the complete Accounting cycle to prepare the financial statements for the BBC.
        Requirements
        Guidelines
            Use the embedded assistance in the template, guidance in your textbook, and examples in the weekly lectures to complete this project. Should you have any questions contact your professor.
            Milestone 1 is due in Week 5 - This includes project requirements 1-3.
            Milestone 2 is due in Week 7 - This includes project requirements 4-10.
Before You Begin:
 Review the Week 2 Lecture prior to starting work on this project.
 Print the Chart of Accounts and October Transactions worksheets for your reference. You will need to refer to both throughout the project.
 Review the Grading Criteria.
 SAVE your work frequently in this workbook.
March Transactions
        During its first month of operation, the Bethany's Bicycle Corporation, which specializes in bicycle repairs, completed the following transactions.
        March Transactions
        Date    Transaction Description
        March 1    Began business by making a deposit in a company bank account of $20,000, in exchange for 2,000 shares of $10 par value common stock.
        March 1    Paid the premium on a 1-year insurance policy, $2,400.
        March 1    Paid the cu
ent month's store rent expense, $1,900.
        March 3    Purchased repair equipment from Andrew Company, $5,800. Paid $1,000 down and the balance was placed on account. Payments will be $400.00 per month for 12 months. The first payment is due 4/1. Note: Use Accounts Payable for the Balance Due.
        March 8    Purchased repair supplies from Jackson Company on credit, $650.
        March 10    Paid telephone bill for March, $340.
        March 11    Cash bicycle repair revenue for the first third of March, $1,650.
        March 18    Made payment to Jackson Company, $400.
        March 20    Cash bicycle repair revenue for the second third of March, $2,450.
        March 31    Cash bicycle repair revenue for the last third of March, $1,250.
        March 31    Paid the cu
ent month's electice bill, $250.
        March 31    Declared and paid cash dividend of $1,000.
Chart of Accounts
        Use the following account descriptions for journal entries.
        Chart of Accounts
        Account Type    Account Number    Account Title    Normal Balance
        Assets
            111    Cash     Debit
            117    Prepaid Insurance     Debit
            119    Repair Supplies    Debit
            144    Repair Equipment     Debit
            145    Accum Dep -Repair Equipment     Credit
        Liabilities
            212    Accounts Payable     Credit
            213    Income Tax Payable    Credit
        Stockholders Equity
            311    Common Stock     Credit
            312    Retained Earnings     Credit
            313    Dividends     Debit
        Revenue
            411    Bicycle Repair Revenue    Credit
        Expenses
            511    Store Rent Expense     Debit
            512    Telephone Expense     Debit
            513    Insurance Expense     Debit
            514    Repair Supplies Expense     Debit
            515    Dep Expense - Repair Equipment     Debit
            516    Income Tax Expense     Debit
            517    Electric Expense    Debit
1 - Journal Entries
    REQUIREMENT #1: Prepare journal entries to record the March transactions in the General Journal below. Remember that Debits must equal Credits—All of your Journal Entries should balance.
    General Journal
    Date    Account Number from Chart of Accounts tab    Account Title from Chart of Accounts tab    Debit    Credit
    1-Mar    111    Cash    20,000
        311     Common stock        20,000
            (To record issue of common stock)
    1-Mar    117    Prepaid Insurance    2,400
        111     Cash        2,400
            (To record one year insurance policy)
    1-Mar    511    Store rent expense    1,900
        111     Cash        1,900
            (To record one month store rent)
    3-Mar    144    Repair equipment    5,800
        111     Cash        1,000
        212     Accounts payable        4,800
            (To record purchase of equipment)
    8-Mar    119    Repair Supplies    850
        212     Accounts payable        850
            (To record purchase of repair supplies)
    10-Mar    512    Telephone expense    340
        111     Cash        340
            (to record payment of utility expense)
    11-Mar    111    Cash    1,650
        411     Bicycle repair Revenue        1,650
            (To record cash revenue for first third of month)
    18-Mar    212    Accounts payable    400
        111     Cash        400
            (To record partial payment
    20-Mar    111    Cash    2,450
        411    Bicycle repai
evenue        2,450
            (To record revenue for second third of month)
    31-Mar    111    Cash    1,250
        411    Bicycle revenue        1,250
            (To record revenue for final third of month)
    31-Mar    517    Electric expense    250
        111    Cash        250
    31-Mar    313    Dividend    1,000
        111    Cash         1,000
            (To record dividend paid )
                38,290    38,290
Journal Entries    
Once you've completed this requirement print your General Journal to complete Requirement #2 on the General Ledger worksheet.
2 - General Ledge
        REQUIREMENT #2: Post the March journal entries to the following T-Accounts and compute ending balances.
    Date    Cash (111)            Date    Bicycle...