ACST6003: Principles of Finance
ASSIGNMENT – S1, 2020
Due date and time:
Friday May 15, 2020 at 11:59pm via iLearn
Instructions – Read Carefully Before Attempting the Assignment
• Provide your answers in the worksheets contained within the acst6003-assignment.xlsx file
1. Each worksheet is named after a question you need to answer, e.g. answer
question 7 in worksheet Q7
• When presenting or commenting on your results, format excel cells to round off numbers
to 3 decimal places but use whole numbers (not rounded off) in subsequent
computations
• When asked to comment on your results it is sufficient to write 3-4 lines of comment
• Fill out the Assignment cover sheet with your details (no need to sign)
• Your assignment submission needs to include only two files:
1. Filled out Assignment cover sheet
2. Completed acst6003-assignment.xlsx file
• Assignment is to be submitted electronically via iLearn
Total number of marks: 30
Total number of questions: 12
Data Description
Excel file acst6003-assignment.xlsx contains the following data:
• Annual yields on 30 day bank accepted bills (prices worksheet)
• All Ordinaries Share price index (prices worksheet)
• Share prices of Insurance Australia Group Limited (IAG) and Macquarie Group Limited
(MQG) (prices worksheet)
• Dividends for IAG (dividends worksheet)
• Dividends for MQG (dividends worksheet)
Questions
1. Calculate monthly returns for the All Ordinaries (
The post ACST6003: Principles of Finance appeared first on My Assignment Online.