Prepare quarterly adjustment entries in excel

Reference no: EM1357618

The ledger of Welch Rental Agency Inc. on March 31 of the current year includes the following selected accounts before adjusting entries have been prepared.

Debit Credit

Prepaid Insurance $ 3,600

Supplies 2,800

Equipment 25,000

Accumulated

Depreciation - Equipment $ 8,400

Notes Payable 20,000

Unearned Rent 12,000

Rent Revenue 60,000

Interest Expense -0-

Wages Expense 14,000

An analysis of the accounts shows the following.

1. The equipment depreciates $300 per month.

2. One-third of the unearned rent was earned during the quarter.

3. Interest of $500 is accrued on the notes payable.

4. Supplies on hand total $1,100.

5. Insurance expires at the rate of $200 per month.

Prepare the adjusting entries at March 31, assuming that adjusting entries are made quarterly. Additional accounts are: Depreciation Expense, Insurance Expense, Interest Payable, and Supplies Expense. Must use excel spreadsheet format.

Reference no: EM1357618

Questions Cloud

How employers can safeguard against inaccuracies : Discuss methods of protecting the employer's interests when faced with inaccurate or inflated and what is the legal protection to employers if a candidate provides inaccurate or inflated information in a résumé?

Illustrate marginal product of the last worker in mexico : The wage in the U.S. is $20. Given current employment, the marginal product of the last worker in Mexico is 100, and the marginal product of the last worker in the U.S. is 500.

Explain what impact does the concept of trustworthiness : Explain In what manner do leaders serve as role models (better or worse) for ethical behavior and What impact does the concept of trustworthiness have on the level of trust in organizational leadership?

Compute the net income : McMaster Corporation, has a times interest earned ratio of 4.0. Based on this ratio, a creditor knows that McMasters EBIT must decline by more than before McMaster will be unable to cover its interest expense.

Prepare quarterly adjustment entries in excel : The ledger of Welch Rental Agency Inc. on March 31 of the current year includes the following selected accounts before adjusting entries have been prepared.

Illustrate what role did the policies of various governments : Illustrate what role did the policies of various governments play in influencing the international expansion strategies of both.

Calculate the energy density in the electric field : Calculate the energy density in the electric field. After the collision, the club head travels (in the same direction) at 46 m/s. Find the speed of the golf ball just after impact.

Generates alternative message that has hash value : Generates an alternative message that has a hash value that collides with Bob's original hash value. Show a message that Alice may have spoofed, and demonstrate that its hash value collides with Bob's original hash."

Theory of multiple intelligences and learning styles : What are different types of intelligences proposed by "The Theory of Multiple Intelligences" and how do they impact an individual's learning style?

User Account

All Pages