Spiller Corporation plans to issue 10%, 15-year, $500,000 par value bonds payable that pay interest semiannually on June 30 and December 31. The bonds are dated January 1 of the current year and are issued on that date. 10% 15 years Contract rate Term Par value Market rate Payments per year $500,000 8% 2 Required: If the market rate of interest for the bonds is 8% on the date of issue, what will be the total cash proceeds from the bond issue? 5 Use formulas that reference data from this worksheet and from the appropriate f Required: If the market rate of interest for the bonds is 8% on the date of issue, what will be the total cash proceeds from the bond issue? Use formulas that reference data from this worksheet and from the appropriate future or present value tables (found by clicking the tabs at the bottom of this worksheet). Table Values are based on: n= Table Value Amount Present Value Cash Flow Present (maturity) value 5 Interest (annuity) 5 Total cash proceeds