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. 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.

Question

Want to see more full solutions like this?

Answer 1

Textbook Question

Chapter 2, Problem 1R

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

Chapter 2, Problem 1R, The trial balance of Wikki Cleaners at December 31, 2012, the end of the current fiscal year, is as

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.

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.

Expert Solution & Answer

To determine

Prepare financial statement by entering the amount in its respective column in the worksheet.

Explanation of Solution

Excel Applications for Accounting Principles, Chapter 2, Problem 1R , additional homework tip 1

(Figure 1)

Excel Applications for Accounting Principles, Chapter 2, Problem 1R , additional homework tip 2

(Figure 2)

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Students have asked these similar questions

The prepaid insurance account had a balance of $7,155 at the beginning of the year. The account was debited for $22,025 for premiums on policies purchased during the year, ending on March 31. Journalize the adjusting entry required under each of the following alternatives for determining the amount of the adjustment: (a) the amount of unexpired insurance applicable to future periods is $8,765; (b) the amount of insurance expired during the year is $20,415. Refer to the Chart of Accounts for exact wording of account titles.

The balance in the prepaid insurance account, before adjustment at the end of the year, is $18,565. Journalize the March 31 adjusting entry required under each of the following alternatives for determining the amount of the adjustment: (a) the amount of insurance expired during the year is $14,135; (b) the amount of unexpired insurance applicable to future periods is $4,430. Refer to the chart of accounts for the exact wording of the account titles. CNOW journals do not use lines for journal explanations. Every line on a journal page is used for debit or credit entries. CNOW journals will automatically indent a credit entry when a credit amount is entered.

Hardy's Landscape Service's total revenue on account for 2018 amounted to $273,205. The company, which uses the allowances method, estimates bad debts at 1/2 percent of total revenue on account. Required: Journalize the following selected entries: 2012 Dec. 12 Record services performed on account for E.E. Morton, $245. Dec. 31 Record the adjusting entry for Bad Debts Expense. Dec. 31 Record the closing entry for Bad Debts Expense. 2013 Feb. 18 Write off the account of E.E. Morton as uncollectible, $245.

Answer 2

Textbook Question

Chapter 2, Problem 1R

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

Chapter 2, Problem 1R, The trial balance of Wikki Cleaners at December 31, 2012, the end of the current fiscal year, is as

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.

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.

Expert Solution & Answer

To determine

Prepare financial statement by entering the amount in its respective column in the worksheet.

Explanation of Solution

Excel Applications for Accounting Principles, Chapter 2, Problem 1R , additional homework tip 1

(Figure 1)

Excel Applications for Accounting Principles, Chapter 2, Problem 1R , additional homework tip 2

(Figure 2)

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 3

Textbook Question

Chapter 2, Problem 1R

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

Chapter 2, Problem 1R, The trial balance of Wikki Cleaners at December 31, 2012, the end of the current fiscal year, is as

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.

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.

Expert Solution & Answer

To determine

Prepare financial statement by entering the amount in its respective column in the worksheet.

Explanation of Solution

Excel Applications for Accounting Principles, Chapter 2, Problem 1R , additional homework tip 1

(Figure 1)

Excel Applications for Accounting Principles, Chapter 2, Problem 1R , additional homework tip 2

(Figure 2)

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 4

Textbook Question

Chapter 2, Problem 1R

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

Chapter 2, Problem 1R, The trial balance of Wikki Cleaners at December 31, 2012, the end of the current fiscal year, is as

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.

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.

Expert Solution & Answer

To determine

Prepare financial statement by entering the amount in its respective column in the worksheet.

Explanation of Solution

Excel Applications for Accounting Principles, Chapter 2, Problem 1R , additional homework tip 1

(Figure 1)

Excel Applications for Accounting Principles, Chapter 2, Problem 1R , additional homework tip 2

(Figure 2)

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 5

Textbook Question

Answer 6

Textbook Question

Answer 7

Expert Solution & Answer

To determine

Prepare financial statement by entering the amount in its respective column in the worksheet.

Explanation of Solution

Excel Applications for Accounting Principles, Chapter 2, Problem 1R , additional homework tip 1

(Figure 1)

Excel Applications for Accounting Principles, Chapter 2, Problem 1R , additional homework tip 2

(Figure 2)

Answer 8

Expert Solution & Answer

To determine

Prepare financial statement by entering the amount in its respective column in the worksheet.

Explanation of Solution

Excel Applications for Accounting Principles, Chapter 2, Problem 1R , additional homework tip 1

(Figure 1)

Excel Applications for Accounting Principles, Chapter 2, Problem 1R , additional homework tip 2

(Figure 2)

Answer 9

Expert Solution & Answer

Answer 10

Expert Solution & Answer

Answer 11

To determine

Prepare financial statement by entering the amount in its respective column in the worksheet.

Answer 12

Explanation of Solution

Excel Applications for Accounting Principles, Chapter 2, Problem 1R , additional homework tip 1

(Figure 1)

Excel Applications for Accounting Principles, Chapter 2, Problem 1R , additional homework tip 2

(Figure 2)

Answer 13

Ch. 2 - The trial balance of Wikki Cleaners at December...Ch. 2 - The trial balance of Wikki Cleaners at December...Ch. 2 - The trial balance of Wikki Cleaners at December...Ch. 2 - The trial balance of Wikki Cleaners at December...Ch. 2 - The trial balance of Wikki Cleaners at December...Ch. 2 - The trial balance of Wikki Cleaners at December...

Concept explainers

Videos

Explanation of Solution

Want to see more full solutions like this?

Chapter 2 Solutions