Question Two:

You have to select one manufacturing company listed on Saudi Exchange (Tadawul) and upload the recent three years financial statements.

Open the Excel workbook Financial Ratio Analysis on LMS. The file contains the ratios names sheet that should be used and applied on the manufacturing company that you selected from Saudi Exchange (Tadawul).

Requirements

Create a new sheet named financial indicators in the Financial Ratio Analysis workbook, and list the required financial indicators that you need to apply financial ratios (the financial indicators are extracted from the selected company).

Hint: an example format

Financial Indicators	2019	2020	2021
Cash on Hand & at Banks
Account Receivables, Net
Inventory
Accounts and Notes Payable
Retained Earnings

Create a new sheet named financial ratios analysis, that contains all ratios listed in the ratios names sheet, and fill these ratios for the three years.

Hints: - the ratios should be formulas referred from the financial indicators sheet.

- an example format

Financial ratio	2019	2020	2021
Turnover Ratio %
Earnings Per Share (SAR)
Dividend Per Share (SAR)		NA

- if any ratio cant be calculated because the financial indicators are not included in the companies' financial statement; fill it NA

the follwing table is the excel sheet provided

Financial Ratios

Turnover Ratio %

Earning Per Share (SAR)

Dividend Per Share (SAR)

Book Value Per Share (SAR)

Price Earnings Ratio (Times)

Dividend Yield %

Dividends Per Share to Earning Per Share %

Price to Book Value (Times)

Gross Margin %

Margin Before Interest and Tax %

Profit Margin %

Return on Assets %

Return on Equity %

Debit Ratio %

Equity Ratio %

Interest Coverage Ratio (Times)

Total Assets Turnover (Times )

Fixed Assets Turnover (Times)

Working Capital Turnover (Times)

Current Ratio (Times)

Working Capital (SAR)