Please see attached for assignment details. I have the balance sheet, income statement, and statement of cash flow data already - I need all the new ratios. I've tried and tried and I'm just not retaining this and keep getting a different answer each time.

FIN 320 Module Four Excel Assignment Rubric This assignment builds on the work you did for the Excel assignment in Module Three. To get started, find and open the file you submitted. From there, complete the following steps: 1. Financial Data Using the same company you selected in Module Three, add another two years of financial statement data so that you have three years of annual data to review for historical analysis. In all, your Excel file must include the following: o o o Three worksheets of annual balance sheet data Three worksheets of annual income statement data Three worksheets of annual statement of cash flow data Important Note: Be sure to label each worksheet in Excel with the appropriate year, as you did in the Module Three assignment. 2. Ratio Calculation On each data tab, use formulas to calculate the following financial indicators for each year of data: o o o o o o o Current ratio Debt/equity ratio Free cash flow Earnings per share Price/earnings ratio Return on equity Net profit margin 3. Written Responses Using the Write Submission area of Blackboard for this part of the assignment, respond to the following: o o Describe how and why each of the ratios has changed over the three-year period. For example, did the current ratio increase or decrease? Why? Describe how three of the ratios you calculated for your company compare to the general industry. Find general industry data by entering your specific company's ticker symbol here. If you are not familiar with the Write Submission feature, see the screen shot below. 4. Professionalism, References, and Mechanics Format the data on all worksheets so that the file has a neat and professional appearance. Include links and properly formatted citations referencing the location of the data used. Your written responses should be free of errors in organization, grammar, and style. Guidelines for Submission: Submit an Excel file that meets the criteria described in the prompt. The written responses should be done in the Write Submission area of Blackboard. 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 Data Exemplary (100%) Meets \"Proficient\" criteria and presents information in a wellorganized manner with clearly labeled tabs and data sections Ratio Calculation Meets \"Proficient\" criteria and presents information in a clear and well-organized manner Proficient (85%) Includes three years of financial statement data (three annual balance sheets, three annual income statements, and three annual statements of cash flows) for the company selected, with minor errors or no errors Accurately calculates the financial indicators (current ratio, debt/equity ratio, free cash flow, earnings per share, price/earnings ratio, return on equity, and net profit margin), with minor errors or no errors Needs Improvement (55%) Includes three years of financial statement data (three annual balance sheets, three annual income statements, and three annual statements of cash flows) for the company selected, with noticeable errors Calculates the financial indicators (current ratio, debt/equity ratio, free cash flow, earnings per share, price/earnings ratio, return on equity, and net profit margin), with noticeable errors Not Evident (0%) Does not include three years of financial statement data (three annual balance sheets, three annual income statements, and three annual statements of cash flows) for the company selected Value 20 Does not calculate the financial indicators (current ratio, debt/equity ratio, free cash flow, earnings per share, price/earnings ratio, return on equity, and net profit margin) 40 Written Responses: Changes in Ratios Meets \"Proficient\" criteria and includes supporting details and data Written Responses: Comparison to Industry Meets \"Proficient\" criteria and includes supporting details and data Professionalism, References, and Mechanics Meets \"Proficient\" criteria, and the material is presented in an especially polished and easy to read format Describes how and why each of the ratios has changed over the three-year period in a clear and logical manner Describes how and why each of the ratios has changed over the three-year period but presents some information in an unclear or illogical manner Describes how the selected Describes how the selected ratios compare to the general ratios compare to the general industry in a clear and logical industry but presents some manner information in an unclear or illogical manner Formats data with a neat and Formats data and provides professional appearance and citations and links, but there are includes properly formatted deficiencies in the appearance of APA-style citations and links with the data and/or flaws in the minor errors or no errors; any citation formatting; there are errors related to organization, some errors related to grammar, and style are minor organization, grammar, and style Does not describe how and why each of the ratios has changed over the three-year period 15 Does not describe how the selected ratios compare to the general industry 15 Does not format data with a neat and professional appearance or include properly formatted APAstyle citations and links; there are major errors related to organization, grammar, and style 10 Earned Total 100% Period Ending Total Revenue Cost of Revenue Gross Profit (Loss) Operating Expenses Research & Development Selling General and Administrative Total Operating Expenses Operating Income or Loss Income (Loss) from Operations Total Other Income/Expenses Net Earnings Before Interest And Taxes (Loss) Interest Expense Income Before Tax Income Tax Expense Net Income From Continuing Ops Net Income (Loss) Preferred Stock And Other Adjustments Net Income Applicable To Common Shares 31-Dec-2015 31-Dec-2014 31-Dec-2013 31-Dec-2012 31-Dec-2011 4,046,025 3,198,356 2,013,496 413,256 204,242 3,122,522 2,316,685 1,557,234 383,189 142,647 923,503 881,671 456,262 30,067 61,595 717,900 922,232 464,700 603,660 231,976 285,569 273,978 150,372 208,981 104,102 1,640,132 1,068,360 517,545 424,350 313,083 -716,629 -186,689 -61,283 -394,283 -251,488 716,629 41,652 875,624 118,851 875,624 13,039 186,689 1,813 284,636 100,886 284,636 9,404 61,283 22,602 71,426 32,934 71,426 2,588 -394,283 1,828 396,077 254 396,077 136 -251,488 2,646 253,922 43 253,922 489 888,663 294,040 74,014 396,213 254,411 -888,663 -294,040 -74,014 -396,213 -254,411 74,014 396,213 254,411 - 888,663 294,040 Balance Sheet Get Balance Sheet for: Tesla Motors Inc View: Annual Data | Quarterly Data All numbers in thousands Period Ending 31-Dec-2015 Assets Current Assets Cash And Cash Equivalents Marketable Securities Net Receivables Inventory Other Current Assets 1,196,908 22,628 168,965 1,277,838 125,229 Total Current Assets Net Operating Lease Vehicles Property and Equipment Restricted Cash Other Assets 2,791,568 1,791,403 3,403,334 31,522 74,633 Total Assets 8,092,460 Liabilities Current Liabilities Accounts Payable Other Current Liabilities 916,148 870,066 Total Current Liabilities Long Term Debt Other Liabilities 2,816,274 2040375 364976 Total Liabilities 6,961,471 Stockholders' Equity Common Stock Retained Earnings (Accumulated Defecit) Other Stockholder Equity 131 -2,322,323 3,411,136 Total Stockholder Equity (Defecit) -1,088,944 Net Tangible Assets 110,346,000 31-Dec-2014 31-Dec-2013 31-Dec-2012 31-Dec-2011 1,905,713 17,947 226,604 953,675 94,718 - 845,889 201,890 255,266 - - 49,109 340,355 27,574 26,842 268,504 8,438 9,539 50,082 9,414 3,198,657 766,744 1,829,267 11,374 43,209 1,265,939 382,425 738,494 6,435 23,637 524,768 10,071 552,229 5,159 21,963 372,838 11,757 298,414 8,068 22,371 5,849,251 2,416,930 1,114,190 713,448 56,689 1,704,564 483,922 306,547 273,062 - 304,555 2,107,166 675,160 539,108 173244 - - 191,339 - - - - 4,879,345 1,749,810 989,490 489,403 126 -1,433,682 2,345,266 123 -1,139,620 1,806,617 115 1,065,606 1,190,191 104 669,392 893,336 -911,710 -667,120 124,700 224,045 102,789,000 117,793,000 84,325,000 61,729,000 Cash Flow Get Cash Flow for: Tesla Motors Inc View: Annual Data | Quarterly Data All numbers in thousands Period Ending Net Income (Loss) Operating Activities, Cash Flows Provided By or Used In Depreciation Changes In Accounts Receivables Changes In Liabilities Changes In Inventories Total Cash Flow From Operating Activities Investing Activities, Cash Flows Provided By or Used In Capital Expenditures Investments Other Cash flows from Investing Activities Total Cash Flows From Investing Activities Financing Activities, Cash Flows Provided By or Used In Dividends Paid Sale Purchase of Stock Net Borrowings Other Cash Flows from Financing Activities Total Cash Flows From Financing Activities Effect Of Exchange Rate Changes Change In Cash and Cash Equivalents 31-Dec-2015 31-Dec-2014 31-Dec-2013 31-Dec-2012 31-Dec-2011 -888,663 -294,040 -74,014 -396,213 -254,411 422,590 46,267 23,697 -1,528,920 231,931 -183,658 224,043 -1,034,655 106,083 -21,917 99,538 -454,352 28,825 -17,303 10,255 -189,797 16,919 -2,829 2,641 -11,810 -524,499 -57,337 257,994 -266,081 -114,364 - - - - - -1,634,850 -38,701 -969,885 -20,558 -264,224 14,807 -239,228 -32,298 -197,896 21,968 -1,673,551 -990,444 -249,417 -206,930 -175,928 1,158,558 568,745 -203,780 2,300,000 -148,962 3,271 -11,179 660,000 -16,153 -8,425 -2,832 -416 1,523,523 -34,278 2,143,130 -35,525 - 635,422 419,635 446,000 7,276,000 -415,000 - - -2,684 - - 3,513,000 -1393 - - 201,890 255,266 Tesla Motors Stock Prices Date Open High 11/10/2016 191.05 11/9/2016 186.88 11/8/2016 193.79 11/7/2016 193.59 11/4/2016 189.00 11/3/2016 189.00 11/2/2016 190.05 Rate of Return Low 191.61 192.00 197.49 194.29 193.46 191.47 192.70 Use Adj Close Step 1 Step 2 Step 3 Final Answer Close 180.42 183.95 191.26 190.05 185.96 187.04 187.51 -2.67 -0.014200617 -1.420061696 -1.42% 185.35 190.06 194.94 193.21 190.56 187.42 188.02 Volume 6,749,452.00 8,169,866.00 3,254,064.00 3,869,582.00 5,144,683.00 2,650,607.00 4,248,052.00 Adj Close 185.35 Latest or most recent 190.06 194.94 193.21 190.56 187.42 188.02 earliest or oldest