Please answer using EXCEL ONLY!!! Other answers will not be accepted. I will upvote a correct answer

2. In 2012, the Pandora Box Company made a rights issue at 9 a share of one new share for every eight shares held. Before the issue there were 10.4 million shares outstanding and the share price was 10. A. What was the total amount of new money raised? B. What was the prospective stock price after the issue? C. The rights issue gave the shareholder the opportunity to buy one new share for less than the market price. What was the value of this opportunity per share owned