You need to have the zero-coupon yield curve information to calculate forward rates, even in Microsoft Excel.

How much you can borrow is often determined by the bank based on internal qualifiers, such as credit score, debt-to-income ratio, interest rate and the type of loan you need. These qualifiers will ...

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

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

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

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

This Technology Workshop illustrates how to leverage a number of functions to perform calculations in Excel involving the time value of money.

Calculating CAGR or Compound Annual Growth Rate in Microsoft Excel is super easy. You will have to use the RRI function to get the job done.