Cash Flow Analysis

rs008f · Mar 10th, 2002, 03:55 PM

Below is an example of my spreadsheet.

Time 0 months (time required for profits to be earned)
Month 1 2 3 4 5 6 7 8....
Profits($)10 20 30 40 50 60 70 80....

My situation is as follows:
The profits depends of Time. If it is 5 months, then all the profits will be shited 5 months later; $10 would be appear under Month 6 and so on. Changing the # of Months will automatically shift the profits back and forth. What formula or tricks should I use to attain this. I tried using the IF function but it's too tedious and wasn't successful as it only allows 7 levels whereas there are 12 months(13 possibilities) in a year. Any advise would be great.

rs008f · Mar 10th, 2002, 09:11 PM

Was I clear enough or do I need to be more detailed?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 10th, 2002, 03:55 PM	#1
rs008f New Member Join Date: Mar 2002 Location: Rochetser, NY Posts: 7	Below is an example of my spreadsheet. Time 0 months (time required for profits to be earned) Month 1 2 3 4 5 6 7 8.... Profits($)10 20 30 40 50 60 70 80.... My situation is as follows: The profits depends of Time. If it is 5 months, then all the profits will be shited 5 months later; $10 would be appear under Month 6 and so on. Changing the # of Months will automatically shift the profits back and forth. What formula or tricks should I use to attain this. I tried using the IF function but it's too tedious and wasn't successful as it only allows 7 levels whereas there are 12 months(13 possibilities) in a year. Any advise would be great.

Mar 10th, 2002, 09:11 PM	#2
rs008f New Member Join Date: Mar 2002 Location: Rochetser, NY Posts: 7	Was I clear enough or do I need to be more detailed?