I would like to do the following:
Example data:
I have a lease entered into on 10 November 2004 and which finishes on 10 May 2006. Monthly rental is $100.
There are lots of leases all at different times/years etc.
How can I calculate how much was due per year, i.e. in 2004, 2005, 2006?
I...