Please show the calculations for below on excel and show me the formulas.

Posted Date: