Cash Flow Modeling

I have a worksheet that models a budget for a new business. I would like to take data from that worksheet and fill another worksheet. That is pretty simple. However, I'd like to have the option of delaying certain payments (think commissions paid) by a factor (say 90 days). To watch the effects of this I'd like to be able to change the factor and have data fill in different months.

For example, in the worksheet in Month 4 there is a value of 100,000 and Month 5 has 150,000, etc. My delay factor in a cell on the new worksheet is "3" which would represent 3 months. I would then ideally have the value from Month 4 (100,000) be put in month 7 and month 5 value (150,000) in Month 8and so on. What is the best way to accomplish this? I need to finish this relatively quickly so if all else fails I'll just hard code it (which I really want to avoid). Thanks for your help, wizards and gurus

If B1:D1 contains data, and you want a 1 period lag, try =OFFSET(C1,0,-1) in C2:E2, or vary as required.

Regards
Mike

I'm a little slow. Can you explain that formula to me in terms of what the operations are for offset? also, can i imbed the number (1 in this case) in another cell somewhere and use it?

Thank you for your help.

steve

Sure: =OFFSET(C1,0,-1)

Syntax = offset(cell ref, # of rows, number of columns)

C1 is the target value (nominal, ie starting in the required cell C1)
0 means don't offset any rows
-1 means take the actual value 1 cell to the left

the -1 can be stored in another cell and referenced instead.
using something like =OFFSET(C1,0,$A$24) - I used dollar signs so that when I copy this formula, that reference remains the same.

Regards
Mike