Using the same publicly traded company you used in the Environmental Scanning Interactive Assignment, and the downloadable Operating Budget Template 4. research the company online by accessing the Mergent University of Arizona Global Campus Library online database which offers company financials, descriptions, history, property, subsidiaries, officers and directors. Also, access the Business Insights: Global University of Arizona Global CampusLibrary online database which offers information on global companies, and industries. It includes SWOT reports, market share data, financial reports, case studies business news, and company comparison charts. (View the Getting Started With. Mergent B and Business Insights: Global B documents for suggested methods of searching University of Arizona Global Campus Library databases generally as well as specific advice for searching these two databases). You can always conduct research using credible online sources of corporate financial information, just be sure that wherever you obtain financial information that you cite your source. For this Interactive Assigmment, you are going to look at the financial statements for the company you selected and, using the previous quarter's financial data, interpret the data and propose a budget for the next Quarter based on your current and previous analysis of company performance. Complete the budget template using this Ooeratios. Budget Temolate t : - List your current sales, discounts and allowances, net sales, margins, operating costs, and earning before and after taxes, - Choose a minimum of two firancial ratios (below) and include in your analysis. - Prepare the next quarter's budget based on yout interpretation of past data. Include at least two of the following types of relevant financial ratios in your analysis. Review the online article Analyze investinents Quichly With Ratios. C. (Elmerrai, 2017) and Chapter 5 in the Abraham's textbook to help with this portion of the budget: - Proftability Ratio - Liquidity Ratio - Solvency Ratio - Valuation Ratio - Leverage Ratio Combany Name: Onerating Budeet OI Net sales: Products Services Total net sales Cost of sales: Products Services Total cost of sales Gross margin \begin{tabular}{rrrr} 46,387 & 42,790 & 201,471 & 192,266 \\ 5,664 & 5,396 & 22,075 & 20,715 \\ \hline 52,051 & 48,186 & 223,546 & 212,961 \\ \hline 38,095 & 35,174 \\ \hline \end{tabular} Operating expenses: Research and development Selling, general and administrative Total operating expenses \begin{tabular}{rrrr} 6,761 & 5,772 & 26,251 & 21,914 \\ 6,440 & 5,616 & 25,094 & 21,973 \\ \hline 13,201 & 11,388 & 51,345 \\ \hline \end{tabular} Operating income Other income/(expense), net Income before provision for income taxes Provision for income taves Net income Earnings per share: Basle Diluted \begin{tabular}{l|lllllll} $ & 129 & $ & 125 & $ & 6.15 & 5 & 5.67 \\ $ & 129 & 5 & 124 & 5 & 6.11 & 5 & 5.61 \end{tabular} Sharet used in computing earnings por share: Basic Diluted \begin{tabular}{|llll} 16,030,382 & 16,487,121 & 16,215,963 & 16,701,272 \\ 16,118,465 & 16,635,097 & 16,325,819 & 16,864,919 \end{tabular} (vet sales by reportable segment: Americas Europe Greater China Japan Rest of Asia Pacific Total net sales NNet sales by calegory? iphone Mac Pad Wearables, Home and Accessaries Services Total net sales CONDENSED CONSOLIDATED BALANCE SHEETS (Unaudited) (In millions, except number of shares which are reflected in thousands and par value) Cash, cash equivalents and restricted cash, beginning balances Operating activities: Net income 99,80394,680 Adjustments to reconcile net income to cash generated by operating activities: Depreciation and amortization Share-based compensation expense Deferred income tax expense/(benefit) Other 11,1049,03889511111,2847,906(4,774)(747) Changes in operating assets and liabilities: Accounts recelvable, net Inventories Vendor non-trade recelvables Other current and non-current assets Accounts payable Deferred revenue Other current and non-cument liablities Cash generated by operating activities \begin{tabular}{rr} (1,823) & (10,125) \\ 1,484 & (2,642) \\ (7,520) & (3,903) \\ (6,499) & (8,042) \\ 9,448 & 12,326 \\ 478 & 1,676 \\ 5,632 & 5,799 \\ \hline 122,151 \\ \hline \end{tabular} Ifvesting activities: Purchases of marketable securities Proceeds from maturities of marketable securities Proceeds from sales of marketable securities Payments for acquisition of property, plant and equipment Payments made in connection with business acquisitions, net Other Cath used in ifverting activities (22,354)(1,780)(14,545)(352) Financing activities: Payments foc taces related to net share settlement of equity awards Payments for dividends and dividend equivalents Repurchases of common stock Proceeds from issuance of term debt, net Repayments of term debt Proceeds from commercial paper, net Other Cash used in financing activities Decrease in cash, cash equivalents and restricted cash Cash, cash equivalents and restricted cash, ending bolances Supplemental cash fiow disclosure Cash paid for income taxes, net Cash paid for interest Using the same publicly traded company you used in the Environmental Scanning Interactive Assignment, and the downloadable Operating Budget Template 4. research the company online by accessing the Mergent University of Arizona Global Campus Library online database which offers company financials, descriptions, history, property, subsidiaries, officers and directors. Also, access the Business Insights: Global University of Arizona Global CampusLibrary online database which offers information on global companies, and industries. It includes SWOT reports, market share data, financial reports, case studies business news, and company comparison charts. (View the Getting Started With. Mergent B and Business Insights: Global B documents for suggested methods of searching University of Arizona Global Campus Library databases generally as well as specific advice for searching these two databases). You can always conduct research using credible online sources of corporate financial information, just be sure that wherever you obtain financial information that you cite your source. For this Interactive Assigmment, you are going to look at the financial statements for the company you selected and, using the previous quarter's financial data, interpret the data and propose a budget for the next Quarter based on your current and previous analysis of company performance. Complete the budget template using this Ooeratios. Budget Temolate t : - List your current sales, discounts and allowances, net sales, margins, operating costs, and earning before and after taxes, - Choose a minimum of two firancial ratios (below) and include in your analysis. - Prepare the next quarter's budget based on yout interpretation of past data. Include at least two of the following types of relevant financial ratios in your analysis. Review the online article Analyze investinents Quichly With Ratios. C. (Elmerrai, 2017) and Chapter 5 in the Abraham's textbook to help with this portion of the budget: - Proftability Ratio - Liquidity Ratio - Solvency Ratio - Valuation Ratio - Leverage Ratio Combany Name: Onerating Budeet OI Net sales: Products Services Total net sales Cost of sales: Products Services Total cost of sales Gross margin \begin{tabular}{rrrr} 46,387 & 42,790 & 201,471 & 192,266 \\ 5,664 & 5,396 & 22,075 & 20,715 \\ \hline 52,051 & 48,186 & 223,546 & 212,961 \\ \hline 38,095 & 35,174 \\ \hline \end{tabular} Operating expenses: Research and development Selling, general and administrative Total operating expenses \begin{tabular}{rrrr} 6,761 & 5,772 & 26,251 & 21,914 \\ 6,440 & 5,616 & 25,094 & 21,973 \\ \hline 13,201 & 11,388 & 51,345 \\ \hline \end{tabular} Operating income Other income/(expense), net Income before provision for income taxes Provision for income taves Net income Earnings per share: Basle Diluted \begin{tabular}{l|lllllll} $ & 129 & $ & 125 & $ & 6.15 & 5 & 5.67 \\ $ & 129 & 5 & 124 & 5 & 6.11 & 5 & 5.61 \end{tabular} Sharet used in computing earnings por share: Basic Diluted \begin{tabular}{|llll} 16,030,382 & 16,487,121 & 16,215,963 & 16,701,272 \\ 16,118,465 & 16,635,097 & 16,325,819 & 16,864,919 \end{tabular} (vet sales by reportable segment: Americas Europe Greater China Japan Rest of Asia Pacific Total net sales NNet sales by calegory? iphone Mac Pad Wearables, Home and Accessaries Services Total net sales CONDENSED CONSOLIDATED BALANCE SHEETS (Unaudited) (In millions, except number of shares which are reflected in thousands and par value) Cash, cash equivalents and restricted cash, beginning balances Operating activities: Net income 99,80394,680 Adjustments to reconcile net income to cash generated by operating activities: Depreciation and amortization Share-based compensation expense Deferred income tax expense/(benefit) Other 11,1049,03889511111,2847,906(4,774)(747) Changes in operating assets and liabilities: Accounts recelvable, net Inventories Vendor non-trade recelvables Other current and non-current assets Accounts payable Deferred revenue Other current and non-cument liablities Cash generated by operating activities \begin{tabular}{rr} (1,823) & (10,125) \\ 1,484 & (2,642) \\ (7,520) & (3,903) \\ (6,499) & (8,042) \\ 9,448 & 12,326 \\ 478 & 1,676 \\ 5,632 & 5,799 \\ \hline 122,151 \\ \hline \end{tabular} Ifvesting activities: Purchases of marketable securities Proceeds from maturities of marketable securities Proceeds from sales of marketable securities Payments for acquisition of property, plant and equipment Payments made in connection with business acquisitions, net Other Cath used in ifverting activities (22,354)(1,780)(14,545)(352) Financing activities: Payments foc taces related to net share settlement of equity awards Payments for dividends and dividend equivalents Repurchases of common stock Proceeds from issuance of term debt, net Repayments of term debt Proceeds from commercial paper, net Other Cash used in financing activities Decrease in cash, cash equivalents and restricted cash Cash, cash equivalents and restricted cash, ending bolances Supplemental cash fiow disclosure Cash paid for income taxes, net Cash paid for interest