Solved
Excel help (using macros)
Posted on 2016-09-13
I have the following problem I'd like to compute in a cell.
Payments start at month X (Mar). They go up increments of 10, every 2 months (payment period) for a number of periods 5, until they stop going up and remain at the same level. I want to create cells with the values under "payments" below, i.e. 0, 0, 100, 100, 110, 110, ... 140, 140, 140, 140 etc.
Payment period: Every 2 months.
Number of periods: 5
Start date: Mar
Payment increment amount: 10
Initial payment: 100
Period: 1 2 3 4 5 6
Month: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb
Payment: 0 0 100 100 110 110 120 120 130 130 140 140 140 140