Trial Balance and Income Statements
Not what you're looking for?
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.
Purchase this Solution
Solution Summary
The solution examines the trial balance and income statements. Excel is used to examine the balance sheet.
Purchase this Solution
Free BrainMass Quizzes
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.
Introduction to Finance
This quiz test introductory finance topics.
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.
Lean your Process
This quiz will help you understand the basic concepts of Lean.