Dear Ken Kindly explain how the q2 forecast figures (based on q1 actual) come fr pls? I cant figure out basic to cal for this table rolling budget. Q3,q4, then q1. Tks alot Ken
Actual qtr 1 = 17932 and this is expected to grow at 3% (we are told that right at the end of the question), so based on actual qtr 1, qtr 2 should be 1.03 x 17932 = 18,470. Qtr 2 = 18,470 x 1.03 etc.