Good afternoon, can anyone please provide me with a full method of DCF/ PV of FCFE for question 3 and with the calculations and graph please? Together, I would like to get the working procedure for the financial ratios. The company that we choose is WALMART;2016,2017 and quarterly 2018 analysis

You are one of the Senior Managers of a listed companies incorporated in Malaysia and your firm is planning to invest oversea (select a company listed on an internationally recognized and well established Stock Exchange and it must not be similar with other group). The Board of Directors has directed your management team to conduct a feasible study on the new undertaking and to come up with a proposal. The main goal of the study is to suggest a suitable country to invest in after considering all industry. economics, social, political, financial potential/risks. For Example ONLY: You firm involved in banking industry in Malaysia namely Malayan Banking Berhad. The BOD has required you and the management team to conduct research either it is beneficial or not for Maybank to expand their operating and investment in countries such as Germany. In order to do so, the BOD demands you to prepare proposal which must include all and not limited to the entire coursework requirement listed below. Year to year analysis (Max 3 years) of the coursework requirement below is necessary. Histogram, graph, table description is encouraging Coursework Requirement: n Explain how successful the company has been at delivering value to its shareholders over the past 3 years. Make sure to use appropriate metrics and benchmarks, for instance share price, dividend stability, growth & performance,etc. 2) SWOT Analysis (Both at firm and country levels) ) Undertake a current valuation of the equity in this company, using the following methods: Net Asset Value Discounted Free Cash Flow (including 3 years of detailed forecast cash flows and terminal value Capital Budgeting 5) Relevant ratio analysis 6) Source and estimated amount of financing 7Etc. (anything necessary) Choice of company Choose a listed company on a recognized stock exchange (e.g. London, New York, Tokyo, Mumbai, Shanghai) for which you can access the share price data over the past 3 years. Large companies will provide financial data on the websites, often under a section titled investors You are one of the Senior Managers of a listed companies incorporated in Malaysia and your firm is planning to invest oversea (select a company listed on an internationally recognized and well established Stock Exchange and it must not be similar with other group). The Board of Directors has directed your management team to conduct a feasible study on the new undertaking and to come up with a proposal. The main goal of the study is to suggest a suitable country to invest in after considering all industry. economics, social, political, financial potential/risks. For Example ONLY: You firm involved in banking industry in Malaysia namely Malayan Banking Berhad. The BOD has required you and the management team to conduct research either it is beneficial or not for Maybank to expand their operating and investment in countries such as Germany. In order to do so, the BOD demands you to prepare proposal which must include all and not limited to the entire coursework requirement listed below. Year to year analysis (Max 3 years) of the coursework requirement below is necessary. Histogram, graph, table description is encouraging Coursework Requirement: n Explain how successful the company has been at delivering value to its shareholders over the past 3 years. Make sure to use appropriate metrics and benchmarks, for instance share price, dividend stability, growth & performance,etc. 2) SWOT Analysis (Both at firm and country levels) ) Undertake a current valuation of the equity in this company, using the following methods: Net Asset Value Discounted Free Cash Flow (including 3 years of detailed forecast cash flows and terminal value Capital Budgeting 5) Relevant ratio analysis 6) Source and estimated amount of financing 7Etc. (anything necessary) Choice of company Choose a listed company on a recognized stock exchange (e.g. London, New York, Tokyo, Mumbai, Shanghai) for which you can access the share price data over the past 3 years. Large companies will provide financial data on the websites, often under a section titled investors