ENCE627 – Solution Set 5 – not understanding which equations were used.

Based on the excel spreadsheet, I cannot seem to determine what equations are used to determine average floods occurring per year, discounted damages per year, or probability x discounted per year.  The equations are not easily followed.  I understand the discount factor being based on the equation, but the other areas I’m not understanding.