Posted: February 5th, 2015
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 🙂
79.
Cross functional Team
Project description
Discuss the individual contributions that could be made by a cross-functional team to the following list of activities. Assume the team consists of engineering,
manufacturing, and supply management personnel.
a. Specifications Development
b. Market Analysis
c. Productivity/cost improvements
d. Make or buy analysis
e. Determination of inventory levels
To kick this off let me say that being able to effectively participate and lead cross functional teams is critical to effectively implementing supply chain management.
Cross functional equates to diversity meaning that you have individuals with different skill sets and motivations (based on their respective organizations). Harnessing
this expertise and working through the natural barriers that exist is truly a challenge that requires effort to achieve the desired end state…that is to resolve
issues and problems and/or to deliver viable alternative solutions.
PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT 🙂
Place an order in 3 easy steps. Takes less than 5 mins.