Calculating Simple Interest is an excellent method to judge your savings in advance. However, calculating it for various interests and principal sums could be complex. This is where Excel comes to ...

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

How to Calculate a Loan's Monthly Payment in Excel With Tax & PMI. Your monthly loan payment consists of more than just equity and interest payments. If you didn't put down at least 20 percent ...

Learn how to approximate the effective convexity of bonds using Microsoft Excel with a modified and simpler version of the standard convexity formula.

Annuities represent a loan or investment which offer monthly fixed payments until the account is depleted or paid off. Whether you are investing or borrowing money does not change the calculation. As ...