Vertical Analysis for balance sheet and and a horizontal trend analysis for income sheet and the ratios

You need these two links for the balance sheet and income sheet and they have to be in excel. Also, the ratios that are   

https://www.sec.gov/cgi-bin/viewer?action=view&cik=732712&accession_number=0000732712-18-000009&xbrl_type=v#

https://www.sec.gov/cgi-bin/viewer?action=view&cik=732712&accession_number=0000732712-18-000009&xbrl_type=v#

i. Current ratio

ii. Debt to equity ratio

iii. Operating profit percentage (EBIT)

iv. Net income percentage

have to be in excel as well. 

a. Prepare a vertical analysis of the company’s most current Balance Sheet

b. Prepare a horizontal (trend) analysis of the company’s income statement over the past two years