Im using Exl-Plan Pro, Super or Super Plus and cannot generate projections for the fourth & fifth years?
If you have entered assumptions for all five years, Pro, Super and Super Plus will display the fourth-fifth year projections provided annual sales are projected to increase/decrease for the fourth-fifth years. By design, they assume that no projections are being made for the fourth-fifth years if there are no changes in sales for these years. If projections are required and there are no planned changes in sales, the work around is to enter very small values (e.g. 0.0001) as the annual increases on the 45_A worksheet. Similar rules apply to the Ultra and Ultra Plus versions for sixth/seven years.