Purchase Solution

Balance sheet transactions analysis

Not what you're looking for?

Ask Custom Question

Enter the following column headings across the top of a sheet of paper:

Transaction/ Owners' Net
Situation Assets Liabilities Equity Income
Enter the transaction / situation number in the first column and show the effect, if any, of the transaction entry or Adjusting entry on the appropriate balance sheet category or on the income statement by entering the amount and indicating whether it is an addition (+) or a subtraction (-). Column headings reflect the expanded balance sheet equation; items that affect net income should not be shown as affecting owners' equity. In some cases, only one column may be affected because all of the specific accounts affected by the transaction are included in that category. Transactions a and b have been provided as illustrations; you should note that each of the remaining items (c-k) require only one transaction or adjustment. Note: As an alternative to using the horizontal model, you may write the journal entry for each transaction or adjustment.

Instructions:
Please proceed to the "Analysis" worksheet and complete the basic problem requirements. Complete the problem requirements by entering appropriate amounts or formulas in shaded worksheet cells:
a. During the month, Supplies Expense was debited $1,800 for supplies purchased. The cost of supplies actually used during the month was $1,400.
b. During the month, Supplies (asset) was debited $1,800 for supplies purchased. The total cost of supplies actually used during the month was $1,400.
c. Received $800 of cash from clients for services provided during the current month.
d. Paid $500 of accounts payable.
e. Received $300 of cash from clients for revenues accrued at the end of the prior month.
f. Received $900 of interest income accrued at the end of the prior month.
g. Received $1,200 of interest income for the current month.
h. Accrued $700 of interest income earned in the current month.
i. Paid $1,900 of interest expense for the current month.
j. Accrued $600 of interest expense at the end of the current month.
k. Accrued $2,500 of commissions payable to sales staff for the current month.

After completing the "Analysis" worksheet, please proceed to the "What the Numbers Mean" worksheet and respond to the additional requirements presented.

Question 1:
In both transactions c and e, cash is received from clients. Explain why net income is increased by transaction c, but is not affected by transaction e.

Question 2:
Transactions f, g, and h all relate to interest income. Yet, transaction f does not affect net income, while transactions g and h both increase net income. Explain why this is the case by making reference to accrual accounting. Similarly, transaction h does not affect cash, while transactions f and g both increase cash. Explain why this is the case, by again making reference to accrual accounting.

Complete the Modeling:
a. During the month, Supplies Expense was debited $1,800 for supplies purchased. The cost of supplies actually used during the month was $1,400.
b. During the month, Supplies (asset) was debited $1,800 for supplies purchased. The total cost of supplies actually used during the month was $1,400.
c. Received $800 of cash from clients for services provided during the current month.
d. Paid $500 of accounts payable.
e. Received $300 of cash from clients for revenues accrued at the end of the prior month.
f. Received $900 of interest income accrued at the end of the prior month.
g. Received $1,200 of interest income for the current month.
h. Accrued $700 of interest income earned in the current month.
i. Paid $1,900 of interest expense for the current month.
j. Accrued $600 of interest expense at the end of the current month.
k. Accrued $2,500 of commissions payable to sales staff for the current month.

Purchase this Solution

Solution Summary

The following solution is comprised of a Word document that contains a number of exercises that aid the reader in learning the ins and outs of a Balance Sheet.

Purchase this Solution


Free BrainMass Quizzes
Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.