论文题目：Major Assignment
论文语种：英文
您的研究方向：ＦＩＮＡＮＣＥ
是否有数据处理要求：否
您的国家：澳大利亚
您的学校背景：５星级大学
要求字数：没有字数要求 文章包括２个部分，一共１７页
论文用途：本科课程论文 BA Assignment
是否需要盲审（博士或硕士生有这个需要）：ukassignment@qq.com(1455780998)
补充要求和说明：附件里是format/printing & submission requirements (很重要)
FIN 221 Introductory Business Finance
Major Assignment
This manual outlines the followings.
•Objective of the assignment
•Details of questions (Instructions will be provided wherever necessary.)
•Format requirements
•Printing requirements
•Submission requirements
Objoctive of the Assignment
In Lecture 4 (CH7), you were introduced to the concept of “beta” which was to be used as a measurement of “Systematic risk”. We also defined it as the “sensitivity of stock returns to market returns”. A beta is a critical component in the estimation of required returns for shareholders as can be seen in the Capital Asset Pricing Model (CAPM). This assignment consists of two components. The first part of the assignment requires you to work with Excel and aims to take you through to the basic exercise of estimating a company beta and computing statistics which are relevant to your investment decision. The second part of the assignment requires you to write a report based on the outputs obtained from the first part and current events. Along the way, you will also find how to download historical share price and index data from online resources. To successfully complete this assignment, you are also expected to search actively for relevant current market information using various sources.
Details of Questions
PART 1
To successfully complete PART 1, please read each section carefully. You must read “Format and printing requirement” before you produce any outputs.
If you have read “Format and printing requirement”, then proceed.
•Provide your answers (or outputs) for the following questions.
•All the calculations and computations are required to be produced in Excel.
•Be prepared to use Excel worksheet functions if advised.
•Apart from what is provided here, any further guidance on the use of Excel functions will not be provided. For further help, students should use ‘Help’ function in Excel.
15012858052
153688106
