Compound interest refers to interest calculated on interest balances as well as principal. Learn how to calculate compound interest using Microsoft Excel.

Reviewed by Thomas J. Catalano Fact checked by Vikki Velasquez The discount rate refers to the interest rate used when calculating the net present value (NPV) of an investment. It represents the ...

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.

Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.

Use Excel in your rate card formulas to calculate discounts, dimensions and unit costs of your advertising rate document. Instead of manually calculating each of these components, use Excel ...

Q. I have prepared projections for a proposed project, and I want to calculate the internal rate of return. Instead of using Excel’s IRR function, should I use simple math formulas so others can ...

Calculate Total Interest Over the Life of the Loan With CUMIPMT The cumulative interest formula (CUMIPMT) will show you how much you'll pay in total on top of your student loan principal, i.e ...

How to Calculate Simple Interest Savings. Savings accounts will earn interest on the amount of money deposited into the account. The formula to calculate simple interest in a savings account is ...

When we think of modern data analysis, we tend to think of companies. But there's a case to be made for more robust personal finance spreadsheets. That's what we are discussing today: Two helpful ...

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

4] Calculating Interest Compounded Monthly in Excel To calculate the interest compounded monthly, change the value of the B4 cell to 12 and use the same formula.