please solved the first question in excel formate and explain how to do it stepsAssume that the cash flow for Buckeye Brewery $5$have the following distribution:

i$.$ What are the expected value and standard deviation of Buckeye Brewery's cash

flow?

ii$.$ With full insurance, how does the distribution of Buckeye Brewery's cash flow

look like $($assume the price of insurance is $P)?$

iii. With full insurance, what does the distribution of the insurer's claim costs look

like?

iv$.$ What is the loading of the insurance if Buckeye Brewery pays $$100,000$ to the

insurer?

v$.$ Given the insurance premium of $$100,000,$ calculate the expected value and

standard deviation of Buckeye Brewery's cash flow after purchasing insurance.