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. The capital-to-risk weighted ...