Hello all - I am new to Pigment and am having some serious difficulty staging up a lease schedule for my client.
The client wants to input future forecasted leases as follows:
- Step 1: Select a region from a drop down menu
- The region is already dimensioned via “L1 Geo”
- Step 2: A lease value column should prepopulate based on default regional values.
- The “L1 Geo” dimension has two additional columns with default Lease Values and default Cage values.
- Step 3: A “Cage Fee” column should prepopulate based on default regional values.
- The “L1 Geo” dimension has two additional columns with default Lease Values and default Cage values.
- Step 4: A rent escalator column should prepopulate with 3%
- Step 5: A term column should prepopulate with 60 months
- Step 6: A “Start Date” column should be manually entered
- Step 7: A monthly view should show two separate calculations that starts based on the start date of the lease: Lease value amortization & Cage Fee amortization.
So far I have the following:
- L1 Geo dimension with additional columns for the default lease and cage fee values
- Lease Selector dimension that is just a list as such: “Lease 1”, “Lease 2”, “Lease 3”...”Lease 25”. This list should be one column in the final table.
I want the “Lease Selector” dimension to be one column. The user will select a region next to each lease selector item. From there the remining fields should populate, except for the start date. Once the start date is populated, the remaining table’s columns should be months that show amortization expense for the lease value and cage fee.
ANY help to get this basic structure started would be GREATLY appreciated!!!