SHOW THE ASNWER IN EXCEL PLEASE

To generate leads for new business, Gustin Investment Services offers free financial planning seminars at major hotels in Southwest Florida. Gustin conducts seminars for groups of 25 individuals. Each seminar costs Gustin $3,300, and the average first-year commission for each new account opened is $4,800. Gustin estimates that for each individual attending the seminar, there is a 0.01 probability that individual will open a new account.

(a)

Determine the equation for computing Gustin's profit per seminar, given values of the relevant parameters.

Profit = New Accounts Opened (4,800 3,300)Profit = (3,300 4,800) New Accounts Opened Profit = 4,800 (New Accounts Opened 3,300)Profit = (New Accounts Opened 3,300) 4,800Profit = (New Accounts Opened 4,800) 3,300

(b)

What type of random variable is the number of new accounts opened? Hint: Review Appendix 12.1 for descriptions of various types of probability distributions.

discrete uniforminteger uniform continuousnormalbinomial

(c)

Construct a spreadsheet simulation model to analyze the profitability of Gustin's seminars. Would you recommend that Gustin continue running the seminars? (Use at least 1,000 trials. Round your expected profit to the nearest integer and your probability of a loss to three decimal places.)

expected profit = $ probability of a loss =

Gustin should ---Select--- consider discontinuing continue the seminars in their current format.

(d)

What is the minimum number of attendees (in a multiple of five, i.e., 25, 30, 35, etc.) that Gustin needs so that the seminar's average profit is greater than zero?

attendees