Digger Company's financial worksheet in OpenOffice Calc with a calculator overlay.

The image shows a worksheet for Digger Company as of June 30, 2013, with sections for the Trial Balance, Adjustments, Adjusted Trial Balance, Income Statement, and Balance Sheet. The goal is to complete this accounting worksheet by filling in the missing values based on the adjustments.

Let’s walk through the steps to solve the problem.

---

Step 1: Understand the Adjustments

From the Adjustments column (D and E), we can see the following:

| Account | Debit (Dr.) | Credit (Cr.) |
|--------|-------------|--------------|
| Prepaid Insurance | | 1,000 |
| Accum. Dep. - Equip. | | 400 |
| Supplies | | 250 |
| Insurance Expense | 1,000 | |
| Depreciation Expense | 400 | |
| Supplies Expense | 250 | |
| Wages Payable | | 220 |
| Wages Expense | 220 | |

These are adjusting entries:
- Prepaid Insurance: $1,000 expired → expense recognized.
- Accumulated Depreciation: $400 depreciation recorded.
- Supplies: $250 used → supplies expense.
- Wages Payable: $220 accrued wages not yet paid.

---

Step 2: Compute Adjusted Trial Balance

We will add the adjustments to the Trial Balance amounts.

#### Cash
- Trial Balance: $87,560
- No adjustment → $87,560

#### Prepaid Insurance
- Trial Balance: $11,000
- Adjustment: Cr. $1,000 → $11,000 - $1,000 = $10,000

#### Equipment
- Trial Balance: $5,000
- No adjustment → $5,000

#### Accum. Dep. - Equip.
- Trial Balance: $400 (Cr.)
- Adjustment: Cr. $400 → $400 + $400 = $800 (Cr.)

#### Supplies
- Trial Balance: $450 (Dr.)
- Adjustment: Cr. $250 → $450 - $250 = $200 (Dr.)

#### Accounts Payable
- Trial Balance: $0
- No adjustment → $0

#### Capital
- Trial Balance: $105,020
- No adjustment → $105,020

#### Wages Expense
- Trial Balance: $840
- Adjustment: Dr. $220 → $840 + $220 = $1,060

#### Rent Expense
- Trial Balance: $570
- No adjustment → $570

#### Insurance Expense
- Trial Balance: $0
- Adjustment: Dr. $1,000 → $1,000

#### Depreciation Expense
- Trial Balance: $0
- Adjustment: Dr. $400 → $400

#### Supplies Expense
- Trial Balance: $0
- Adjustment: Dr. $250 → $250

#### Wages Payable
- Trial Balance: $0
- Adjustment: Cr. $220 → $220

Now fill in the Adjusted Trial Balance column (G and H):

| Account | Dr. | Cr. |
|--------|-----|-----|
| Cash | 87,560 | |
| Prepaid Insurance | 10,000 | |
| Equipment | 5,000 | |
| Accum. Dep. - Equip. | | 800 |
| Supplies | 200 | |
| Accounts Payable | | |
| Capital | | 105,020 |
| Wages Expense | 1,060 | |
| Rent Expense | 570 | |
| Insurance Expense | 1,000 | |
| Depreciation Expense | 400 | |
| Supplies Expense | 250 | |
| Wages Payable | | 220 |
| Total | 105,420 | 105,420 ✔ |

✔ Total debits = Total credits = $105,420

---

Step 3: Prepare Income Statement

Only revenue and expenses go here.

From Adjusted Trial Balance:

- Revenue: Not shown → assume zero (no revenue account listed)
- Expenses:
- Wages Expense: $1,060
- Rent Expense: $570
- Insurance Expense: $1,000
- Depreciation Expense: $400
- Supplies Expense: $250

Total Expenses = 1,060 + 570 + 1,000 + 400 + 250 = $3,280

So, Net Loss = $3,280 (since no revenue)

→ Fill in Income Statement:
- Dr. (Expenses): $3,280
- Cr. (Net Loss): $3,280

---

Step 4: Prepare Balance Sheet

Assets, Liabilities, and Equity.

#### Assets:
- Cash: $87,560
- Prepaid Insurance: $10,000
- Equipment: $5,000
- Less: Accum. Dep. - Equip.: $800
- Supplies: $200

Total Assets = 87,560 + 10,000 + 5,000 - 800 + 200 = $101,960

#### Liabilities:
- Accounts Payable: $0
- Wages Payable: $220

Total Liabilities = $220

#### Equity:
- Capital: $105,020
- Less: Net Loss: $3,280

Ending Capital = 105,020 - 3,280 = $101,740

Check: Assets ($101,960) = Liabilities ($220) + Equity ($101,740) → $101,960 = $101,960 ✔

---

Final Answer Summary

#### Adjusted Trial Balance:
- Cash: $87,560
- Prepaid Insurance: $10,000
- Equipment: $5,000
- Accum. Dep. - Equip.: $800
- Supplies: $200
- Wages Expense: $1,060
- Rent Expense: $570
- Insurance Expense: $1,000
- Depreciation Expense: $400
- Supplies Expense: $250
- Wages Payable: $220
- Capital: $105,020

#### Income Statement:
- Total Expenses: $3,280
- Net Loss: $3,280

#### Balance Sheet:
- Total Assets: $101,960
- Total Liabilities: $220
- Equity: $101,740

---

Key Takeaway:

The calculator showing 200 likely refers to the adjusted supplies balance ($450 - $250 = $200), which matches the highlighted cell.

✔ All adjustments are properly reflected, and the worksheet balances correctly.

Let me know if you want me to help format this into the spreadsheet!