Instructions: Do not insert or add rows or columns since the assignment will be auto-marked using formulas which will ex Only the answers entered into the yellow cells will be marked. Do not link this spreadsheet to other spreadsheets saved in different files since you will only be able to subn Choose any Australian or US listed firm that has 4 years of past financial reports available, is not a bank and Do not choose GameStop or Woolworths since these will be the examplars shown in the recorded classes. Note that only banks tend to have preferred stock. Australian companies have only one class of common sto it will complicate the process of finding the number of stock which is used to calculate the share price. Try to avoid choosing the same firm as your friends. Doing so and sharing files will result in serious plagiarism Side note: If you really want to, you can pick a US firm with multiple classes of stock, just be sure to calculate share price is equal to the equity market cap divided by this adjusted number of shares. Say the 1 million class A shares have 10 times the voting power and dividends as the 100 million class B mos You can download financial reports from the Yahoo finance website which is free and online. Copy these financial statements into your 'questions' spreadsheet tab under row 115. Re-arrange this data so that it's in ascending date order from left to right. Try to line the dates up with the di You should construct pro-forma income statements and balance sheets in the 'questions' spreadsheet tab ur Note that depreciation and amortisation may not be shown in the Yahoo finance data, which is a headache. After this, you might try extrapolationg the depreciation (and amortisation) expense into the future using, say Each week during Keith's Zoom class we'll walk through certain technically challenging sections of how to so The class will be recorded and posted to online for everyone to see. Not all questions will be discussed and answered in these classes or in the forums since we wish for you to d We encourage you to discuss the assignment with other students and teachers in class and in the forums. Co But be very careful not to send your assignment file to any other students. Plagiarism is looked upon as a very serious offense by the university and can result in failure of the course ar Do not re-use assignments submitted by students in past semesters, this is plagiarism. This assignment must Please submit the assignment online Reference for Q2c: Fernandez, Pablo and de Apellaniz, Eduardo and F. Acin, Javier, Survey: Market Risk Premium and Risk-Free R