Business Finance:Objectives:

This project is designedfor you to analyze different aspects of a firms operations. You will learn how to use internet resources (theBusiness Insight: Globaldatabase), and develop your quantitative and analytical skills.

Requirements:Chooseanon-financialpublicly traded company from the Business Insight: Global database.A publicly traded company means that it has common equity traded in a stock exchange.Download its balance sheet and income statement for the most recent 5 years to a spreadsheet from the Business Insight: Global.

Create another worksheet in the Excel file for financial ratios.

Please calculate all of the following financial ratios in the sections of Profitability, Financial Strength, and Efficiency Ratios for the most recent five years (2014-2018) in the Excel spreadsheet.

When you work on the calculations, the formula you use in the Excel spreadsheet should reference the data from the Income Statement or Balance Sheet.

Excel has to know the location and the name of the file, the name of the worksheet, and the cell address. Please round the number to two decimal places. The profitability ratios should be expressed in percentage.

Trend Analysis: Please draw line or bar charts of the ratios over the past 5 years in Excel. You should have three charts(One chart for Profitability, one chart for financial health, and one chart for efficiency ratios).

Please use the Z-score model to predict whether this company will experience financial distress within the next yearfor the most recent year only, 2017. His Z-score model for publicly traded companies is defined as:

Z=1.2X1+1.4X2+3.3X3+0.6X4+X5

where X1=net working capitaltotal assets

net working capital = current assets current liabilities

X2=retained earningstotal assets

X3=EBITtotal assets

EBIT is earnings before interest and taxes

X4=market capitalizationbook value of total liabilities

X5=net salestotal assets

Please compute the Z-score for the company you choose in an Excel worksheet, and discuss whether this company will experience financial distress in the upcoming year. For this part, you can collaborate with your group members. However, I want to see calculations of the Z-score shown in your Excel file. Again, your calculations of X1,, X5, and Z-score should reference to the data in the Income Statement and Balance Sheet in the Excel file. Please summarize the companys financial performance based on ratio analysis, trend analysis, z-score, and common-size financial statement. Please write no more than two pages.