For our example, we will analyze several financial scenarios. In the Excel document, I have defined the key input variables that will drive the scenario analysis: revenue growth, cost of goods sold, ...

Figure A We’ll use this simple mortgage calculator to demonstrate Excel’s Scenario Manager. Refer to Table A to build this sheet if you like, or download the example file.

This article provides example scenarios and explains various approaches for calculating the time value of money using Microsoft Excel. The Excel tools discussed herein include the FV, FVSCHEDULE, PV, ...

Task Management You can use conditional formatting for task management scenarios in Excel, but the most common application for me is highlighting overdue tasks.