Inserting Missing Data into a Worksheet

question 119

Essay

Inserting missing data into a worksheet
Certain data are given on the worksheet below, and certain missing data are indicated by the blank lines. Sufficient information is included to fill in the missing data. Each account has a debit or credit balance characteristically normal for that kind of account. Note that the dollar amounts have been reduced to figures of not more than three digits to simplify the arithmetic. Insert the figures necessary to complete the worksheet in the blanks indicated by an underline. The lines cover both debit and credit columns; be sure to insert the missing figures in the correct column of the blank line. If no figure should appear in a column within a line, indicate this by placing a "0" in one or more columns with a blank line (see sample box opposite Cash).

---

Definitions:

Cash Budget

A forecast of cash inflows and outflows over a specific period, used to estimate a company's short-term liquidity needs.

Cash Balance

Cash balance refers to the amount of cash that a company or an individual has available at any given time.

Cash Payments

Cash payments refer to transactions where cash is used to settle the payment for goods, services, or obligations.

Cash Budget

An estimation of cash inflows and outflows for a business over a specific period, used for managing liquidity.