Please someone help me find the answer through excel

1. You've been assigned to analyze the profitability of Bill Clinton's new autobiography. The following assumptions have been made: o Bill is receiving a one-time royalty payment of $12 million. o The fixed cost of producing the hardcover version of the book is $1 million. o The variable cost of producing each hardcover book is $4. o The publisher's net from book sales per hardcover unit sold is $15. o The publisher expects to sell 1 million hardcover copies. o The fixed cost of producing the paperback is $100,000. o The variable cost of producing each paperback book is $1. o The publisher's net from book sales per paperback unit sold is $4. o Paperback sales will be double hardcover sales. Use this information to answer the following questions. o Determine how the publisher's before-tax profit will vary as hardcover sales vary from 100,000 through 1 million copies. o Determine how the publisher's before-tax profit varies as hardcover sales vary from 100,000 through 1 million copies and the ratio of paperback to hardcover sales varies from 1 through 2.4