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