Instructions

The following Excel file has multiple worksheets which will be used in completing your

responses.

"Beginning Transactions" on the first Excel worksheet will provide the Balance Sheet for $2019$

and the Transactions for January $2020.$

On the second Excel worksheet, "Journal Entries", you should record the transactions provided

on the first Excel worksheet by creating Journal Entries with dates and descriptions.

On the third Excel worksheet, $"$T$-$accounts and trial balance", you should record the required

journal entries in the T$-$accounts and prepare an unadjusted trial balance.

The fourth and final Excel worksheet, "Financial Statements", you will prepare an Income

Statement, Statement of Equity and a Balance Sheet as of January $31,2020$ and answer the

inventory question. Chapter $1$ Appendix A$,$ Section $1\mathrm{.}8$ in the text will show examples of

financial statements. This is very much like your assignment in Week $1$ and there is a module

for Financial Statement review which will have videos to help.