Zabberer Corporation bonds pay a coupon rate of interest of 12 percent annually and have a maturity value of $1,000. The bonds are scheduled to mature at the end of 14 years. The company has the option to call the bonds in 8 years at a premium of 12 percent above the maturity value. You believe the company will exercise its option to call the bonds at that time. If you require a pretax return of 10 percent on bonds of this risk, how much would you pay for one of these bonds today?

What is the best way to slove this in excel?