Forum Moderators: phranque
a script or excel template or something along those lines that will projects next months payment based on the current trend of payments..does anyone know of a simple script or better yet an excel template that will do this?
thanks for any help.
if so, you can do a pretty trivial spreadsheet showing a column with various payments in each row, then in the next column calculate a % increase. your next month's estimated value would then be the last month's value times (1 + the average % increase for the past, say, three months).
if you have a lot of past history, you can get much more complex to accommodate seasonal variation, if any, etc.
i have been searching google ever since i posted and have yet to find anything.
it sounds like an easy thing to do in excel and im sure it wouldnt take notime, but i wouldnt know where to start.
If anyone is willing to help me I would be very thankful indeed! All I am looking for is an excel sheet where you type in the previous payments and it calculates the projected next month’s payment...
