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

 ATTACHMENT PREVIEW Download attachmentFIN 320 Module Three Excel Assignment RubricThis is the first of two Excel assignments you will complete in this course. Before you get started, be sure to watch theYahoo! Finance and Investor Relationsvideo. For this assignment, consider the stock you own in your TDAU thinkorswim portfolio. Choose one of the companies from your portfolio and useYahoo!Financeto complete the following steps:1.Financial ReportsFor 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 titled20XX Balance Sheet; the second,20XXIncome 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 PricesCreate a fourth worksheet within the same Excel file for historical stock prices. (You can name the worksheetStock Prices.)On the Yahoo! Finance page for your company, click theHistorical Priceslink on the left-hand side. Find the stock prices for themost recentseven weekdaysin the Adj Close column. The Adj Close stock price is adjusted for dividends and stock splits. In your Excel file, enter thoseseven 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.

View the Answer3.ProfessionalismFormat the data on all worksheets so that the file has a neat and professional appearance.4.ReferencesAt 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,reviewthese instructions.Critical ElementsProficient (100%)Not Evident (0%)ValueFinancial ReportsIncludes annual balance sheet, annual income statement, andannual statement of cash flows for the company selectedDoes not include annual balance sheet, annual income statement,and annual statement of cash flows for the company selected25Stock PricesAccurately calculates the stock’s rate of return over the seven-dayperiodDoes not accurately calculate the stock’s rate of return over theseven-day period45ProfessionalismFormats data with a neat and professional appearanceDoes not format data with a neat and professional appearance15ReferencesIncludes properly formatted APA-style citations and links withminor errors or no errorsDoes not include properly formatted APA-style citations orincludes citations and links with noticeable errors15Earned Total100%

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"