Please kindly help me with this question. It is highly important to use only excel PLEASE. Also, the cell reference or formula is very important so that I can under the route to the answer. PLEASE

(7-5) Blunderbluss Manufacturing's balance sheets report $200 million in total debt, $70 million Intrinsic Price per short-term investments, and $50 million in preferred stock. Blunderbluss has 10 million Share Based on FCFs shares of common stock outstanding. A financial analyst estimated that Blunderbuss's value of operations is $800 million. What is the analyst's estimate of the intrinsic stock price per share