Contract vs PAYG Comparison.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Cost Comparison of Mobile Phone Contract (24 Months) vs PAYG
3
4
24 MONTH CONTRACTPAY AS YOU GO
5
6
Up Front Cost£29.00Up Front Cost£415.10
7
8
Monthly Cost£32.00Monthly Cost£15.00
9
10
DatePayments
Running Total
Payments
Running Total
Difference
11
1/12/2014£32.00£61.00£15.00£430.10-£369.10
12
1/1/2014£32.00£93.00£15.00£445.10-£352.10
13
1/2/2014£32.00£125.00£15.00£460.10-£335.10
14
1/3/2014£32.00£157.00£15.00£475.10-£318.10
15
1/4/2014£32.00£189.00£15.00£490.10-£301.10
16
1/5/2014£32.00£221.00£15.00£505.10-£284.10
17
1/6/2014£32.00£253.00£15.00£520.10-£267.10
18
1/7/2014£32.00£285.00£15.00£535.10-£250.10
19
1/8/2014£32.00£317.00£15.00£550.10-£233.10
20
1/9/2014£32.00£349.00£15.00£565.10-£216.10
21
1/10/2014£32.00£381.00£15.00£580.10-£199.10
22
1/11/2014£32.00£413.00£15.00£595.10-£182.10
23
1/12/2014£32.00£445.00£15.00£610.10-£165.10
24
1/1/2015£32.00£477.00£15.00£625.10-£148.10
25
1/2/2015£32.00£509.00£15.00£640.10-£131.10
26
1/3/2015£32.00£541.00£15.00£655.10-£114.10
27
1/4/2015£32.00£573.00£15.00£670.10-£97.10
28
1/5/2015£32.00£605.00£15.00£685.10-£80.10
29
1/6/2015£32.00£637.00£15.00£700.10-£63.10
30
1/7/2015£32.00£669.00£15.00£715.10-£46.10
31
1/8/2015£32.00£701.00£15.00£730.10-£29.10
32
1/9/2015£32.00£733.00£15.00£745.10-£12.10
33
1/10/2015£32.00£765.00£15.00£760.10£4.90
34
1/11/2015£32.00£797.00£15.00£775.10£21.90
35
36
Additional Notes:
37
In actual fact, upgrading early on PAYG would yield a greater profit as the early sale of the phone would generate more revenue (i.e. there would be less depreciation of the asset)
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
Loading...
Main menu