Explore BrainMass

Explore BrainMass

    Trial Balance and Income Statements

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    John Smith starts a sole proprietorship, Johnny's Store, on December 1, 2008. He plans to reinvest all profits in the business for the first several years.

    I. Using Excel, record the following transactions in debit/credit form.

    1. Smith opens a bank account in the name of Johnny's Store with his personal check for
    $5,000
    2. The company borrows $10,000 from bank on a 3-year note
    3. The company prepays rent, $1,800 for 3 months
    4. The company buys equipment for cash, $4,800
    5. The company buys supplies on account, $800
    6. The company buys merchandise on account, $3,500
    7. The company sells merchandise, cost $900, for $1,450 cash
    8. The company sells merchandise, cost $1,250, for $2,200 on account
    9. The company pays for the supplies purchased in #5 above
    10. The company receives electric bill for December, not due until January, $160

    II. John wishes to have his fiscal year end on December 31st. Record the following adjusting entries in debit/credit form.

    1. Accrued interest on the note (interest rate is 6% annually)
    2. Depreciation on equipment (life, 10 years)
    3. Expiration of one month rent
    4. $75 worth of supplies were used during the month

    III. Prepare a trial balance, using formulas in the cells linking to the above transactions.

    IV. Prepare an income statement and balance sheet, linking cells to trial balance. Formulas must be present in excel to perform the mathematical functions.

    © BrainMass Inc. brainmass.com June 3, 2020, 11:09 pm ad1c9bdddf
    https://brainmass.com/business/accounting/accounting-problem-265825

    Solution Summary

    The solution examines the trial balance and income statements. Excel is used to examine the balance sheet.

    $2.19

    ADVERTISEMENT