Create an adjusted trial balance & journal entries

Bank charges of $932.70 were not recorded in the books for 2014. These were credit card fees charged by the bank for Edwards, INC accepting credit cards from their customers. The charges were recorded accurately on the bank reconciliation (use bank charge expense)

70% of the accounts payable balance at 12-31-14 was paid in 1st quarter 2015. The balance will be paid in the 2nd quarter 2015.

A new factory warehouse was purchased on 1-1-14 for $3,475,500. Prior to this time the facilities had been rented. The cost of the warehouse was not recorded on the books when purchased. Company obtained financing on a 15-year note signed on 1-1-14. The payment is $34,945/month (principal $19,308.33 interest of $15,636.67). Assume equal payments each month and a balloon payment at the end of the note. Land of $100,000 is included in the original purchase price. All payments were recorded in the general ledger to the notes payable short term account

The beginning cash balance at 1-1-15 for the cash budget should be the ending cash balance at 12-31-14

The company sold common stock in Aug 2014 for $190,500 (note recorded in 2014)

The company applied the Direct Write-off Method for bad debts. $30,610 was determined to be bad debt in 2014. (not recorded in general ledger)

Payment on 3 year Factory Equipment purchased on 07-13-14 not recorded in 2014. First payment due 8-13-14
Principal $869.38
Interest $712.50
Total $1581.88

Depreciation for the office building for 12-31-14 was $11,392 and not recorded. Depreciation over 39.5 yrs. Use straight line method

Depreciation for new warehouse was 39 yrs. Use straight line method

Unearned revenue of $4960 was earned in 2014

Interest expense of $6200 was paid in each quarter, 2014 was not recorded in the general ledger

Purchased Factory Equipment on 9-1-14 for $11,450 cash. $775 sales tax was included in purchase price. Depreciation 7 yrs. straight line

Sales commissions are applied at the rate 3% of gross sales & have been recorded throughout 2014 - $58,519.05

Dividends declared on Dec 31, 2014: Common $6250, preferred $7000 (not previously recorded)

Purchased factory eq. $29,250 (not including sales tax of $2047.50) on 7-13-14 on a 3 yr note. Depreciate 3 yrs ($4346.88). Not previously recorded. 1st payment due 8-13-14

An advertising invoice for Dec 2014 was not recorded nor paid. The amount of $4500 was paid in January, 2015. (use prepaid advertising)

Unexpired prepaid office insurance at 12-3-14 was $2650

Record all debts affecting CGS to CGS account

The factory water invoice of $4550 for Dec 2014 was not accrued into general ledger

Collections from customers are: 80% collected in quarter of sales & 20% collected in quarter following quarter of sales

Prepaid rent- Factory was amortized at 12-31-14 for full amount

Finished goods inventory, Jan 1, 2014 $177,808.71
Raw materials Inventory, Jan 1, 2014 $21,475
Work in process inventory, Jan 1, 2014 $16,290

Prepaid office supplies on hand Dec 31, 2014 was $764.50

Estimated Labor for 2015 is paid in quarter incurred

fixed & Administrative expenses paid in quarter incurred

Manufacturing overhead expenses paid in quarter incurred

Sales of preferred stock on 4-19-15, $260,500

Line of credit utilized to maintain $55,000 cash balance at the end of each quarter. 5.75% interest rate

Amortized 50% of prepaid advertising at 12-31-2014

Info for ratios:
Beginning A/R (Net) $160,500
Beginning Inventory 1-1-14 $190,500

Use straight line dep, do not consider bonus dep

Company sold preferred stock in September 2014 for $260,500 (not recorded in 2014)

To create an adjusted trial balance and journal entries based on the provided information, follow these steps:

1. Start by listing all the accounts and their respective balances from the general ledger. These balances will be derived from the trial balance. For example:

- Cash: $XX
- Accounts Receivable: $XX
- Inventory: $XX
- Prepaid Expenses: $XX
- Land: $XX
- Accounts Payable: $XX
- Notes Payable - Short Term: $XX
- Notes Payable - Long Term: $XX
- Unearned Revenue: $XX
- Common Stock: $XX
- Preferred Stock: $XX
- Retained Earnings: $XX
- Sales: $XX
- Cost of Goods Sold: $XX
- Advertising Expense: $XX
- Bank Charges: $XX
- Depreciation Expense - Office Building: $XX
- Depreciation Expense - Factory Warehouse: $XX
- Bad Debt Expense: $XX
- Sales Commissions Expense: $XX
- Dividends: $XX
- Interest Expense: $XX
- Rent Expense - Factory: $XX
- Rent Expense - Office: $XX
- Utilities Expense: $XX
- Manufacturing Overhead: $XX
- Amortized Prepaid Advertising: $XX
- Amortized Prepaid Rent - Factory: $XX
- Prepaid Office Insurance: $XX
- Prepaid Office Supplies: $XX
- Factory Equipment: $XX

2. Adjust the balances for any transactions that occurred during the year but were not recorded in the general ledger. Use journal entries to record these transactions. For example:

- Bank Charges (Bank Charge Expense): Comprise $932.70. Create a journal entry to record this expense, debiting Bank Charges and crediting Bank Charge Expense.
- Accounts Payable Partial Payment: 70% of the accounts payable balance at 12-31-14 was paid in the 1st quarter of 2015. Adjust the Accounts Payable balance accordingly by debiting Accounts Payable and crediting Cash.
- Factory Warehouse Purchase: Purchase a new factory warehouse on 1-1-14 for $3,475,500. Create a journal entry to record this asset acquisition, debiting Factory Warehouse and crediting Notes Payable - Long Term.
- Depreciation Expenses: Record the depreciation expenses for both the office building and the factory warehouse. Debit Depreciation Expense - Office Building and Factory Warehouse, and credit Accumulated Depreciation - Office Building and Factory Warehouse respectively.
- Unearned Revenue Earned: Unearned revenue of $4960 was earned in 2014. Adjust the Unearned Revenue balance by debiting Unearned Revenue and crediting Sales.
- Dividends Declared: Dividends of $6250 for common stock and $7000 for preferred stock were declared on Dec 31, 2014. Create a journal entry to record these dividends, debiting Retained Earnings and crediting Common Stock Dividends and Preferred Stock Dividends.
- Prepaid Advertising Amortization: Amortize 50% of the prepaid advertising at 12-31-2014. Adjust the Prepaid Advertising balance by debiting Amortized Prepaid Advertising and crediting Prepaid Advertising.
- Sales of Preferred Stock: Record the sales of preferred stock on 4-19-15 for $260,500. Create a journal entry to record the issuance of the stock, debiting Cash and crediting Preferred Stock.

3. After making the necessary adjustments using journal entries, update the balances in the general ledger.

4. Once all the adjustments have been incorporated, prepare an adjusted trial balance by listing the accounts and their adjusted balances.

5. Finally, review and verify the adjusted trial balance to ensure that total debits equal total credits.

By following these steps, you can create an adjusted trial balance and journal entries based on the provided information.