I’m trying to build a statement of adjustment model for Real Estate conveyance. I’m stumped trying to set up the adjustment for rent allocated between the vendor and purchaser.
Say the adjustment date falls on some day in the month. I need to calculate the amount of rent to debit the vendor and credit the purchaser. For simplicity, assume that the rent is always paid on the first of the month. The adjustment day can be any day of the month.
If the adjustment date fell on Feb 20th, I would want to calculate my adjustment factor as: (feb 20 – 1)/(number of days in Feb). Of course, I can manually figure out that the factor would be 19/28 (assuming no leap year). Is there a way that Quantrix could manage this calculation?