I need help on problem 6-13. using the template provided.

plinelpal at the Initial offerings of bonds occur in a(n) while resale of bonds occurs in a(n) 12. Interest payments on bonds that make periodic interest payments are calculated by the num- 6- by dividing the ber of and multiplying by 6-15 of the bond. 6-13. The Town of Hill Valley is issuing a 30-year bond with a face value of $50,000,000 and a stated annual interest rate of 4 percent. The town will make interest payments twice a year. ng-term 6-4. How are general obligation bonds sold on the primary market? d? 6-5. Summarize the advantages and disadvan- tages of leasing. o,o00 out a repay rcent much purchased today, when market interest rates are 4-5 percent. How much would you have to pay to buy the bond? 6-8. You could purchase a zero coupon bond that has a maturity value of $25,000 and earns a current market rate of 3 percent. If the bond matures in 10 years and we assume semiannual compounding, what is the bond worth today? ond and Calculate the semiannual interest payment. 2. Calculate how much Hill Valley will receive from the bond offering under 1. as l. the following conditions Market interest rates remain unchanged at the time of the offering Market interest rates increase to 4.2 a. b. percent at the time of the offering. 6-14. The State Pension System wants to sell a 20-year original maturity General Industries' bond that it purchased 1o years ago. The bond pays interest twice each year. The par value of the bond is $100,000,00o. The coupon rate t If tho gurront morket interest AutoSave f Week 3 problem Template(2) (1) Protected File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to 6 Problem 6-13 Input 6 Par value of Bond 7 Coupon Rate 8 Interest Payments per year 9 Rate per coupon = coupon rate / # payments 0.00% 10 Years to maturity 11 Periods to maturity-years * # payments 12 Market Rate at time of offering 131 Market Rate per coupons coupon rate / # payments 14 15.1. Coupons par value" coupon rate / # payment-nper 16 0.00% $ -pvfrate,nper,pmt,fv,type) 17 2-a Bond value at coupon rate 18 2-b Bond value at market rate 19 20 21 23 24 25 26 27