You can calculate Ratio in Excel by using the GCD function and the Substitute function. This article is a step-by-step guide to help you.

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.

The LTV ratio is used by lenders before approving a mortgage to a potential borrower. You can use Microsoft Excel to calculate the loan-to-value ratio if you have the mortgage amount and appraised ...