How can I calculate dates based on a Lease Term divided into periods by number of months. For example if I have a lease start date of 9/1/11 and the rent adjusts according to a schedule such as this:
Months 1-12 - $x/mo
Months 13-24 - $y/mo
Months 25-36 - $z/mo
And so on…
What is a formula I can use to calculate that date for me for any particular month based on 9/11 being month 1?
Any help is much appreciated!
Is X Y & Z going to be different amounts? All persiods listed are for 12 months, is there a sliding scale of rent per month if someone takes a 12 month lease, which will reduce in the second period if they commit to 24 months and the third part reduce again if they commit to 36 months?
If thats the case, please let us know the amounts (as a guide) for each section if not then please elaborate a little further
Windows 7 using Office 2007 & 2010
Remember your [ code ] [ /code ] tags, makes reading soooo much easier
scottylad2: Yes the rent is a certain amount months 1-12 ($10,590.80) and then adjusts to a $10,831.50 months 13-24, $11,072.20 months 25 -36 and so on. The Lease is already signed so these amounts are fixed and the tenant has commited to them. I am creating a Lease Abstract in Excel which using the 9/1/11 start date will specify which months the increases will take place based on the schedule mentioned above. The reason we dont just use the dates in the Lease are that we do not know when the Commencement date will be usually, so instead its by months 1-12, etc. I hope that provides the clarification you needed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks