I choose Maaden company in Saudi Arabia1. Introduction
This is a group assignment having two parts. First part will be considered as assignment 1 of this
course where you will analyze one selected company from following list for a period of three years.
We will allocate you to perform credit or equity analysis of that company on first come first get basis.
2. Content of Assignment:
A. Excel Analysis (Credit/Equity analysis)
Get last three years’ data to perform the analysis of selected company. Transform the data in Excel.
All analysis should be performed in excel file.
Key note:
•
For three years’ take 2022, 2021,2020
•
Company: Maaden in Saudi Arabia
B. PowerPoint presentation
Prepare a PowerPoint presentation covering the following content:
• Introduce the company in one slide.
• Mention the proper formulae in slides along with the values taken from excel.
• Discuss at least 3 scenarios to analyze the Credit or Equity situation of company for last 3 years.
Add proper interpretation of the analysis. (3 to 4 slides)
• Conclude the credit/equity situation of company in clear words.
• References: For reference provide the website link from where data is taken.
• Follow proper formatting for PowerPoint.
• Team work table. Remember that PPT preparation is not a contribution by one team member. All
members should prepare and present the assignment.
3. Submission
a. Excel file
b. PPT
Plagiarized work will be awarded zero.
———————————————————————————————————
To be clear:
Analysis instruction:
•
All groups will copy three main financial statements in Excel (Balance sheet, Income
Statement and Cash Flow Statement).
•
Perform the common size analysis for three statements.
•
Perform the Horizontal Analysis for three statements.
•
From Chapter 7 Choose analysis tool to analyze Equity or Credit Analysis (which ever
is assigned to group).
For Presentation follow the instructions given before.
Good luck