Available for download from the final assessment folder are two csv files which contain daily unit prices for two Australia-based funds (labelled Fund A and Fund B) since inception. According to their fund profiles, they claim to be investing in high quality global companies including US big tech. a. For each of the data files, import the net asset value (NAV) as a Pandas dataframe. Fix any bugs in the data including ensuring there are no duplication in the dates. Once the data has been cleaned and sorted appropriately, compute the daily returns for each of the funds.(5 marks) b. Download the last 10 years of daily prices of NDQ.AX, an Exchange Traded Fund (ETF) on the Australian Stock Exchange that tracks the NASDAQ 100 index. Compute its daily returns.(5 marks)

use python to answer: c. Create a dataframe that holds the daily returns of the 2 funds as well as the ETF. Note that since the three time series have different lengths, when combining them in a dataframe using concat, the time series that has no record on a given date will have NaN value. Removing those rows will give you a database that contains dates that are common across the three series. Rename the columns appropriately and display the final dataframe.

he current realisable value per unit of mutual fund is known as ___________.(1.0 Marks)Net Asset Value (NAV)AEntry LoadBAssets Under Management (AUM)CNew Fund Offer (NFO)

use python to answer: File "fund_return.csv' contains the historical returns generated by an active fund manager over 2001-2021. File FF_Research_Factor_Data.csv contains historical returns on Fama-French's 3 factors. The files are available for download from the assessment's folder. a. Write a code to perform factor analysis on this manager using Fama-French's 3 factor model. Display the regression results. (10 marks) b. Based on your results in a), describe the investment style of this manager in terms of value versus growth and small stocks versus big stocks. What is their factor benchmark portfolio? Did the manager generate any positive alpha? (10 marks)

Additional question Your client, Macquarie Holdings, holds a large portfolio of investments in shares of other entities, approximately 80% of them being listed on the Australian Stock Exchange (ASX). Approximately 800 parcels of shares are held at any time.The following data on each share parcel is maintained on the share investment master file.Investment identification numberDate purchasedDate soldInvestee nameTotal number of shares purchasedNumber of shares soldNumber of shares currently heldInvestment cost for shares currently heldYear-end market value of shares heldProfit/loss on saleDividend income for the periodDividend income to dateThe above data is maintained on the IT system for a period of five years.Required:Identify the two (2) key assertions the auditor will need to address for ‘share investments’ account balance.Discuss how generalised audit software (GAS) other than exception reports, could assist in the audit of these investments for each of the assertions identified in (a) above. Provide an example of an exception report the auditor might create to gather evidence on the two assertions identified in (a) above.Outline one (1) practical programmed application control that you would expect to find in Macquarie Holding’s share investment master file.                                                                           Your answer to parts (a) and (b) should be presented in the following format.AssertionUse of GAS to Assist in the Audit1. 2.

The corpus collected by the mutual fund under a scheme is known as:2 pointsa) AUMb) NAVc) Unit Capitald) Deposits