Discussion Post: Financial Modeling
• On a tab named ‘Taxes', create a working version of the tab named ‘Taxes Template'.
• On a tab named ‘DDM', create a working version of ‘DDM Template'.
• Use the information on ‘Two Risky' to graph the efficient frontier. There should be 101 points on the graph.
• On the same tab as #3, allow the user to choose a preferred return and show the resulting risk and weights in MSFT and TGT. It should look something like:
Vol 15%
MSFT 75 %
TGT 25%
Total 100%
• Use the data on the Original Data tab to find five-year rolling betas for all available stocks.. Use the value-weighted index for your market proxy. Put your output in a tab named. "Betas".
The response should include a reference list. Using one-inch margins, Times New Roman 12 pnt font, double-space and APA style of writing and citations.