Microsoft Excel can calculate a bank's capital-to-risk weighted assets ratio if you know the tier 1 and tier 2 capital and risk-weighted assets.