I need an expert to help me. My sleected company is google need in 10 hours.

FIN 320 Module Three Excel Assignment Rubric This is the first of two Excel assignments you will complete in this course. Before you get started, be sure to watch the Yahoo! Finance and Investor Relations video. For this assignment, consider the stock you own in your TDAU thinkorswim portfolio. Choose one of the companies from your portfolio and use Yahoo! Finance to complete the following steps: 1. Financial Reports For the company you have selected, find the most recent annual balance sheet, annual income statement, and annual statement of cash flows. Copy each of these three reports to its own worksheet within a single Excel file. The first worksheet should be titled 20XX Balance Sheet; the second, 20XX Income Statement; the third, 20XX Cash Flow. (Replace the XX with the appropriate year.) The image below illustrates the way the file should be set up. 2. Stock Prices Create a fourth worksheet within the same Excel file for historical stock prices. (You can name the worksheet Stock Prices.) On the Yahoo! Finance page for your company, click the Historical Prices link on the left-hand side. Find the stock prices for the most recent seven weekdays in the Adj Close column. The Adj Close stock price is adjusted for dividends and stock splits. In your Excel file, enter those seven prices. On the Stock Prices worksheet, use an Excel formula to calculate the stock price's rate of return over that seven-day period. To do this, 1. Subtract the stock price of the first day from the stock price of the last day. 2. Divide this amount by the stock price from the first day. 3. Multiply by 100 to get the rate of return. 3. Professionalism Format the data on all worksheets so that the file has a neat and professional appearance. 4. References At the bottom of each data tab in the spreadsheet, include a link and a properly formatted citation referencing the location of the data used. Guidelines for Submission: Submit an Excel file that meets the criteria described in the prompt. Citations should be formatted according to APA style. Instructor Feedback: This activity uses an integrated rubric in Blackboard. Students can view instructor feedback in the Grade Center. For more information, review these instructions. Critical Elements Financial Reports Stock Prices Professionalism References Proficient (100%) Includes annual balance sheet, annual income statement, and annual statement of cash flows for the company selected Accurately calculates the stock's rate of return over the seven-day period Formats data with a neat and professional appearance Includes properly formatted APA-style citations and links with minor errors or no errors Not Evident (0%) Does not include annual balance sheet, annual income statement, and annual statement of cash flows for the company selected Does not accurately calculate the stock's rate of return over the seven-day period Does not format data with a neat and professional appearance Does not include properly formatted APA-style citations or includes citations and links with noticeable errors Earned Total Value 25 45 15 15 100% Google Inc. CONSOLIDATED STATEMENTS OF INCOME (In millions) 2015 Revenues Costs and expenses: Cost of revenues Research and development Sales and marketing 74,989 28,164 12,282 9,047 General and administrative 6,136 Total costs and expenses 55,629 Income from operations 19,360 Other income (expense), net Income from continuing operations before income taxes Provision for income taxes Net income from continuing operations Net income (loss) from discontinued operations Net income Less: Adjustment Payment to Class C capital stockholders Net income available to all stockholders 291 19,651 3,303 16,348 0 16,348 522 15,826 Reference: https://www.sec.gov/Archives/edgar/data/1288776/000165204416000012/goog10-k2015.htm Google Inc CONSOLIDATED BALANCE SHEETS (In millions, except share and par value amounts which are reflected in thousands, and par value per share amounts) 2015 Assets Current assets: Cash and cash equivalents 16,549 Marketable securities 56,517 Total cash, cash equivalents, and marketable securities (including securities loaned of $4,058 and $4,531) 73,066 Accounts receivable, net of allowance of $225 and $296 Receivable under reverse repurchase agreements Income taxes receivable, net 11,556 450 1,903 Prepaid revenue share, expenses and other assets Total current assets Prepaid revenue share, expenses and other assets, noncurrent 3,139 90,114 3,181 Non-marketable investments Deferred income taxes Property and equipment, net Intangible assets, net 5,183 251 29,016 3,847 Goodwill 15,869 Total assets 147,461 Liabilities and Stockholders' Equity Current liabilities: Accounts payable Short-term debt Accrued compensation and benefits Accrued expenses and other current liabilities Accrued revenue share Securities lending payable Deferred revenue Income taxes payable, net Total current liabilities Long-term debt Deferred revenue, non-current Income taxes payable, non-current Deferred income taxes Other long-term liabilities Commitments and contingencies (Note 11) 1,931 3,225 3,539 4,768 2,329 2,428 788 302 19,310 1,995 151 3,663 189 1,822 Stockholders' equity: Convertible preferred stock, $0.001 par value per share, 100,000 shares authorized; no shares issued and outstanding Class A and Class B common stock, and Class C capital stock and additional paid-in capital, $0.001 par value per share: 15,000,000 shares authorized (Class A 9,000,000, Class B 3,000,000, Class C 3,000,000); 680,172 (Class A 286,560, Class B 53,213, Class C 340,399) and par value of $680 (Class A $287, Class B $53, Class C $340) and 687,348 (Class A 292,297, Class B 50,295, Class C 344,756) and par value of $687 (Class A $292, Class B $50, Class C $345) shares issued and outstanding Accumulated other comprehensive income (loss) Retained earnings 0 32,982 -1874 89,223 Total stockholders' equity 120,331 Total liabilities and stockholders' equity 147,461 Reference: https://www.sec.gov/Archives/edgar/data/1288776/000165204416000012/goog10-k2015.htm Google Inc. CONSOLIDATED STATEMENTS OF CASH FLOWS (In millions) 2015 Operating activities Net income Adjustments: Depreciation and impairment of property and equipment Amortization and impairment of intangible assets Stock-based compensation expense Excess tax benefits from stock-based award activities Deferred income taxes Gain on divestiture of business (Gain) loss on marketable and non-marketable investments, net Other Changes in assets and liabilities, net of effects of acquisitions: Accounts receivable Income taxes, net Prepaid revenue share, expenses and other assets Accounts payable Accrued expenses and other liabilities Accrued revenue share Deferred revenue Net cash provided by operating activities 16,348 4,132 931 5,203 -548 -179 0 334 212 -2094 -179 -318 203 1,597 339 43 26,024 Investing activities Purchases of property and equipment Purchases of marketable securities Maturities and sales of marketable securities Purchases of non-marketable investments -9915 -74368 62,905 -2172 Cash collateral related to securities lending Investments in reverse repurchase agreements Proceeds from divestiture of business -350 425 0 Acquisitions, net of cash acquired, and purchases of intangibles and other assets -236 Net cash used in investing activities -23711 Financing activities Net payments related to stock-based award activities Excess tax benefits from stock-based award activities Adjustment Payment to Class C capital stockholders Capital transactions with Alphabet Proceeds from issuance of debt, net of costs -1612 548 -47 -2543 13,705 Repayments of debt -13728 Net cash used in financing activities Effect of exchange rate changes on cash and cash equivalents Net increase (decrease) in cash and cash equivalents -3677 -434 -1798 Cash and cash equivalents at beginning of period 18,347 Cash and cash equivalents at end of period 16,549 Supplemental disclosures of cash flow information Cash paid for taxes Cash paid for interest 3338 96 Reference: https://www.sec.gov/Archives/edgar/data/1288776/000165204416000012/goog10-k2015.htm Date Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Open High Low Close Volume Adj Close Differenc Return 2/26/2016 708.58 713.43 700.86 705.07 2240000 705.07 -1.39 -0.20% 2/25/2016 700.01 705.98 690.585 705.75 1631900 705.75 2/24/2016 688.92 700 680.78 699.56 1958600 699.56 2/23/2016 701.45 708.4 693.58 695.85 1999700 695.85 2/22/2016 707.45 713.24 702.51 706.46 1946100 706.46 2/19/2016 695.03 703.081 694.05 700.91 1582300 700.91 9.90997 1.43% 2/18/2016 710 712.35 696.03 697.35 1859100 697.35 2/17/2016 698.09 709.75 691.38 708.4 2490000 708.4 2/16/2016 692.98 698 685.05 691 2520000 691 2/12/2016 690.26 693.75 678.6 682.4 2141400 682.4 -0.34 -0.05% 2/11/2016 675 689.35 668.868 683.11 3024000 683.11 2/10/2016 686.86 701.31 682.13 684.12 2638000 684.12 2/9/2016 672.32 699.9 668.77 678.11 3608900 678.11 2/8/2016 667.85 684.03 663.06 682.74 4247400 682.74 2/5/2016 703.87 703.99 680.15 683.57 5105700 683.57 -68.43 -9.10% 2/4/2016 722.81 727 701.86 708.01 5168700 708.01 2/3/2016 770.22 774.5 720.5 726.95 6171000 726.95 2/2/2016 784.5 789.87 764.65 764.65 6348100 764.65 2/1/2016 750.46 757.86 743.27 752 5139200 752 1/29/2016 731.53 744.99 726.8 742.95 3474300 742.95 31.28 4.40% 1/28/2016 722.22 733.69 712.35 730.96 2676400 730.96 1/27/2016 713.67 718.235 694.39 699.99 2194200 699.99 1/26/2016 713.85 718.28 706.48 713.04 1331700 713.04 1/25/2016 723.58 729.68 710.01 711.67 1711700 711.67 1/22/2016 723.6 728.13 720.121 725.25 2011800 725.25 23.46 3.34% 1/21/2016 702.18 719.19 694.46 706.59 2412200 706.59 1/20/2016 688.61 706.85 673.26 698.45 3445000 698.45 1/19/2016 703.3 709.98 693.41 701.79 2268100 701.79 1/15/2016 692.29 706.74 685.37 694.45 3592400 694.45 -21.58 -3.01% 1/14/2016 705.38 721.925 689.1 714.72 2225800 714.72 1/13/2016 730.85 734.74 698.61 700.56 2501700 700.56 1/12/2016 721.68 728.75 717.317 726.07 2024500 726.07 1/11/2016 716.61 718.855 703.54 716.03 2090600 716.03 Google Inc. CONSOLIDATED STATEMENTS OF INCOME (In millions) 2015 Revenues Costs and expenses: Cost of revenues Research and development Sales and marketing 74,989 28,164 12,282 9,047 General and administrative 6,136 Total costs and expenses 55,629 Income from operations 19,360 Other income (expense), net Income from continuing operations before income taxes Provision for income taxes Net income from continuing operations Net income (loss) from discontinued operations Net income Less: Adjustment Payment to Class C capital stockholders Net income available to all stockholders 291 19,651 3,303 16,348 0 16,348 522 15,826 Reference: https://www.sec.gov/Archives/edgar/data/1288776/000165204416000012/goog10-k2015.htm Google Inc CONSOLIDATED BALANCE SHEETS (In millions, except share and par value amounts which are reflected in thousands, and par value per share amounts) 2015 Assets Current assets: Cash and cash equivalents 16,549 Marketable securities 56,517 Total cash, cash equivalents, and marketable securities (including securities loaned of $4,058 and $4,531) 73,066 Accounts receivable, net of allowance of $225 and $296 Receivable under reverse repurchase agreements Income taxes receivable, net 11,556 450 1,903 Prepaid revenue share, expenses and other assets Total current assets Prepaid revenue share, expenses and other assets, noncurrent 3,139 90,114 3,181 Non-marketable investments Deferred income taxes Property and equipment, net Intangible assets, net 5,183 251 29,016 3,847 Goodwill 15,869 Total assets 147,461 Liabilities and Stockholders' Equity Current liabilities: Accounts payable Short-term debt Accrued compensation and benefits Accrued expenses and other current liabilities Accrued revenue share Securities lending payable Deferred revenue Income taxes payable, net Total current liabilities Long-term debt Deferred revenue, non-current Income taxes payable, non-current Deferred income taxes Other long-term liabilities Commitments and contingencies (Note 11) 1,931 3,225 3,539 4,768 2,329 2,428 788 302 19,310 1,995 151 3,663 189 1,822 Stockholders' equity: Convertible preferred stock, $0.001 par value per share, 100,000 shares authorized; no shares issued and outstanding Class A and Class B common stock, and Class C capital stock and additional paid-in capital, $0.001 par value per share: 15,000,000 shares authorized (Class A 9,000,000, Class B 3,000,000, Class C 3,000,000); 680,172 (Class A 286,560, Class B 53,213, Class C 340,399) and par value of $680 (Class A $287, Class B $53, Class C $340) and 687,348 (Class A 292,297, Class B 50,295, Class C 344,756) and par value of $687 (Class A $292, Class B $50, Class C $345) shares issued and outstanding Accumulated other comprehensive income (loss) Retained earnings 0 32,982 -1874 89,223 Total stockholders' equity 120,331 Total liabilities and stockholders' equity 147,461 Reference: https://www.sec.gov/Archives/edgar/data/1288776/000165204416000012/goog10-k2015.htm Google Inc. CONSOLIDATED STATEMENTS OF CASH FLOWS (In millions) 2015 Operating activities Net income Adjustments: Depreciation and impairment of property and equipment Amortization and impairment of intangible assets Stock-based compensation expense Excess tax benefits from stock-based award activities Deferred income taxes Gain on divestiture of business (Gain) loss on marketable and non-marketable investments, net Other Changes in assets and liabilities, net of effects of acquisitions: Accounts receivable Income taxes, net Prepaid revenue share, expenses and other assets Accounts payable Accrued expenses and other liabilities Accrued revenue share Deferred revenue Net cash provided by operating activities 16,348 4,132 931 5,203 -548 -179 0 334 212 -2094 -179 -318 203 1,597 339 43 26,024 Investing activities Purchases of property and equipment Purchases of marketable securities Maturities and sales of marketable securities Purchases of non-marketable investments -9915 -74368 62,905 -2172 Cash collateral related to securities lending Investments in reverse repurchase agreements Proceeds from divestiture of business -350 425 0 Acquisitions, net of cash acquired, and purchases of intangibles and other assets -236 Net cash used in investing activities -23711 Financing activities Net payments related to stock-based award activities Excess tax benefits from stock-based award activities Adjustment Payment to Class C capital stockholders Capital transactions with Alphabet Proceeds from issuance of debt, net of costs -1612 548 -47 -2543 13,705 Repayments of debt -13728 Net cash used in financing activities Effect of exchange rate changes on cash and cash equivalents Net increase (decrease) in cash and cash equivalents -3677 -434 -1798 Cash and cash equivalents at beginning of period 18,347 Cash and cash equivalents at end of period 16,549 Supplemental disclosures of cash flow information Cash paid for taxes Cash paid for interest 3338 96 Reference: https://www.sec.gov/Archives/edgar/data/1288776/000165204416000012/goog10-k2015.htm Date Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Open High Low Close Volume Adj Close Differenc Return 2/26/2016 708.58 713.43 700.86 705.07 2240000 705.07 -1.39 -0.20% 2/25/2016 700.01 705.98 690.585 705.75 1631900 705.75 2/24/2016 688.92 700 680.78 699.56 1958600 699.56 2/23/2016 701.45 708.4 693.58 695.85 1999700 695.85 2/22/2016 707.45 713.24 702.51 706.46 1946100 706.46 2/19/2016 695.03 703.081 694.05 700.91 1582300 700.91 9.90997 1.43% 2/18/2016 710 712.35 696.03 697.35 1859100 697.35 2/17/2016 698.09 709.75 691.38 708.4 2490000 708.4 2/16/2016 692.98 698 685.05 691 2520000 691 2/12/2016 690.26 693.75 678.6 682.4 2141400 682.4 -0.34 -0.05% 2/11/2016 675 689.35 668.868 683.11 3024000 683.11 2/10/2016 686.86 701.31 682.13 684.12 2638000 684.12 2/9/2016 672.32 699.9 668.77 678.11 3608900 678.11 2/8/2016 667.85 684.03 663.06 682.74 4247400 682.74 2/5/2016 703.87 703.99 680.15 683.57 5105700 683.57 -68.43 -9.10% 2/4/2016 722.81 727 701.86 708.01 5168700 708.01 2/3/2016 770.22 774.5 720.5 726.95 6171000 726.95 2/2/2016 784.5 789.87 764.65 764.65 6348100 764.65 2/1/2016 750.46 757.86 743.27 752 5139200 752 1/29/2016 731.53 744.99 726.8 742.95 3474300 742.95 31.28 4.40% 1/28/2016 722.22 733.69 712.35 730.96 2676400 730.96 1/27/2016 713.67 718.235 694.39 699.99 2194200 699.99 1/26/2016 713.85 718.28 706.48 713.04 1331700 713.04 1/25/2016 723.58 729.68 710.01 711.67 1711700 711.67 1/22/2016 723.6 728.13 720.121 725.25 2011800 725.25 23.46 3.34% 1/21/2016 702.18 719.19 694.46 706.59 2412200 706.59 1/20/2016 688.61 706.85 673.26 698.45 3445000 698.45 1/19/2016 703.3 709.98 693.41 701.79 2268100 701.79 1/15/2016 692.29 706.74 685.37 694.45 3592400 694.45 -21.58 -3.01% 1/14/2016 705.38 721.925 689.1 714.72 2225800 714.72 1/13/2016 730.85 734.74 698.61 700.56 2501700 700.56 1/12/2016 721.68 728.75 717.317 726.07 2024500 726.07 1/11/2016 716.61 718.855 703.54 716.03 2090600 716.03