#BanHomeworkTheives >:(((

Bonds often pay a coupon twice a year. for the valuation of bonds that make semiannual payments, the number of periods doubles, whereas the amount of cash flow decreases by half. using the values of cash flows and number of periods, the valuation model is adjusted accordingly. assume that a $1,000,000 par value, semiannual coupon us treasury note with three years to maturity has a coupon rate of 3%. the yield to maturity (ytm) of the bond is 7.70%. using this information and ignoring the other costs involved, calculate the value of the treasury note:

You get your monthly banking statement and notice that the number is lower than expected. you decide that you should create a cash flow statement. why are cash flow statements useful in managing money? what are the steps in creating a statement?

Perform a goal seek analysis to find a packing weight that will bring the shipping weight of the retro fit clothing set down to 39.75 lbs. use cell i9 as the cell to set, 39.75 as the target value, and cell f5 as the changing cell. keep the values generated by the goal seek analysis as the value for cells f5, i9, and i10.