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 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
Get step-by-step solutions from verified subject matter experts
