Note: This guided practice activity is designed to help you successfully complete your course project.
Instructions
Step 1: Download the 
. Read the template carefully.
Step 2: Using the data from the adjusted trial balance provided in the template workbook, populate the blue cells to create the following financial statements:
Income Statement:
Calculate the total expenses.
Compute net income.
Statement of Owners Equity:
Please key in the net income amount that goes into cell J17.
Calculate the J. Smith Capital balance as of June 30, 2017 in cell J9.
Balance Sheet:
Enter the equity balance from J9.
Calculate the balance for the total liabilities and equity.
HINT: You can verify your answer with the “check figure” numbers.
Save and name your file using the following file naming convention: YourFirst_LastName_Guided Practice for Excel Practice for the Project.
