Coursehero USA logo
  • My account
  • Order now
Order Now
Homework Help

Accounting excel | Accounting homework help

2 min read
Posted on 
January 21st, 2023
Home Homework Help Accounting excel | Accounting homework help

 PLEASE FOLLOW MY WORKSHEET (unadjustment) to complete question 5(a) and 6.(one upload is information, another one is excel, complete it in excel)

5. Worksheet

a. Use the following information to record adjustments in the Adjustments column of the worksheet:

▪ furniture: Depreciation on the furniture owned by the business for the month of June is $156.

▪ equipment: Depreciation on the equipment owned by the business for the month of June is $366.

▪ Electricity expense for the month of June is estimated to be $874.

▪ The water usage for the month of June is estimated to be $235.

▪ The amount of wages incurred during the month of June but not yet paid to sales staff is $1,320.

▪ Interest expense incurred during the month of June but not yet paid to MRMC Bank for the bank loan is

$275.

▪ Interest earned from short-term investments in BitiBank for the month of June is $100.

▪ The value of office supplies used during the month of June is $4,037.

▪ $3,000 worth of prepaid rent expired during the month of June.

▪ $3,000 worth of prepaid advertising was used up in June.

▪ $590 worth of prepaid insurance expired during the month of June.

 

6. Adjusting entries

Use the worksheet to help journalize adjustments for June.

a. Record adjusting entries in the general journal.

b. Post the adjusting entries from the general journal to the relevant ledgers

Order an Essay Now & Get These Features For Free:

Turnitin Report

Formatting

Title Page

Citation

Outline

Place an Order
Share
Tweet
Share
Tweet
Calculate the price
Pages (275 words)
$0.00
Coursehero USA
Company
Legal
How Our Service is Used:
Coursehero USA essays are NOT intended to be forwarded as finalized work as it is only strictly meant to be used for research and study purposes. Coursehero USA does not endorse or condone any type of plagiarism.
Subscribe
No Spam
© 2023 Coursehero USA. All rights reserved.
Coursehero USA will be listed as ‘Coursehero USA’ on your bank statement.