What is required is as follows

1- Analyze the firms' liquidity position in comparison with industry average.

2- Analyze the asset management position in comparison with industry average

3- Analyze the debt management in comparison with industry average.

4- Analyze the profitability position in comparison with industry average.

5- Use Solver to optimize any ratio. Please discuss the results before and after the optimization.

6- Please write your discussion in the same Excel sheet

-------------------------------------------------------------------------------------------------------------------------------------------------

What is required is as follows

1- Analyze the THREE sources of cash flow over years.

2- Please write your discussion in the same Excel sheet

2018 31/12 2019 31/12 733.94 733.94 1433.64 1433.64 2017 31/12 1554.65 1554.65 0 1378.45 176 2016 31/12 813.9 813.9 0 651.01 163 739.71 (6) 1301.58 132 824 1434.32 1537.34 791.49 72.24 114.94 147.72 66.54 0 0 0 AJWA for Food Industries Period Ending Total Revenue Revenue Other Revenue, Total Cost of Revenue, Total Gross Profit Total Operating Expenses Selling/General/Admin. Expenses, Total Research & Development EBIT Depreciation / Amortization Interest Expense (Income) - Net Operating Unusual Expense (Income) Other Operating Expenses, Total Operating Income Interest Income (Expense), Net Non- Operating Gain (Loss) on Sale of Assets Other, Net Net Income Before Taxes -78.01 0 0 17.12 0 28.48 0 96.35 0 0 0 0 0 0 3.81 8.38 -1.28 2.05 8.62 -90.44 9.42 -0.68 12.45 17.31 71.89 22.41 -0.16 5.04 3.04 18.91 0.45 5.34 -0.23 15.09 -1.03 -0.21 0.33 -90.27 10.15 35.21 40.08 17.05 39.95 34.81 -107.32 16.11 40.26 -30.11 -1.79 4.74 -2.18 5.27 -3.27 -91.21 -31.9 -6.92 2 Provision for Income Taxes Net Income After Taxes Minority Interest Equity In Affiliates U.S GAAP Adjustment Net Income Before Extraordinary Items Total Extraordinary Items Net Income Total Adjustments to Net Income Income Available to Common Excluding Extraordinary Items Dilution Adjustment Diluted Net Income Diluted Weighted Average Shares 0 0 0 -6.92 -91.21 -31.9 2 -31.9 -6.93 2.01 -91.22 0 -91.22 100.49 0 -31.9 100.48 0 -6.93 100.48 0 2.01 100.48 -0.91 -0.32 -0.07 0.02 Diluted EPS Excluding Extraordinary Items DPS - Common Stock Primary Issue Diluted Normalized EPS * In Millions of EGP (except for per share items) -0.88 -0.27 -0.08 0.04 2019 31/12 499 8 0 8.32 2018 31/12 402 86 0 85.56 2017 31/12 480 108 0 107.89 0 194.74 146.62 177.52 0 2016 31/12 412 129 0 129.01 412.25 Period Ending Total Current Assets Cash and Short Term Investments Cash Cash & Equivalents Short Term Investments Total Receivables, Net Accounts Receivables - Trade, Net Total Inventory Prepaid Expenses Other Current Assets, Total Total Assets Property/Plant/Equipment, Total 156.34 106.66 167.26 78.01 0 131.65 92.63 150.94 0 160.16 0 0 0 0 0 1996.30 2239.22 2307.87 2324.40 1548.31 1234.12 1539.52 1590.4 - Net 1234.12 1539.52 1548.31 1590.4 Property/Plant/Equipment, Total - Gross Accumulated Depreciation, Total Goodwill, Net Intangibles, Net Long Term Investments Note Receivable - Long Term Other Long Term Assets, Total Other Assets, Total Total Current Liabilities Accounts Payable Payable/Accrued Accrued Expenses Notes Payable/Short Term Debt Current Port of LT Debt/Capital Leases Other Current liabilities, Total Total Liabilities Total Long Term Debt Long Term Debt Capital Lease Obligations Deferred Income Tax Minority Interest Other Liabilities, Total 0 258.89 0 4.71 0 0 0 978.32 353.17 241.27 0 3.77 0 0 292.88 0 4.76 0 0 0 928.15 242.81 234.55 0 18.32 0 289.85 0 6.09 0 0 0 974.7 245.3 264.74 0 31.7 0 0 299.57 0 6.3 0 0 0 894.23 83.3 343.5 0 46.84 0 0 380.11 1,462 0 0 0 3.23 198.88 281.5 432.47 1549.04 2.39 2.39 0 22.42 314.49 281.59 432.96 1602.17 4.47 4.47 0 23.97 312.39 286.64 420.59 1537.39 3.67 3.67 0 20.33 326.55 292.61