Mary Jane Project

PROJECT 1: MARY WILLIAMS, ACCOUNTING INTRODUCTION (EXCEL Project) Textbook and Directions in the files It’s now time to complete your first graded project from the textbook, entitled Project 1: Mary Williams, Accounting. Take time to read the instructions carefully. Complete your work accurately and be sure to check it thoroughly when you complete it. This project will be submitted for grading. PROJECT INSTRUCTIONS Project 1: Mary Williams Accounting is found after Chapter 11 in your textbook. For your graded project, you’ll complete the accounting cycle for the month of December 2017. First, read through the project to become familiar with the tasks you’re required to do. Refer back to Chapters 9–11 if you’re unsure how to perform an assigned task. This project is very similar to what you’ve been doing throughout these chapters. 1. Complete Steps 1–28 as instructed in the textbook. 2. Please note the following important changes to Step 29: Export only the following reports to an Excel file: Balance Sheet Income Statement See the section “Export Financial Statements to Excel” in Chapter 7 of your textbook. These detailed instructions show how to export a financial state- ment to an Excel file and then to add additional statements as worksheets within the file when needed. When creating the Excel file for the Balance Sheet, under the File option, select the Create a new Microsoft Excel workbook option. To name the file, use your student number, followed by an underscore, and the first six digits of the exam number. For example: 12345678_061459 (Your student ID_exam number). When creating the Excel file for the Income Statement, under the File option, select the Add a new worksheet to an existing Microsoft Excel workbook option. Click on the Browse button to find and select the file you just created. Add the Income Statement to the file containing the Balance Sheet. APPLICATIONS PAGE 36 IN ACCOUNTING