O'Reilly logo

Formulas and Functions with Microsoft® Excel 2003 by Paul McFedries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

19. Working with Bonds

IN THIS CHAPTER

Glossary of Bond Terms

Calculating Bond Yields

Calculating Bond Prices

Calculating Bond Duration

Calculating Bond Principal at Maturity

Working with Coupons

Working with Zero-Coupon Bonds

Working with Treasury Bills

A bond is a debt instrument by which companies and governments raise money by borrowing it from investors. The bond is a promise to pay back at some future date the amount borrowed and to pay interest periodically throughout the term. This chapter takes you through a few formulas and functions that enable you as an investor to work with bonds.

Glossary of Bond Terms

Before beginning, here are a few bond terms that you’ll see throughout the next few sections and that you should be familiar with: ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required