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.

Liquidity ratios are important financial metrics that can determine whether a company can pay off its short-term debts without having to raise more capital ... to calculate it using Excel.