In: Accounting
1) Use the following information to prepare adjusting entries for Gilbert Holdings
2) Then make an adjusted trial balance, income statement & balance sheet for the information
a. On April 1, 2019, Gilbert Holdings signed a 4.30% bank loan due in 4 years. This is the only outstanding note payable.
b. Prepaid insurance represents a 4-month insurance policy purchased on December 1.
c. On Oct 1, 2019, Gilbert Holdings paid $11,880 for a 9-month lease for office space.
d. Unearned revenue represents a 12-month contract for consulting services. The payment was received on July 1, 2019.
e. Supplies on hand total $10,480.
f. Equipment is depreciated on a straight-line basis; residual value is estimated to be $15,000 with an estimated service life of 10 years. The assets were held the entire year.
g. On Nov 1, Gilbert Holdings issued Monroe Supplies an 3-month note receivable at a 8.2% annual interest rate.
h. The company uses the percentage-of-receivables basis for estimating uncollectible accounts. The aging schedule of accounts receivable must be completed to determine management's desired balance for 2019.
i. Accrued wages totaling $35,838 were unpaid and unrecorded at December 31, 2019.
j. Utility costs incurred but unrecorded for the month of December were estimated to be $2,561.
DR | CR | |
Cash | 67,188 | |
Accounts Receivable | 265,584 | |
Allowance for Doubtful Accounts | 11,194 | |
Interest Receivable | ||
Note Receivable | 113,180 | |
Merchandise Inventory | 194,172 | |
Prepaid Insurance | 7,128 | |
Prepaid Rent | 11,880 | |
Supplies | 30,096 | |
Equipment | 277,464 | |
Accumulated Depreciation - Equipment | 29,304 | |
Accounts Payable | 27,746 | |
Salaries & Wages Payable | ||
Unearned Revenue | 32,000 | |
Interest Payable | ||
Utilities Payable | ||
Note Payable (final payment due 2023) | 188,100 | |
Common Stock | 145,200 | |
Retained Earnings | 224,400 | |
Dividends | 64,680 | |
Sales | 2,773,980 | |
Consulting Revenue | ||
Sales Returns and Allowances | 15,840 | |
Sales Discounts | 34,056 | |
Cost of Goods Sold | 1,888,788 | |
Salaries & Wages Expense | 430,056 | |
Depreciation Expense - Equipment | ||
Bad Debt Expense | ||
Insurance Expense | ||
Rent Expense | ||
Supplies Expense | ||
Utilities Expense | 31,812 | |
Interest Revenue | ||
Interest Expense | ||
3,431,924 | 3,431,924 |
Age of Accounts | Balance December 31, 2019 | Estimated % Uncollectible | Estimated Amount Uncollectible |
Current | 159,350 | 2% | 3,187.01 |
1–30 days past due | 66,396 | 4% | 2,655.84 |
31–90 days past due | 31,870 | 20% | 6,374.02 |
Over 90 days past due | 7,968 | 37% | 2,947.98 |
Total Accounts Receivable | $ 265,584 | 15,165 |