Enter a formula in the selected cell using SUMIF to calculate the total expenses for the category Office Expense. Use the range name Category for the Range argument, the text string "Office Expense" for the Criteria argument, and Cost for the Sum_range argument. Font Size

Who is better at multi-tasking? in business, employees are often asked to perform a complex task when their atten-tion is divided (i.e., multi-tasking). human factors (may 2014) published a study designed to determine whether video game players are better than non–video game play-ers at multi-tasking. each in a sample of 60 college stu-dents was classified as a video game player or a non-player. participants entered a street crossing simulator and were asked to cross a busy street at an unsigned intersec-tion. the simulator was designed to have cars traveling at various high rates of speed in both directions. during the crossing, the students also performed a memory task as a distraction. two variables were measured for each student: (1) a street crossing performance score (measured out of 100 points) and (2) a memory task score (measured out of 20 points). the researchers found no differences in either the street crossing performance or memory task score of video game players and non-gamers. “these results,” say the researchers, “suggest that action video game players [and non-gamers] are equally susceptible to the costs of dividing attention in a complex task”

Which of the following statements is true regarding the reporting of outside interests and the management of conflicts? investigators are responsible for developing their own management plans for significant financial interests. the institution must report identified financial conflicts of interest to the u.s. office of research integrity. investigators must disclose their significant financial interests related to their institutional responsibilities and not just those related to a particular project. investigators must disclose all of their financial interests regardless of whether they are related to a research project.

Calculate the cost of each capital component—in other words, the after-tax cost of debt, the cost of preferred stock (including flotation costs), and the cost of equity (ignoring flotation costs). use both the capm method and the dividend growth approach to find the cost of equity.calculate the cost of new stock using the dividend growth approach.what is the cost of new common stock based on the capm? (hint: find the difference between re and rs as determined by the dividend growth approach and then add that difference to the capm value for rs.)assuming that gao will not issue new equity and will continue to use the same target capital structure, what is the company’s wacc? e. suppose gao is evaluating three projects with the following characteristics.each project has a cost of $1 million. they will all be financed using the target mix of long-term debt, preferred stock, and common equity. the cost of the common equity for each project should be based on the beta estimated for the project. all equity will come from reinvested earnings.equity invested in project a would have a beta of 0.5 and an expected return of 9.0%.equity invested in project b would have a beta of 1.0 and an expected return of 10.0%.equity invested in project c would have a beta of 2.0 and an expected return of 11.0%.analyze the company’s situation, and explain why each project should be accepted or rejected g