Example of using the Future Value Formula on a Commercial Loan

My first post on this blog was in August of 2014 and it was called: No XNFV Excel Function?┬áThe idea was a formula for calculating future value with dates. There was a XNPV function for present value, but no function for future value. My formula looks like this: =SUMPRODUCT((1+APY)^((MAX(Dates)-Dates)/365)*Data) Of course there are other workarounds, […]