Download into Excel the financial data for the firm assigned to you from yahoo.com's finance section (instructions provided on how to do the download) Format the data in Excel by using proper formatting of cells, appropriate labels, arranging the data in ascending years (2016 to 2019) and providing spark lines for each item. I have given you basic formatting in my example slides. I expect all numbers, columns, graphs, etc... to be formatted correctly and professionally. : . Provide two separate graphs: (a) Net Income over time (b) Total Assets and Long- term Debt (plot these two trends on the SAME graph) making sure that the graph is appropriately titled, series labelled, etc.. WRITTEN PART (in Word): Describe carefully three trends in total that you observe in this data, with at least one from the Balance Sheet and one from the Income statement. What information do these trends provide? How might they relate to each other? You must turn the assignment in by June 2, 2020 on Blackboard in the Week 2 Content Area using (a) an Excel file labelled something like JArmourExcel 1.xls if your name is Justin Armour, as well as a Word file for the written part (e.g. JArmour Word1.doc) 12/31/2019 TTM 12/31/2018 12/31/2017 12/31/20 Breakdown 321,782,000 135,987,0 Total Revenue 280,522,000 232,887,000 177,866,000 239,893,000 105,884,0 Cost of Revenue 205,768,000 173,183,000 137,183,000 81,889,000 30,103,04 Gross Profit 74,754,000 59.704,000 40.683.000 60,213,000 65,020,000 47,283,000 36,577,000 25,917.01 16,869,000 14,541,000 12,421,000 4.106.000 4,186,00 > Operating Expenses Operating Income or Loss Interest Expense Total Other Income/Expenses Net 1,656,000 1,600,000 1,417,000 848,000 484.000 305,000 203,000 - 183,000 346,000 90,000 16,289,000 13,976,000 11,261,000 3,800,000 Income Before Tax 3,892,00 Income Tax Expense 3,009,000 2,374,000 1.197.000 769,000 1,425,00 13,180,000 11.588,000 10,073,000 Income from Continuing Operations 3,033,000 2,371,00 13,180,000 11,588,000 10,073,000 3,033,000 2,371,00 Net Income N N 13.180,000 Net Income available to common s.. 11,588,000 10,073,000 3,033,000 2,371,00 . 23.46 Basic EPS 20.68 5.01 6.32 ,000 Total Revenue 232,887,000 177,866,000 135,987,000 ,000 Cost of Revenue 173,183,000 137,183,000 105,884,000 000 Gross Profit 59,704,000 40,683,000 30,103,000 000 > Operating Expenses 47,283,000 36,577,000 25,917,000 000 Operating Income or Loss 12,421,000 4,106,000 4,186,000 000 Interest Expense 1,417,000 848,000 484,000 Total Other Income/Expenses Net 00 -183,000 346,000 90,000 000 Income Before Tax 11,261,000 3,806,000 3,892,000 100 Income Tax Expense 1,197,000 769,000 1,425,000 000 Income from Continuing Operations 10,073,000 3,033,000 2,371,000 000 10,073,000 3,033,000 2,371,000 Net Income 000 10,073,000 3,033,000 Net Income available to common s... 2,371,000 20.68 6 6.32 5.01 Basic EPS Basic EPS 23.46 20.68 6.32 5.01 Diluted EPS 23.01 20.14 6.15 4.90 Basic Average Shares 494,000 487,000 480,000 474,000 Diluted Average Shares 504,000 500,000 493,000 484,000 EBITDA 37,365,000 28,019,000 16,132,000 12,492,01 B 20.68 6.32 5.01 Basic EPS 1 20.14 6.15 Diluted EPS 4.90 00 487,000 480,000 Basic Average Shares 474,000 DO Diluted Average Shares 500,000 493,000 484,000 EBITDA 000 28,019,000 16,132,000 12,492,000 HOW TO DOWNLOAD THE DATA FROM YAHOO INTO EXCEL - 5 Open up a new Excel sheet and then Paste Special" with the Unicode Text" option as shown below. Note that I pasted it with my cursor in cell A2 1 30 10 1 S HOW TO DOWNLOAD THE DATA FROM YAHOO INTO EXCEL - 6 You should now have the data looking something like what I have below. We will format this later. 190 4 50 2 13-14 IN 15 11 BA 19 20 HOW TO DOWNLOAD THE DATA FROM YAHOO INTO EXCEL - 7 Next, repeat and paste the balance sheet data. Here things are a bit trickier as you may have to "open up" each section. For example, for Assets, I click on the ">" symbol next to Assets and it opens up a bit to give me the breakdown of ">Assets" into">Current Assets" and ">Non-current Assets" as you see in the lower graph PURDUE ! PURDUE HOW TO DOWNLOAD THE DATA FROM YAHOO INTO EXCEL - 8 "Once you have "opened up" ALL the Balance sheet sections, cut and paste the data into Excel below the Income Statement data, MAKING SURE the years line up!!! In the examples below, they didn't (the Net Income data has an extra TTM column that I needed to delete to make them line up) and so I had to cut and pasto and delete, etc... as needed to line things up (note that you may also need to retype the date headings! DO HOW TO DOWNLOAD THE DATA FROM YAHOO INTO EXCEL - 9 Finally, I format the data AFTER arranging the dates in ascending order. I then generate Sparklines for each Cow(I have used lines; you can use columns or whatever you think works best). You use "Insert" and then "Sparklines) (In the example below I am about to insert a sparkline graph in cell F7 for the range B7 to E7) Download into Excel the financial data for the firm assigned to you from yahoo.com's finance section (instructions provided on how to do the download) Format the data in Excel by using proper formatting of cells, appropriate labels, arranging the data in ascending years (2016 to 2019) and providing spark lines for each item. I have given you basic formatting in my example slides. I expect all numbers, columns, graphs, etc... to be formatted correctly and professionally. : . Provide two separate graphs: (a) Net Income over time (b) Total Assets and Long- term Debt (plot these two trends on the SAME graph) making sure that the graph is appropriately titled, series labelled, etc.. WRITTEN PART (in Word): Describe carefully three trends in total that you observe in this data, with at least one from the Balance Sheet and one from the Income statement. What information do these trends provide? How might they relate to each other? You must turn the assignment in by June 2, 2020 on Blackboard in the Week 2 Content Area using (a) an Excel file labelled something like JArmourExcel 1.xls if your name is Justin Armour, as well as a Word file for the written part (e.g. JArmour Word1.doc) 12/31/2019 TTM 12/31/2018 12/31/2017 12/31/20 Breakdown 321,782,000 135,987,0 Total Revenue 280,522,000 232,887,000 177,866,000 239,893,000 105,884,0 Cost of Revenue 205,768,000 173,183,000 137,183,000 81,889,000 30,103,04 Gross Profit 74,754,000 59.704,000 40.683.000 60,213,000 65,020,000 47,283,000 36,577,000 25,917.01 16,869,000 14,541,000 12,421,000 4.106.000 4,186,00 > Operating Expenses Operating Income or Loss Interest Expense Total Other Income/Expenses Net 1,656,000 1,600,000 1,417,000 848,000 484.000 305,000 203,000 - 183,000 346,000 90,000 16,289,000 13,976,000 11,261,000 3,800,000 Income Before Tax 3,892,00 Income Tax Expense 3,009,000 2,374,000 1.197.000 769,000 1,425,00 13,180,000 11.588,000 10,073,000 Income from Continuing Operations 3,033,000 2,371,00 13,180,000 11,588,000 10,073,000 3,033,000 2,371,00 Net Income N N 13.180,000 Net Income available to common s.. 11,588,000 10,073,000 3,033,000 2,371,00 . 23.46 Basic EPS 20.68 5.01 6.32 ,000 Total Revenue 232,887,000 177,866,000 135,987,000 ,000 Cost of Revenue 173,183,000 137,183,000 105,884,000 000 Gross Profit 59,704,000 40,683,000 30,103,000 000 > Operating Expenses 47,283,000 36,577,000 25,917,000 000 Operating Income or Loss 12,421,000 4,106,000 4,186,000 000 Interest Expense 1,417,000 848,000 484,000 Total Other Income/Expenses Net 00 -183,000 346,000 90,000 000 Income Before Tax 11,261,000 3,806,000 3,892,000 100 Income Tax Expense 1,197,000 769,000 1,425,000 000 Income from Continuing Operations 10,073,000 3,033,000 2,371,000 000 10,073,000 3,033,000 2,371,000 Net Income 000 10,073,000 3,033,000 Net Income available to common s... 2,371,000 20.68 6 6.32 5.01 Basic EPS Basic EPS 23.46 20.68 6.32 5.01 Diluted EPS 23.01 20.14 6.15 4.90 Basic Average Shares 494,000 487,000 480,000 474,000 Diluted Average Shares 504,000 500,000 493,000 484,000 EBITDA 37,365,000 28,019,000 16,132,000 12,492,01 B 20.68 6.32 5.01 Basic EPS 1 20.14 6.15 Diluted EPS 4.90 00 487,000 480,000 Basic Average Shares 474,000 DO Diluted Average Shares 500,000 493,000 484,000 EBITDA 000 28,019,000 16,132,000 12,492,000 HOW TO DOWNLOAD THE DATA FROM YAHOO INTO EXCEL - 5 Open up a new Excel sheet and then Paste Special" with the Unicode Text" option as shown below. Note that I pasted it with my cursor in cell A2 1 30 10 1 S HOW TO DOWNLOAD THE DATA FROM YAHOO INTO EXCEL - 6 You should now have the data looking something like what I have below. We will format this later. 190 4 50 2 13-14 IN 15 11 BA 19 20 HOW TO DOWNLOAD THE DATA FROM YAHOO INTO EXCEL - 7 Next, repeat and paste the balance sheet data. Here things are a bit trickier as you may have to "open up" each section. For example, for Assets, I click on the ">" symbol next to Assets and it opens up a bit to give me the breakdown of ">Assets" into">Current Assets" and ">Non-current Assets" as you see in the lower graph PURDUE ! PURDUE HOW TO DOWNLOAD THE DATA FROM YAHOO INTO EXCEL - 8 "Once you have "opened up" ALL the Balance sheet sections, cut and paste the data into Excel below the Income Statement data, MAKING SURE the years line up!!! In the examples below, they didn't (the Net Income data has an extra TTM column that I needed to delete to make them line up) and so I had to cut and pasto and delete, etc... as needed to line things up (note that you may also need to retype the date headings! DO HOW TO DOWNLOAD THE DATA FROM YAHOO INTO EXCEL - 9 Finally, I format the data AFTER arranging the dates in ascending order. I then generate Sparklines for each Cow(I have used lines; you can use columns or whatever you think works best). You use "Insert" and then "Sparklines) (In the example below I am about to insert a sparkline graph in cell F7 for the range B7 to E7)