Portfolio Theory Questions Use the information about the individual investments provided in the Excel file to answer questions 1-4. Report expected return to two decimal places (i. e. 12.34%) and the portfolio variance to 4 decimal places (i. e. 0.1234). 1. What is the expected return and variance of a portfolio with 70% of your wealth invested in IBM and 30% of your wealth invested risk-free bonds

Horace society is planning its annual western fair raceway gala. the gala committee has assembled the following expected costs for the event: dinner (per person) $10 gaming token and program (per person) $2 prize payouts $4,300 tickets and advertising $800 private box suite rental $1,700 lottery licenses $200 the committee members would like to charge $40 per person for the evening’s activities. required: 1. what is the break-even point for the dinner-dance (in terms of the number of persons who must attend)? 2. assume that last year only 200 persons attended the dinner-dance. if the same number attend this year, what price per ticket must be charged in order to break even? 3. refer to the original data ($40 ticket price per person). prepare a cvp graph for the dinner- dance from zero tickets up to 600 tickets sold.

Dr. sperry, a biologist, is using excel to track growth rates of different populations of bacteria. she has a very complex formula in one cell. it begins with “round”. dr. sperry would like to see exactly how excel’s calculation reached the final rounded value that she sees in the cell. what could dr. sperry do to best understand how the calculation was made? try different formulas on her own until she reaches the value shown in excel click on the evaluate formula button in the formulas tab and then click “step in” select the cell and then look at the formula in the formula field of the ribbon remove “round” from the formula in order to see the actual value before rounding

On january 1, eastern college received $1,350,000 from its students for the spring semester that it recorded in unearned tuition and fees. the term spans four months beginning on january 2 and the college spreads the revenue evenly over the months of the term. assuming the college prepares adjustments monthly, what amount of tuition revenue should the college recognize on february 28?