- Requirement 1 As The Accountant For Wikki Cleaners You Have Been Asked To Prepare Financial Statements For The Year A 1 (502.39 KiB) Viewed 11 times
- Requirement 1 As The Accountant For Wikki Cleaners You Have Been Asked To Prepare Financial Statements For The Year A 2 (234.37 KiB) Viewed 11 times
REQUIREMENT 1. As the accountant for Wikki Cleaners, you have been asked to prepare financial statements for the year. A file called F1WORK has been provided to assist you in this assignment. As you review this file, it should be noted that columns H and I will automatically change when you enter values in columns E or G. 2. Open the file F1WORK from the website for the book at cengagebrain.com. Enter the formulas in the appropriate cells on the worksheet. Then enter the adjusting amounts in columns E and G. Also, in column D or F. insert the letter corresponding to the adjusting entry (a-d). Column A is "frozen" on the screen to assist you in completing requirement 3. 3. Complete the income
statement and balance sheet columns by entering formulas in columns J, K, L, and M that reference the appropriate cells in columns H or 1. Net income will be automatically calculated for the income
statement and balance sheet. Check to be sure that these numbers are the same. Enter your name in cell A1. Save the completed file as F1WORK3. Print the worksheet. Also print your formulas using landscape orientation and fit-to-1 page scaling. Check figure: Net income (cell J30), $71,320.
42-M2 7 8 9- Account Title 10 Cash 11 Cleaning supplies 12 Prepaid insurance 13 Equipment 14 Accumulated depr. 15 Accounts payable 16 Wikki Lee, capital 17 Wikki Lee, drawing 18 Revenue 19 Rent expense Wages expense Utilities expense Misc. expense 21 24 25 28 P1 WORK 31 32 Supplies expense Insurance expense Depreciation exp. Wages payable Net income B C Trial Balance Dr. Cr. 13,200 22,000 5,400 206,000 27,000 28,500 39,720 74,100 8,500 91,200 171,560 2,130 1,410 345,360 345,360 D E F G For Year Ended December 31, 2012 Adjustments Adj. T/Balance Dr. Cr. 13,200 22,000 5,400 206,000 Dr. FORM1 Cr. H 0 0 0 27,000 0 28,500 39.720 2,130 1,410 0 0 0 0 74,100 8,500 91,200 0 171,560 0 0 0 0 0000 0 0 0 0 FORM2 FORM3 FORM4 K Income
Statement Dr. Cr. FORM5 FORM6 #VALUE! #VALUE! 0 0 L M Balance Sheet Dr. Cr. FORM7 #VALUE! #VALUE! FORM8 0 0 N O