Start wth the partial model in the file chos P10 Build a Model.xisx, which contains the 2021 finuncal sfatements of Zieber Corporation. Forecast Zieher's 202z income statement and balance shects. Uie the following assumptions: (1) Sales giow by 7\%. (2) The ratios of expenses to sales, depreciation to fixed assets, cash to iles, accounts receivable to salies, inventories to saies, fixed assets to sales, accounts payable to sales, and accruals to sales will be the same in 2022 as in 2021 . (3) Zieber will not issue any new stock or new iong-term bonds. (4) moe interest fate is 12% for long-term debt, and the interest expense on long-term debt is bosed on the average balance during the year. (5) No interest is earned on cash. (6) Regular alvisends grow at an 8% rate. (7) The tax rate is 25%. Caloulate the additional funds neesed (AFN). It aew finanoing is required, assume it will be ralsed by drawing on a line of crede with an interest rate of I3W. Assume that any draw on the ine of credit will be made on the last day of the vear, to there will be no additional interest expense for the new line of credit, If surplus tunds are avalable, pay a special dividend. The data has been coliected in the Microseft Excel file below. Donalowd the spreadiheet and perform the required analysis to anwwer the questions below. Do not round intermediate caloulations. Enter your answers in thousands. For example, an answer of $1.23 thousand thould be entered as 1.23, not 1,230. Apund your answers to two decimal places. If your answer is zero, enter "o: X Dewnioad soreadsheet Chog p10 sula a Model-5c5ds visx a. What are the forecasted levels of the ine of credit and specil dividends? (hints: Create a column showing the ratios for the current yean, then create a new columin shoning the ratios wted in the forecast. Aso, creste a preliminary forecast that doeset include any new line of credit or special dividends: Ideotify the financing defiot or surplus in this preliminary forecast and then add a new column that shows the final forecast that inctudes any new tine of credit or special dividend.) Pequired line of credat $5 Special dividends b. Now assume that the growth in sales is only 4%. What are the forecasted levels of the line of ardt and special dividends? Hequired line of credt thousand Start wth the partial model in the file chos P10 Build a Model.xisx, which contains the 2021 finuncal sfatements of Zieber Corporation. Forecast Zieher's 202z income statement and balance shects. Uie the following assumptions: (1) Sales giow by 7\%. (2) The ratios of expenses to sales, depreciation to fixed assets, cash to iles, accounts receivable to salies, inventories to saies, fixed assets to sales, accounts payable to sales, and accruals to sales will be the same in 2022 as in 2021 . (3) Zieber will not issue any new stock or new iong-term bonds. (4) moe interest fate is 12% for long-term debt, and the interest expense on long-term debt is bosed on the average balance during the year. (5) No interest is earned on cash. (6) Regular alvisends grow at an 8% rate. (7) The tax rate is 25%. Caloulate the additional funds neesed (AFN). It aew finanoing is required, assume it will be ralsed by drawing on a line of crede with an interest rate of I3W. Assume that any draw on the ine of credit will be made on the last day of the vear, to there will be no additional interest expense for the new line of credit, If surplus tunds are avalable, pay a special dividend. The data has been coliected in the Microseft Excel file below. Donalowd the spreadiheet and perform the required analysis to anwwer the questions below. Do not round intermediate caloulations. Enter your answers in thousands. For example, an answer of $1.23 thousand thould be entered as 1.23, not 1,230. Apund your answers to two decimal places. If your answer is zero, enter "o: X Dewnioad soreadsheet Chog p10 sula a Model-5c5ds visx a. What are the forecasted levels of the ine of credit and specil dividends? (hints: Create a column showing the ratios for the current yean, then create a new columin shoning the ratios wted in the forecast. Aso, creste a preliminary forecast that doeset include any new line of credit or special dividends: Ideotify the financing defiot or surplus in this preliminary forecast and then add a new column that shows the final forecast that inctudes any new tine of credit or special dividend.) Pequired line of credat $5 Special dividends b. Now assume that the growth in sales is only 4%. What are the forecasted levels of the line of ardt and special dividends? Hequired line of credt thousand