i have two financial modeling problems that i would like some support for.here i

i have two financial modeling problems that i would like some support for.here is the files

and for 9-10
Income Statements: 2021
(December 31, in thousands of dollars)

Sales $455,150
Expenses (excluding depr. & amort.) $386,878
Depreciation and Amortization $14,565
EBIT $53,708
Interest expense on long-term debt $11,880
Interest expense on line of credit $0
EBT $41,828
Taxes (25%) $10,457
Net Income $25,097

Common dividends (regular dividends) $12,554
Special dividends
Addition to retained earnings $12,543

Balance Sheets 2021
(December 31, in thousands of dollars)

Assets:
Cash $18,206
Accounts Receivable $100,133
Inventories $45,515
Total current assets $163,854
Fixed assets $364,120
Total assets $527,974

Liabilities and equity
Accounts payable $31,861
Accruals $27,309
Line of credit $0
Total current liabilities $59,170
Long-term debt $120,000
Total liabilities $179,170
Common stock $60,000
Retained Earnings $106,745
Total common equity $166,745
Total liabilities and equity $345,914

Requirements: answers only but using cell reference