Download spreadsheet Ch$09$ P$10$ Build a Model$-3$f$6$b$7$f$.$xlsx

a$.$ What 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.$)$

Required line of credit $

thousand

Special dividends

$

thousand

b$.$ Now assume that the growth in sales is only $4\%.$ What are the forecasted levels of the line of credit and special dividends?

Required line of credit

$

thousand

Special dividends

$

thousand