Excel Applications for Accounting Principles 4th Edition by Gaylord Smith

تمرين 5

PROBLEM DATA
The trial balance of Wikki Cleaners at December 31, 2012, the end of the current fiscal year, is as follows:

Information for the adjusting entries is as follows:
a. Cleaning supplies on hand on December 31, 2012, $18,750.
b. Insurance premiums expired during the year, $1,800.
c. Depreciation on equipment during the year, $21,600.
d. Wages accrued but not paid at December 31, 2012, $1,830.
REQUIREMENT
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.