How to Use Excel to Calculate a Bond's Yield to Call. Bonds are investment vehicles that make regular coupon payments until maturity, at which time the bond's face value is paid.

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

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.

Learn about bond coupons, how they're calculated, and their effect on investments. Discover the differences between coupon ...

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 Annuities Using Excel. Annuities represent a loan or investment which offer monthly fixed payments until the account is depleted or paid off.

Bond investors routinely have to make judgment calls about expectations on future conditions in the credit markets, including changes in prevailing interest rates and inflation.

Why would you pay more than face value for a bond? The main reason bond prices move has to do with interest rates. If a bond is issued at a given rate and then prevailing interest rates in the ...

In this case, the break-even interest rate will tell you how far prevailing rates would need to rise by the time the shorter-term bond matures in order to make up for its smaller interest payments.