Forum

Notifications
Clear all

Sensitivity Analysis - Question

2 Posts
1 Users
0 Reactions
113 Views
(@usb)
Posts: 244
Honorable Member
Topic starter
 

Hello,
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 !!
Leah

 
Posted : 11/07/2019 1:19 pm
(@usb)
Posts: 244
Honorable Member
Topic starter
 

I managed thanks!

 
Posted : 13/07/2019 8:44 am
Share: