If you need to find the percentage change in Excel, especially across a range of cells, then this post offers step by step guidance.

To increase a price by a percentage, use the formula: Original Price * (1 + Percentage Increase). For price decreases, the formula is: Original Price * (1 – Percentage Decrease).

Learn how to calculate percentage change, and how work out a new or an original value after a percentage increase or decrease, with video, practice questions and a quiz.

Input the call premium as a percentage in cell B6. The call premium is the percent increase over the bond's face value which is paid by the issuing company to exercise their call option.