Doxserá forms are brainy and can include scores of math, date, and finance functions. This form automatically calculates a prorated monthly payment by (a) determining the number of days between the starting date and the end of the month, (b) dividing that number by the total number of days in the month, and (c) multiplying the result by the monthly lease payment. The form also automatically determines several dependent dates based on a single Effective Date.

Click the Start button to begin.

The Effective Date of this Lease is {LeaseDate}. The monthly payment due on the 1st of each month is {MonthlyPmt} (${MonthlyPmt}), beginning {if:{LeaseDate}}{if:{LeaseDate (offset)}}. Late payments will incur an additional 5% fee (${###}). {if:A prorated payment of {###} (${###}) for the first partial month of occupancy (the period from {LeaseDate} to {LeaseDate (offset)}) is due within ten (10) business days of the Effective Date (no later than {LeaseDate (offset)}).}

Doxserá (c) 2020 Snapdone, Inc.
Label	Question	Answer
LeaseDate	When does the lease take effect? Format: m/d/yyyy	[??]
MonthlyPmt	What’s the monthly payment? Format: 1,000	[??]
DayOfMonth	(derived)	{LeaseDate}
LastDayOfMonth	(derived)	{LeaseDate (offset)}

After answering both questions, click the Fill button.

Try out a few scenarios. What happens if the Effective Date is on the 1st of the month? What if it’s in the middle of the month or at the end of the month? How is the due date of the prorated payment affected when a three-day weekend intervenes?