FinanceTier 818 minadvanced

Running Cash Position

Track a running cash balance across several days of movements, starting from the real opening balance.

What you will learn

• Use SCAN with LAMBDA to build a running total from a genuine starting value
• Explain why starting a running total from zero instead of the opening balance offsets every figure
• Read a specific day's balance out of a running-total array with INDEX

Excel skills

SCAN, LAMBDA, INDEX · Running Calculations

The task

An account has an opening balance and a list of daily net movements. Work out the balance after day 5, in Summary!B4 - starting the running total from the real opening balance, not from zero.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free