Hey all,
I'm working on a staggered time cash flow project. I'm trying to figure out a better way of calculating the formula in the yellow cells of the attached. The current formula works, but it is extremely manual and not very flexible. I'm 100% positive there is a better way of doing it, but have hit a mental block.
Any ideas?
The request should be pretty clear in the attached. ie find a better, more efficient formula for the yellow cells. I am not married to the current layout, and would actually like to put some things in Excel tables in case I want to do pivots or charts later.
Any help would be greatly appreciated.
Cheers.
Bookmarks