This is a tough one to give a proper title and to describe, but I'm going to take a stab.
Essentially I am ultimately trying to put together a cash flow forecast. On the 1st tab, I have an input field for launch date. On the 2nd tab I have my revenue assumptions by year 1 through year 5 and then peak. I've linked the date above year1 to the input launch date and then calculated based on that the associated year for year 2 through 5. Note that these years are based upon June 30 fiscal year. And on the last tab (cash flow), I've currently manually linked the revenue into the proper columns based on the launch columns. The 1st columns have zeros typed in and starting with year 6 and after the revenue is based upon peak revenue.
I'd like to be able to change the input launch date field and have the revenue shift appropriately on the cash flow tab. I think I could accomplish this with a bunch of embedded IF statements, but I hoping there might be a more efficient way.
I've attached a sample file to help illustrate what I'm trying to accomplish.
Bookmarks