Even though interest rates are usually quoted on an annual basis, they are typically calculated over shorter periods, either monthly or daily. This is known as the periodic rate. If you know the annual rate and the length of each period, the periodic rate is easy to calculate. One tool that can be used for this is Microsoft Excel, a spreadsheet program from Microsoft which is available as a single application or as part of the Microsoft Office suite of applications. Writer Bio

How to Calculate Periodic Rates in Excel - 63