Imagine that you are the asset manager for a major northern European Hub Airport. The airport is under strong competition from Amsterdam, Frankfurt, London, Madrid & Paris.
The probability of a winter snow closure is 0.333 per year. The downtime cost for the airport is 1m / day. In addition, the marketing department has estimated that reputation damage costs an additional 1m per closure.
With existing equipment it takes on average three days to clear snow during which time the airport has to be closed and penalties are incurred.
There is an option to buy new state of the art snow clearing equipment.
This equipment has been successfully used at Denver airport in the USA. It would cost 3m to buy and it would last 30 years if properly looked after and maintained. It is estimated that annual storage, upkeep, painting, maintenance and running costs for this equipment would be 50,000 per year. Training for drivers would be 10,000 initially and 500 / year thereafter. The snow clearance time with this equipment would be reduced from the current three days to one day.
Another option would be to lease the snow clearing equipment for 400,000 per year for a 30 year period. Under this option, the lease company would keep the equipment at the airport and undertake all maintenance and upkeep activities at their expense. You would still have to provide the drivers.
The airport finance department requires that all new investments have to make at least a 10% / year internal rate of return. It also states that a 5% discount rate has to be used in all financial calculations (this takes into account potential future inflation and the cost of raising capital).
Your task in this assignment is to consider the three available options:
1.    The status quo where no additional investment is made
2.    The purchase and upkeep of new snow clearing equipment
3.    The lease of new snow clearing equipment.
Fully discuss each of these three options. Consider all benefits, costs and risks associated with each one. Then state which would be your preferred option giving reasons. If you have to make any assumptions to complete your answer, then please state what these assumptions are and why you have made them.
For your information, the airport risk matrix is made available as a separate file: risk matrix.pdf.
As always report presentation and content are both important. Good diagrams and relevant photos always add impact. Make sure that your report has an abstract, contents page and section headings. Detailed descriptions of methodologies can be put in appendices so that the main report reads smoothly.
At least 5,000 words will be needed to adequately describe your analysis and recommendations. You will not be penalised if you feel that you need to use more words than the minimum.

the pdf explains everything but it wrote in italian and in english. You can use google translate to traslate the italian part of pdf. The exercise is only 3 ( not do the 4th ).
In the zip there is the project and it will very easy to complete if you are able to use java.
Thank you.

If you don’t understand some part in italian, also with using google maps, you can wrote me and I will explain to you

Format: Calculation and brief working or short answer with explanation as well as the calculation solved in an Excel spreadsheet. For each calculation you must provide a manual solution and a solution using excel. Typing straight into excel without doing the calculations in excel does not qualify as solving in excel. Use the excel template provided. Do all the assignment with explanations in excel and upload one file. Type your explanation and manual answer in text boxes.

Two answers one in Excel and one in a Text box
You must provide a full answer with explanation and accompanied with the calculation done manually and one done in Excel. See the example below.
1.    Manual answer as if you were answering the question in an exam (but typed). Include a time line or cash flow map/table, an explanation of the logic used to arrive at the answer, the formula used and then the calculations. The formula on its own followed by the answer is not enough.
2.    You must also do the solution in Excel. Typing the answer as a number into excel is not enough.
Do all the assignment with explanations in excel and upload one file. Type your explanation and manual answer in text boxes. Use the template provided. This is the preferred method.

Two answers one in Excel and one in a Text box
You must provide a full answer with explanation and accompanied with the calculation done manually and one done in Excel. See the example below.
1.    Manual answer as if you were answering the question in an exam (but typed). Include a time line or cash flow map/table, an explanation of the logic used to arrive at the answer, the formula used and then the calculations. The formula on its own followed by the answer is not enough.
2.    You must also do the solution in Excel. Typing the answer as a number into excel is not enough.
Do all the assignment with explanations in excel and upload one file. Type your explanation and

Groups should answer the questions provided by the instructor in the case in a PowerPoint presentation of 10-15 slides.  Summarize the case first and then proceed with the answers to the questions at the end of the case. The questions should be answered directly and comprehensively. Names should be displayed on the first slide. Finally wrap up your presentation with some concluding comments of the point of the case and what you learned (takeaways). Be sure to show the tables with your calculations for asset allocation. Be sure to discuss the answers to the questions in detail. You will not be presenting, the PowerPoint is just to turn in to me (emailed on CANVAS). Please use slide numbers on each slide.