Quiz 1’s Take-Home Makeup Quiz
• Who can take the make-up exam?
For those who did not get a A/A+ in Quiz 1, you can choose to do this makeup quiz. Your Excel quiz score will be the average of the original one and this make-up. Based on the new score, you may get A/B+/B/C/C+/D/D+/F, but not A+. If you already get an A/A+, you do not need to do the makeup quiz.
Check your score in Blackboard. If our TA noted that you get an A or A+, you do not need to take the make-up quiz.
• Deadline: April 03 Friday 10:00AM
• Submission:
You only need to submit an excel file, named QuizExcel2.PolyUID.LastName.FirstName.xlsm.
For example, your name is George Washington and your ID 1900000D, then the excel file to submit is QuizExcel2.1900000D.Washington.George.xlsm
• Question: Given the two risky assets and the riskless asset, we build a portfolio. The portfolio is composed on X% of riskless asset and (1-X%) of risky assets. Within the risky assets group, Y% will be allocated to SPY, and (1-Y%) will be allocated to TLT. In summary, riskless asset is x%; SPY is (1-X%) * Y%; TLT is (1-X%)*(1-Y%).
Instead of using data table, use VBA programming to calculate the portfolio return under different X% = (0, 10%, 20%, ……, 1) and Y% = (0,10%,20%, ……, 1)