amex overzicht.xlsx

	B	C	D	F	G	H	I	J	K	L	P	Q	R
1
2	American Express Worthiness Sheet										Reward profit realization
3		Unit	Year 1	Unit 2	Year 2	Year 3	Year 4	Year 5	Year 6	Year 7	Segment booked
4	Yearly fee in €	1	€ 377	1	€ 760	€ 760	€ 760	€ 760	€ 760	€ 760	Airline
5	Deduction 1	0	€ 0.00	0	€ 0.00						Booking Class
6	Deduction 2	0	€ 0.00	0	€ 0.00						Total miles cost	0	0
7	Sign up bonus/retention offer MR	0	€ 0	0	€ 0.00						Total MR used	0	0
8	Referral bonusses (30.000)	0	€ 0	0	€ 0.00						Additional taxes	€ 0	€ 0
9	Referral Bonusses (60.000)	0	€ 0	0	€ 0.00						Specific trip fare @ airline	€ 0	€ 0
10	New Referral Bonusses (20.000)	0	€ 0	0	€ 0.00						Cheapest alternative	€ 0	€ 0
11	Lounge accessed @ €30	0	€ 0	0	€ 0.00
12	MR earned through purchases	0	€ 0.00	0	€ 0.00						Profit with airline fare	€ 0	€ 0
13	Privium border check @ €10	0	€ 0	0	€ 0.00						Profit with cheapest alternative	€ 0	€ 0
14	Privium Priority Check-In @ €10	0	€ 0	0	€ 0.00
15	Privium Lounge Access @ €40	0	€ 0	0	€ 0.00						CPP with airline fare	#DIV/0!	#DIV/0!
16	LoungeBox On The Go @ €6	0	€ 0	0	€ 0.00						CPP with cheapest alternative	#DIV/0!	#DIV/0!
17	Dining Voucher in €	0	€ 0	0	€ 0.00
18	Hilton Breakfast @ €15	0	€ 0	0	€ 0.00
19	Hilton discounts (In €)	0	€ 0	0	€ 0.00
20
21
22	This years profit				€ 0.00
23	First year surplus on profit				-€ 377	€ -1,137	€ -1,897	€ -2,657	€ -3,417	€ -4,177
24
25	Total earned/utilized		€ 0		€ -377	€ -1,137	€ -1,897	€ -2,657	€ -3,417	€ -4,177
26	Total costs		€ 377		€ 760	€ 760	€ 760	€ 760	€ 760	€ 760
27
28	Total Profit		€ -377		€ -1,137	€ -1,897	€ -2,657	€ -3,417	€ -4,177	€ -4,937
29
30	Value per point in Euro	€ 0.004
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100