How do I produce monthly projections extending beyond one year?
If you need monthly projections for two or three years, you should consider upgrading to Exl-Plan Ultra or Ultra Plus which create monthly projections for three years, quarterly projections for the following two years and,optional, annual projections for a further two years. Alternatively, you can use any other version of Exl-Plan to generate two-year monthly projections by creating the first-year projections using one Exl-Plan file and using a second file to handle the second-year and subsequent year projections. You will need to either file link or directly insert the first-year’s P&L and closing balance sheet data from the first file into the second file.