英语论文网

留学生硕士论文 英国论文 日语论文 澳洲论文 Turnitin剽窃检测 英语论文发表 留学中国 欧美文学特区 论文寄售中心 论文翻译中心 我要定制

Bussiness ManagementMBAstrategyHuman ResourceMarketingHospitalityE-commerceInternational Tradingproject managementmedia managementLogisticsFinanceAccountingadvertisingLawBusiness LawEducationEconomicsBusiness Reportbusiness planresearch proposal

英语论文题目英语教学英语论文商务英语英语论文格式商务英语翻译广告英语商务英语商务英语教学英语翻译论文英美文学英语语言学文化交流中西方文化差异英语论文范文英语论文开题报告初中英语教学英语论文文献综述英语论文参考文献

ResumeRecommendation LetterMotivation LetterPSapplication letterMBA essayBusiness Letteradmission letter Offer letter

澳大利亚论文英国论文加拿大论文芬兰论文瑞典论文澳洲论文新西兰论文法国论文香港论文挪威论文美国论文泰国论文马来西亚论文台湾论文新加坡论文荷兰论文南非论文西班牙论文爱尔兰论文

小学英语教学初中英语教学英语语法高中英语教学大学英语教学听力口语英语阅读英语词汇学英语素质教育英语教育毕业英语教学法

英语论文开题报告英语毕业论文写作指导英语论文写作笔记handbook英语论文提纲英语论文参考文献英语论文文献综述Research Proposal代写留学论文代写留学作业代写Essay论文英语摘要英语论文任务书英语论文格式专业名词turnitin抄袭检查

temcet听力雅思考试托福考试GMATGRE职称英语理工卫生职称英语综合职称英语职称英语

经贸英语论文题目旅游英语论文题目大学英语论文题目中学英语论文题目小学英语论文题目英语文学论文题目英语教学论文题目英语语言学论文题目委婉语论文题目商务英语论文题目最新英语论文题目英语翻译论文题目英语跨文化论文题目

日本文学日本语言学商务日语日本历史日本经济怎样写日语论文日语论文写作格式日语教学日本社会文化日语开题报告日语论文选题

职称英语理工完形填空历年试题模拟试题补全短文概括大意词汇指导阅读理解例题习题卫生职称英语词汇指导完形填空概括大意历年试题阅读理解补全短文模拟试题例题习题综合职称英语完形填空历年试题模拟试题例题习题词汇指导阅读理解补全短文概括大意

商务英语翻译论文广告英语商务英语商务英语教学

无忧论文网

联系方式

uk finance assignment:Data-Yearly

论文作者:留学生论文网论文属性:作业 Assignment登出时间:2012-06-20编辑:dawm_zhong点击率:4816

论文字数:3778论文编号:org201206201605381657语种:英语 English地区:英国价格:免费论文

关键词:Data-YearlyDataAssignment

摘要:Assessed Coursework for the degree of MA Accounting and Finance, MSc Banking and Finance; MSc International Finance

 

Subject to external approval

 

Important:

This coursework is the formal assessment for LUBS5011. Note that you must only submit work that is wholly your own. Collaboration and working in teams is NOT permitted.

Please read the rules governing the submission of coursework, including penalties for late submission and the University's rules about plagiarism and cheating.

 

Assignment Details

 

Your assignment consists of two parts: Part I Excel Calculations (60%) and Part II Written essay (40%). You are required to submit both parts of your assignments before the deadline on 12 PM Thursday 17th December 2009.

The file contains three worksheets, “Summary Report”, “Data-Yearly” and “Data - Monthly”. The data worksheets contain the data that relates to the https://www.51lunwen.org/ukthesis.html coursework questions, whilst the “Summary Report” is a template into which you must place your answers to the requirements for Part I.

You should insert additional worksheets into the file, within which you are to carry out the calculations necessary to meet the requirements below.

When performing the necessary calculations never manually retype any of the information contained in the data worksheet, always use cell references, functions and/or formulae. Use in-built Excel functions whenever possible .

When completing the “Summary Report” worksheet never manually retype figures contained in other worksheets, always use cell references, functions and/or formulae.

You are encouraged to format the “Summary Report” worksheet. However, when doing so never move the location of the answering cells.

 

Required


1) The “Data - Yearly” worksheet contains yearly statistics which are exported from Berkshire Hathaway annual report. Use the data in the worksheet to complete the following requests. You can create additional worksheets for your calculation or do it on the data worksheet.

a) Format the return series in the “Data-Yearly” worksheet to show negative return in red and positive return in blue. Create a hyperlink to the “Data-Yearly” worksheet in cell C4 of the “Summary Report” worksheet.

b) Plot both return series in one chart; place the chart in a separate worksheet named “Yearly Chart”. Use formatting options to improve the presentation of the chart. Create a hyperlink to the Yearly Chart worksheet in cell C5 of the “Summary Report” worksheet.

c) Show how the overall gains (buy and hold return) 1964-2008 in cells B52 and C52 are calculated. The return series given in the worksheet “Data - Yearly” are simple returns. Reference your estimates of the overall gains in cells C8:D8 of the “Summary Report” worksheet.

d) Show how the Compounded Annual Gains in cells B51 and C51 are calculated. Reference https://www.51lunwen.org/ukessay/ your estimates of these gains in cells C9:D9 of the “Summary Report” worksheet.

e) Calculate the basic statistics of the two annual return series (Mean, Median, Min, Max, Variance, Standard deviation, Skewness, and Kurtosis). Reference your final estimates in cells C12:D19 of the “Summary Report” worksheet.

f) Draw frequency distributions of the two annual return series in a worksheet named “Frequency Distributions”. Create a hyperlink to this worksheet in cell C20 of the “Summary Report” worksheet.

g) Show in which year Berkshire and S&P500 have the best and wo论文英语论文网提供整理,提供论文代写英语论文代写代写论文代写英语论文代写留学生论文代写英文论文留学生论文代写相关核心关键词搜索。

共 1/3 页首页上一页123下一页尾页

英国英国 澳大利亚澳大利亚 美国美国 加拿大加拿大 新西兰新西兰 新加坡新加坡 香港香港 日本日本 韩国韩国 法国法国 德国德国 爱尔兰爱尔兰 瑞士瑞士 荷兰荷兰 俄罗斯俄罗斯 西班牙西班牙 马来西亚马来西亚 南非南非