Below is the Excel so you can practice (you will need to download it by clicking on the download icon in the bottom border).
Don’t forget to see our other post on what increments you should be using. Enjoy.
Valuate automates all of this, and makes it look especially beautiful.
Try it for yourself in Valuate under Reports > Sensitivity Analysis
[…] less is more. While there are many applications of two-way data tables (see here for a free video tutorial and downloadable worksheet), one-way data tables are quite valuable and […]
I need help with a data table using IRR LTV -Rows Purchase price-Columns can you provide an example?
Hi Charles, watch the video above. Note that the data table must reside on the same tab as the tab on which your IRR output exists and on which your inputs for LTV and Purchase Price exist.