Suppose you purchase a bond with a face value of \(1,000, a purchase price of \) 950, and a term to maturity of 5 years. To calculate the RFT, you would use the following formula:

Mastering the RFT Formula in Excel: A Step-by-Step Guide**

The RFT formula in Excel has the following syntax: