Please could you answer this with workings on excel? Thank you in advance!

Question:

Hint to help answer the question:

A bank estimates that its profit next year is normally distributed with the mean and the standard deviation shown in the table below: Mean Return (as % of assets) Standard Deviation (as % of assets) 0.950 2.400 a. How much equity (as a percentage of assets) does the company need to be 99% sure that it will have a positive equity at the end of the year? Ignore taxes. b. How much equity (as a percentage of assets) does the company need to be 99.9% sure that it will have positive equity at the end of the year? Ignore taxes. Have a look at Hint 2 in the Hints sheet! :) Hint 2: You need to refresh your memory on Business Statistics a bit! Remember the normal distribution tables? Well... You know where the mean (the mid-point on the distribution) is, and you know that you'd need to go a certain number of "standard deviations" back from the mean [that's what you find in those tables!) in order to get to the point where: (a) the area under the curve (or the probability) is 0.01 or 1% (b) the area under the curve (or the probability) is 0.001 or 0.1% So... that's gonna give you the maximum loss with the probability of (a) 99% and (b) 99.9%. Now, that's how much equity you'd need in place in order to make sure the company would still have positive equity