aWhat are the forecasted levels of the line of credit and special dividends? $($Hints: Create a column showing the ratios for the current year; then create a new column showing the ratios used in the forecast. Also, create a preliminary forecast that doesn't include any new line of credit or special dividends. Identify the financing deficit or surplus in this preliminary forecast and then add a new column that shows the final forecast that includes any new line of credit or special dividend.$)1$Required line of credit $2$ Special dividendsNow assume that the growth in sales is only $4\%.$ What are the forecasted levels of the line of credit and special dividends?$1$Required line of credit $2$ Special dividends