1a) Please compute the Aggregate Return and Aggregate Dispersion for Table 1 using Formula. (with accuracy...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1a) Please compute the Aggregate Return and Aggregate Dispersion for Table 1 using Formula. (with accuracy up to 3 decimal places in %) (4 marks) Table 1. End of Year 2017 2018 2019 2020 2021 Returns Client A 11% 10% 9% 8% Client B 10% 9% 8% 7% Client C 9% 8% 6% Asset Amount (in Smillion) Client A 50 55.500 61.050 66.545 71.868 Client B 100 110.000 119.900 129.492| 138.556 Client C 150 163.500 176.580 188.941 200.277 ТОTAL 300 329.000 357.530 384.977 410.702 Aggregate Return RaD18 R2019 R2020 R2021 Aggregate Dispersion G2021 1.b) Please compute the Aggregate Return and Aggregate Dispersion for Table 2 using Formula. (with accuracy up to 3 decimal places in %) (4 marks) Note that Client C terminated the account at the end of 2017 with balance of $163.5m. End of Year 2017 2018 2019 2020 2021 Returns Client A 11% 10% 9% 8% Client B 10% 9% 8% 7% Client C 9% Asset Amount (in $million) Client A 50 55.500 61.050 66.545 71.868 Client B 100 110.000 119.900 129.492 | 138.556 Client C 150 163.500 329.000 180.950 196.037 210.425 TOTAL 300 Aggregate Return R2019 Ra020 R021 Aggregate Dispersion O2019 O021 1.c) Under ethical reporting of investment performance, should the Fund Manager include or exclude the performance of Client C when he aggregates the returns of his clients for 2018, 2019, 2020 and 2021? Please fill in "Include" or "Exclude" in the table below (2 marks). 1.d) Should he use asset-weighted or equally-weighted when he computes the aggregate return? (2 marks] 1.e) Should he use asset-weighted or equally-weighted when he computes the aggregate dispersion? (2 marks) 1a) Please compute the Aggregate Return and Aggregate Dispersion for Table 1 using Formula. (with accuracy up to 3 decimal places in %) (4 marks) Table 1. End of Year 2017 2018 2019 2020 2021 Returns Client A 11% 10% 9% 8% Client B 10% 9% 8% 7% Client C 9% 8% 6% Asset Amount (in Smillion) Client A 50 55.500 61.050 66.545 71.868 Client B 100 110.000 119.900 129.492| 138.556 Client C 150 163.500 176.580 188.941 200.277 ТОTAL 300 329.000 357.530 384.977 410.702 Aggregate Return RaD18 R2019 R2020 R2021 Aggregate Dispersion G2021 1.b) Please compute the Aggregate Return and Aggregate Dispersion for Table 2 using Formula. (with accuracy up to 3 decimal places in %) (4 marks) Note that Client C terminated the account at the end of 2017 with balance of $163.5m. End of Year 2017 2018 2019 2020 2021 Returns Client A 11% 10% 9% 8% Client B 10% 9% 8% 7% Client C 9% Asset Amount (in $million) Client A 50 55.500 61.050 66.545 71.868 Client B 100 110.000 119.900 129.492 | 138.556 Client C 150 163.500 329.000 180.950 196.037 210.425 TOTAL 300 Aggregate Return R2019 Ra020 R021 Aggregate Dispersion O2019 O021 1.c) Under ethical reporting of investment performance, should the Fund Manager include or exclude the performance of Client C when he aggregates the returns of his clients for 2018, 2019, 2020 and 2021? Please fill in "Include" or "Exclude" in the table below (2 marks). 1.d) Should he use asset-weighted or equally-weighted when he computes the aggregate return? (2 marks] 1.e) Should he use asset-weighted or equally-weighted when he computes the aggregate dispersion? (2 marks)
Expert Answer:
Related Book For
College Mathematics for Business Economics Life Sciences and Social Sciences
ISBN: 978-0321614001
12th edition
Authors: Raymond A. Barnett, Michael R. Ziegler, Karl E. Byleen
Posted Date:
Students also viewed these accounting questions
-
Using Formula 71 on page 165, compute RF (risk-free rate). The real rate of return is 3 percent and the expected rate of inflation is 5 percent.
-
3 1 point Assume that 1 ton of greenhouse gas emissions does $100 of damage 30 years from now. If society has a discount rate of 1 per cent, what is the cost of that damage in today's terms? Give...
-
Amount in Dollars Amount in Dollars Sales 1 00 000 79 900 Cost of goods sold 47 500 39 950 Operating expenses 750 500 Selling expenses 9 500 9 000 Administrative expenses 12 000 12 000 Net income 30...
-
HL Co. uses the high-low method to derive a total cost formula. Using a range of units produced from 1,500 to 7,500, and a range of total costs from $21,000 to $45,000, producing 2,000 units will...
-
The purchasing manager is still concerned about the impact of price on sales. Write a query to display the brand name, brand type, product SKU, product description, and price of any products that are...
-
A machine costing $207,800 with a four-year life and an estimated $17,000 salvage value is installed in Luther Company's factory on January 1. The factory manager estimates the machine will produce...
-
What was the role of anthropology in colonialism?
-
Ramirez Company has the following data for the weekly payroll ending January 31. Employees are paid 1 times the regular hourly rate for all hours worked in excess of 40 hours per week. FICA taxes are...
-
Certain court decisions have defined the types of state antitakeover laws that are acceptable and those that are not. These decisions, which were recorded in the 1980s, are still relevant today....
-
Capstone Case: Sunrise Bakery Expansion The Sunrise Bakery Corporation was originally founded in Houston, TX in 1991 by Griffin Harris, who currently serves as the company's Chief Executive Officer....
-
Students need to understand the concepts of the following software process models: The waterfall is the first methodology generally acknowledged as being dedicated to software development. Its...
-
Take a copy of the above program, rename the class and modify the appropriate line so that the program accepts input from the standard input stream (i.e., using a Scanner around the standard input...
-
Write code to draw hearts, spades, clubs, and diamonds. To draw a heart, draw a filled diamond, then attach two filled semicircles to the upper left and upper right sides.
-
Write a program that takes an integer command-line argument n, reads n floating-point numbers from standard input, and prints their mean (average value) and sample standard deviation (square root of...
-
Write a program Checkerboard that takes an integer command-line argument n and uses a loop nested within a loop to print out a two-dimensional n-by-n checkerboard pattern with alternating spaces and...
-
What are the three typical levels of firm strategy?
-
Users and Views, Queries and BackupCompetencies: Creation and Design of MySQL Schema Objects Creating and modifying views List the benefits of using views Create a view Alter or drop a view Select...
-
Write a paper detailing a geographic information system (GIS) of your own design that would utilize data in an original manner.
-
In Problem, there is a tie for the choice of the first pivot column. Use the simplex method to solve each problem two different ways: first by choosing column 1 as the first pivot column, and then by...
-
The total profit (in dollars) from the sale of x gas grills is P(x) = 20x - 0.02x2 - 320 0 x 1,000 (A) Find the average profit per grill if 40 grills are produced. (B) Find the marginal average...
-
In Problems 37-52, find the area bounded by the graphs of the indicated equations over the given intervals (when stated). Compute answers to three decimal places.
-
A steel cylinder containing air has a closely fitted piston and a set of stops as shown in Fig. 3.7. The piston is loaded with certain weights. The air inside the cylinder is initially at...
-
What is the difference between compressed liquid and saturated liquid?
-
Calculate the molar volume of methane at \(773 \mathrm{~K}\) and 15 bar using the following methods: (a) Ideal gas equation of state (b) van der Waals equation of state, with \(a=0.2303...
Study smarter with the SolutionInn App