After completing the journal entries, you must then complete the missing pieces of the $T$ accounts, trial balance, and

statements highlighted in yellow. Only excel functions may be used to calculate the appropriate cell value on these pages.

DO NOT INPUT THE ACTUAL NUMBER INTO THE T ACCOUNTS, TRIAL BALANCE, OR STATEMENTS.

Use excel functions $($such as making a cell equal another from the journal entry page, summing numbers together, or using the

plus or minus symbols to help you find the appropriate number$).$ Your balance sheet should balance when you are complete.

Tip: After each journal entry, update the appropriate $T$ accounts.

Select Retailer$/$Merchandiser$-$Related Transactions: