I need to understand how the IRR, NPV and FPV formulas work? Thks

I am working on a Lease vs. Buy analysis, I have these formulas in the file
but I cannot understand how they work, so I cannot validate the results, and
I need to.

Thanks.