Thread: determine $Value by time periods

Hello-
I have an amortization schedule that is not calculating the correct amount per period.

For example, The area shaded in blue is the "input" area. The user needs to enter the # of months something should be amortized over. If there is something that cost $1,200 and it is to be spread out over 12 periods, then each month, from the beginning date, the amount would be $100 per period. In my example, line #8 the total cost is $100,000 and the # of periods it should be spread out over is 3. In the green shaded area, the amount in jan, feb and mar should be $33,333. I can't find the error with my statement where March would only return a value of $1,411.29.

Ideally I would also need to be able to expense more in one period if the "start date" is older than the current period. For example, if the first time something was recorded was say Jan 1, however the date it should have started was nov 1, then in january there should be 3 periods of expenses.

I'd prefer VBA code for this - however I can't figure that one out.

thanks in advance for your help!