Question

In: Accounting

Prepare a trial balance and financial statements. The accounts in the ledger of Bastin Delivery Service...

Prepare a trial balance and financial statements.

The accounts in the ledger of Bastin Delivery Service contain the following balances on July 31, 2017.

Accounts Receivable $13,400

Accounts Payable 8,400

Cash ?

Equipment 80,000

Maintenance and Repairs Expense 1,958 Insurance Expense 900

Accumulated Depreciation 20,640

Notes Payable (due 2020) 28,450

Prepaid Insurance 2,200

Service Revenue 15,500

Dividends 700

Common Stock 40,000

Salaries and Wages Expense 7,428

Salaries and Wages Payable 820

Retained Earnings (July 1, 2017) 5,200 Instructions:

1. Prepare a trial balance with the accounts arranged in financial statement order (assets, liabilities, equity, revenue, expense) and fill in the missing amount for Cash.

2. Prepare an income statement, a retained earnings statement, and a classified balance sheet for the month of July 2017.

Must be Prepared in Excel Worksheet.

Solutions

Expert Solution


Related Solutions

Prepare an adjusted trial balance. If an amount Ledger Accounts, Adjusting Entries, Financial Statements, and Closing...
Prepare an adjusted trial balance. If an amount Ledger Accounts, Adjusting Entries, Financial Statements, and Closing Entries; Optional Spreadsheet. The unadjusted trial balance of Recessive Interiors at January 31, 2019, the end of the year, follows: Recessive Interiors Unadjusted Trial Balance January 31, 2019 Debit Balances Credit Balances 11 Cash 13,100 13 Supplies 8,000 14 Prepaid Insurance 7,500 16 Equipment 113,000 17 Accumulated Depreciation—Equipment 12,000 18 Trucks 90,000 19 Accumulated Depreciation—Trucks 27,100 21 Accounts Payable 4,500 31 Jeanne McQuay, Capital...
REQUIRED: Prepare General Ledger, Accounts Receivable Ledger, Accounts Payable Ledger, Trial Balance, Schedule of Accounts Receivable...
REQUIRED: Prepare General Ledger, Accounts Receivable Ledger, Accounts Payable Ledger, Trial Balance, Schedule of Accounts Receivable and Schedule of Accounts Payable from the following information and Journals using T Accounts with a balance column. Grassley Company completes these transactions during November of the current year (terms for all its credits sales are 2/10, n/30). Nov.1 Purchased $5,058 of office equipment on credit from Brun supply, invoice dated November 1, terms n/10 EOM. 2 Borrowed $88, 500 cash from Wisconsin Bank...
Required --------------------- 1. Post to the ledger. 2. Prepare the trial balance of Harper Service as...
Required --------------------- 1. Post to the ledger. 2. Prepare the trial balance of Harper Service as at 31 March 2018 -------- During March, the business engaged in the following transactions, All figures are GST (GST is 15%)inclusive where applicable: Journalise each transaction. Key journal entries by transaction letter, using the format below: General Journal Transactions Accounts Debit ($) Credit ($)         1 March: Borrowed $45,000 from the bank and signed a bill payable in the name of the business. 2...
Ledger Accounts, Adjusting Entries, Financial Statements, and Closing Entries; End-of-Period Spreadsheet. The unadjusted trial balance of...
Ledger Accounts, Adjusting Entries, Financial Statements, and Closing Entries; End-of-Period Spreadsheet. The unadjusted trial balance of Recessive Interiors at January 31, 2018, the end of the year, follows: Recessive Interiors Unadjusted Trial Balance January 31, 2018 Debit Balances Credit Balances 11 Cash 13,100 13 Supplies 8,000 14 Prepaid Insurance 7,500 16 Equipment 113,000 17 Accumulated Depreciation—Equipment 12,000 18 Trucks 90,000 19 Accumulated Depreciation—Trucks 27,100 21 Accounts Payable 4,500 31 Common Stock 30,000 32 Retained Earnings 96,400 33 Dividends 3,000 41...
Ledger Accounts, Adjusting Entries, Financial Statements, and Closing Entries; End-of-Period Spreadsheet. The unadjusted trial balance of...
Ledger Accounts, Adjusting Entries, Financial Statements, and Closing Entries; End-of-Period Spreadsheet. The unadjusted trial balance of Recessive Interiors at January 31, 2018, the end of the year, follows: Recessive Interiors Unadjusted Trial Balance January 31, 2018 Debit Balances Credit Balances 11 Cash 13,100 13 Supplies 8,000 14 Prepaid Insurance 7,500 16 Equipment 113,000 17 Accumulated Depreciation—Equipment 12,000 18 Trucks 90,000 19 Accumulated Depreciation—Trucks 27,100 21 Accounts Payable 4,500 31 Common Stock 30,000 32 Retained Earnings 96,400 33 Dividends 3,000 41...
Ledger Accounts, Adjusting Entries, Financial Statements, and Closing Entries; End-of-Period Spreadsheet. The unadjusted trial balance of...
Ledger Accounts, Adjusting Entries, Financial Statements, and Closing Entries; End-of-Period Spreadsheet. The unadjusted trial balance of Recessive Interiors at January 31, 2018, the end of the year, follows: Recessive Interiors Unadjusted Trial Balance January 31, 2018 Debit Balances Credit Balances 11 Cash 13,100 13 Supplies 8,000 14 Prepaid Insurance 7,500 16 Equipment 113,000 17 Accumulated Depreciation—Equipment 12,000 18 Trucks 90,000 19 Accumulated Depreciation—Trucks 27,100 21 Accounts Payable 4,500 31 Common Stock 30,000 32 Retained Earnings 96,400 33 Dividends 3,000 41...
Journalize these transactions, post the transactions to the ledger accounts, prepare a trial balance. Assets 111...
Journalize these transactions, post the transactions to the ledger accounts, prepare a trial balance. Assets 111 Cash 112 Accounts Receivable 114 Prepaid Insurance 121 Land 122 Building 123 Accumulated Depreciation, Building 124 Pool/Slide Facility 125 Accumulated Sepreciation, Pool/Slide Facility 126 Pool Furniture 127 Accumulated Depreciation, Pool Furniture Liabilities 221 Accounts Payable 222 Wages Payable 223 Mortgage Payable Owners Equity 311 L. Judar, Capital 312 L. Judar, Drawing 313 Income Summary Revenue 411 Income from services 412 Concessions Income Expenses 511...
Describe the purposes of the General Journal, General Ledger, Trial Balance, and Financial Statements, and how...
Describe the purposes of the General Journal, General Ledger, Trial Balance, and Financial Statements, and how they "flow into" each other. Feel free to cite sources and even include quotations 250 words or more
After the trial balance is prepared, the business owner can prepare the financial statements.
After the trial balance is prepared, the business owner can prepare the financial statements. List and discuss the purpose of each financial statement, the order in which the financial statements are prepared, and the information included in each financial statement information also in Chapter 1, illustration 1.9). In addition, consider the fact that many people feel that financial statements should be expanded beyond the traditional components (income statement, statement of owner's equity, statement of cash flows and balance sheet). Should financial...
9.7 Enter the following transactions in the ledger of A Baker and prepare a trial balance...
9.7 Enter the following transactions in the ledger of A Baker and prepare a trial balance at 31 May, together with a calculation of the profit for the month and a balance sheet at 31 May. May 1 Started in business with £1,500 in the bank and £500 cash May 2 Purchased goods to the value of £1,750 from C Dunn, agreeing credit terms of 60 days May 3 Bought fixtures and fittings for the bakery for £150, paying by...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT