Prepare analyze the common-size balance sheet for the last reported year. 2. Review the main sources of financing and uses of financing. Which are the main investments and the main sources of financing? 3. To further analyze investment and financial decisions consider the following questions: a. Short-term horizon How do current assets match with current liabilities? Are you concerned that current assets are not large enough to cover current obligations (liabilities)? b. Long-term horizon Which sources of financing are used to undertake long-term investment projects? For this part, compare: a) long-term assets to long-term liabilities & shareholders’ equity, and b) property, plant and equipment (PPE) to long-term debt (LTD). 4. In your opinion, is the mixture of long-term liabilities & shareholders’ equity appropriate given the nature of corporate assets (e.g., tangible and intangible assets) and the level of cash flow predictability (e.g., highly/less certain cash flows in less/more cyclical industries).
2 Internship Report2nd Balance sheet 1. Prepare analyze the common-size balance sheet for the last reported year. 2. Review the main sources of financing and uses of financing. Which are the main investments and the main sources of financing? 3. To further analyze investment and financial decisions consider the following questions: a. Short-term horizon How do current assets match with current liabilities? Are you concerned that current assets are not large enough to cover current obligations (liabilities)? b. Long-term horizon Which sources of financing are used to undertake long-term investment projects? For this part, compare: a) long-term assets to long-term liabilities & shareholders’ equity, and b) property, plant and equipment (PPE) to long-term debt (LTD). 4. In your opinion, is the mixture of long-term liabilities & shareholders’ equity appropriate given the nature of corporate assets (e.g., tangible and intangible assets) and the level of cash flow predictability (e.g., highly/less certain cash flows in less/more cyclical industries). Income Statement 1. Prepare the common-size income statement for the last reported year. 2. Review the main sources of expenses (e.g., large depreciation or interest expenses relative to total sales). 3. Do you find the profit margin high/low? (Note: You can use as a benchmark the profit margins in different industries) 4. Is it higher/lower than the industry peers? How would you explain the difference (i.e., diversified products, price-sensitive consumers, entry barriers) Instructions : 1. This project must be completed individually. 2. Write your name and ID number on the report’s first page. 3. Your analysis and report must be in bullet points with discussions. 4. All reports MUST be submitted MS Word file (No PDF file will be accepted) via the SafeAssign in the Blackboard to allow for plagiarism check, which MUST NOT exceed 15%. 5. Use the data available in the Qatar Stock Exchange, the company’s official website, and any other electronic references. 6. Use tables, graphs, charts and any other statistical data to support your answers. 7. Number of pages: 6 - 10. 8. Font type: Times New Roman, Font size: 12. Line spacing: 1.5. 9. The submission deadline is 10/06/2021 10. Failure to follow the above-mentioned instructions leads to losing some marks. 2 Internship Report3rd 1) Evaluating cash positions and cash flows trends (cash flow statement analysis): a. Examine the cash flow statement and its main blocks in the past three years (cash flows from operations, cash flows from investing and cash flows from financing activities). Do you find an addition to the cash balance? (A positive (negative) sign signifies that cash has been accumulated (disbursed from) to the cash balance); b. Compare the three sections of the cash flow statement. How do cash flows from operations compare to cash flows from investment activities and cash flows from financing activities? c. Which specific decisions explain changes in the CFI (cash flow from investing) and CFF (cash flows from financing) (e.g., new loans, issuing stocks, buying property, etc.) 2) Evaluating profitability from an investor’s perspective a. Calculate return on equity (Net income to equity) and its components using the ratio decomposition (return on assets and leverage). Which are the drivers of profitability? Interpret the trends over time. How the level of profitability using return on equity compares to selected peers? Would different business models explain the relative contribution of the drivers? How business conditions and industry dynamics affects the drivers of profitability? b. Decompose the return on assets (profit margin and asset turnover) to evaluate operating profitability. Which is the driver explaining changes over time in return on assets? How the trends differ across peers? Instructions : 1. This project must be completed individually. 2. Write your name and ID number on the report’s first page. 3. Your analysis and report must be in bullet points with discussions. 4. All reports MUST be submitted MS Word file (No PDF file will be accepted) via the SafeAssign in the Blackboard to allow for plagiarism check, which MUST NOT exceed 15%. 5. Use the data available in the Qatar Stock Exchange, the company’s official website, and any other electronic references. 6. Use tables, graphs, charts and any other statistical data to support your answers. 7. Number of pages: 6 - 10. 8. Font type: Times New Roman, Font size: 12. Line spacing: 1.5. 9. The submission deadline is 19/06/2021 10. Failure to follow the above-mentioned instructions leads to losing some marks. 4 Final Report Introduction The final reports provides an opportunity to reflect and synthesize the entire online internship experience as well as facilitate closure of the online internship experience. It should summarize your learning, assess overall success in achieving your learning objectives, and highlight any additional insights about the organization, industry, or career field. Task: Critically review and analyze the assigned company and individually work out a report. The report must be in bullet points with discussion and must include, but not limited to, the following: First: 1) The report of the auditors on the annual financial statements a) Since when was the last review performed? b) What does the reviewer say - conservative or not conservative? 2) The balance sheet A. Does the corporation have enough cash ready (see 'Cash in the bank' listed under current assets) to pay off its immediate debt (see creditors)? B. Is there a schedule for the collection period of accounts receivable? What do you conclude from that? C. How long can a company continue with its business if it loses all of its financing? (Calculate "survival rate - continuity") How does this compare to last year? 3) Calculating income and spending (or profit and loss) a) Are revenues and expenditures generally balanced? (Look for net income / spending) b) Is there a noticeable increase or decrease in activity levels (sales) from the previous year? c) What is the balance of expenses and direct costs against the costs and expenses of management and the Board of Directors? Is it reasonable for the size and nature of the company? 4) Are there any non-budgeted expenditures that may occur during the rest of the year? Or the next year? Second: Assuming that, due to the economic crisis caused by the Corona pandemic and the drop in oil and gas prices, the sales of the company assigned to you decreased by 10% during the fourth quarter of 2019 and the decline continued in the first and second quarters of 2020. In addition, assume that this situation resulted in a decrease in the company's net profit by 25% and an increase in the company's costs and expenses by 35% in the same period mentioned ( Attached is an Excel file for Qatari companies for the first Quarter 2020). A. As an investor and you have an amount of one million Qatari riyals, will you invest in the company designated for you by buying shares in the current circumstances, and why (knowing that the rate of return on fixed deposits in banks is 2% annually)? Will you invest in other sectors and companies on the Qatar Stock Exchange, and why? B. As an investor, will you invest in other sectors and companies on the Qatar Stock Exchange and why? 5 C. As the director of the company, what decisions will you take to deal with this situation during the year 2020 in terms of employees, products, prices, promotions, supply and storage chains ... etc. in order to control the costs and expenses of the company, increase sales, and preserve the profits of the company? D. As the manager of the company, what strategy / business strategies will you follow during the next three years to deal with the current situation and the expected future situation? E. As a credit manager in a commercial bank and the company has applied for a loan of 10 million Qatari riyals, will you agree to the loan in the current circumstances and why? Third: 1. Outline of the achieved learning outcomes and newly learned skills. 2. Major challenges faced during the online internship. 3. How you applied your classroom knowledge to the online internship experience. 4. How has this online internship reinforced or changed your career goals/focus? 5. What questions, assignments, or tasks were you expecting and would like to accomplish in this training? 6. What other websites and resources have you used to accomplish this training? 7. How could this experience be improved for students who take online internship in the future? Instructions 1. This project must be completed individually. 2. Write your name and ID number on the report’s first page. 3. Your analysis and report must be in bullet points with discussions. 4. All reports MUST be submitted MS Word file (No PDF file will be accepted) via the SafeAssign in the Blackboard to allow for plagiarism check, which MUST NOT exceed 15%. 5. Use the data available in the Qatar Stock Exchange, the company’s official website, and any other electronic references. 6. Use tables, graphs, charts, pictures and any other statistical data to support your answers. 7. Number of pages: 10 - 10. 8. Show all references used in your report. 9. Font type: Times New Roman. Font size: 12. 10. The submission deadline is 28/06/2021 11. Failure to follow the above-mentioned instructions leads to losing some marks. 2 First Internship Report 1. Provide general analysis about the selected Qatari company to include its business strategy and any recent developments (data can be obtained from Qatar Exchange website or Companies website in addition to using search engine). The analysis must include, but not limited to a. Company Managerial and organizational structure (Board of Directors); b. Company Vision and Goals c. Research and discuss the company industry (local, regional, and international) d. Company Challenges and Markets (company branches if applicable) e. Company products and services, Size (in terms of employees and assets) 2. Compare the selected company with one of its competitors (local or international) and benchmark in relation to assets, services, branches, and others. A comparison should include performance (profitability and sales) against major competitors and industry. Instructions : 1. This project must be completed individually. 2. Write your name and ID number on the report’s first page. 3. Your analysis and report must be in bullet points with discussions. 4. All reports MUST be submitted MS Word file (No PDF file will be accepted) via the SafeAssign in the Blackboard to allow for plagiarism check, which MUST NOT exceed 15%. 5. Use the data available in the Qatar Stock Exchange, the