Enter a formula using pv in cell b6 to calculate the present value needed for this pension fund. Cell b3 is the expected annual interest rate. Cell b4 is the total number of monthly payments that will be made. Cell b2 is the amount of each monthly payment. Payments will be made at the beginning of every period. Remember to express the pmt argument as a negative.

Frugala is when sylvestor puts $2,000 into 10-year state bonds and $3,000 into 5-year aaa-rated bonds in steady hand hardware, inc. he buys the four state bonds at a 5 percent interest rate and the three steady hand bonds at a 6.5 percent rate. sylvestor also buys $1,500 worth of blue chip stocks, and $800 worth of stock in a promising new sportswear company that reinvests its earnings in new growth. 1. (a) what is the maturity for each of the bond groups sylvestor buys? (b) the coupon rate? (c) the par value?