Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 cash

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Version 3.1

Authors: Joe Ben Hoyle, C.J. Skender, Leah Kratz

1st Edition

1453339442, 9781453339442

More Books

Students also viewed these Accounting questions

Question

What is involved in the administration of a labor agreement?

Answered: 1 week ago

Question

What are topics included in virtually all labor agreements?

Answered: 1 week ago