Financial Ratios Analysis Excel Dashboard

A simple Financial Rations Analysis Dashboard in Microsoft Excel.

by mahmoud al khateeb
Financial and Banking Expert . Ex . CFO .Ex. AuditorFollow

1 review981 views|2 comments|Bookmark Add to cart - $10.00

Description
This is a simple dashboard to calculate the financial ratios analysis with dynamically slicers and pivot table and awesome charts, key features of this model are:
- No need to recalculate any figure or indicators as all have been linked with formulas directly
- Only thing you need to do is adding your accounting figures, all will be automatically calculated in just one single click ( refresh button)
- Chart is linked to the table, and dynamically changed abon your selection of data needed to be displayed
- Can show all ratios in one chart or simply select one, two or as much as you want.
- Can compare two or more ratio in one chart
-Can compare two or more periods in one chart
- This model designed to calculate three years financial ratios,
- Simple design and easy to understand and work on
- One page design, so its easy to present.
- Ratios included in this dashboard are:
Asset Growth
Current Ratio
Debt to Total Assets
Dividend Payout Ratio
Fixed Asset Turnover
Income Growth
Inventory Turnover
Price Earnings Ratio
Profit Margin
Quick Ratio
Receivable Turnover
Return on Assets
Return on Equity

Should you have any questions on the model you're welcome to Private Message me via my Eloquens Channel or use the discussion feed below.

Feel free to leave a review and a rating if you have appreciated the model!

This Best Practice includes
1 Excel File