IAB wants to invest a total of R4 375000 in the two entities by investing R1 954000 into Zeev, and the remaining amount in Nutritious. STEPS TO FOLLOW AND REQUIRED: 1. Open the "Expect Return" and "Risk" tabs on the Excel Answer Book you have been provided with on ColCampus. IAB have also determined the potential returns that could be made by purchasing ordinary shares in Zeev, together with the likelihood of the potential share manifesting. 4. On the tab "Interpretation", provide the reason for calculating a portfolio's covariance and give an interpret what occurred within the portfolio's covariance that you have calculated. Evidence required: Please submit the following as part of your completed assignment: - Excel Assignment - PDF version of all your completed sheets showing the amounts. - PDF version of all your completed sheets showing the formulas you used. To get the formula view of each of your sheets, go to Formulas > Show Formulas. Your sheet will change so that all the cells where you entered formulas now display the actual formula that you entered. Click on the "File" tab in Excel, then "Save As" and Zeev Ltd: Zeev Ltd ("Zeev") is an Indian clothes manufacturer that export to foreign countries. A large portion of Zeev's customer base that they export to consist of South African customers. 2. Perform research on the following Excel formulas: - Addition, Subtraction, Division and Multiplication - Square root and exponents - SUM-formula - Referencing between cells and between different Excel tabs - Absolute referencing - Covariance formula 3. By ONLY using the above formulas (amount typing is also not allowed), complete the Excel answer book ("Expected Return" and "Risk" tabs) by calculating the cells highlighted in yellow. save the document as a PDF. Very important: Ensure the borders of your Excel document is properly set before saving the Excel to PDF. You may inspect the borders by selecting the "View" tab in Excel and then "Page Break Preview". The borders will then be shown as dotted lines. If you would like to change them, click and drag them to the desired area. Once you have saved your Excel to PDF, inspect the PDF to ensure that the information on the PDF is not too small as it will hinder the visibility when grading. If too small, either change the borders or set the orientation of the Excel document's layout to landscape before producing a PDF document again. Invest-At-Best Ltd. ("IAB") is a South African investment entity. IAB is constantly evaluating various market segments and industries to proactivity identify promising entities or entities of which the shares are undervalued, to invest in. Two investment opportunities have recently come to the attention of IAB as potential investments - Nutritious Ltd and Zeev Ltd. Nutritious Ltd: Nutritious Ltd ("Nutritious") is a South African public company that grows and exports fruit to the international market. Among the foreign countries exported to, is India. IAB performed preliminary evaluations to determine the potential returns that could be made on an investment in Nutritious, as well as identified the likelihood of each of these potential returns. IAB wants to invest a total of R4 375000 in the two entities by investing R1 954000 into Zeev, and the remaining amount in Nutritious. STEPS TO FOLLOW AND REQUIRED: 1. Open the "Expect Return" and "Risk" tabs on the Excel Answer Book you have been provided with on ColCampus. IAB have also determined the potential returns that could be made by purchasing ordinary shares in Zeev, together with the likelihood of the potential share manifesting. 4. On the tab "Interpretation", provide the reason for calculating a portfolio's covariance and give an interpret what occurred within the portfolio's covariance that you have calculated. Evidence required: Please submit the following as part of your completed assignment: - Excel Assignment - PDF version of all your completed sheets showing the amounts. - PDF version of all your completed sheets showing the formulas you used. To get the formula view of each of your sheets, go to Formulas > Show Formulas. Your sheet will change so that all the cells where you entered formulas now display the actual formula that you entered. Click on the "File" tab in Excel, then "Save As" and Zeev Ltd: Zeev Ltd ("Zeev") is an Indian clothes manufacturer that export to foreign countries. A large portion of Zeev's customer base that they export to consist of South African customers. 2. Perform research on the following Excel formulas: - Addition, Subtraction, Division and Multiplication - Square root and exponents - SUM-formula - Referencing between cells and between different Excel tabs - Absolute referencing - Covariance formula 3. By ONLY using the above formulas (amount typing is also not allowed), complete the Excel answer book ("Expected Return" and "Risk" tabs) by calculating the cells highlighted in yellow. save the document as a PDF. Very important: Ensure the borders of your Excel document is properly set before saving the Excel to PDF. You may inspect the borders by selecting the "View" tab in Excel and then "Page Break Preview". The borders will then be shown as dotted lines. If you would like to change them, click and drag them to the desired area. Once you have saved your Excel to PDF, inspect the PDF to ensure that the information on the PDF is not too small as it will hinder the visibility when grading. If too small, either change the borders or set the orientation of the Excel document's layout to landscape before producing a PDF document again. Invest-At-Best Ltd. ("IAB") is a South African investment entity. IAB is constantly evaluating various market segments and industries to proactivity identify promising entities or entities of which the shares are undervalued, to invest in. Two investment opportunities have recently come to the attention of IAB as potential investments - Nutritious Ltd and Zeev Ltd. Nutritious Ltd: Nutritious Ltd ("Nutritious") is a South African public company that grows and exports fruit to the international market. Among the foreign countries exported to, is India. IAB performed preliminary evaluations to determine the potential returns that could be made on an investment in Nutritious, as well as identified the likelihood of each of these potential returns