Using the actuals and budget to create a forecast

Hi There

I was wanting to create a report in Netsuite which shows the following:

For the months that have elapsed, the actual figures are shown and for out months (future months) the budget figures are shown.

The report layout will look like the following:

The year projected figure (highlighted yellow in the above screencap) will be calculated as the sum of all of the ytd actuals + the sum of the monthly budgets for the future months.

Is this something that can be done in Netsuite?

So far, I have looked into customising existing financial reports as well as analytics workbooks though it doesn't appear to be an option with either of these.