This is a statistics & probability question I$\text{'}$m needing assistance with, preferably step by step information using Excel.

A particular company is considering bidding on a contract for a new office building complex. The figure below shows the decision tree prepared by one of the company's analysts. At node $1,$ the company must decide whether to bid on the contract. The cost of preparing the bid is $$210,000.$ The upper branch from node $2$ shows that the company has a $0\mathrm{.}8$ probability of winning the contract if it submits a bid. If the company wins the bid, it will have to pay $$2$ million to become a partner in the project. Node $3$ shows that the company will then consider doing a market research study to forecast demand for the office units prior to beginning construction. The cost of this study is $$110,000.$ Node $4$ is a chance node showing the possible outcomes of the market research study. Nodes $5,6,$ and $7$ are similar in that they are the decision nodes for the company to either build the office complex or sell the rights in the project to another developer. The decision to build the complex will result in an income of $$5$ million if demand is high and $$3$ million if demand is moderate. If the company chooses to sell its rights in the project to another developer, income from the sale is estimated to be $$3\mathrm{.}5$ million. The probabilities shown at nodes $4,8,$ and $9$ are based on the projected outcomes of the market research study.

$($a$)$

Verify the company's profit projections shown at the ending branches of the decision tree by calculating the payoffs of $$2,680,000$ and $$680,000$ for first two outcomes, the outcomes extending from chance node $8.$

$($b$)$

What is the expected profit $($in $$)$ for this project?

$($c$)$

What would the cost $($in $$)$ of the market research study have to be before the company would change its decision about conducting the study?

$($d$)$

Develop a risk profile for the company. $($Submit a file with a maximum size of $15$ MB$.)$