Project 1 Objectives

In this project, students will

• practice using an accounting information system for a small business, including recording journal entries, posting to accounts, creating a trial balance, and creating financial statements.
• analyze accounting information for the benefit of a manager and a potential creditor
• listen to and communication accounting information.

Project 1 Assignment Project 1

Scofield Enterprises has been operating for one year and the company needs additional working capital to expand its business. The owner doesn't really know whether the business is profitable or not, but she is sure from the increase in orders already experienced that the business concept can be successful. Now she needs to provide GAAP-compliant financial statements to the banker and may hire your company to create them. The company has been entering information in general ledger software all year and the software has generated an Unadjusted Trial Balance which is available separately in a spreadsheet.The owner of Scofield Enterprises sat down with your boss this week when she realized that the bank wasn't going to accept the computer output, and their conversation is available atACCT 3310 Professional Application: Part Iprovided below in this folder.

REQUIRED:

Download theProject 1 Spreadsheetand customize your project by entering your phone number on the Start Here worksheet.

1. Listen to and watch the conversation between the accountant and the owner atACCT 3310 - Professional Application: Part I.
2. Use the unadjusted trial balance on theOriginal Trial Balanceworksheet in theProject 1 Spreadsheet,plus the information you gather from the owner / accountant's discussion to develop GAAP-compliant financial statements in the EXCEL workbook provided.
3. Prepare adjusting / error correction journal entries in theGeneral Journalworksheet. Skip theGeneral Ledgerworksheet.
4. Prepare an Adjusted Trial Balance on theTrial Balanceworksheet.
5. Prepare an Income Statement, Statement of Retained Earnings, and Balance Sheet in good form on the appropriate worksheets.
6. Prepare a memorandum in a separate WORD file to the owner that
   • presents your evaluation of the company's cash management and profitability and
   • explains the transformation of the unadjusted trial balance to finished financial statements.
7. Upload both files in the dropbox for Project 1.

NOTE: Each piece of numerical information should be entered into the workbook just once and use cell addresses in all subsequent formulas -- even to bring information from one worksheet to the next. Your workbook should be sufficiently integrated that a change to the number in a journal entry will flow through to the final financial statements without your having to make any additional adjustments.

Accountant Business Owner Accountant Business Owner Accountant Business Owner Accountant Business Owner Accountant Business Owner Accountant Business Owner Accountant Business Owner Accountant Business Owner Accountant Business Owner Accountant Business Owner Accountant Business Owner Come in. Thank you for seeing me today. First Bank recommended that I see an accountant, but I'm not sure exactly why. I'm just trying to set up a line of credit so that I can stock up on inventory before the Christmas buying season. The bank is asking for an income statement and balance sheet on my business. I'm sure I can help you. That's a very standard request. Let me see the information you have. This is the print out from my accounting software. I'm very careful to enter every transaction, so I don't see why this list isn't good enough. That's a great start. Let's see if I understand what you have here. (Pause) You seem to have a very high accounts receivable. Yes. That's one of the strongest points of the business to show the bank. We have just received a $20,000 order, so I entered it right away as sales and accounts receivable. I want to keep track of every transaction. Have you delivered anything on the order yet? No. We're on track to finish by the 15 th and then inspect and ship by the end of the month. That's actually something that will need to be adjusted. Did you decrease your inventory yet for this order? No. It hasn't been shipped yet, so I wouldn't change inventory. Isn't that right? Yes, that's good that your inventory here matches your inventory at your business today. Now I noticed something else about the assets you have listed. You have a building listed, but no land. That's very unusual. Do you own your own building? Yes, we've just closed on our headquarters. Of course, we own the land too. The $250,000 I recorded for the building is for both. That's what I thought. We'll have to separate out the value for the building and land because they are separate assets and have different accounting treatment. But I didn't pay a separate price for the land and building. How would I know the separate values? Most appraisers apply 20% of the total price to the land and 80% to the building in these cases, so we can follow that rule of thumb safely for a new standard purchase. I notice that your income statement is missing two expenses that I would normally expect. There is no depreciation listed. What's that? Depreciation is an expense because all equipment and facilities have a limited life. As they are used, there is wear and tear and their productivity goes down. Now, since you have just purchased the building, it wouldn't have any depreciation yet. But I wonder about the equipment. When did you purchase the equipment? At the beginning of the year. And how long do you expect before you replace the equipment? About five years. So we'll decrease your income a little each year to allocate the cost of the equipment over the five years you will be using the equipment. That's depreciation expense. Now the second item that I would expect to see is tax expense. I haven't had to pay taxes yet. Accountant Business Owner Accountant Business Owner Accountant Business Owner Accountant Business Owner Even though you haven't paid any taxes, taxes are due whenever you have a profitable business. So even though you won't be paying current year taxes until March, you still need to record the amount that you currently owe based on the amount of profit you have had so far. But won't that confuse the tax office to get my payments ahead of time? You won't be actually paying the taxes early. You'll be recording the tax amount each period, so that when the year is over the taxes associated with that year will be on your books already. Then when the taxes are due, you'll be paying off that obligation you have already recorded. If you wait to record tax expense on your books, you'll have taxes associated with last year's income on your books for this year. So how do I record taxes if they aren't even due yet? Let's estimate taxes as your pretax income multiplied by 15%. You should be getting enough credits and deductions to keep you in a low marginal tax rate level. I think That's a lot of changes. I can have my staff make these adjustments to your accounting records and create the income statement and balance sheet that your bank wants from you. Here are the adjustments we've identified: Adjust sales and accounts receivable for unfilled orders Adjust the value of the building and add the land to the records Add depreciation on the equipment Add taxes owed on your pretax income Can you stop back tomorrow morning to pick up the financial statements? Thank you so much. Directions: Enter your phone number, one number per cell, in the cells below: Phone Number 4 3 2 - 5 5 2 - Use the Original Trial Balance Worksheet and the Project 1 Video to complete this Project. See separate assignment documen Additional Information Needed: 2 1 8 separate assignment document for directions. 3 Trial Balance Provided by Owner DEBIT CREDIT Cash 4,850 Accounts Receivable 25,000 Inventory 11,700 Building purchase price 250,000 Equipment 16,000 Accounts Payable 8,300 Note Payable 250,000 Common Stock 30,000 Retained Earnings Dividends Declared Sales Revenue 60,000 Cost of Goods Sold 20,220 Rent Expense 3,450 Wages Expense 6,000 Other Expenses 11,080 Total 348,300 348,300 Date Account Posting Reference Debit Credit General Ledger CASH Date Item Post Ref. Debit Credit Debit Balance Credit You do not need to post to the Journal Entries to the General Ledger. You can put your Journal Entries directly on the Trial Balance Worksheet. This is provided for completeness of an accounting information system. ACCOUNT NAME HERE Date Item Post Ref. Debit ACCOUNT NAME HERE Date Post Ref. Debit Item ACCOUNT NAME HERE Date Item Post Ref. Debit ACCOUNT NAME HERE Credit Balance Debit Credit Credit Balance Debit Credit Debit Balance Credit Credit Date Item Post Ref. Debit Credit ACCOUNT NAME HERE Date Item Post Ref. Debit Credit Balance Debit Credit Debit ACCOUNT NAME HERE Date Item Post Ref. Debit Credit ACCOUNT NAME HERE Date Item Post Ref. Debit Credit Balance Credit Balance Debit Credit Debit Balance Credit ACCOUNT NAME HERE Date Item Post Ref. Debit Credit Balance Debit Credit ACCOUNT NAME HERE Date Item Post Ref. Debit Credit Balance Debit Credit ACCOUNT NAME HERE Date Item Post Ref. Debit Credit Debit ACCOUNT NAME HERE Date Item Post Ref. Debit Credit Balance Credit Balance Debit Credit ACCOUNT NAME HERE Date Item Post Ref. Debit Credit Balance Debit Credit ACCOUNT NAME HERE Date Item Post Ref. Debit Credit Balance Debit Credit ACCOUNT NAME HERE Date Item Post Ref. Debit Credit Debit ACCOUNT NAME HERE Date Item Post Ref. Debit Credit ACCOUNT NAME HERE Date Item Post Ref. Debit Credit Balance Debit Credit Debit ACCOUNT NAME HERE Date Item Post Ref. Debit Credit ACCOUNT NAME HERE Date Item Post Ref. Debit Credit ACCOUNT NAME HERE Date Item Post Ref. Debit Balance Credit Balance Credit Balance Debit Credit Debit Balance Credit Debit Balance Credit Credit ACCOUNT NAME HERE Date Item Post Ref. Debit ACCOUNT NAME HERE Date Item Post Ref. Debit Credit Debit Balance Credit Debit Balance Credit Credit do not need to post to the rnal Entries to the General ger. You can put your Journal ries directly on the Trial Balance rksheet. is provided for completeness n accounting information em. Accounts Total Net Income Retained Earnings Total Unadjusted Trial Balance Debit Credit Adjustments Debit Credit Adjusted Trial Balance Debit Credit Income Statement Debit Credit Statement of Retained Earnings Debit Credit Balance Sheet Debit Credit You should enter a well-formatted income statement here. Do NOT retype numbers. Write formulas for every number that you include on your income statement. You should enter a well-formatted statement of retained earnings here. Do NOT retype numbers. Write formulas for every number that you include on your statement of retained earnings. You should enter a well-formatted balance sheet here. Do NOT retype numbers. Write formulas for every number that you include on your balance sheet. You should enter a well-formatted posts-closing trial balance here. Do NOT retype numbers. Write formulas for every number that you include on your post-closing trial balance