The discount rate is the interest rate used to calculate net present value (NPV). It represents the time value of money. NPV can help companies determine whether a proposed project may be profitable.

Learn how to calculate the discount rate in Microsoft Excel, what the discount factor is, and how the discount rate and discount factor compare.

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.

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

If your business makes investments in equipment and employee benefit contributions, you may need to track the average annual rate of return over a span of time for financial reporting obligations.

How to Calculate Annuities Using Excel. Annuities represent a loan or investment which offer monthly fixed payments until the account is depleted or paid off.

How to Calculate the Average Return for the Share of Stock in Excel Credit: Next, I need to fill in all the other cash flows I've received from my Microsoft investment.