Question: You need these two links for the balance sheet and income sheet and they have to be in excel. Also, the ratios that are attached.
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
Information related to above question is enclosed below: