Finanacial CASH FLOW ESTIMATION

Finanacial CASH FLOW ESTIMATION attached a data sheet and an example sheet , kindly do the financial cash flow estimation using to years balance sheet & current year income statement . this assignment is about CASH FLOW Estimation - you are provided with data that include the income statement current year and balance sheet for current year and the one before , therefore you need to make a cash flow estimation , not Free CASH FLOW .. you will find the data given in the excel sheet attached & an example of this is also given and attached . please be sure that its the cash flow estimation !! Emirates NBD PJSC (EMIRATES UH) - Standardized In Millions of AED except Per Share    FY 2011    FY 2012    FY 2013    Last 12M 12 Months Ending    2011-12-31    2012-12-31    2013-12-31    2014-09-30 Cash From Operating Activities + Net Income    2,531.0    2,554.0    3,256.2    4,585.1 + D&A and Provision for Loan Losses    6,024.3    4,268.0    4,916.0    5,236.8 + Other Non-Cash Adjustments    -1,644.2    -256.7    -360.1    -831.4 + Changes in Non-Cash Capital    13,101.9    -3,350.8    -8,478.0    2,069.5 Cash From Operations    20,013.0    3,214.5    -665.8    11,060.1 Cash From Investing Activities + Disposal of Fixed Assets    0.0    0.0    0.0    0.0 + Capital Expenditures    -467.1    -193.0    -175.5    -227.6 + Increase in Investments    -1,101.0    -580.7    -261.5 + Decrease in Investments    0.0    1,781.4    0.0    3,678.1 + Change in Loans    -11,545.1    -18,788.9    -20,932.6    -18,024.4 + Other Investing Activities    1,565.1    69.5    2,275.7    2,567.8 Cash From Investing Activities    -11,548.2    -17,711.7    -19,093.9    -12,662.0 Cash from Financing Activities + Dividends Paid    -1,111.6    -1,110.4    -1,388.0    -1,388.0 + Change in Short-Term Borrowings    0.0    0.0    0.0    0.0 + Increase in Long-Term Borrowings    0.0    2,199.0    2,250.5 + Decrease In Long-Term Borrowings    -3,806.9    0.0    0.0 + Increase in Capital Stocks    0.0    0.0    3,648.5    1,828.6 + Decrease in Capital Stocks    0.0    0.0    0.0    0.0 + Change in Deposits    -6,658.0    20,614.4    17,961.9    21,036.2 + Other Financing Activities    1,365.8    -262.3    -385.4    -477.0 Cash from Financing Activities    -10,210.7    21,440.7    22,087.6    21,583.2 Net Changes in Cash    -1,745.9    6,943.4    2,327.9    19,981.4 Reference Items Free Cash Flow    19,545.9    3,021.5    -841.3    10,832.5 Free Cash Flow to Equity    15,738.9    5,220.5    1,409.2    11,415.9 Free Cash Flow per Basic Share    3.5    0.5    -0.2    1.9 Direct Method Cashflow Source: Bloomberg Balance Sheet (In Dollars) 12/31/2012    12/31/2013 Cash        30,771.9    38,355.0 + Interbanking Assets        17,478.4    20,587.2 + Short-Term Investments        15,066.0    17,101.7 Net Loans        218,161.4    238,344.1 Geographic Segmentation            238,344.1 GCC            228,751.2 Loans and receivables            196,722.0 Islamic financing receivables            32,029.2 International             9,592.9 Loans and receivables            9,268.2 Islamic financing receivables            324.7 Reserve for Losses on Loans        16,595.2    20,765.9 + Net Fixed Assets        1,559.1    1,594.5 + Other Assets        2,469.2    2,757.9 Product/Brand Segments        308,296.4    342,061.3 Government, Corporate & Commercial Banking        308,296.4    342,061.3 Retail Banking        194,443.9    204,303.0 Investment & Funds Management        31,475.8    39,286.8 Islamic Banking        36,975.5    38,704.7 Other        40,732.3    38,631.4 Cards Processing        4,668.8    21,135.3 UAE        308,296.4    342,061.3 International            39,050.2 Total Assets        1,065,773.5    1,943,613.2 + Interest Bearing Deposits        73,142.3    99,796.3 + Saving Deposits        139,426.5    136,745.0 + Time Deposits        17,971.8    27,236.8 + Other Deposits        121,454.7    109,508.3 + Customer Deposits        1,359.7    3,084.4 Geographic Segments        213,928.4    239,625.8 GCC        --    239,625.8 Customer deposits        --    219,081.8 Islamic customer deposits        --    175,138.0 International        --    43,943.9 Customer deposits        --    20,543.9 Islamic customer deposits        --    20,133.2 + ST Borrowings & Repos        --    410.7 + Other Short-Term Liabilities        22,899.7    23,704.5 + Long-Term Borrowings        13,364.4    12,419.0 + Other Long-Term Liabilities        20,863.8    23,778.1 + Total Preferred Equity        271,797.8    300,346.0 + Minority Interest        0.0    0.0 + Share Capital & APIC        46.3    4.5 Real Estate Loan        38,107.2    49,435.4 Other Loans        100,563.1    206,844.2 + Retained Earnings & Other Equity        30,894.5    36,153.0 Total Liability        1,065,773.9    1,943,613.2 Cash Flow Estimation -Emirates NBD PJSC (EMIRATES UH) - Standardized        (In Dollars) Income Statement- 31/12/2013        Adjustment     Change    Cash Flow Sales    12314.246         (-) A/R    9268.2    21,582.4 Cost of goods sold    9187.246        (-) A/P    818.6 (+) Inventory     2,757.0    11,415.9 Gross Profit    3127    Gross Profit margin    2,757.0    5884 Salaries    11856.179 (-)Operating Accruals    2,000.0    39,485.27 Advertising    16569.03 Appreciation    33764.9    (+) Appreciation    15,000.0    -18,764.00 Operating profit    9856        -13,000.00    -14,837.00 Interest    4652    (-) Accrued Interest    283.44    4,935.0 Taxes    41.124    (-) Deferred Taxes    0.0    41.124 Net Loss    -8118    Net Loss Margin    283.4    -13,788.0 Dividends    0 Additional to retained earning     0 PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT :)