MCO201 CORPORATE FINANCE Task
ief & ru
ics
Final assessment Exam – Dashboard about investments
Details of the task as follow:
· Individual report in Pdf format is required
· The objective of the case is to be able to translate the key points and examples of the class to a real investment portfolio
· The instructions for the students are:
· You are called to build a dashboard and comment about your results to help an investor to decide where to allocate his funds
· To do that, you receive information regarding financial performance of some cu
encies against EUR, commodities, Index, cryptocu
encies and some tech-stocks from Dec 17th 2020 to January 15th 2021.
· The dashboard could be built using excel
· The Table of contents is based on:
· A dashboard that the students can build using their creativity for the design but in term of financials, it should respond to the following questions:
· What is the forecast of the following 5 days using the past 20 and 10 points of data
· Based on the forecast, what are the 1 or 2 best investments to hold and to short if the investor will take the decision based on the forecast of the day 5?
· Recommendations and conclusions explaining to the investor:
· Methodology and formulas to select and use the data
· Explanations to the management regarding forecast types and uses in the dashboard
· Exposure to the risk and mitigations actions
· Brief introduction of the main types of the investments
Formalities:
· Wordcount: 2500 words.
· Cover and Table of Contents are excluded of the total Wordcount.
· Font: Arial 12,5 pts.
· Text alignment: Justified.
· Please include the dashboard and numerical tables to justify your content.
Submission: Week 10 – Via Moodle (Turnitin)
Weight: This task is a 60% of your total grade for this subject.
It assesses the following learning outcomes:
· Evaluate the possibilities to pick the right investments based on financial methodologies as P/E Ratio
· Forecast and judge based on the numbers the risk behind Cryptocu
encies investments
· Assess and suggest mitigations actions for risk management
· Suggest a diversified portfolio including BETA analysis
Ru
ics
Descripto
9-10
The student demonstrates an excellent understanding of the concepts.
8-8.9
The student demonstrates a good understanding of the concepts.
7-7.9
The student demonstrates a fair understanding of the concepts.
6-6.9
The student demonstrates some, but insufficient understanding of the concepts.
3-5.9
The student demonstrates insufficient understanding of the concepts. They may mention some relevant ideas or concepts, although it is clear that the relationship between them is not understood by the student.
1-2.9
The student demonstrates insufficient understanding of the concepts and does not mention any relevant ideas or concepts.
0
The student leaves the question blank or cheats.
Points are stated at the end of each question.
DATA
D17 D18 D21 D22 D23 D24 D28 D29 D30 D31 J04 J05 J06 J07 J08 J11 J12 J13 J14 J15
USD 1.2256 1.2238 1.2203 1.2152 1.2197 1.2189 1.2234 1.2251 1.2267 1.2282 1.2285 1.2290 1.2332 1.2296 1.2233 1.2176 1.2155 1.2192 1.2164 1.2134
JPY 126.221 126.567 126.427 126.040 126.102 126.354 126.537 127.023 126.636 126.736 126.269 126.284 126.852 127.146 127.026 126.700 126.700 126.500 126.487 125.783
CHF 1.083 1.085 1.081 1.082 1.084 1.085 1.087 1.085 1.085 1.083 1.081 1.081 1.082 1.084 1.084 1.082 1.083 1.082 1.079 1.077
GBP 0.9027 0.9063 0.9207 0.9106 0.9077 0.8973 0.9021 0.9086 0.9036 0.8993 0.8977 0.9031 0.9043 0.9032 0.8996 0.9018 0.8970 0.8911 0.8913 0.8893
Gold 1,894 1,889 1,900 1,867 1,875 1,880 1,888 1,886 1,882 1,897 1,936 1,951 1,958 1,923 1,891 1,850 1,855 1,855 1,839 1,854
Silver 26.1 26.1 26.9 25.3 25.7 25.9 26.6 26.4 26.4 26.6 27.4 27.6 27.8 27.4 26.6 25.2 25.4 25.5 25.2 25.5
Petro Brent 51.34 52.09 50.27 49.96 49.88 50.81 51.50 51.46 51.39 51.28 53.15 51.67 53.94 54.49 54.75 55.36 56.03 56.86 55.75 55.45
Nikkei 26,807 26,763 26,714 26,436 26,525 26,668 26,854 27,568 27,444 27,444 27,258 27,159 27,056 27,490 28,139 28,139 28,164 28,457 28,698 28,519
Hang Seng 26,678 26,499 26,307 26,119 26,343 26,387 26,315 26,568 27,147 27,231 27,473 27,650 27,692 27,549 27,878 27,908 28,277 28,236 28,497 28,574
DAX 13,667 13,631 13,246 13,418 13,418 13,587 13,790 13,761 13,761 13,719 13,727 13,651 13,891 13,968 14,050 13,937 13,925 13,940 13,989 13,932
IBEX35 8,153 8,037 7,790 7,934 8,074 8,112 8,156 8,175 8,154 8,074 8,099 8,092 8,350 8,386 8,408 8,358 8,352 8,361 8,372 8,351
FTSE100 6,551 6,529 6,416 6,453 6,496 6,502 6,502 6,603 6,556 6,461 6,572 6,612 6,842 6,857 6,873 6,798 6,754 6,746 6,802 6,776
CAC40 5,549 5,528 5,393 5,467 5,528 5,522 5,588 5,612 5,599 5,551 5,589 5,565 5,631 5,670 5,707 5,662 5,651 5,662 5,681 5,650
FTSE MIB 22,012 21,976 21,411 21,844 21,844 22,130 22,289 22,259 22,259 22,233 22,316 22,201 22,734 22,746 22,794 22,722 22,646 22,744 22,638 22,685
Bitcoins 18,914 18,402 19,372 19,183 19,234 19,049 21,989 21,762 22,755 23,567 27,258 25,629 27,645 30,182 32,057 29,101 29,417 28,493 31,418 31,749
Ethereum 541 521 516 513 500 478 602 590 592 607 821 840 895 972 993 906 920 876 948 1,013
AMZN 3,240.96 3,236.08 3,201.65 3,206.18 3,206.52 3,185.27 3,172.69 3,283.96 3,322.00 3,285.85 3,256.93 3,186.63 3,218.51 3,138.38 3,162.16 3,182.70 3,114.21 3,120.83 3,165.89 3,127.47
NFLX 524.83 532.90 534.45 528.91 527.33 514.48 513.97 519.12 530.87 524.59 540.73 522.86 520.80 500.49 508.89 510.40 499.10 494.25 507.79 500.86
AMD 96.85 96.84 95.92 93.23 93.16 91.55 91.81 91.60 90.62 92.29 91.71 92.30 92.77 90.33 95.16 94.58 97.25 95.36 91.78 90.79
TSLA 622.77 655.90 695.00 649.86 640.34 645.98 661.77 663.69 665.99 694.78 705.67 729.77 735.11 755.98 816.04 880.02 811.19 849.44 854.41 845.00
ZM 404.00 401.62 406.01 408.97 409.00 383.88 375.17 351.39 353.75 353.40 337.32 359.98 360.83 344.41 342.50 349.61 337.71 356.81 364.63 383.24