Finanacial CASH FLOW ESTIMATION

Finanacial CASH FLOW ESTIMATION 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 !! regards, ---------- Added on 01.02.2015 14:26 I forgot to mention that you need to get the financial CASH FLOW estimation from the data given this is the assignment ! EXAMPLE of Cash flow estamitiation Balance Sheet 31/12/2012    31/12/2013 Cash    $5,000     $3,850 Account Receivable     $2,500     $1,750 Inventory     $2,750     $1,925 Fixed assets     $5,000     $3,025 Depreciation     ($3,250)    ($1,000) Total Assets     $12,000     $9,550 Account payable    $2,250     $1,850 operating Accruals     $1,450     $950 Accrued Interest     $850     $550 Deferred Taxes    $700     $650 Debt    $3,750     $2,550 Common Stock    $2,000     $2,000 Retained earnings     $1,000     $1,000 Total     $12,000     $9,550 Cash Flow Estimation Income Statement (31/3/2013)    Adjustment    Change    Cash Flow Sales    $49,000     (-) A/R    ($750)    $49,750 Cost of Goods Sold    $24,000     (-) A/P ($400) (+) Inventory     ($825)    $23,575 Gross Profit     $25,000     Gross Profit Margin     ($825)    $26,175 Salaries    $11,500 (-) Operating Accruals    ($500)    $13,400 Advertising    $1,400 Depreciation     $1,100     (-) Depreciation    ($2,250)     $ 3,350 Operating Profit     $11,000         $1,750     $9, 425 Interest     $1,200     (-) Accrued Interest     ($300)    $1,500 Taxes    $1,800     (-) Deferred Taxes    ($50)    $1,850 Net Profit     $8,000     Net Profit Margin     ($350)    $6,075 Dividends     $0 Additional to Retained Earning            $ 8,000 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 PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT :)