Suppose cell C2 contains the number of people showing up for an airline flight which can seat 100 people. Which of the following formulas would return the number of people who are "overbooked" and cannot get on the flight? a. IF(C2>100,C2-100,0)
b. IF(C2>100,C2,0)
c. IF(C2<100,0,C2-100)
d. IF(C2<=100,0,C2-100)

You manage an equity fund with an expected risk premium of 10% and a standard deviation of 14%. the rate on treasury bills is 6%. your client chooses to invest $60,000 of her portfolio in your equity fund and $40,000 in a t-bill money market fund. what is the expected return and standard deviation of return on your client’s portfolio?

Mae jong corp. issues $1,000,000 of 10% bonds payable which may be converted into 10,000 shares of $2 par value ordinary shares. the market rate of interest on similar bonds is 12%. interest is payable annually on december 31, and the bonds were issued for total proceeds of $1,000,000. in accounting for these bonds, mae jong corp. will: (a) first assign a value to the equity component, then determine the liability component. (b) assign no value to the equity component since the conversion privilege is not separable from the bond.(c) first assign a value to the liability component based on the face amount of the bond.(d) use the “with-and-without” method to value the compound instrument.

Pederson company reported the following: manufacturing costs $480,000 units manufactured 8,000 units sold 7,500 units sold for $90 per unit beginning inventory 2,000 units what is the average manufacturing cost per unit? (round the answer to the nearest dollar.)