The manager of a video store was interested in examining the relationship between a person's weekly take-home pay and the number of movies rented by that person per week. He polled 50 customers. In an Excel spreadsheet, the take-home pays of the 50 customers are stored in cells A1 to A50, and the number of videos rented per week by the 50 customers are stored in cells B1 to B50. Write an Excel formula that will find the correlation coefficient of this data.

Problem 9-5. net present value and taxes [lo 1, 2] penguin productions is evaluating a film project. the president of penguin estimates that the film will cost $20,000,000 to produce. in its first year, the film is expected to generate $16,500,000 in net revenue, after which the film will be released to video. video is expected to generate $10,000,000 in net revenue in its first year, $2,500,000 in its second year, and $1,000,000 in its third year. for tax purposes, amortization of the cost of the film will be $12,000,000 in year 1 and $8,000,000 in year 2. the company’s tax rate is 35 percent, and the company requires a 12 percent rate of return on its films. required what is the net present value of the film project? to simplify, assume that all outlays to produce the film occur at time 0. should the company produce the film?

Calculate the required rate of return for climax inc., assuming that (1) investors expect a 4.0% rate of inflation in the future, (2) the real risk-free rate is 3.0%, (3) the market risk premium is 5.0%, (4) the firm has a beta of 2.30, and (5) its realized rate of return has averaged 15.0% over the last 5 years. do not round your intermediate calculations.

Which external factor has enabled addition of special effects in advertisements and tracking of responses of customers over websites?