The attached Excel spreadsheet provides a template fo a Cash Flow analysis. I have provided the full sheet for your possible future use. In this discussion I have placed sample data in selected cells (highlighted in blue) for the first month. Two options.
1. Complete the spreadsheet for the year by estimating the cash amounts for the highlighted rows. Note that the spreadsheet automatically calculates totals so you do not have to remove rows. After estimating the rows create a proforma statement for the following year ( only need a single yearly estimate ). Provide a summary paragraph providing your rationale for your estimates ( for both the cash in and out.
