Guidance to Task 3 (individual assignment)-3.xlsx - ACF5150...

ACF5150 TASK 3-Semester 1, 2018
This is an INDIVIDUAL assignment
You must read carefully all information provided in this sprea
You are given the following research question, hypothesis and equation.
Research Question: Does the firm size of IPO firm affect the stock returns on the first-day of
Hypothesis 1: The size of IPO firm is negatively associated with the stock returns on the firs
or
Hypothesis 1: IPO firms with larger size have lower stock returns on the first-day of trading
Equation to test hypothesis 1:
Please note that the variable of interest is firm size. The proxy of firm s
LNRETURNS = the dependent variable.
LNAGE, BIGN, LNBSIZE, and AUDCOM are control variables
ε = ERROR TERM
Required: Complete Task 3
To complete TASK 3, you should follow the following steps
Individual student should collect data of 21 IPO firms that list on the Australian Stock Excha
This is an INDIVIDUAL assignment
Your sample firms consist of firms listing on the time period which we randomly assign to yo
Arrange the data in the excel spread sheet. Please go to the SAMPLE data set p
Please read carefully each ABBREVIATION AND ITS DEFINITION
Prepare the descriptive statistics and run the regression analysis using "YOUR DATA SET". Pr
Report the results in Tables and interpret them. You should re
do not forget to provide the limitations of your findings
Print out your data set, the equation, abbreviations (labels) and definitions, th
All above documents should be submitted together with your assignment cove
Drop a hard copy of your assignment in the box provided at H3 Building by the
ALSO, email a soft copy of your assignment to the course's Chief Examiner
On line submission is NOT ALLOWED
LNRETURNi= β0 + β1 LNASSETSi + β2 LNAGEi + β3 BIGNi + β4

Important information how to obtain the data of your s
Source of main variables: IPO (Initial Public Offering) Prospectuses. How to download IPO p
Go to MyMonash and then choose library, search, go to data bases, click on 'D' from the pa
type ASX code for particular company and go to "ASX announcements" on the left hand side
Click "last" and find out the IPO prospectus from the annoucement entitled "Disclosure doc
How to download IPO firms list on the Australian Stock Exchange (ASX), go to libary ....... dat
In the main menu, click "search tool", go to "advance search". Go to section B and click "com
and then click "ASX Listing Date for SUB_SECTION, and then
type of term (s). If you would like to download the listing date of IPO firms from 1 January 2
For your sample selection, only choose companies and ignore FUND and TRUST
To obtain the closing price on the first-day of trading of an IPO firm on the stock exchange, g
Type company code (see get quotes, finance search) type ASX code of the company e.g., MY
Note: You need to put .AX after the ASX code; click "historical data" and then
enter an appropriate "Time period" to find out the closing price on the listing date of particu