analysis on changing interest rates for cd accounts

[annetteinmd]

planning to increase cd rates offered to customers, will assume that a
certain percentage of customers will close out accounts that pay lower
interest to open one with better rates and yields. How do I determine the
total cost of the rate movement (increase) to the company? How do I
determine the balance requirements for the higher rate account to make money?

 

[Echo S]

Ummm, you're asking for business financial formulas -- I don't think you're
going to find that in a template on microsoft.com. I'm sure there's some
kind of break-even analysis or some such out there, though. Maybe check
with your local small business administration if you need this kind of help.