Excel Forecast sheet: Forecasting the 2021 Pag-IBIG 2 Dividend Rate

 

If you have historical time-based data, Excel Forecast Sheet can help you create a forecast by creating a new worksheet that contains both a table of the historical and predicted values and a chart that expresses this data. A forecast can help data analysts predict things like future sales, inventory requirements, or consumer trends.

Forecast Sheet can be found in Excel for Microsoft 365, Excel 2021, Excel 2019, and Excel 2016. 

Let us have the Pag-IBIG 2 Dividends as an example. The Modified Pag-IBIG II (Pag-IBIG MP2) Savings Program is a special and voluntary savings facility with a 5-year maturity, designed for active Pag-IBIG Fund members who wish to save more and earn even higher dividends, in addition to their Pag-IBIG Regular Savings. Every March, Pag-BIG Fund announces the dividend rate earned by members, and in 2020 it was 6.12%.

Our goal is to forecast the 2021 Pag-IBIG 2 Dividend Rate,

1. Select the range of cells containing the target data.

2. From the ribbon, go to Data > Forecast > Forecast Sheet.

3. Select the chart and in the Chart Elements include Data Labels.

4. The forecast shows the Pag-IBIG 2, 2021 Dividend Rate is 6.3% with lower confidence of 4.61% and upper confidence of 8%.

Let us see in March 2021, if the Pag-IBIG 2 dividend rate will range between 4.61% and 8% and whether 6.3% is fairly accurate.