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

Excel can quickly calculate amortization. Microsoft Excel is a widely used spreadsheet program that can use formulas to compute and display values.

Learn how to use the powerful Excel PMT Function to help you manage your loan payments and easily calculate detailed loan repayment schedules ...

To calculate interest, you need to know variables such as interest rate, principal loan amount and loan term. So if you had 4% interest on a $100,000 mortgage loan, and your loan term was 30 years ...

How Simple Interest Works: An Example Suppose you take out a $5,000 loan at 6% interest for two years. To calculate the amount of interest you will pay, use the simple interest formula above.

The formula for calculating simple interest in a savings account is Interest = P * R * T. Multiply the account balance by the interest rate by the time period.

Discover how to calculate the modified Macaulay duration of a bond or other fixed-income security using Microsoft Excel.

Excel percentage formulas can help with many everyday applications. We'll walk through several examples, including turning fractions to percentages, and calculating percentage of total, increase ...

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.

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.