Mr. Praveen Kumar Maheswari is the CFO at Hindalco Ltd a leading Aluminium producer and processor of Copper. The company has weathered the storm of the pandemic reasonably well. It is now looking to benefit from the easing of controls, growing burinsess volumes and the fact that India will perhaps be one of the largest growing economy in the world. At the same time he is deeply concerned with the turbulence in the markets, the ongoing War between Russia and Ukraine, the energy crisis world over, rapidly chaning climate issues, environmental disasters etc. He has a lot of questions that he will have to answer at the Board Meeting and hence is seeking your support and assistance to guide him in those answers. To help him with the answers you will need the following: The latest annual report of the company for the year ended 31st March 2022. The quarterly results for June 22 and September 22. Market report of the future of prices of copper and Aluminium. Historical prices of both the products. Market intelligence on the future of Aluminium and copper industry Your expectations of the future of currency prices and their volatility and expectations of interest rate globally and in India. From the annual report and those of the quarterly reports of the company and the articulation of the management in analyst meet you will help the CFO prepare a one year projection for the next four quarter starting from January 23 to Dec 23. In doing this projected statement you will estimate the quantity that they are likely to sell and the price they will realise and hence the turn over. Based on the turnover you will populate the rest of the income statement. You must note that the two business segment of Copper and Aluminium are different. Aluminium is manufactured by them from Alumina and sold in the market. In copper the company is a converter of copper to tubes, rods etc. Find out from the annual report this distinction in the business of the company. Once you have made the projections, you will make the following assumptions:

Q.a) The ratio of imports to total cost of goods sold and that of exports to total sales will remain the same as it was for the last financial year ending March 22.