Please calculate the quintile returns, using the Excel file above, for:
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →Please calculate the quintile returns, using the Excel file above, for:
i. Average value weighted b/m returns (calculate the average return for the period 1980 through 2020)
ii. average equal-weighted b/m returns (calculate the average return for the period 1980 through 2020)
Find the average for the same period (calculate the average BE/MV for the period 1980 through 2020) as required below.
a.
Sum of BE / Sum of ME
b. Value Weight Average of BE / ME
When you do so in Excel the bar charts will populate, and you can draw conclusions about the returns for equal-weighted quintiles and value-weighted quintiles.
Please discuss what you’ve found in the data. Is there a relation between quintiles and average returns?
Please in your Excel file add your commentary about what you’ve found.
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds