Hello,
I have attached a spreadsheet that has forecasted monthly revenues out to six years. I have then summed each year to give annual revenues.
I would like to write a formula that shows how the annual revenues will change (go up in this case) if the monthly revenue is realized earlier e.g 5 weeks earlier (but I would like to be able to change this number to reflect different scenarios.
Does anyone have any idea how to do this?
Any help would be greatly appreciated.
Many thanks!
Bookmarks