How can I consolidate Exl-Plan projections for several subsidiary companies?
Two solutions are offered. First, if you need consolidated projections for just one year (12 months), you should consider acquiring a related product, Cashflow Plan Super or Ultra, which contains a comprehensive tool for consolidating projections (i.e. cash flow and income statements plus forecast balance sheets) for subsidiary businesses using a special Report for Consolidation. This report is linked to an additional workbook (Cashflow Plan Consolidator) which facilitates the consolidation process and includes tools for changing currencies/ denominations and eliminating inter-company transactions. A Cashflow Plan Consolidator Guide is included in the download files for Cashflow Plan Super and Ultra.