COP1570 Extra Credit Assignment – 100 pts

Do an Accounting Trail Balance Sheet & Income Statement with three related worksheet tabs, as shown below:

The colors are used to help you better see how these sheets and numbers are related. You do everything in black. 

	Points
Correctly Sum the Expenses up in each appropriate area.	10
Right Justify appropriate Numeric Headers (Dr, Cr). All calculated numbers must be right-justified.	5
Rename (Right-click > Rename) the worksheet tabs at bottom of page to: Worksheet, Adjustments, Income	5
Get Work Sheet Adjustments (D19:890 & E10:890) from the Adjustments Tab on the bottom of the screen.	10
Ex: click on E10, type =, click the Adjustments Tab, click the Supplies credit (890), then tap [Enter]
The Adjusted Trial Balance is the end of the month final Account balances: Trial Balance + Adjustments      Use appropriate formulas.	10
Do the appropriate math to calculate Net Income: Revenue (such as Sales) - Expenses	10
Add 1 other Adjustment to the Adjustments Sheet which automatically adds to the Work Sheet Adjustments columns (D & E) for both Dr and Cr	5
Ex: In addition to the extra Supplies Expense on Row 19, add an Accounts Receivable or a Wages Expense
Autoformat the Adjustments sheet to: "List 2" (it is a Dark Green/Green Autoformat)	5
Use appropriate formulas to do the Income Statement portion of the Work Sheet      (Columns H & I) from the Adjusted Trial Balance	10
Do the Income statement worksheet (see bottom green worksheet tab) from the Adjusted Trail Balance	10
Ex: on the Income Tab at bottom, in the Software Sales cell, type =, then point to the appropriate cell      on the Worksheet Tab
Format all cells as shown for decimals, commas and dollar signs. All double underlines balance      (Format > Cell for Accounting Double Underline). Include borders. Merge and Center where appropriate.	10
Everything (except the Trial Balance columns B & C  and the Adjustments Tab) are formulas	10
Total Points	100