24/7 writing help on your phone
Save to my list
Remove from my list
Students these days tend to go on an exchange program to learn about a different country's and explore them. The aim of this report is to investigate as well as determine the financial requirements required for this person travelling to Berlin in Germany on an exchange program in April 2020.
It is my responsibility to conduct and create a personal budget for this person to ensure that they are 100% capable to attend Berlin in Germany in 2020. To create a budget for this person I will be creating a monthly budget using a Xcel spreadsheet.
This budget that will be created will be used to save and investigate for the upcoming trip in 2020. The total amount of savings required for Germany will include:
Once the calculations have been collected and I have calculated the amount of money required in Australian Dollars, the total amount of money required will need to be converted into Euro's.
For this specific calculation that I will be doing I will need to discover the conversion rate in Euro's once a week for the next three weeks to keep up to date with the rate and how it varies.
Causal Job (See appendix 1)
This person is currently undergoing a casual job at Kenmore Tavern as a bartender earning $25.28 per hour while doing a 12-hour week each week due to still being a school student there are restrictions on the number of hours you can work. (GOV.UK Child Employment).
Total Income - Maximum Allowable Hours
Flights in April in 2020 cannot be booked due to it still being a certain amount of time in advance. I have decided to go with flights in April 2019.
The most expensive flights were Turkish Airlines starting from $2933.00 return. Where the cheapest flights were Royal Dutch Airlines that started from $1554.00 return. There seems to be a big difference with prices as well as the layover's and duration of the flight. The Turkish airlines flight has layover's that are 3 hours where Royal Dutch airlines layovers were less than 3 hours long. Most flights seem to have 2 or more stopovers.
The flights that I have decided to go with is Air France Airlines return flight that starts from $1671.00 with a duration of just over 30 hours each way.
Travel insurance cost is $170.62 which includes overseas emergency assistance, medical assistance, cancellation, luggage, dental expenses, accidental death, permeant disability, hospital cash allowance, loss of income, etc.
$1671.00 + $170.62 = $1841.62
Above is the Airfares cost due to inflation increasing
Cost of the airfares are likely to increase in the next year and 2 months due to inflation rates. I will be investigating and calculating the increased future cost. I calculated the mean of the rate from 2016-2018.
1.3 x 1.9 x 1.9 = 1.6
From the calculations above it has shown the average inflation rate was 1.6% over the past three years.
By using the 2019 airfare and travel insurance cost of $1841.62 and then applying an increased price of 1.6% due to inflation will result in finding the predicted cost in 2020
Predicted cost in 2020
1.6 x $1841.62 = $29.46
= $1841.62 + $29.46 = $1871.08
The amount has been rounded to a total of $1880, which I will be using for my budget calculations.
I have decided to go with the Homestay website, www.homestay.com, I have come across accommodation starting from $60 per night which is $351 a week. This includes a max of a 30 night stay as well as 7 home cooked meals out of 21 nights and it is also only 9.4km away from the Berlin Centre.
As 2020 prices are not available at this time and day due to it still being over a year away, I will budget for $180 per day which will allow for eating out as well as home cooked meals at the homestay accommodation.
Accommodation at Homestay and some days of eating out for 14 days ( 8th April - 22nd April)
Accommodation = $351.00 x 3 = $1053.00
Food = $180 x 14 = $2520.00
$1053 + $2520 =
Total Accommodation and food cost = $3573
This person will need to be able to travel from their accommodation to their attractions in Germany as well as any other sights of Germany. Extra spending money of $100/ day for 21 days will also be budgeted for.
Extra Spending money = 21 x 100 = $2100
Extra spending money of $2100 needs to be converted to Euro's. The exchange rates tend to vary and change daily which would be an issue. It would be ideal for the person to keep up to date with the exchange rate frequently to keep up to date with it and eventually exchange cash when the rate is approving and at its best.
After the total amount of spending money has been determined and calculated in Australian dollars, it will then need to be converted into Euro's after investigating the exchange rate. An online calculator has been used to determine what the exchange rate will be.
Exchanging Australian Dollars for Euro's.
2100 x 0.63 = 1323
When they convert their $2100 into Euro's, they will then have 1323.00
10 year validity passport (for persons aged 16 and over) $293
This person will need to order a new passport 6 months prior to their trip in 2020 which is a total cost of $293.00 for them to be able to join their trip in 2020 to Germany.
This person's total regular income is $341.28 weekly from their casual job as a bartender.
Regular expenses (See appendix 6 for formula)
The person's regular expenses include phone bill, entertainment and extra spending for food or other necessitates. Estimated values for this person's budget are given in the spreadsheet below.
Can this person afford to attend the trip in 2020 to Germany?
By using the budget in the section 4.2 to save for costs required for the trip will help plan for the trip as well as keep saving accurately. According to the budget calculations that have been determined this person can 100% afford to travel to Germany, Berlin next year in April 2020. This person will have successfully saved the estimated amount needed.
The strengths are that the casual time job has successfully shown in the monthly budget that this person will be attending the trip. The total cost required included:
There have been no limitations found due to this person having the saving required for this trip. There could be issues in the future but with this person being finically stable they will be prepared.
Once this person returns home from their trip there may be some Euro currency unspent. It is being assumed that the amount remaining will be 5% of the amount originally budgeted for.
1323.00 x 5% = 661.50
661.50 x 1.59 = $1051.78
Remaining Euro's converted back to Australian Dollars would be $1051.78
(See Appendix for budget formula spreadsheet)
The amount required for trip is $8022.00
From the calculations that have been gathered from investigating this person's budget shows that they will have earned enough money in from February 2019 to April 2020 which is exactly 1 year and 2 months. Due to having a well-paid job to travel to Germany, Berlin on an exchange program in April 2020. The budget takes into consideration that prices are likely to increase due to inflation.
By April 2020 this person will have earned $13100.68. Due to having earned this amount of money this person we be able to afford this trip even if there were to be an issue there would be extra money to use
Exchange Program and Budgeting for Students. (2019, Dec 08). Retrieved from https://studymoose.com/exchange-program-and-budgeting-for-students-essay
👋 Hi! I’m your smart assistant Amy!
Don’t know where to start? Type your requirements and I’ll connect you to an academic expert within 3 minutes.
get help with your assignment