Hello, I am looking for guidance with how to go about calculating some values located within a consolidation entries worksheet such as the value of dividends paid to non-controlling shareholders.

I have quite a bit of data to work with including;

Cash, accounts receivable, inventory, land, building & equipment, less: accumulated depreciation, patents, just to name a few of the details I have to work with among others such as liabilities and a fair share of cash flows.