Copy Format Painter BIU - DA Merge & Center Clipboard Font Alignment fox C D E F G CORPORATE TRIAL BALANCE FTB Excel Aplications for Accounting Principles: Website Alternative Problem by Gaylord N. Smith The general ledger of Jay Consulting, Inc. shows the following balances at July 31 8 Cash $ 4,440 9 Accounts receivable 5,780 10 Prepaid rent 1.200 11 Accounts payable 2,850 12 Salaries payable 475 13 Common stock Retained earnings (beginning) 3,000 14 4 486 Dividends 15 2.000 Consulting fees 6,920 600 2,600 755 196 21 160 22 Click the Worksheet tab and prepare a trial balance for Jay Consulting, Inc. as of 23 July 31 24 25 Review the Model-Building Problem Checklist on page 154 to ensure that your 26 worksheet is complete. Print the worksheet when done. Check figure: Total 27 debits, 17,731 28 29 16 Rent expense 17 Salary expense 18 Supplies expense 19 Utilities expense 20 Miscellaneous expense e G D E B Store Supplies Store Supplies Expense 5,880 14,250 Answer Section 5 Sales Discount 48,000 FORMULA Bonnie's Buds 56 Income Statement 37 38 For Month Ended 39 May 31, 2012 40 41 Revenue 42 Sales 43 Less: TITLE A 44 Net sales 45 Cost of goods sold 46 Beginning merchandise inventory FORMULA4 Less TITLE C FORMULAS 49 Net purchases 50 Goods available for sale 51 Less ending inventory 52 Cost of goods sold 53 TITLED 54 55 Operating expenses 56 Selling expenses ST TITLEE 58 TITLEF EE- 47 SO FORMULA $0 FORMULA FORMULAS SO GO TITLE 61 TITLE 2 TITLE FORMULAS FORMULA 10 FORMULA11 FORMULA12 FORMULA 13 FORMULA 14 Total expenses Worksheet SO e chapte