Question
I need help getting started with the sources and uses of funds statement. 1.Create an annual sources and uses of funds statement for Oracle. 2.When
I need help getting started with the sources and uses of funds statement.
1.Create an annual sources and uses of funds statement for Oracle.
2.When the above statement is completed and the balances tie out: -Adjust the change in PP&E for the year's depreciation expense to calculate capital expenditures.
-Consolidate the change in working capital accounts other than cash by adding together the changes in individual working capital accounts. BE ESPECIALLY MINDFUL OF USING THE CORRECT SIGNS.
-Similarly, consolidate changes in other operating assets and liabilities that would not be accounted for in other cash flow categories (i.e., investing or financing).
-Adjust the change in retained earnings to reflect its subcomponents and place those subcomponents in the appropriate "buckets" on the cash flow statement.
-Reorganize the rest of the adjusted sources and uses information to complete a properly formatted cash flow statement, using the required categories of operations, investing and financing and reconciling to the year's change in cash.
Oracle CorporationYear-over-Year Balance Sheet, May 31Amounts in $ MillionsSources & Uses StatementAssets20222023ChangesSources:Uses:Cash and Equivalents21,90210,187Accounts Receivable5,9536,915Prepaid Expenses and Other Current Assets3,7783,902Total Current Assets31,63321,004- Property, Plant & Equipment9,71617,069Goodwill and Intangible Assets45,25172,098Other long-term assets9,91511,987Total Assets96,515122,158- Total sources- Total usesLiabilities + EquityAccounts Payable and Accruals3,2613,257Short-term Debt and Current Maturities3,7494,061Assume net income of8,503Deferred Revenues8,3578,970Assume DD&A expense of6,108Other current liabilities4,1446,802Assume dividends and stock buy-backs of(4,787)Total Current Liabilities19,51123,090- Change in non-cash wkg capLong-term Debt and lease liabilities72,11086,420Change in other operating assets & liabsDeferred Income Taxes (net)5,4594,623Capital expendituresOther Long-term Liabilities5,2036,469Total Long-term Liabilities82,77297,512- Total Liabilities102,283120,602- Common Stock and APIC (net of Treasury stock)26,80830,215Retained Earnings(31,336)(27,620)Other comp. income and equity(1,240)(1,039)Total Shareholders Equity(5,768)1,556- Cash Flow StatementNet incomeDepreciation & AmortizationDeferred taxesOperating cash flow- Change in working capitalChange in other oper A&LCash flow from operations- Capital expendituresOther investmentsCash flow from investing- Additional debtAdditional equityDividends & share buybacksCash flow from financing- Change in cashStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started