March 10, 2016
The attached file contains 3 issues based on 3 offers from 3 credit card companies
I have to present the data to investors -
They want to know in any quantity what tickets will be revenue
For example, how much revenue will be in 1000 tickets - 100,000 in 10,000 jumps
My variables are - the amount of tickets + average expense per ticket
The end result that you want to see is the cumulative gain / loss - the lines are marked in yellow
How do you do this with a sensitivity table?
How do I create a 3-sheet sensitivity table?
I thank you very much for answering !!