Posted: February 2nd, 2015

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 🙂