Learn how to calculate the Simple Interest in Excel either for a single entry or a range or entries, between two dates, using this forumula.

We show you how to calculate compound interest in Excel at different rate of interests, like semi-annually, quarterly, monthly, etc.

Calculate the weighted average of interest rates in Microsoft Excel to compute the most accurate average interest rate among a group of lenders who received different rates.

Excel 2013 provides the DATE and XIRR functions, which derive the final annual interest rate from a series of payments on known dates.

Learn how to calculate the internal rate of return (IRR) in Excel and how it’s used to determine whether a capital investment can be profitable.

How to Excel at calculating the Internal Rate of Return A blonde wanting to earn some money decided to hire herself out as a handyman-type and started canvassing a wealthy neighbourhood.

Doing the math and crunching the numbers when it comes to figuring out your loan's interest can be complicated. Here's how to calculate interest on a loan.