I need help with a formula to show a linear ramp up of revenue and then optional ramp down of revenue over the term of a contract.
Term of agreement: cell A1
Steady state revenue: column F (start F3, example $100,000)
Billing start date: column C (start C3, example "3" formatted to "month 3")
Ramp up period: Column D (start D3, example "9" formatted to "month 9")
Steady state period: Column E (start E3, example "12" formatted to "month 12")
Ramp down period: Column E (start E3, example "3" formatted to "month 3")
So the end result should show the steady state revenue of $100,000 ramping up starting in month 3 and reaching steady state billing in month 12, then billing steady state at $100K for 12 months, then ramping down to $0 over 3 months. Each month of the term is in it's own column so month 3 would show 11,111, month 4 would be 22,222, month 5 33,333 etc. until $100,000 is reached in month 12.
The ramp down period might not be needed if the revenue would remain through the remainder of the term so if the ramp down period is blank or 0 then the $100K would just stay steady state for the rest of the term.
Term of agreement: cell A1
Steady state revenue: column F (start F3, example $100,000)
Billing start date: column C (start C3, example "3" formatted to "month 3")
Ramp up period: Column D (start D3, example "9" formatted to "month 9")
Steady state period: Column E (start E3, example "12" formatted to "month 12")
Ramp down period: Column E (start E3, example "3" formatted to "month 3")
So the end result should show the steady state revenue of $100,000 ramping up starting in month 3 and reaching steady state billing in month 12, then billing steady state at $100K for 12 months, then ramping down to $0 over 3 months. Each month of the term is in it's own column so month 3 would show 11,111, month 4 would be 22,222, month 5 33,333 etc. until $100,000 is reached in month 12.
The ramp down period might not be needed if the revenue would remain through the remainder of the term so if the ramp down period is blank or 0 then the $100K would just stay steady state for the rest of the term.
