A basic financial growth model

I would like to build a relatively simple Excel based model that allows someone to plus in the following variables: 1) their age 2) when they would like to exit their business (thus calculating how many years they will be in their business for) 3) how much they would like to receive when they retire / exit their business 4) their current revenue and profit (against which, we can plug in a variable multiplier to give an estimate of how much their business is worth 'now') 5) their historical annual growth rate The idea being that we are able to show a business owner how much their business will be worth in x years if they only continue to grow organically, or what their business value would be worth if they make an acquisition allowing for the compound growth of a larger business. I would like to keep the front worksheet quite simple with only a handful of 'inputs' and then these answers drive a table in a second sheet, which in turn drives an animated graph that ultimately shows: 1) the approximate value of their business now 2) the likely value of their business at the time they wish to exit 3) the amount they would 'like' it to be worth at retirement 4) the gap We can then use this data to go in to the model, and insert an acquisition and see what that does to the end result, or by changing some of the initial variables to influence a better result.