Скачать или смотреть Ratio Analysis dashboard | Google data studio | Financial Reporting

We have made this video to analysis our Ratios in graphical presentation with the help of google data studio tools.

Ratios:
1. Cash Ratio
2. Quick Ratio
3. Current Ratio
4. Capitalization Ratio
5. Debt to Equity Ratio
6. Networking Capital Ratio
7. Days Sales Outstanding (DSO)
8. Days Payable Outstanding (DPO)

Cash Ratio
Cash Ratio = (Cash + Bank) / Current Liabilities
It shows the ability of current assets to meet the current liabilities. The higher the quick ratio, the better the position of the company.

Quick Ratio
Quick Ratio = (Current Assets – Inventories) / Current Liabilities
It shows the company’s ability to meet its short-term obligations with its most liquid assets. The higher the quick ratio, the better the position of the company.

Current Ratio
Current Ratio = Current Assets / Current Liabilities
Used to determine the company’s ability to pay back its short term liabilities.
If the ratio is below 1, it raises a warning sign as to whether the company is able to pay its short term obligations when due.

Capitalization Ratio
Capitalization Ratio = Long term Liabilities /(Long term Liabilities + Total Equity)
It measure the proportion of debt in a company’s capital base, its funds from lenders and stockholders.

Debt to Equity Ratio:
Debt to Equity Ratio = Total Liabilities / Total equity
The debt-to-equity (D/E) ratio compares a company’s total liabilities to its shareholder equity and can be used to evaluate how much leverage a company is using.
Higher leverage ratios tend to indicate a company or stock with higher risk to shareholders.

Networking Capital Ratio:
Net Working Capital Ratio = Current Assets / Current Liabilities
It is intended to reveal whether a business has a sufficient amount of net funds available in the short term to stay in operation

Days Sales Outstanding (DSO)
Days Sales Outstanding = (Receivables / Revenue) x 365
A low DSO number means that it takes a company fewer days to collect its accounts receivable. A high DSO number shows that a company is selling its product to customers on credit and taking longer to collect money.

Days Payable Outstanding (DPO)
Days Payable Outstanding = (Accounts Payable / COGS) x 365
Days Payable Outstanding shows the time in days a business has to pay back its creditors. On the flip side, it also shows how long the company can utilize the cash before paying it back.
The longer a company can delay payments, the better.

We have used the following charts in our report in Google Data Studio:
1. Score Cards
2. Time Series Chart
3. Tables
4. Area Charts
5. Bar charts
Every chart has its own specialty in data presentation.

The most important thing to create dynamic dashboard is to study the connected database.
Study the following link better that how I have prepared the database in google sheets in accurate form for financial data visualization in google data studio.
If the base data correctly sorted then the data visualization will be easy and we can manipulate the data in any form in google data studio to make the financial reports.

Link of Google spreadsheet database:
https://docs.google.com/spreadsheets/...


You can access the reports anytime, anywhere by sign in to your google account.

Subscribe & share this channel for more videos.
Thanks

#professionalgrooming #GoogleDataStudioDashBoard #FinancialDashboardInGoogleDataStudio #Ratioanalysis