Cash Flow Excel Template

I need a reusable Excel file that builds a complete cash-flow statement from basic entries such as beginning cash, operating, investing, and financing activities. Once the figures are keyed in, the workbook should automatically total each section, reconcile ending cash, and alert me through clear conditional formatting whenever a subtotal is negative or an amount is missing.

Please structure the sheet so formulas stay intact when rows are inserted or deleted, and protect the calculation cells while keeping input cells unlocked. Label everything cleanly, add a quick instruction tab, and keep the layout printer-friendly on A4.

Deliverables
• .xlsx template with built-in formulas and conditional formatting rules
• Brief notes explaining the logic and any named ranges

I will test the file by dropping in last quarter’s data; if the ending cash ties out and red flags appear only where expected, the job is complete.