Annual P&L & Cashflow Model

I have a detailed case-study with all the underlying revenue, cost and funding assumptions, and I need it turned into a fully linked Excel workbook. Your task is to build an annual profit-and-loss statement and a matching cash-flow schedule that draw every figure from the source assumptions, so I can change any input later and watch the numbers update automatically.

The profit-and-loss must cover one complete fiscal year, moving cleanly from revenue through to net profit. The cash-flow should start with that net profit, adjust for non-cash items and working-capital swings, then lay out any investing or financing movements to arrive at the closing cash balance. Clear, self-explanatory formulas are essential—no hard-coded totals, please.

Deliverables
• One unlocked Excel file with separate tabs for assumptions, annual P&L, and cash-flow
• Consistent formatting, readable labels, and error-free cross-checks between the two statements
• A short note inside the file outlining the logic behind each section

I’ll send the case-study document as soon as we agree to proceed. Accuracy and transparency are critical, so let me know if you have any questions before you begin.