Business Analysis with Microsoft® Excel, Second Edition

Getting a Current Asset Cash Balance

In the balance sheet shown in Figure 2.1, the Cash classification of Current Assets section contains this formula:

=NovemberEndCashBalance+SUM(DecemberCashDebits)–SUM(DecemberCashCredits)

The names in this formula refer to ranges in the cash worksheet shown in Figure 2.2.

In the worksheet shown in Figure 2.2, there are three named ranges:

• NovemberEndCashBalance refers to cell E3. This amount is the closing cash balance at the end of November, the prior month.

• DecemberCashDebits refers to cells C4:C24. This range contains all the deposits to Bell Books' corporate checking account that were made during December.

• DecemberCashCredits refers to cells D4:D24. This range contains all the withdrawals from Bell Books' ...