Total assets are calculated by adding the values of all current and non-current assets on a company’s balance sheet. Assets are categorized into two broad types: current and non-current.
First, input your current assets and current liabilities into adjacent cells, say B3 and B4. In cell B5, input the formula "=B3/B4" to divide your assets by your liabilities, and the calculation ...
The formula for working capital is: Working Capital = Current Assets - Current Liabilities Current assets are those that a company reasonably expects to convert into cash within one year.