At the beginning of the second year, MBC had the following balance sheet: $1$ Record journal entries for the transactions dated January $1-25$ of the current year on the journal entry form $($separate tab$).$

$2$

Create a T$-$account for every account used to date by MBC on the T$-$account tab $($There are extra$).$ Correctly post any beginning balances.

Post each of the journal entries to the correct T$-$account using linking$/$referencing functionality. See example video as needed.

Using the math functionality in Excel$/$Sheets$,$ calculate the correct SUBTOTAL balance for each T$-$account. Adjusting journal entries for Part B will be posted

$3$ after this subtotal.

$4$ Prepare an unadjusted Trial Balance for Jan $31$ using linking$/$referencing functionality to each T$-$account subtotal balance.

Use of the basic reference$/$linking function and math functionality in Excel$/$Sheets must be included to the fullest extent possible to earn full project points.

Referencing 'answer' cells $($T$-$accounts$)$ back to 'input' cells $($Journal entries$)$ creates a functioning, effective worksheet.

The Google Sheet should be shared with me $($ with editor status and the Excel worksheet should be placed in the Assignment folder in D$2$L$.$

REQUIRED FOR POINTS Part B:

This uses your corrected Part A file to continue the process.

Using the balances in the T$-$accounts $($update as needed from Part A$)$ and the information given, calculate and record the adjusting journal entries for Jan $31$ in

$5$ the journal.

$6$ Post each of the adjusting entries to the T$-$accounts $($after the previous subtotals submitted for Part A$)$ using the same linking$/$referencing functionality.

Using the math functionality in Excel$/$Sheets$,$ calculate the correct final balance for each T$-$account on the correct side. The $T-$account should have the

$7$ unadjusted total, the adjusting journal entries, then a new separate final total.

$8$ Prepare an ADJUSTED Trial Balance for Jan $31$ using the linking$/$referencing functionality to the final totals in each T$-$account.

$9$ Prepare the $3$ Financial statements in good form using the final adjusted account totals as of January $31,$ current year $9$ Prepare the $3$ Financial statements in good form using the final ending T$-$account balances as of January $31,$ current year

Use the reference or linking function in Excel$/$Sheets to link the financial statements accounts and amounts to the Adjusted Trial Balance. Referencing 'answer' cells $($Financial Statements$)$ back to 'inps

account titles and totals$)$ creates a functioning, effective worksheet. Making these connections allows the worksheet to be used for analyzing potential changes in the results.

Financial statements must follow outline shown in the textbook and homework with titles and totals, and must be classified.

You are creating the financial statements on this 'blank' worksheet.

You may change the width of a column, format a number, or insert lines as needed. You may create & use a Trial Balance. Make changes as needed. Use example video as needed.

The goal of a functioning worksheet is that an amount can be changed in the journal, and the T$-$accounts, Trial Balance, and the financial statements update automatically. Try that before you submit. If you

on this sheet, you are not meeting the requirements of the project.