Forum Discussion
Cash amortization table
Inspired by a video posted by PeterBartholomew1 on Youtube some years ago, I thought I could apply the technique covered in it on your cash projection problem. It's in the attached file and you don't need a row for each week. One single formula in B3 gives you the total projected collections for each week.
I wouldn't be surprised if Peter can come-up with an even better solution with some more years of Excel developments behind us.
One single formula in B3 gives you the total projected collections for each week.
One "single formula" made up of functions I've never before seen used! Good job, Riny_van_Eekelen , but can you explain it? Or do I need to view Peter's video?
I'm still at the level of Excel where I like to see intermediate steps, steps I can understand. But I always appreciate seeing these powerful examples of how much there is yet to learn.
Hope all is OK with you.
Thankfully, we are all doing well.
Yes, please look at Peter's video. It says it all 🙂
I've looked, and bookmarked the video to watch (along with the several others that Peter has done). One viewing, however, shows me that it's possible, but oh, my, I'd have to go through those steps again, repeating them with my own data (if I can find a situation where I'd use it) before fully understanding it.
So glad that there are people like you and Peter here on this site helping me to keep on learning.