Hi,
I have a FIN619 finance assignment and I chose Saudi Telecom Company (STC) as the company for analysis.
Please prepare the assignment as follows:
1. Company Data Source:
Use the official STC investor relations financial reports to get real financial numbers for the last three years (2023, 2024, and 2025). You can download annual and quarterly financial statements from the STC official website:
Alternatively, you can also check financial summaries through Tadawul / Argaam:
2. Assignment Requirements:
You need to prepare:
A) Financial Ratios (with formulas)
Calculate the following ratios for each year (2023, 2024, and 2025):
- Current Ratio
- Debt-to-Equity Ratio
- Net Profit Margin
- Return on Assets (ROA)
- Total Asset Turnover
Use the financial numbers (revenue, profit, assets, liabilities, etc.) from the STC annual reports.
3. Excel File:
Create an Excel file with the calculations and formulas clearly shown.
4. Written Report (Word):
Your written report should include:
a. Financial Situation Analysis:
- Show the calculated ratios for each year.
- Explain each ratio in simple words.
- Discuss whether the companys financial performance improved or declined over the three years.
b. Financial Risk Identification:
- Identify the main financial risk for STC based on the ratios (e.g., low liquidity, high debt, weak profitability).
c. Managerial Recommendations:
- Suggest 3 practical solutions STC can implement to improve its financial performance.
5. Oral Presentation:
Be prepared to explain in a short 5-minute presentation:
- STCs financial condition
- The main risk
- Your recommendations
6. Academic Rules:
- Keep the work original (Turnitin should be low).
- Use real numbers from STC reports.
- No copying general text focus on actual financial analysis.
Example of where to find real financial reports:
You can download STC financial reports and statements for 20232025 from their investor relations page:
What I need:
1) Excel File
- Calculate the required financial ratios for the three years:
- Current Ratio
- Debt-to-Equity Ratio
- Net Profit Margin
- Return on Assets (ROA)
- Total Asset Turnover
- Clearly show all formulas used in Excel.
- The sheet must be clean and well-organized.
2) Word Report
Prepare a short executive report including:
- Financial Situation Analysis
- Financial Risk Identification
- Managerial Recommendations (3 practical actions)
- Clear interpretation of whether STC improved or worsened financially.
No long theory focus on real financial analysis.
3) Professional Infographic-Style Summary
I also need a short, professional visual summary (infographic style) that:
- Highlights key ratios and trends
- Shows main financial risk
- Presents the 3 recommendations clearly
- Looks executive and presentation-ready
The work must be original and meet academic integrity requirements.
Please make sure the work follows the academic integrity guidelines:
- The work must be original and based on real financial data.
- Turnitin similarity must not exceed 15%.
- AI-generated content must not exceed 15%.
- No copy-paste from websites, reports, or previous papers.
- All analysis must reflect proper financial understanding and interpretation.
- Use your own wording and calculations.
- All financial data must be referenced from official sources (e.g., STC annual reports). Please check the attachment for more clarification.
Requirements: Academic

Leave a Reply
You must be logged in to post a comment.