Question one:

Many accounting applications can be applied through Excel in business fields. Mention the benefits of using Excel in accounting department at manufacturing and service firms with providing some examples for the main applications that can be applied.

Hint: list at least five examples not mentioned in the course material, each one contains benefits, uses, and explanation how to use.

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

Good Luck