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 ...

How to Calculate the Average Annual Rate of Return in Excel. If your business makes investments in equipment and employee benefit contributions, you may need to track the average annual rate of ...

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.

Microsoft Excel has dozens of preset formulas for many types of mathematical calculations, but compounding interest isn't one of them. To calculate the future value of a single amount compounded ...

Percentages aren't always easy to calculate, but one of the best tools in Excel's toolbox is calculating percentages for you. Here's how to do it.

How to calculate mutual fund returns in Excel: Find out SIP returns of your MF schemes XIRR basically calculates the internal rate of return of an investment when there are irregular cash flows ...

Reviewed by Samantha Silberstein A forward rate is the applicable interest rate of a financial security that will occur at some future date. It is calculated using two zero-coupon bonds of varying ...

In this article we will take a quick look at simple formulas in Excel, especially the calculation of VAT and inclusive of the sale price (including tax) for a purchase price without VAT (tax).