P6-16 (similar to) Bond valuation Annual interest Calculate the value of the bond shown in the following table, assuming it pays interest annually. (Click on the icon here spreadsheet.) Par value Coupon interest rate 14% Years to maturity 8 Required return 16% $100 The value of the bond is $100. (Round to the nearest cent.) can you show me how to get it in excel ​

Amethod of allocating merchandise cost that assumes the first merchandise bought was the first merchandise sold is called the a. last-in, first-out method. b. first-in, first-out method. c. specific identification method. d. average cost method.

There are three factors that can affect the shape of the treasury yield curve (r* t , ip t , and mrp t ) and five factors that can affect the shape of the corporate yield curve (r* t , ip t , mrp t , drp t , and lp t ). the yield curve reflects the aggregation of the impacts from these factors. suppose the real risk-free rate and inflation rate are expected to remain at their current levels throughout the foreseeable future. consider all factors that affect the yield curve. then identify which of the following shapes that the us treasury yield curve can take. check all that apply.a. downward-sloping yield curveb. upward-sloping yield curvec. inverted yield curve

Your subscription to investing wisely weekly is about to expire. you plan to subscribe to the magazine for the rest of your life, and you can renew it by paying $85 annually, beginning immediately, or you can get a lifetime subscription for $620, also payable immediately. assuming that you can earn 6.0% on your funds and that the annual renewal rate will remain constant, how many years must you live to make the lifetime subscription the better buy?