$1.$ Prepare a preliminary forecast for $2022$ without special dividends or line or credit

$2.$ Prepare final forecast for $2022$ with special dividends or line or credit

show answers are done in excel with formulas, please. $\backslash$table$[[$Interest expense on long$-$term debt,$$11,880],[$Interest expense on$\_$line of credit,$$0],[$ERT$,$$$78,120],[$Taxes $(25\%),$$$19,530],[$Net Income,$$58,590],[,],[$Common dividends $($regular dividends$),$$$12,554],[$Special dividends,$$0],[$Addition to retained earnings,$$46,036],[,],[,],[,],[,],[$Balance Sheets,$2023],[($December $31,$ in thousands of dollars$),],[,],[,],[$Assets:$,],[$Cash$,$$$20,000],[$Accounts Receivable,$$80,000],[$Inventories$,$$$75,000],[$Total current assets,$$175,000],[$Fixed assets,$$220,000],[$Total assets,$$395,000],[,],[$Liabilities and equity,$],[$Accounts payable,$$20,000],[$Accruals$,$$$30,000],[$Line of credit,$$0],[$Total current liabilities,$$50,000],[$Long$-$term debt,$$120,000],[$Total liabilities,$$170,000],[$Common stock,$$160,000],[$Retained Earnings,$$56,036],[$Total common equity,$$216,036],[$Total liabilities and equity,$$386,036],[,]]$