This excel file has 6 tabs for the 3 projected years, projected collection, factoring activities & loan / remittances. the 1st 3 worksheets has the account names on the first column, then followed by the 12 months of the year, January to December. The numbers on relates to the number on the other financial statements namely the income statement and the balance sheet statements. Rates and other assumptions can be changed to suit your situation. Fully customizable in Ms Excel format.
3-year Projected Cash Flows
Excel file has 6 tabs for the 3 projected years