Please see the attached excel file. I have included the answer and just need the work shown in excel.
From the specified terms, it appears that Beedles always gets $14 million regardless of the price of the stock to the public. We're also told that Security Brokers spends $300,000 in design and distribution costs. ...
Profit or Loss factors are determined.