Ali - thanks for directions on posting the file.


Quote Originally Posted by Glenn Kennedy View Post
"So in the FY18 box, I want the entry to calculate " where is it?

Show us (on the excel sheet) whhere these numbers are and how they are derived:

"I want the entry to calculate a payment of past sales equaling a multiplier times the last eight quarters (including the first quarter) which is 25% of FY16, all of FY17, and 75% of FY18. This would the payment for past sales, and to this I would add 25% of the FY18 forecast to represent a payment for Q4/FY18. FY19 and onwards would just be the forecast number."


Where will you be doing this:
"I can change either the year or quarter "
Hopefully the attached spreadsheet example provides the details you have requested. Columns D and E are where those two variables are changed.

Cory