im going to attach file in chat
MCO201 CORPORATE FINANCE Task brief & rubrics 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 currencies against EUR, commodities, Index, cryptocurrencies 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 Cryptocurrencies investments · Assess and suggest mitigations actions for risk management · Suggest a diversified portfolio including BETA analysis Rubrics Descriptor 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 D17D18D21D22D23D24D28D29D30D31J04J05J06J07J08J11J12J13J14J15 USD1.22561.22381.22031.21521.21971.21891.22341.22511.22671.22821.22851.22901.23321.22961.22331.21761.21551.21921.21641.2134 JPY126.221126.567126.427126.040126.102126.354126.537127.023126.636126.736126.269126.284126.852127.146127.026126.700126.700126.500126.487125.783 CHF1.0831.0851.0811.0821.0841.0851.0871.0851.0851.0831.0811.0811.0821.0841.0841.0821.0831.0821.0791.077 GBP0.90270.90630.92070.91060.90770.89730.90210.90860.90360.89930.89770.90310.90430.90320.89960.90180.89700.89110.89130.8893 Gold1,8941,8891,9001,8671,8751,8801,8881,8861,8821,8971,9361,9511,9581,9231,8911,8501,8551,8551,8391,854 Silver26.126.126.925.325.725.926.626.426.426.627.427.627.827.426.625.225.425.525.225.5 Petro Brent51.3452.0950.2749.9649.8850.8151.5051.4651.3951.2853.1551.6753.9454.4954.7555.3656.0356.8655.7555.45 Nikkei26,80726,76326,71426,43626,52526,66826,85427,56827,44427,44427,25827,15927,05627,49028,13928,13928,16428,45728,69828,519 Hang Seng26,67826,49926,30726,11926,34326,38726,31526,56827,14727,23127,47327,65027,69227,54927,87827,90828,27728,23628,49728,574 DAX13,66713,63113,24613,41813,41813,58713,79013,76113,76113,71913,72713,65113,89113,96814,05013,93713,92513,94013,98913,932 IBEX358,1538,0377,7907,9348,0748,1128,1568,1758,1548,0748,0998,0928,3508,3868,4088,3588,3528,3618,3728,351 FTSE1006,5516,5296,4166,4536,4966,5026,5026,6036,5566,4616,5726,6126,8426,8576,8736,7986,7546,7466,8026,776 CAC405,5495,5285,3935,4675,5285,5225,5885,6125,5995,5515,5895,5655,6315,6705,7075,6625,6515,6625,6815,650 FTSE MIB22,01221,97621,41121,84421,84422,13022,28922,25922,25922,23322,31622,20122,73422,74622,79422,72222,64622,74422,63822,685 Bitcoins18,91418,40219,37219,18319,23419,04921,98921,76222,75523,56727,25825,62927,64530,18232,05729,10129,41728,49331,41831,749 Ethereum5415215165135004786025905926078218408959729939069208769481,013 AMZN3,240.963,236.083,201.653,206.183,206.523,185.273,172.693,283.963,322.003,285.853,256.933,186.633,218.513,138.383,162.163,182.703,114.213,120.833,165.893,127.47 NFLX524.83532.90534.45528.91527.33514.48513.97519.12530.87524.59540.73522.86520.80500.49508.89510.40499.10494.25507.79500.86 AMD96.8596.8495.9293.2393.1691.5591.8191.6090.6292.2991.7192.3092.7790.3395.1694.5897.2595.3691.7890.79 TSLA622.77655.90695.00649.86640.34645.98661.77663.69665.99694.78705.67729.77735.11755.98816.04880.02811.19849.44854.41845.00 ZM404.00401.62406.01408.97409.00383.88375.17351.39353.75353.40337.32359.98360.83344.41342.50349.61337.71356.81364.63383.24