review on expenses 1997 - 2001
Post on 14-Jan-2016
35 Views
Preview:
DESCRIPTION
TRANSCRIPT
Review on expenses 1997 - 2001
Lund – London – Montreal – Marseille
Peter Platan
© Peter Platan 2
Definition of terms
Exchange ratesaverage
FIM/SEK 0,67EUR/SEK 0,11EUR/GBP 1,52EUR/CAD 0,69EUR/FRF 0,15
These figures cover the time period of 1.9.1997 – 31.12.2001 with the exception of summer periods (June-August). However, London is included for June – August, 1999.
The time period during which observations have been made includes 43 months in total.
All figures are in EUR and have been converted from local currencies. Exchange rates above.
Expenses have been classified in 9 categories:
Accommodation. Including rental expenses and all expenses related to accommodation such as electricity, water, telephone and heating expenses.
Food. Including all expenses for foodstuffs bought in e.g. supermarkets etc.
School. Including all expenses related to education such as books, copy fees, possible tuition etc.
Clothing. Including expenses for clothes.
Party. Relates to expenses for restaurants, night clubs, drinks, alcohol, entrance fees etc.
Sports. Expenses related to hobbies such as tennis, gym cards etc.
Lunch. Expenses from eating “out”. In other words, food bought and eaten in restaurants and cafeterias.
Travel. Travel expenses such as monthly bus cards, metro tickets, train tickets, airplane etc.
Other. Expenses not related to any of the categories mentioned above. Such as movie tickets, investments in fixed assets (e.g. kitchen utensils, stereo), postage expenses, gifts, extraordinary travel expenses (e.g. trips to Colombia, NYK, L.A, Caribbean), postage, dry cleaner etc.
© Peter Platan 3
Total expenses 1997 – 2001: 38,572 eur
302,2
99,1
30,7
28,8
99,4
17,0
47,7
56,9
215,4
897,0
0,0 100,0 200,0 300,0 400,0 500,0 600,0 700,0 800,0 900,0 1000,0
Accommodation
Food
School
Clothing
Party
Sports
Lunch
Travel
Other
Total average per month
eur / mth
38 572 eur
0
5 000
10 000
15 000
20 000
25 000
30 000
35 000
40 000
45 000
eur
Total expenses 1997 – 2001 Total average monthly expenses 1997 - 2001
© Peter Platan 4
Summary of total expenses
Total expenses for the period of 1.9.1997 – 31.12.2001 accumulate to EUR 38,572.
Average monthly expenses for the time period amount to EUR 897,0 per month.
The largest expenditure item is accommodation (33,7%) followed by other (24,0%) and party (11,1%).
A more detailed analyses is provided on the following pages.
The cities of residence during the time period of 1.9.1997 – 31.12.2001 are:
Lund 09/97 – 05/98
Lund 09/98 – 05/99
London 06/99 – 08/99
Montreal 09/99 – 05/00
Lund 09/00 – 12/00
Marseille 01/01 – 05/01
Lund 09/01 – 12/01
Grand Total Accommodation Food School Clothing Party Sports Lunch Travel Other Total1997 - 2001:
Total 12 992,7 4 259,7 1 318,8 1 238,1 4 275,5 728,9 2 051,9 2 444,9 9 261,4 38 572,0Average/mth 302,2 99,1 30,7 28,8 99,4 17,0 47,7 56,9 215,4 897,0
% of total 33,7 % 11,0 % 3,4 % 3,2 % 11,1 % 1,9 % 5,3 % 6,3 % 24,0 % 100,0 %
© Peter Platan 5
Funding
Expenses: Total expenses 38 573 €Average expenses on student loan(1 458 €Total expenses 39 031 €
Sources: Governmental student allowance 18 490 €Student loan 6 430 €Other private support 13 653 €Total sources 38 573 €
1) Assumed interest rate 4,75% p.a. on bullet type loan drawn during years 0-3 and repaid at end of year 3.
© Peter Platan 6
Average pay-back time
33 943
29 050
24 345
19 822
15 472
11 290
7 268
3 4010
0
5 000
10 000
15 000
20 000
25 000
30 000
35 000
40 000
1 2 3 4 5 6 7 8 9
Rem
ain
ing
ou
tsta
nin
d e
xpen
ses,
eu
r
The average monthly salary in Finland (year 2002) is approximately 2,220 eur.
Higher education should enable, on average, a 20% higher long-term monthly income. In other words, 444 eur higher income per month.
If the extra income is assumed to be utilised solely for the repayment of education expenses (here € 39,031) it would take 8,7 years to repay the total amount of education related expenses. Time value of money is accounted for (at 4% p.a).
Average pay-back time of total expenses 8,7 years.
Years
© Peter Platan 7
Total expenses per month 1997 - 2001
Total expenses for the period of 1.9.1997 – 31.12.2001 accumulate to EUR 38,572.
Average monthly expenditure for the period is EUR 897,0 per month.
0
200
400
600
800
1 000
1 200
1 400
1 600
1 800
2 000
09/9
711
/97
01/9
803
/98
05/9
810
/98
12/9
802
/99
04/9
906
/99
08/9
910
/99
12/9
902
/00
04/0
009
/00
11/0
001
/01
03/0
105
/01
10/0
112
/01
eur
Compounded monthly growth rate 0,4%
Total expenses by category 1997 - 2001
12 993
4 260
1 319 1 238
4 276
729
2 0522 445
9 261
0,0
2 000,0
4 000,0
6 000,0
8 000,0
10 000,0
12 000,0
14 000,0
Accommod. Food School Clothing Party Sports Lunch Travel Other
eu
r
302
99
31 29
99
17
48 57
215
0,0
50,0
100,0
150,0
200,0
250,0
300,0
350,0
Accommod. Food School Clothing Party Sports Lunch Travel Other
eur
/ m
th
Total average monthly expenses by category 1997 - 2001
© Peter Platan 9
Total average monthly expenses (%) by category
Accommodation
35 %
Clothing
3 %
Party
11 %
Sports
2 %
Lunch
5 %
Travel
6 %
Other
24 %
Food
11 %
School
3 % 1. Accommodation
2. Other
3. Food / Party
© Peter Platan 10
Total expenses by city
19 304
3 437
11 071
4 760
0
5 000
10 000
15 000
20 000
25 000
Lund London Montreal Marseille
eur 50%
9%
29%
12%
© Peter Platan 11
Average total monthly expenses by city and time period
644
799
1146
1230
822
952
759
0
200
400
600
800
1000
1200
1400
eur
/ mth
Lund 09/97-05/98
Lund 09/98-05/99
London 06/99-08/99
Montreal 09/99-05/00
Lund 09/00-12/00
Marseille 01/01-05/01
Lund 09/01-12/01
Highest monthly expenses in Montreal (eur 1,230 per month)
Lowest monthly expenses in Lund during first term (eur 644 per month)
© Peter Platan 12
Proportion of total expenses by city and time period
Lund 09/97-05/98
15 %
Lund 09/99-05/99
19 %
London 06/99-08/99
9 %Montreal 09/99-05/00
28 %
Lund 09/00-12/00
9 %
Marseille 01/01-05/01
12 %
Lund 09/01-12/01
8 %
Proportion of total expenses by cityCity and period % Expenses
Lund 09/97-05/98 15,0 % 5 795Lund 09/99-05/99 18,6 % 7 187London 06/99-08/99 8,9 % 3 437Montreal 09/99-05/00 28,7 % 11 071Lund 09/00-12/00 8,5 % 3 287Marseille 01/01-05/01 12,3 % 4 760Lund 09/01-12/01 7,9 % 3 035Total 100,0 % 38 572
© Peter Platan 13
275
243
274
392
272
371
260
0
50
100
150
200
250
300
350
400
450
eu
r /
mth
Lund 09/97-05/98
Lund 09/98-05/99
London 06/99-08/99
Montreal 09/99-05/00
Lund 09/00-12/00
Marseille 01/01-05/01
Lund 09/01-12/01
Average monthly accommodation expenses by city
Highest monthly expenses in Montreal (eur 392 per month)
Lowest monthly expenses in Lund during second term (eur 243 per month)
© Peter Platan 14
Average monthly food expenses by city
111
104
59
74
124
100
122
0
20
40
60
80
100
120
140
eu
r /
mth
Lund 09/97-05/98
Lund 09/98-05/99
London 06/99-08/99
Montreal 09/99-05/00
Lund 09/00-12/00
Marseille 01/01-05/01
Lund 09/01-12/01
Highest monthly expenses in Lund during fifth term (eur 124 per month)
Lowest monthly expenses in London (eur 59 per month). However, proportion of food expenses category low in London as most food was eaten out (e.g. restaurants etc. and classified as lunch).
© Peter Platan 15
Average monthly party expenses by city
72
87
274
96
77 75
119
0
50
100
150
200
250
300
eur
/ mth
Lund 09/97-05/98
Lund 09/98-05/99
London 06/99-08/99
Montreal 09/99-05/00
Lund 09/00-12/00
Marseille 01/01-05/01
Lund 09/01-12/01
Highest monthly expenses in London (eur 274 per month) !!
Lowest monthly expenses in Lund during first term (eur 243 per month)
No life in Lund during first term, too much in London in 3 months!
© Peter Platan 16
Average monthly lunch expenses by city
2328
102
66
72
58
29
0
20
40
60
80
100
120
eu
r /
mth
Lund 09/97-05/98
Lund 09/98-05/99
London 06/99-08/99
Montreal 09/99-05/00
Lund 09/00-12/00
Marseille 01/01-05/01
Lund 09/01-12/01
Highest monthly expenses in London (eur 102 per month)
Lowest monthly expenses in Lund during first term (eur 23 per month)
In line with food expenses as most of food was eaten out in London (eating out categorised as lunch expense).
© Peter Platan 17
Lund: Average expenditure pattern
Accommodation
36 %
Clothing
2 %
Party
11 %
Sports
2 %
Travel
7 %
Other
19 %
Lunch
4 %
School
4 %
Food
15 %1. Accommodation
2. Other
3. Food
© Peter Platan 18
London: Average expenditure pattern
Accommodation.
24 %
Clothing
8 %
Party
24 %
Sports
2 %
Travel
9 %
Other
19 %
Food
5 %
School
0 %Lunch
9 %
1. Accommodation / Party
2. Other
© Peter Platan 19
Montreal: Average expenditure pattern
Accommodation
32 %
Clothing
4 %Party
8 %
Sports
2 %
Other
36 %
Travel
2 %Lunch
5 %
School
5 %
Food
6 %
1. Other
2. Accommodation
3. Party
© Peter Platan 20
Marseille: Average expenditure pattern
Accommodation
39 %
Party
8 %
Other
25 %
Clothing
1 %
Sports
0 %
Food
11 %School
0 %
Lunch
6 %
Travel
10 %
1. Accommodation
2. Other
3. Food
© Peter Platan 21
Final Summary
All figures in eurosSummary Accommodation Food School Clothing Party Sports Lunch Travel Other Total
1997-2001:
Lund 6792,1 2915,0 765,4 467,5 2213,0 440,2 863,2 1409,6 3438,0 19 304,1
% 35,2 % 15,1 % 4,0 % 2,4 % 11,5 % 2,3 % 4,5 % 7,3 % 17,8 % 50 %
Average / mth 261,2 112,1 29,4 18,0 85,1 16,9 33,2 54,2 132,2 742,5
London 820,8 176,7 0,0 285,1 821,0 83,8 304,5 300,0 645,6 3 437,4
% 23,9 % 5,1 % 0,0 % 8,3 % 23,9 % 2,4 % 8,9 % 8,7 % 18,8 % 9 %
Average / mth 273,6 58,9 0,0 95,0 273,7 27,9 101,5 100,0 215,2 1 145,8
Montreal 3523,7 667,8 532,0 455,0 864,4 204,9 593,9 241,5 3987,7 11 070,8
% 31,8 % 6,0 % 4,8 % 4,1 % 7,8 % 1,9 % 5,4 % 2,2 % 36,0 % 29 %
Average / mth 391,5 74,2 59,1 50,6 96,0 22,8 66,0 26,8 443,1 1 230,1
Marseille 1856,2 500,2 21,4 30,5 377,2 0,0 290,3 493,8 1190,1 4 759,6
% 39,00 % 10,51 % 0,45 % 0,64 % 7,92 % 0,00 % 6,10 % 10,37 % 25,00 % 12 %
Average / mth 371,2 100,0 4,3 6,1 75,4 0,0 58,1 98,8 238,0 951,9
Total 12 992,7 4 259,7 1 318,8 1 238,1 4 275,5 728,9 2 051,9 2 444,9 9 261,4 38 572,0
% 33,7 % 11,0 % 3,4 % 3,2 % 11,1 % 1,9 % 5,3 % 6,3 % 24,0 % 100 %
Average / mth 302,2 99,1 30,7 28,8 99,4 17,0 47,7 56,9 215,4 897,0
top related