Chat with AI
Excel Applications for Accounting Principles 4th Edition by Gaylord Smith
Edition 4ISBN: 978-1111581565Excel Applications for Accounting Principles 4th Edition by Gaylord Smith
Edition 4ISBN: 978-1111581565 Exercise 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.
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.
Explanation
Verified
Verified
The required financi...
Excel Applications for Accounting Principles 4th Edition by Gaylord Smith
Why don’t you like this exercise?
Other Minimum 8 character and maximum 255 character
Character 255
