Need some help!
EXCEL PROJECT FINANCIAL ACCOUNTING 3 Name 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 14 and 15 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 type followed by the cell number it was in before (click on cell F14 to see the formula used there). Other times you 9 may have to add or subtract (see the formula in cell F15). When you are adding more than two numbers, use the 10 sum formala Complete and save. 11 12 Trial Balance Adjustments Adj. Trial Balance Income Statement Balance Sheet 13 Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit 14 Cash 5,000 5,000 5,000 15 AR 1,000 1000 2,000 2000 16 Supplies 500 200 FORMULA FORMULA 17 PP Rem 200 100 FORMULA FORMULA 18 PP Insurance 300 150 FORMULA FORMULA 19 Otlice Equip 1,500 FORMULA FORMULA 20 Accum. Dep 200 200 FORMULA FORMULA 21. AP 500 FORMULA FORMULA 22 Salanes Pay 400 FORMULA FORMULA 23 Unearned Fees 1.200 1000 FORMULA FORMULA 24 Retained taming 2,000 FORMULA FORMULA 25 Common Stock 3,000 FORMULA FORMULA 26 Dnidends 600 FORMULA 27 Fes Eamed FORMULA 3.000 2000 FORMULA 28 Salary Ex FORMULA 5001 120 29 fer Exp FORMULA FORMULA 400 100 FORMULA FORMULA 30 Supplies Exp 0 200 FORMULA 11 g Exp FORMULA 0 200 FORMULA 22 Inwrcp FORMULA 0 150 30 Mac EXP FORMULA FORMULA 300 34 FORMULA FORMULA 75 Total 10.100 10300 2,770 2770 FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA 36 Income 37 Total FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA 120 Consulting 41 Income Statement 12 For month endedne 30, 20XX 44 44 es Eamed FORMULA Operating Expenses 16 Saly Exp FORMULA 41 Rent Exp FORMULA Sees Exp FORMULA 45 Depp FORMA Orice tap FORMULA 51 Me FORMULA sts n FORMULA FORMA Instructions Use followed by the cell member where last appeared in the worksheet to bring numbers down Cel C5 will need num for adding all expenses, colle2 will need a Subtraction formula Complete the facial statements Quixote Consulting Statement of Stockholders' Equity For month ended June 30, 20XX Common Retained Stock Earnings Total Balance on June, 1, 20XX FORMULA FORMULA FORMULA Issued Common Stock 0 0 Net Income FORMULA FORMULA Dividends FORMULA FORMULA Balance, June 30, 20XX FORMULA FORMULA FORMULA Assume no additional Common Stock was issued so zero has been filled in. Notice the word "Formula" is in the appropriate place to give you the proper format for a balance sheet. Quixote Consulting Balance Sheet 1 June 30, 20XX 2 Assets 3 Current Assets: 4 Cash FORMULA 5 AR FORMULA 6 Supplies FORMULA 7 PP Rent FORMULA 18 PP Insurance FORMULA 79 Total Current Assets FORMULA 30 Property Plant and Equipment: B1 Office Equip FORMULA 32 Accum. Dep. FORMULA FORMULA 83 Total Property Plant and Equip FORMULA 84 Total Assets FORMULA 85 86 Liabilities 87 Current Liabilities 88 AP FORMULA 89 Salaries Pay FORMULA 90 Unearned Fees FORMULA 91 Total Liabilities FORMULA 92 93 Stockholders' Equity 94 Common Stock FORMULA 95 Retained Earnings FORMULA 96 Total Stockholders' Equity FORMULA 97 Total Liabilities & Stockholders' Equity FORMULA 98 99 100 101
