Use an Excel spreadsheet to calculate the appropriate price and yield to maturity for the three bonds listed below: a. Bond with coupon rate of 10% and face value of $1000 that matures in 6 years. b. Bond with coupon rate of 5% and face value of $1000 that matures in 4 years c. Bond with coupon rate of 2% and face value of $1000 that matures in 2 years. Assume that the one-year, two-year, three-year, four-year, five-year, and six-year spot rates are 4.00%, 4.50%, 4.75%, 5.00%, 5.20%, and 5.50%, respectively. All coupons are paid annually. Please print out a copy of the spreadsheet used to price bond (b) and attach it to your homework. You do not need to show your work for bonds (a) or (c).

Harry is 25 years old with a 1.55 rating factor for his auto insurance. if his annual base premium is $1,012, what is his total premium? $1,568.60 $2,530 $1,582.55 $1,842.25

Skychefs, inc. prepares in-flight meals for a number of major airlines. one of the company's products is grilled salmon in dill sauce with baby new potatoes and spring vegetables. during the most recent week, the company prepared 4000 of these meals using 960 direct labor hours. the company paid these direct labor workers a total of $19,200 for this work, or $20.00 per hour. according to standard cost card for this meal, it should require 0.25 direct labour-hours at a cost of $19.75 per hour.1. what is the standard labor-hours allowed (sh) to prepare 4,000 meals? 2. what is the standard labor cost allowed (sh x sr) to prepare 4,000 meals? 3. what is the labor spending variance? 4. what is the labor rate variance and the labor efficiency variance?

Which is cheaper: eating out or dining in? the mean cost of a flank steak, broccoli, and rice bought at the grocery store is $13.04 (money. msn website, november 7, 2012). a sample of 100 neighborhood restaurants showed a mean price of $12.75 and a standard deviation of $2 for a comparable restaurant meal. a. develop appropriate hypotheses for a test to determine whether the sample data support the conclusion that the mean cost of a restaurant meal is less than fixing a comparable meal at home. b. using the sample from the 100 restaurants, what is the p-value? c. at a = .05, what is your conclusion? d. repeat the preceding hypothesis test using the critical value approach