H J Income Statement Debit Credit 200 B D E F G 4 5 Instructions: The worksheet and the financial statements have been started and outlined. Where you see the word 6 "FORMULA", that is where a formula should be typed in Cash and AR in rows 13 and 14 have been 7 done for you as an example. Sometimes the formula is just bringing a number over to the next area in that case 8 type = followed by the cell number it was in before (click on cel F13 to see the formula used there). Other times you 9 may have to add or subtract (see the formula in cell F14) When you are adding more than two numbers use the 10 =sum formula Complete and save 11 12 Trial Balance Adjustments Adj. Trial Balance 13 Debit Credit Debit Credit Debit Credit 14 Cash 5,000 5,000 15 AR 1,000 1000 2.000 16 Supplies 500 200 300 17 PP Rent 100 100 18 PP Insurance 300 150 150 19 Office Equip 1500 1 500 20 Accum. Dep 200 200 400 21 AP 500 500 22 Salaries Pay 400 120 520 23 Unearned Fees 1,200 1000 200 24 Retained Earnings 2.000 2.000 25 Common Stock 3,000 3.000 26 Dividends 600 600 27 Fees Earned 3 000 2000 5000 28 Salary Exp 500 120 620 29 Rent Exp 400 100 500 30 Supplies Exp 0 200 200 31 Dep Exp, 200 200 32 Insurance Exp 0 150 150 33 Misc. Exp 300 300 34 35 Total 10,300 10300 2,770 2,770 11 620 11 620 36 Net Income 37 Total Balance Sheet Debit Credit 5,000 2000 300 100 150 1,500 400 500 520 200 2.000 3,000 600 5000 620 500 200 200 150 300 0 5,000 9.650 1970 3,030 5,000 6,620 3,030 9,650 5.000 9.650 D D FORMULA A B 31 Dep Exp. 0 32 Insurance Exp 0 33 Misc. Exp 300 34 35 Total 10,300 10,300 36 Net Income 37 Total 38 39 40 Quixote Consulting 41 Income Statement 42 For month ended June 30, 20XX 43 44 Fees Earned FORMULA 45 Operating Expenses 46 Salary Exp FORMULA 47 Rent Exp FORMULA 48 Supplies Exp FORMULA 49 Dep, Exp. FORMULA 50 Insurance Exp FORMULA 51 Misc. Exp FORMULA 52 Total Expenses FORMULA 53 Net Income FORMULA 54 55 B 67 68 69 Quixote Consulting 70 Balance Sheet 71 June 30, 20XX 72 Assets 73 Current Assets 74 Cash FORMULA 75 AR FORMULA 76 Supplies FORMULA 77 PP Rent FORMULA 78 PP Insurance FORMULA 79 Total Current Assets 80 Property Plant and Equipment 81 Office Equip FORMULA 82 Accum Dep FORMULA FORMULA 83 Total Property Plant and Equip 84 Total Assets 85 86 Liabilities 87 Current Liabilities 88 AP FORMULA 89 Salaries Pay FORMULA 90 Uneamed Fees FORMULA 91 Total Liabilities 92 93 Stockholders' Equity 94 Common Stock FORMULA 95 Retained Earnings FORMULA 96 Total Stockholders' Equity 97 Total Liabilities & Stockholders' Equity 98 FORMULA FORMULA FORMULA FORMULA FORMULA