Below are samples of various business models that utilize the concept of dynamic modeling, giving the user of the model the ability to adjust variables with the click of a button. All of the dynamic variables are located on one page along with a summary of the resulting effects. Such models are ideal for executive team meetings to throw what-if scenarios back and forth without having to redo the model, enter new numbers, or give multiple scenarios. A business model should be a one pager with variables and summary results together, with the back end calculations on other tabs if detail is requested.
         
 
  Simple mortgage calculator in Excel with sensitivity analysis, including property tax payment.