F G H I J L M B D E EXCEL PROJECT FINANCIAL ACCOUNTING Name Instructions: The worksheet and the financial statements have been started and outlined. Where you see the word "FORMULA", that is where a formula should be typed in. Cash and AR in rows 13 and 14 have been 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 F13 to see the formula used there). Other times you may have add or subtract (see the formula in cell F14). When you are adding more than two numbers, use the =sum formula. Complete and save Cash AR Supplies PP Rent PP Insurance Office Equip Accum. Dep. AP Salaries Pay Unearned Fees Retained Earnings Common Stock Dividends Fees Earned Salary Exp. Rent Exp. Supplies Exp. Dep. Exp Insurance Exp. Misc. Exp. Trial Balance Debit Credit 5,000 1,000 500 200 300 1,500 200 500 400 1,200 2,000 3,000 600 3,000 500 4001 01 0 0 300 Adjustments Adj. Trial Balance Income Statement Debit Credit Debit Credit Debit Credit 5,000 1000 2,000 200 FORMULA 100 FORMULA 150 FORMULA FORMULA 200 FORMULA FORMULA 120 FORMULA 1000 FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA 120 FORMULA FORMULA 100 FORMULA FORMULA 2001 FORMULA FORMULA 200 FORMULA FORMULA 150 FORMULA FORMULA FORMULA FORMULA Balance Sheet Debit Credit 5,000 2,000 FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA 2000 10,300 10,300 2,770 2,770 FORMULA FORMULA Total Net Income Total FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA Quixote Consulting Income Statement For month ended June 30, 20XX FORMULA Fees Earned Operating Expenses: Salary Exp Rent Exp. Sunnlies Fyn Sheet1 Instructions: Use = followed by the cell number where it last appeared in the worksheet to bring numbers down. Cell C51 will need an =sum formula adding all expenses, cell c52 will need a subtraction formula Complete all three financial statements FORMULA FORMULA FORMULA Sheet3 Sheet2 E F H B Quixote Consulting Income Statement For month ended June 30, 20XX FORMULA Fees Earned Operating Expenses: Salary Exp. Rent Exp. Supplies Exp Dep. Exp. Insurance Exp Misc. Exp. Total Expenses Net Income Instructions: Use = followed by the cell number where it last appeared in the worksheet to bring numbers down. Cell C51 will need an =sum formula adding all expenses, cell c52 will need a subtraction formula Complete all three financial statements. FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA FORMULA 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 as been filled in. Quixote Consulting Balance Sheet June 30, 20XX Assets Current Assets: Cash AR FORMULA FORMULA FORMULA FORMULA FORMULA Notice the word "Formula" is in the appropriate place to give you the proper format for a balance sheet. FORMULA Supplies PP Rent PP Insurance Total Current Assets Property Plant and Equipment: Office Equip Accum. Dep. Total Property Plant and Equip. Total Assets FORMULA FORMULA FORMULA FORMULA FORMULA Liabilities Sheet1 Sheet2 Sheet Quixote Consulting Balance Sheet June 30, 20XX Assets Current Assets: Cash AR FORMULA FORMULA FORMULA FORMULA FORMULA Notice the word "Formula" is in the appropriate place to give you the proper format for a balance sheet. FORMULA Supplies PP Rent PP Insurance Total Current Assets Property Plant and Equipment: Office Equip Accum. Dep. Total Property Plant and Equip Total Assets FORMULA FORMULA FORMULA FORMULA FORMULA Liabilities Current Liabilities AP Salaries Pay. Unearned Fees Total Liabilities FORMULA FORMULA FORMULA FORMULA Stockholders' Equity Common Stock Retained Earnings Total Stockholders' Equity Total Liabilities & Stockholders' Equity FORMULA FORMULA FORMULA FORMULA
