Hello All and thanks in advance,
I'm looking for assistance in two ways regarding a cashflow model I'm building on the revenue side F12:AO16.
Currently I'm able to capture the revenue and spread it over the appropriate months, calculated on the number of days to make each sale.
Question 1:
Is it possible to create a seasonal variation formula and link this to the corresponding qtr (e.g. Q3 will account for a greater percentage of annual revenue than Q1).
Question 2:
Is it possible to round up revenue so that each month's revenue corresponds to a full number of unit price sales?
Kind regards
Daniel
Bookmarks