Jane wants to count the number of cells in a range in her spreadsheet. she would like to count only the cells in that range that contain 100. what function should he use?

Jackson is preparing for his hearing before the federal communications commission (fcc) involving a complaint that was filed against him by the fcc regarding the interruption of radio frequency. the order to "cease and desist" using the radio frequency has had a detrimental impact on his business. once the administrative law judge prepares his or her initial order, jackson has no further options. no, jackson can request that the matter be reviewed by an agency board or commission. yes, once the initial order is presented, it's only a matter of time before the order becomes final.

Onsider the following subscription behavior information from genie, a web site that provides tools for constructing a family tree (ancestor search). subscriptions cost $9.99 per month, but you are charged for the entire year at the time of purchase. there is a one-year minimum term when you sign up for the service. once purchased, subscriptions are set to renew automatically unless the subscriber cancels them. when a membership renews, it renews for a one-year term and again you are charged for the entire year. there are no variable costs associated with providing this service to an individual customer, but genie does engage in customer relationship activities that they believe will increase customer retention. these customer relationship activities cost genie about $10 per year per customer. based on a sample of 1000 customers that joined genie five years ago, near the time when the company was founded, they were able to determine how many of those customers remained subscribers in the second year, third year etc. based on this information, genie calculated the average annual retention rate to be 20%. genie uses an annual discount rate of 8%. a. last year, genie spent $10,000 placing advertisements on google. genie management believes that these advertisements were responsible for about 300 new subscribers. would you recommend to genie management that they purchase more google ads? b. suppose a newly-introduced loyalty program increases the number of customers that remained to 30%. does this new data change your answer to 9.a? c. do you have any hesitations or concerns about making recommendations to management based on your above estimate of customer lifetime value?

Suppose that the firm cherryblossom has an orchard they are willing to sell today. the net annual returns to the orchard are expected to be $50,000 per year for the next 20 years. at the end of 20 years, it is expected the land will sell for $30,000. calculate the market value of the orchard if the market rate of return on comparable investments is 16%.