Question: Can you please work the excel sheet, most the answers are filled in already just fill in the blank areas that need the numbers filled

Can you please work the excel sheet, most the answers are filled in already just fill in the blank areas that need the numbers filled in, the instructions are on the first sheet, the actual fill in work is on sheet two. Thanks, need it done as soon as possible. Can you please work the excel sheet, most the answers are filled

AC2760 Week 2 Assignment Read the following scenario, and complete the form on the following worksheet: On March 1, 2012, Mitch Quade established Mitch Realty, which completed the following transactions during the month: (a) (b) (c) (d) (e) (f) Mitch Quade transferred cash from a personal bank account to an account to be used for the business in exchange for capital stock, $18,000. Purchase supplies on account, $1,200. Earned sales commission, receiving cash, $14,00. Paid rent on office and equipment for the month, $2,800. Paid creditor on account, $750. Paid office salaries, $3,000. Instructions: 1 Journalize entries for transactions (a) through (f). Omit the journal entry explanations. Please use the drop-down list (right of the cell) to enter the account description box on the worksheet. 2 3 Post the journal entries the T accounts, placing the appropriate letter to the left of each amount to identify the transactions. Determine the account balance after all posting is complete. Accounts containing only a single entry do not need a balance. Prepare and unadjusted trial balance as of March 31, 2012. Name: Section: Luis Vega AC2760 Enter the appropriate amount or item in the shaded cells. An asterisk (*) will appear next to an incorrect entry in the outlined cells. 1. Journal - Mitch Realty Description Debit (a) Cash Capital Stock Credit 18,000 18,000 (b) Supplies Accounts Payable 1,200 (c) Cash Sales Commissions 1,400 * (d) Rent Expense Cash 2,800 * 1,200 1,400 * 2,800 * (e) Accounts Payable Cash (f) 750 750 Office Salaries Expense Cash 2. 3,000 * 3,000 * Ledger - Mitch Realty (a) (c) Cash 18,000 (d) (e) (f) 2 Capital Stock (a) Bal. (b) (e) Supplies 1,200 1 Accounts Payable 750 (b) Bal. 3. 18,000 Sales Commission (c) * 3,000 750 2,800 1,400 (f) 1,200 450 Office Salaries Expense 2,800 1 (d) Rent Expense 3,000 1 MITCH REALTY Unadjusted Trial Balance March 31, 2012 Debit Cash Supplies Accounts Payable Capital Stock Sales Commissions Rent Expense Office Salaries Expense Credit 1,200 18,000 2,800 3,000 October 1, 2010 October 31, 2010

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!