Retention ratio: How do you calculate it in excel?

The average retention ratio ranges from 20% to 25%, but it can vary based on the industry that you're in. It's calculated by dividing retained earnings by the total net income. You can find plenty of excel templates and an expanded version of the formula online.