Scenario Analysis with columns for Expected Scenario (this will be the same as your income statement, so link to the numbers on your income statement), Pessimistic Scenario, and Optimistic Scenario.
7 Hints for Developing a financial plan exhibits for a New Business When creating your spreadsheet, start by reviewing your business objectives and your planning assumptions. Do they make sense? Do you want to revise them?
Express your assumptions such that a number, for example, your membership fee, can be linked wherever appropriate throughout the Exhibits. All numbers showing in exhibits should be calculated by using formulas and links. This way you can easily change the numbers and see the effect on the spreadsheet. Have all pages of the spreadsheet linked and all in one file. Re-name and add sheets as needed.