14 May FINANCIAL MODELLING ASSIGNMENT 2015/16
Details: You will have to apply the skills youve learned during the lecture and tutorials and use excel to answer the assignment question. You must answer all your questions in one document i.e. in word, and provide screenshots or copy and paste all your workings from excel into the word document. You must not provide your answers in essay form. You are assessed on how you are able to use excel and how you are able to decompose the information it provides. Therefore your answers need to be clear and concise. Task Collect ten years (1/1/2005 31/12/2014) of daily closing prices for a company of your choice. a. What does the distribution of its daily log returns look like over the ten years? Please think of appropriate method to represent your data. Is assuming that log returns are normally distributed a reasonable assumption to make here? (Excels ‘Frequency function may be useful here). (40%) b. Using Monte Carlo simulations, with 10,000 runs, simulate the closing prices of the company you have chosen in 130 trading days from the last day in your sample i.e. in half a years time (260 trading days in a year). You will have 10,000 different estimated closing prices in half a years time. (Remember to calculate the a, µ, and s for the asset). What does the distribution of simulated closing prices look like? Does the assumption that stock prices are lognormally distributed hold? (40%) c. Imagine that on the last trading day (31/12/2014) you brought 100 shares of the firm you have selected. Using the simulations from part b., how much can you potentially loose on this investment in half a year with 1% certainty? (Excels ‘percentile function will be useful here). (20%) You need to consider carefully with your partner the best way to represent your data. Please state which company you have chosen. For part a. different companies have different return histories, therefore the history of one company is different to the history of another. You are required to go into depth into your analysis of the companys historical returns, i.e. has any extreme events occurred? For part b. think about what the starting stock price is where you begin your simulation, the value will depend on the company you have chosen, but use the most recent closing price as the start value for the simulations (should be 31/12/2014). Imagine that 31/12/2014 is t =0 or today, and we are simulating into the future. Benningas Financial Modelling textbook, may be useful. There are also various excel hints and tips online.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.