Please help I do no know why my formulas are not giving me the right answers

Excel Activity: Forecasting Financial Statements Start with the partial model in the file Ch09 P10 Build Model.xlsx, which contains the 2021 financial statements of Zieber Corporation. Forecast Zieber's 2022 income statement and balance sheets. Use the following assumptions: (1) Sales grow by 7%. (2) The ratios of expenses to sales, depreciation to fixed assets, cash to sales, accounts receivable to sales, inventories to sales, 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 long-term bonds. (4) The interest rate is 11% for long-term debt, and the interest expense on long-term debt is based on the average balance during the year. (5) No interest is earned on cash. (6) Regular dividends grow at a 10% rate. (7) The tax rate is 25%. Calculate the additional funds needed (AFN). If new financing is required, assume it will be raised by drawing on a line of credit with an interest rate of 12%. Assume that any draw on the line of credit will be made on the last day of the year, so there will be no additional interest expense for the new line of credit. If surplus funds are available, pay a special dividend. The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations. Enter your answers in thousands. For example, an answer of $1.23 thousand should be entered as 1.23, not 1,230. Round your answers to two decimal places. If your answer is zero, enter "O". Download spreadsheet Ch09 P10 Build a Model-d97d4f.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 Special dividends 1.39 thousand o 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? 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 1.39 thousand Special dividends 0 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 4.53 thousand Check My Work Reset Problem 1. Balance Sheets 2021 Historical rarias Forecasting bask 2022 Input ratias 2021 Historical radas Forecasting basis 2022 Preliminary forecast doesn't include special dividend or LOC) 2021 2022 Final forecast (includes special didend or LOC 20zz Input racias 2021 Aaseda *55 55 So sada o' 2022 Preliminary forecast doesn't 2022 Final forecast include special includes special dividend or LOC) dividend or LOCI $20.372.00 $20,972.00 $100,957 29 CE 567.20 345 ABR 80 $173,159.99 183,541.60' 169.541.60 5255719.49 S2EE,710.40 21.08 Soisas of sacs of a =10 =C20 -021 90% S19040.00 40% 99 sco.co 24.0% 42 84000 5161 840.00 180 88000 28.08 S342 720.00 Accounts receivable Inven Total current assets FilE sila Total assets $19.040.00-010142 99.960.00 =B201842 42 84000 -R21/542 180 390.00 =B22842 880 = 5342 720.00 $17.NO -C1B =E20'S $42 -F21'S542 -SUMIF 19.-21) =E235542 ESUMIF 22 =22 -F19 =F20 -F21 =F23 =SUMIG22:22) W:621) 28.08 =023 7.09 OZT Soses so' ZAD in preliminary forces 7.08 BOX of sacs , - Zero in preliminary for Linculties and Accounts payable ACH Lire of credi Telur Long term debt Teid isbites Common los Ficta ned ning Tolony Tollabilities and uly 533 320.00 28 58000 0.00 55188800 110.000.00 S171.880.00 50,000.00 120 840.00 S170 840 00 5342 720.00 $35,552.49 30 55A 23" 30 SAA 2103 110.00000" 3178.2163 50,000.00 Carry over from previous year Carry over from previous year Previous FE + Add to RE $26,662.40 90 SSS 20 1,397.43 SE7 SAR 110,000.00 $ 177.506.03 50.000,00 125.110.27 $185, 71197 S9EE 710.40 533 320.00 =B271842 2856000 - 20342 0.00 581 2000 110.000.00 5171 880.00 50.000.00 120 840.00 S170 84000 $342 720.00 Carry ove from previous year Carry over from previous year Previous FE + Add to RE =E27S 342 -F2 =512 -B28 -SUMF27 729 -331 =SUMIF30-F31) -D33 =B34+F64 + -SUMF 33 794) =F32 F35 =F27 -F28 =F06 -SUMIG27 (20) -F31 SUWG30.091) -r33 =B34+004 -SUMGS334) =C321ags 193.1111 31A4 111 37 529522207 2. Income Streets F 2022 Preliminary forecast doesn't 2022 Final forecast inchide special includes special dividend or LOC) dividend or LOCI 350A 329 $5CS 920 00 432,922.00 432,622.00 13,547 91 19547.91 $82,860.00 312,133 09 12,100.00 0.00 $50.750.09 " $60,760.00 12,937.52" 12,687.52 $38,052.57 $18, CE2.67 319,79120 $19,79120 $ 0.00 $18,271.5" $118,271.37 $ 2022 Preliminary forecast doesn't 2022 Final forecast include special (includes special dividend or LOC)didend or LOC) ) -B4241+421 -F42 -E43=42 F43 -E44E23 -F44 -F42-43-444 -342-043-044 -B5"AVERAGEB31,F:-F46 -R47 -F47 -F45-F48-547 -G45-646-647 =F48'RT =O43'e =F48.40 =G43.649 $82.53 09 2021 Historical Forecasting 2022 Input 2021 ratios basis ratios $478.000.00 Growth 404 600.00 =B431542 of sacs-043 12 681 60 -B44623 Xalicu $68.738.40 10 78000 Interest wax Average debt curing year 000 347.968.40 119.60 535 968 80 ' F 9.00 S17 99200 000 $ Growth =84 Zero in preliminary forca 17.976.80 =B52'1+E52) -D58 =F30-- =F52 - 67 =G50-662-003 6253 2021 Historical Forecasting 2022 Input 2021 ratios basis radios Se $478.000.00 Grat 70% Expensos icxcluding dox & amor 404.000.00 26.0% osas 26.0% C precision marition 12 68160 7.05 Xarice 7.0% $68.738.40 nire exome on long-term der 10 780.00 Interest ex Averse debt during year In THX online al will 000 S47.868.40 Taxe 1254.1 11 08960 Not income $35.968.80 Feguler common didenda S17 902.00 Greath 10.ON Secis dicends 0.00 Zero in preliminary forecas: Addition to retained ear" S17.976.80 3. Elimination of the Financial Deficit or Surplus Increase in spontaneous abilincs (ccounts payable and actress + Increase in long-term benda and commenstock + Net income in preliminary fortal min. regular common dividends -Promousine of credit In infirming Increase in total 59 Amount af andre declaraula defct in Mancing negative cree on Ine of credit f surplus infinseng Iposta apecial civided Daterining the forecasted levels of the line of credit and special dividends Formulas Salee grooth rele Line of credit Special dividend nt (B31 S138743 SO.CO IE 44 $4,331.80 0.00 10,271.37 3.02 322,427 23.943 -31,387.43 -1F27-F20B27-3281 =1F31+F33631+533 -F30-F52 =B23 -SUMF58 FAN-91 - +24 24 =F62-F63 31.38743 * 30.00 =IFF640,- 54.0 -IFF8408 Line of credit $1,33743 JANA Special divided SC.00 IA Sheet1 + H Formulex 1. Asante Sheets 2022 Preliminary forecast doesn't 2022 Final Forecast Include special Includes special 2022 Input ratios diviend or LOCI dividend or LOC) 2022 Freilminary forecast doesnt Include special dodend or LOC) 2021 Historical ratios Forecasting beslis 2001 2:22 Final forest Includes special dMdend or LOCI 2021 Historical rados 2021 Forecasting basis 2022 Inpur ratios JAMAT Cash ACCOLIS rceva Inventors Totalcmentis Fbeasts Totsiens $17.674.00 N 87 870.00 EN 29 641.60 EN 8144956.00 175 740.00 N SOM assic . Sofa 517.07-09 87.870 09 29.641. GB $144.986 69 175.740 09 5:23 T355 EN S of sales of als of Sal NA of sales of sales Zac in prehryforecast Zero in pray foreca 525,38109 21,9769 000 ) 348.828.50 12.02003 11688281 3,000 0 92.327.02 1182.32702 $320.72660 Carry corrompressor Icoalities and ty Decent ble Accruals Le ofreck L Total current abilis Long-term dab: : Teilles Coronateck Rutine amnes Tod_ky Totalists and quite 2. Mom Sawwal $25 a con 21957.60 NA 0.00 $48228.40 120 000.00 $168 828.60 ED 00.00 92 997.00 $162 997.00 $320 7200 Carry Darton presies you a 4 ANA NA ANA 14 11 11 NA Curry over fru U. Nr Prvo. READ. I RE Carry Dario preska you Free Ride. E 2021 Hilul m 2022 ruhninery forwawal durant 22nul rece Porcing indu piel re:H xx 2022 Ingut mulin dividend or LGCL didendur LDC) Cach 2021 $499 SUU 373.4475 4* 2022 Piruller inclus dinder LOGI 414A ANA NA ANA See oled HEX 2022 Primity Ierown 2021 Hour Premalny include 2021 Ilus Les 20022 Inpui rebus inundur LOGI :43 1M CJ ANA 323447 WA 2. ANA 14 10 MAN NA $14110 11 400.00 Iniprestrel Awwape cu ngar 0.00 EN 510 443 20 SVIR 10.10.22 EN 530 17:40 HTT4 T5 | HG: LEEF tsu". . HIEErl | Depen - Man EHT Iriores capers on Instandub Ill capers online of creat EST Tas 12 NN in Interest ratesveroce dobt during you SSLHS 11,40003 003 540.43.39 10.11003 $13.417 41 WA $16.174.00 0.00 516 18.48 BN SNN EN Zero In pre may forecast Rog.lar common donds 3517403 Growth Specialidad 003 Zoro in pronar forecast Add on to the carriegs 315.168.43 3. Embarton of the Financial Denar or Surplus Increman poiando. Tables (accounts payable and accruals + increase in long-term bands and common stock + Net Income in preliminary forcestnins regular corinon didends - Previous Ing of credit Ircross nhancina - Therese in a wa Amount of frending or surplus delictinanong nine of credit sublin francia auch der b. Determining the forcested levels of the line of arcdit and special dMdends Formula Selmayrowe credit Selwynwch Line ofercdit Scolai cilvidend 5003 300 34% Line of one di special divend