Category Archives: 4 Reporting

Calculating Fixed Assets Turnover Ratio in Excel

Fixed assets turnover ratio shows how efficiently a company uses its fixed assets to generate revenue. To calculate fixed assets turnover ratio open your income statement and balance sheet. Divide revenue from income statement with property, plant and equipment plus intangible assets from the balance sheet

Continue reading

Calculating Fixed Assets to Net Worth Ratio in Excel

Fixed assets to net worth ratio indicates the extent to which the owners’ cash is frozen in the form of fixed assets and the extent to which funds are available for the company’s operations. To calculate fixed assets to net worth ratio open your balance sheet and divide property, plant and equipment with total equity.

Continue reading