Reference no: EM133328336

Project: Valley Bikes is found after Chapter 15 in your textbook. Valley Bikes sells bicycles and is organized as a corporation. You purchased Valley Bikes in December 2018.

First, read through the project to become familiar with the tasks you're required to do. Refer back to Chapters 12-15 for a review of accounting for a merchandising business if you're unsure how to perform an assigned task. This project is very similar to what you've been doing throughout these chapters.

Complete Steps 1-9 as instructed in the textbook.
Complete Steps 1-5 for the General Ledger.
Complete Steps 1 and 2 for Accounts Payable.
Complete Steps 1 and 2 for Accounts Receivable.
Complete Steps 1-6 for Payroll.
Complete Steps 1-4 for Inventory.
Journalize and post the transactions.
Complete the account reconciliation.
Complete Steps 1-7 for printing the reports.

Please note the following important points:

You're to export the following reports to an Excel file:
<Standard> Balance Sheet
<Standard> Income Statement
Statement of Cash Flows

When creating the Excel file for the Balance Sheet, under the File option, select make new Microsoft Excel workbook option. To name the file, use your student number, followed by an underscore, and then the first six digits of the exam number. For example: 12345678_061212 (Your student ID_exam number).

When creating the Excel file for the Income Statement and the Statement of Cash Flows, under the File option, select Add a new worksheet to an existing Microsoft Excel workbook. Click Browse to find and select the file you just created to add the Income Statement and the Statement of Cash Flows as new worksheets in the already existing file that contains the Balance Sheet.

The time frame to be used for both reports is the current period default (01/1/19 through 01/31/19).

It isn't necessary to export the other statements. They aren't being graded. Only the Balance Sheet, Income Statement, and the Statement of Cash Flows will be used for grading purposes.