Project Analysis (Excel): Ali Yaqoob Yusuf Ali graduated from University of Bahrain, College of Business Administration in July and has been working for about a month as a Junior Financial Analyst at Aluminium Bahrain B.S.C. (#ALBA), one of the largest and most modern aluminium smelters in the world. When Ali arrived at work on Thursday morning, he found the following memo in his e-mail: To: Ali Yaqoob Yusuf alod From: Bryan Harris, Chief Financial Officer, ALBA RE Capital Budgeting Analysis Provide an evaluation of three proposed projects whose cash flow forecasts are found below. Potline 7a Potline 7 Potline 7 Initial Outlay BHD 11,000,000) BHD (16,950,000) BHD 14,100,000) Year 1 3,000,000 8.100.000 3,900,000 Year 2 3,000,000 2.900.000 3,900.000 Year 3 4,000,000 4.400.000 3.900,000 Year 4 (1,400.000) 3,900.000 Year 5 7,000 000 8.100.000 3.900.000 Year 6 7000.000 8.100.000 3.900.000 Aluminum for the world www.albasmelter.com 0