Hello, can you please explain how questions (c) and (d) answers were determined in the attached excel file. I have ben trying to work this problem

Hello, can you please explain how questions (c) and (d) answers were determined in the attached excel file. I have ben trying to work this problem out , but I can seem to figure out the values of G42, G43 and G44 question (c). Also, how was the Risk Tolerance ($570,000) determined in question (d).

Thank you.

Kevin