Your assignment is to set up a journal and general ledger to account for transactions during

2011. This should all be set up in an Excel Workbook. You may use different worksheets but

only one workbook. The general ledger can be comprised of a set of T-accounts.

To assist your preparation of financial statements, you should generate post-transaction

(unadjusted), pre-closing (adjusted) and post-closing trial balances for each year. (A

worksheet like you used in Accounting Principles 1 may be helpful.)

You should also create a set of financial statements (balance sheet, income statement,

statement of cash flows and notes to the statements) for 2011. The balance sheet should

also have a comparative for 2010.

You should have notes to the financial statements as necessary but as a minimum should

include significant accounting policies, current assets, depreciable assets, and long-term

debt.

Finally, compose a reflective paragraph describing your experience working on the Portfolio

Project. Specifically, describe the concepts learned from this assignment and assess whether

financial statements are easier to understand as a result of this assignment.

Background Information

The Widget Company is a small company with only a few employees. Its line of business is to

purchase several items from a line of widgets and resale them to other companies. The

Company owns one small shop with two rooms, one for sales and office work, and one for

product receiving and shipping. The company is owned by a group of investors and it is

organized as a corporation.

Widget Company uses a straight-forward financial accounting information system. Of course,

accrual accounting is used. Other generally accepted accounting principles used are the $-

Value LIFO of valuing product inventory, FIFO for valuing supplies, the straight-line

depreciation method for matching the cost of long-term assets to periods of use (half year of

depreciation in year of acquisition and disposition), and earnings per share. Widgets fiscal

year extends from January 1 through December 31.

Additional information

Accounts receivable is recorded at gross. The Allowance for doubtful accounts is

computed at 2% of ending accounts receivable. The Office supplies inventory is valued

according to FIFO.