Excel Assignment _2

Excel Assignment _2 - 2,000 Prepaid Rent 400 Accounts...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Excel Problem: Post-Closing Trial Balance Name: Using cell references, properly place each account's balance in either the debit column or the credit column, assuming each account has a normal balance. Input a simple formula to determine the credit balance of "Account X" that will correctly complete the trial balance. Use formulas to finish the trial balance with totals for each column. DATA: Account Balance Account Balance Cash
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 2,000 Prepaid Rent 400 Accounts Receivable 900 Notes Payable 250 Accounts Payable 380 Retained Earnings 850 Equipment 700 Common Stock 550 Accum. Depreciation 70 Post-Closing Trial Balance Debit Credit Cash 2,000 Accounts Receivable 900 Prepaid Rent 400 Equipment 700 Accum. Depreciation 70 Accounts Payable 380 Notes Payable 250 Retained Earnings 850 Common Stock 550 Account X 1,900 TOTALS: 4,000 4,000...
View Full Document

This note was uploaded on 04/27/2010 for the course ACCT 215 taught by Professor Thompsonabbot during the Spring '10 term at Marshall.

Ask a homework question - tutors are online