O'Reilly logo

Business Analysis with Microsoft® Excel, Second Edition by Conrad Carlberg

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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' ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required