urgent

don't answer in excel

subject : financial system analysis

answer question 1

question 1:

You are asked to analyze the company financial statements from different perspectives to assess how the company is performing.

1-Analyse the profitability of the company.

To do that calculate for the las 3 years:

The return on total assets

The return on equity

The return on sales

June 30 , Assets Current assets: Cash and cash equivalents Short-term investments Accounts receitories to of allowance for doubtful accounts of $633 and $751 Total current assets Equity investments Goodwill Intangible assets, net Other long-term assets Total assets Liabilities and stockholders' equity Current liabilities: Accounts payable Current portion of long-term debt Accrued compensation Short-term income taxes Short-term unearned revenue Other current liabilities Total current liabilities Long-term debt Long-term income taxes Long-term unearned revenue Deferred income taxes Operating lease liabilities Other long-term liabilities Total liabilities Commitments and contingencies Stockholders' equity: Commonstockandpaid-incapital-sharesauthorized24,000;outstanding7,464and7,5RetainedearningsAccumulatedothercomprehensiveincome(loss)Totalstockholdersequity86.93984.281(4.678)166.54283.11157.0551.822141.98880.55234.5663.186118.304 Total liabilities and stockholders' equity $364.840$333.779$301.311 Statement of cash flows (In millions) Year Ended June 30, Operations Net income Adjustments to reconcile net income to net cash from operations: Depreciation, amortiration, and other stock-based compensation expense Net recognized gains on investments and derivatives Deferred income taxes Changes in operating assets and liabilities: Accounts receivable Inventories Other current assets Other long term assets Accounts payable Unearned revenue Income taxes Other current liabilities Other long-term liabilities Net cash from operations Financing Cash premium on debt exchange Repayments of debt Common stock issued Common stock repurchased Common stock cash dividends paid Other, net Net cash used in financing Investine Additions to property and equipment Acquisition of companies, net of cash acquired, and purchases of intangible and other assets Purchases of investments Maturities of investments Sales of investments Other, net Net cash used in investing Effect of foreign exchange rates on cash and cash equivalents Net change in cash and cash equivalents Cash and cash equivalents, beginning of period Cash and cash equivalents, and of period (In millions, except per share amounts) Year Ended Juna an You are asked to analyze the company financial statements from different perspectives to assess how the company is performing. - 1-Analyse the profitability of the company. - To do that calculate for the las 3 years: - The return on total assets (5 points) - The return on equity (5 points) - The return on sales (5 points) June 30 , Assets Current assets: Cash and cash equivalents Short-term investments Accounts receitories to of allowance for doubtful accounts of $633 and $751 Total current assets Equity investments Goodwill Intangible assets, net Other long-term assets Total assets Liabilities and stockholders' equity Current liabilities: Accounts payable Current portion of long-term debt Accrued compensation Short-term income taxes Short-term unearned revenue Other current liabilities Total current liabilities Long-term debt Long-term income taxes Long-term unearned revenue Deferred income taxes Operating lease liabilities Other long-term liabilities Total liabilities Commitments and contingencies Stockholders' equity: Commonstockandpaid-incapital-sharesauthorized24,000;outstanding7,464and7,5RetainedearningsAccumulatedothercomprehensiveincome(loss)Totalstockholdersequity86.93984.281(4.678)166.54283.11157.0551.822141.98880.55234.5663.186118.304 Total liabilities and stockholders' equity $364.840$333.779$301.311 Statement of cash flows (In millions) Year Ended June 30, Operations Net income Adjustments to reconcile net income to net cash from operations: Depreciation, amortiration, and other stock-based compensation expense Net recognized gains on investments and derivatives Deferred income taxes Changes in operating assets and liabilities: Accounts receivable Inventories Other current assets Other long term assets Accounts payable Unearned revenue Income taxes Other current liabilities Other long-term liabilities Net cash from operations Financing Cash premium on debt exchange Repayments of debt Common stock issued Common stock repurchased Common stock cash dividends paid Other, net Net cash used in financing Investine Additions to property and equipment Acquisition of companies, net of cash acquired, and purchases of intangible and other assets Purchases of investments Maturities of investments Sales of investments Other, net Net cash used in investing Effect of foreign exchange rates on cash and cash equivalents Net change in cash and cash equivalents Cash and cash equivalents, beginning of period Cash and cash equivalents, and of period (In millions, except per share amounts) Year Ended Juna an You are asked to analyze the company financial statements from different perspectives to assess how the company is performing. - 1-Analyse the profitability of the company. - To do that calculate for the las 3 years: - The return on total assets (5 points) - The return on equity (5 points) - The return on sales (5 points)