Payment Schedule

Hi - I have a payment schedule that is summarized annually that I would like to expand to show monthly. Additionally, there are two columns that dictate the Start and End date of the lease. The EFFDATE column shows when the rent amounts are effective.

Please see attached input and output.

I believe the tool to use is a multirow tool but having trouble with the expression. Any sample workflows would be greatly appreciated.

Thanks!

Leasing Table.xlsx

Expression

Accepted answers

danilang

Here you go

Incorporating the 3 "tweaks" you requested.

WF prorated.png

Dan

PaymentSchedProrated.yxmd

All comments

danilang

Hi @cireost

Here's a WF that accomplishes what you're looking for.

It starts by using a multi-row to get the [next EffDate] from the next row, then generates the monthly rows. The Filter and Select tools remove the months before the lease starts and clean up the results, respectively.

The output looks like this (showing the rows where the payment changes, but all rows are included)

Dan

PaymentSched.yxmd

cireost

This is great! Couple tweaks -

1) if the Start date was instead 4/15, this would skip the month of April and move on to May, losing the ability to prorate the month of April. Is there a way to address that?

2) if there is another Property in the list, I think the expression in multi-row tool might need to be tweaked? Not sure how though.

3) If the first effective date is not the first of the month, is there a way to update the loop expression in the generate row tool to return the first of the next month?

Updated example attached.

Thanks!

Leasing Table2.xlsx

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335