This video tutorial shows you how to value and price simple bonds through excel. This will teach you how to do present value PV(), future value FV(), payment PMT(), yield to maturity rate RATE(), and number of periods NPER() calculations in excel for simple bonds. This tutorial will explain how to use these functions in conjuction with each other in order to find any missing information.
Topics Covered
 Bond Valuation and Pricing in Excel
PV(), FV(), PMT(), RATE(), & NPER() Functions
Used for simple bonds with no special features or provisions
Difficulty: Intermediate
Video: Yes
Spreadsheet: Yes
Download
|
