You can calculate a bank's capital to risk-weighted assets ratio in Microsoft Excel once you determine its tier 1 and tier 2 capital and its risk-weighted assets. First, let's define our variables.

How to calculate debt-to-equity ratio in Excel Using a balance sheet template in Excel is an easy way to calculate a company's debt-to-equity ratio automatically. To calculate the D/E ratio ...