Financial Analysis | Aditya Prakash

FINANCIAL ANALYSIS USING TABLEAU

This dashboard was developed using a comprehensive dataset that includes various types of financial data such as General Ledger (GL), Chart of Accounts, Calendar, Territory, Cash Flow Statement, and Statement of Changes in Equity (SOCE). Each of these elements contributes to a detailed financial analysis, offering insights across different dimensions of the organization’s financial performance.
At the top, we have the key financial metrics displayed for each year (2018, 2019, and 2020), providing a summary of the company's gross profit, EBITDA, operating profit, PBIT, and net profit.
- Gross Profit: The company’s gross profit has steadily increased from 2.38M in 2018 to 5.34M in 2020.
- EBITDA: The EBITDA also saw growth, rising from 1.15M in 2018 to 2.01M in 2019, reaching 2.52M in 2020.
- Operating Profit: The operating profit follows a similar trend, growing over the three years from 740K to 1.52M.
- Net Profit: The net profit peaked in 2019 at 1.30M, with a slight decline in 2020 to 1.29M.
- These high-level metrics allow stakeholders to quickly assess the company’s financial health over time.
We also have interactive filters for Region, Country, Quarter, and Month, which allow users to drill down into specific time periods or geographical segments. Currently, the dashboard shows the overall data, but users can refine the view for more detailed analysis.
The Profit & Loss (P&L) Statement is split into two main sections:
- Trading Account:
  - Sales: Sales have been increasing steadily, from 3.69M in 2018 to 5.86M in 2020.
  - Cost of Sales: Similarly, the cost of sales has also risen, but at a slower rate than sales, which helps improve the gross profit over the years.
- Operating Account: This section breaks down the operating expenses, showing detailed line items like:
  - Marketing: We can see that marketing expenses have increased significantly, particularly commissions and sales staff costs.
  - Professional Services: The company has also invested more in professional services, rising from 88K in 2018 to 226K in 2020.
  - Depreciation: There is a consistent increase in depreciation and amortization expenses across the years.
- The total operating expenses grew, but with the increase in sales and gross profit, the company still managed to improve its profitability.
Main Insights:
- Steady Growth: The overall trend shows steady growth in both sales and profitability, with gross profit, EBITDA, and operating profit improving significantly from 2018 to 2020.
- Marketing Investment: There is a clear correlation between increased marketing expenses and sales growth, especially in 2020, where we see a substantial rise in marketing investments.
- Profit Margins: The GP and NP margins remain relatively stable, suggesting the company has managed its costs well, even as it scales up its sales operations.
Key Takeaways: The dashboard provides stakeholders with a clear picture of how the company is managing its operating expenses relative to sales growth, allowing them to identify where investments (like marketing) are paying off and where profitability could be improved further.

FINANCIAL ANALYSIS USING TABLEAU

At the top, we have the key financial metrics displayed for each year (2018, 2019, and 2020), providing a summary of the company's gross profit, EBITDA, operating profit, PBIT, and net profit.

Gross Profit: The company’s gross profit has steadily increased from 2.38M in 2018 to 5.34M in 2020.

EBITDA: The EBITDA also saw growth, rising from 1.15M in 2018 to 2.01M in 2019, reaching 2.52M in 2020.

Operating Profit: The operating profit follows a similar trend, growing over the three years from 740K to 1.52M.

Net Profit: The net profit peaked in 2019 at 1.30M, with a slight decline in 2020 to 1.29M.

These high-level metrics allow stakeholders to quickly assess the company’s financial health over time.

We also have interactive filters for Region, Country, Quarter, and Month, which allow users to drill down into specific time periods or geographical segments. Currently, the dashboard shows the overall data, but users can refine the view for more detailed analysis.

The Profit & Loss (P&L) Statement is split into two main sections:

Trading Account:

Sales: Sales have been increasing steadily, from 3.69M in 2018 to 5.86M in 2020.

Cost of Sales: Similarly, the cost of sales has also risen, but at a slower rate than sales, which helps improve the gross profit over the years.

Operating Account: This section breaks down the operating expenses, showing detailed line items like:

Marketing: We can see that marketing expenses have increased significantly, particularly commissions and sales staff costs.

Professional Services: The company has also invested more in professional services, rising from 88K in 2018 to 226K in 2020.

Depreciation: There is a consistent increase in depreciation and amortization expenses across the years.

The total operating expenses grew, but with the increase in sales and gross profit, the company still managed to improve its profitability.

Main Insights:

Steady Growth: The overall trend shows steady growth in both sales and profitability, with gross profit, EBITDA, and operating profit improving significantly from 2018 to 2020.

Marketing Investment: There is a clear correlation between increased marketing expenses and sales growth, especially in 2020, where we see a substantial rise in marketing investments.

Profit Margins: The GP and NP margins remain relatively stable, suggesting the company has managed its costs well, even as it scales up its sales operations.

Key Takeaways: The dashboard provides stakeholders with a clear picture of how the company is managing its operating expenses relative to sales growth, allowing them to identify where investments (like marketing) are paying off and where profitability could be improved further.