Question: Excel Spreadsheet Template Preparing a worksheet Exercise 4-1 The unadjusted trial balance of Overland Trekkers appears below OVERLAND TREKKERS Unadjusted Trial Balance September 30, 2017

 Excel Spreadsheet Template Preparing a worksheet Exercise 4-1 The unadjusted trial

Excel Spreadsheet Template Preparing a worksheet Exercise 4-1 The unadjusted trial balance of Overland Trekkers appears below OVERLAND TREKKERS Unadjusted Trial Balance September 30, 2017 Net income, $12,520 Cash Accounts receivable Prepaid rent Supplies Equipment Accumulated amortization-equipment Accounts payable Salaries payable R. Puri, capital R. Puri, withdrawals Service revenue Amortization expense-equipment Salaries expense Rent expense Utilities expense Supplies expense Total $ 14,240 11,880 2,400 6,780 65,200 $ 5,680 10,320 72,060 6,000 23,600 3,600 1,560 111,660 111,660 Additional information at September 30, 2017 a. The business had sales that were not recorded yet in the amount of $840. It must accrue this service revenue b. Equipment Amortization in the amount of $260 needs to be recorded. c. The business needs to accrue salaries expense of $2,100 for work done but not yet d. Prepaid rent used in the amount of $1,200 e. Supplies worth $3,200 were used up during the period Required Complete the Overland Trekkers worksheet for September 2017. What was net income for the month ended September 30, 2017

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!